1. Assessing the Quality of Data
2. Intro to Tabular Formats
3. Parsing CSV
4. Parsing XLS with XLRD
5. Intro to JSON
6. Using Web APIs

1. Intro to XML
2. XML Design Principles
3. Parsing XML
4. Web Scraping
5. Parsing HTML

1. What is Data Cleaning?
2. Sources of Dirty Data
3. Measuring Data Quality
4. A Blueprint for Cleaning
5. Auditing Validity
6. Auditing Accuracy
7. Auditing Completeness
8. Auditing Consistency
9. Auditing Uniformity

1. Data Modeling in MongoDB
2. Introduction to PyMongo
3. Field Queries
4. Projection Queries
5. Getting Data into MongoDB
6. Using mongoimport
7. Operators like $gt, $lt, $exists, $regex
8. Querying Arrays and using $in and $all Operators
9. Changing entries: $update, $set, $unset

1. Examples of Aggregation Framework
2. The Aggregation Pipeline
3. Aggregation Operators: $match, $project, $unwind, $group
4. Multiple Stages Using a Given Operator

1. Using iterative parsing for large data files
2. Open Street Map XML Overview
3. Exercises around OpenStreetMap data

1. Use important skills from data munging to improve OpenStreetMaps data for a part of the world that you care about and give back to the community.
2. You can find the final project grading rubric here. It also contains final project submission instructions for students who are enrolled in the full course experience.

REFERENCE:

[0]Course Materials

[1]Requests

[2]xlutils (xlrd/xlwd)

[3]BeautifulSoup

[4]PyMongo