Data Wrangling With MongoDB
summary
Walks through a 70% demo that actually builds and runs Python scripts to convert CSV to JSON and insert into MongoDB, including using the csv module, datetime parsing, pymongo client and matplotlib for a chart. Shows the full pipeline: discovery/profiling, remove rows with empty title, replace dashes with 0, replace empty certification fields with "Unknown", reformat release dates, insert into a collection and run an aggregation to count platinum/gold/silver — all demonstrated working end to end.
AI-written summary · about
chapters (5)
- 0:00Start
- 3:09What is Data Wrangling
- 6:23Data Wrangling in Practice: What to Expect
- 36:21Data wrangling vs. data cleaning vs. data mining
- 37:21Data wrangling best practices
related talks
38mData Analysis and Map-Reduce with mongoDB and pymongo
43mHelp! I Need To UnSQLize My Application
38mFrom Tables to Documents—Changing Your Database Mindset
41mFrom Tables to Documents - Changing Your Database Mindset
29mSwitching to MongoDB: The challenges of translating database schemas
45mDatabases for Data Science
34mNoSQL Python: making data frames work for you in a non-rectangular world
30mHelp! I Need To UnSQLize My Application