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...