Chapter 2. Making Your Data All It Can Be

In this chapter, we will cover the steps that you need to perform to get your data ready for analysis. You will learn about the following:

• Importing data into MongoDB
  • Importing a CSV file into MongoDB
  • Importing an Excel file into MongoDB
  • Importing a JSON file into MongoDB
  • Importing a plain text file into MongoDB
• Working with MongoDB using PyMongo
  • Retrieving a single record using PyMongo
  • Retrieving multiple records using PyMongo
  • Inserting a single record using PyMongo
  • Inserting multiple records using PyMongo
  • Updating a single record using PyMongo
  • Updating multiple records using PyMongo
  • Deleting a single record using PyMongo
  • Deleting multiple records using PyMongo
• Cleaning data using Pandas
  • Importing a CSV File into a Pandas DataFrame
  • Renaming column headers in Pandas
  • Filling in missing values in Pandas
  • Removing punctuation in Pandas
  • Removing whitespace in Pandas
  • Removing any string from within a string in Pandas
• Standardizing data with Pandas
  • Merging two datasets in Pandas
  • Titlecasing anything
  • Uppercasing a column in Pandas
  • Updating values in place in Pandas
  • Standardizing a Social Security number in Pandas
  • Standardizing dates in Pandas
  • Converting categories to numbers in Pandas for a speed boost