subject

Udacity: Data Wrangling with MongoDB

 with  Shannon Bradshaw
Sponsored
Digital Marketing Certificate
Cornell University via eCornell
Sponsored
A Beginner's Guide to Coffee
Sunway University via Open Learning
In this course, we will explore how to wrangle data from diverse sources and shape it to enable data-driven applications. Some data scientists spend the bulk of their time doing this!

Students will learn how to gather and extract data from widely used data formats. They will learn how to assess the quality of data and explore best practices for data cleaning. We will also introduce students to MongoDB, covering the essentials of storing data and the MongoDB query language together with exploratory analysis using the MongoDB aggregation framework.

This is a great course for those interested in entry-level data science positions as well as current business/data analysts looking to add big data to their repertoire, and managers working with data professionals or looking to leverage big data.

This course is also a part of our Data Analyst Nanodegree.

Why Take This Course?
At the end of the class, students should be able to:

* Programmatically extract data stored in common formats such as csv, Microsoft Excel, JSON, XML and scrape web sites to parse data from HTML.
* Audit data for quality (validity, accuracy, completeness, consistency, and uniformity) and critically assess options for cleaning data in different contexts.
* Store, retrieve, and analyze data using MongoDB.



This course concludes with a final project where students incorporate what they have learned to address a real-world data analysis problem.

Syllabus

### Lesson 1: Data Extraction Fundamentals

- Assessing the Quality of Data
- Intro to Tabular Formats
- Parsing CSV
- Parsing XLS with XLRD
- Intro to JSON
- Using Web APIs

### Lesson 2: Data in More Complex Formats

- Intro to XML
- XML Design Principles
- Parsing XML
- Web Scraping
- Parsing HTML


### Lesson 3: Data Quality

- What is Data Cleaning?
- Sources of Dirty Data
- Measuring Data Quality
- A Blueprint for Cleaning
- Auditing Validity
- Auditing Accuracy
- Auditing Completeness
- Auditing Consistency
- Auditing Uniformity

### Lesson 4: Working with MongoDB

- Data Modelling in MongoDB
- Introduction to PyMongo
- Field Queries
- Projection Queries
- Getting Data into MongoDB
- Using mongoimport
- Operators like $gt, $lt, $exists, $regex
- Querying Arrays and using $in and $all Operators
- Changing entries: $update, $set, $unset

### Lesson 5: Analyzing Data

- Examples of Aggregation Framework
- The Aggregation Pipeline
- Aggregation Operators: $match, $project, $unwind, $group
- Multiple Stages Using a Given Operator

### Lesson 6: Case Study - OpenStreetMap Data

- Using iterative parsing for large datafiles
- Open Street Map XML Overview
- Exercises around OpenStreetMap data
- Final Project Instructions
9 Student
reviews
Cost Free Online Course
Pace Self Paced
Subject Databases
Institution MongoDB University
Provider Udacity
Language English
Hours 6 hours a week
Calendar 8 weeks long

Disclosure: To support our site, Class Central may be compensated by some course providers.

+ Add to My Courses
FAQ View All
What are MOOCs?
MOOCs stand for Massive Open Online Courses. These are free online courses from universities around the world (eg. Stanford Harvard MIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you.  They also have student discussion forums, homework/assignments, and online quizzes or exams.

Reviews for Udacity's Data Wrangling with MongoDB
3.0 Based on 9 reviews

  • 5 stars 22%
  • 4 stars 22%
  • 3 stars 22%
  • 2 star 0%
  • 1 stars 33%

Did you take this course? Share your experience with other students.

Write a review
  • 1
1.0 4 weeks ago
Anonymous partially completed this course.
I do not know how anyone can rate the class more than 1 star. The learning materials were pathetic, and not usually on topic. I have had to go through the materials at least 3 times and consulted with Senior Data Analysts at my current employer. Their comments range from "That is completely unhelpful" to just quiet sighs.

At the start, the forums for the entire Nanodegree, were supported by mentors who would respond, often unhelpfully, but sometimes gleaning a nugget of knowledge. Late in 2017, I was informed that the forums are no longer being monitored. I was assigned a mentor, I don't want a mentor, I want help when I need help not at their convenience.

The "instructor" (notice the quotes) from MongoDB , although very knowledgeable, is a not a very good communicator of that knowledge. He talks FAST, jumps around from subject to subject, utilizes at time random data modules. He may be a good person to ask a question of, but to teach, he is sever
Read more
I do not know how anyone can rate the class more than 1 star. The learning materials were pathetic, and not usually on topic. I have had to go through the materials at least 3 times and consulted with Senior Data Analysts at my current employer. Their comments range from "That is completely unhelpful" to just quiet sighs.

At the start, the forums for the entire Nanodegree, were supported by mentors who would respond, often unhelpfully, but sometimes gleaning a nugget of knowledge. Late in 2017, I was informed that the forums are no longer being monitored. I was assigned a mentor, I don't want a mentor, I want help when I need help not at their convenience.

The "instructor" (notice the quotes) from MongoDB , although very knowledgeable, is a not a very good communicator of that knowledge. He talks FAST, jumps around from subject to subject, utilizes at time random data modules. He may be a good person to ask a question of, but to teach, he is severely lacking.

Now attempting to complete the project, it is too a joke. the instructions are very unclear and unstructured as to expectations.

If you are on the fence about learning Data Analysis, look elsewhere, this one is poorly designed.
Was this review helpful to you? Yes
1.0 2 years ago
Anonymous is taking this course right now.
There are two main parts of that, SQL and MongoDB, SQL lecturer gave more details for students to understand but not for Data Wrangling and MongoDB, skipping lot of details and not well explanation for the codes. Sure that students need to invest more time to study but not recommend for those who do not have python knowledge, it's the worst course so far from data analyst nanodegree.
2 people found
this review helpful
Was this review helpful to you? Yes
5.0 2 years ago
by Roshan Shetty completed this course, spending 10 hours a week on it and found the course difficulty to be hard.
I think the project at the end was very helpful. Getting to clean data, convert it from XML to JSON, load it into MongoDB and analyze it took effort. At the end, it seemed worth it.
1 person found
this review helpful
Was this review helpful to you? Yes
1.0 a week ago
by Scott Stevens is taking this course right now, spending 12 hours a week on it and found the course difficulty to be very hard.
Where to start.

Although self paced, the course was without direction and expectations. I have worked through the lessons so many times and still the materials are not on target for the exercise. The "project Rubric", was a waste of a mouse click as it showed no specifics as to what is expected.

I have spent more than 5 months learning from other sites, (read non-Udacity) on how to proceed but I feel like a ship with out a rudder and no destination. It boggles the mind that there is no desired outcome for the project... Just ... Explore that data... what does that mean anyways?
Was this review helpful to you? Yes
4.0 3 years ago
by Anirudha Bose completed this course.
I would highly recommend this course. Since this course is self paced, it is possible to finish it very quickly, as the material is not tough to comprehend. I didn't find any "Final Project Instructions" in the course though.
Was this review helpful to you? Yes
4.0 3 years ago
by Lukas Tencer completed this course and found the course difficulty to be medium.
0 person found
this review helpful
Was this review helpful to you? Yes
5.0 3 years ago
by Gennady completed this course.
0 person found
this review helpful
Was this review helpful to you? Yes
3.0 11 months ago
by Adam Hjerpe completed this course.
Was this review helpful to you? Yes
3.0 11 months ago
by Atila Romero partially completed this course.
Was this review helpful to you? Yes
  • 1

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free