About this Course

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.

Course Cost
Free
Timeline
Approx. 2 months
Skill Level
Intermediate
Included in Course
  • Icon course 01 3edf6b45629a2e8f1b490e1fb1516899e98b3b30db721466e83b1a1c16e237b1 Rich Learning Content

  • Icon course 04 2edd94a12ef9e5f0ebe04f6c9f6ae2c89e5efba5fd0b703c60f65837f8b54430 Interactive Quizzes

  • Icon course 02 2d90171a3a467a7d4613c7c615f15093d7402c66f2cf9a5ab4bcf11a4958aa33 Taught by Industry Pros

  • Icon course 05 237542f88ede3178ac4845d4bebf431ddd36d9c3c35aedfbd92e148c1c7361c6 Self-Paced Learning

  • Icon course 03 142f0532acf4fa030d680f5cb3babed8007e9ac853d0a3bf731fa30a7869db3a Student Support Community

Join the Path to Greatness

This free course is your first step towards a new career with the Data Analyst Nanodegree Program.

Free Course

Data Wrangling with MongoDB

by MongoDB

Enhance your skill set and boost your hirability through innovative, independent learning.

Icon steps 54aa753742d05d598baf005f2bb1b5bb6339a7d544b84089a1eee6acd5a8543d

Course Leads

  • Gundega Dekena
    Gundega Dekena

    Instructor

  • Shannon Bradshaw
    Shannon Bradshaw

    Instructor

What You Will Learn

Lesson 1

Data Extraction Fundamentals

  • Assessing the Quality of Data
  • Intro to Tabular Formats
  • Parsing CSV
Lesson 1

Data Extraction Fundamentals

  • Assessing the Quality of Data
  • Intro to Tabular Formats
  • Parsing CSV
Lesson 2

Data in More Complex Formats

  • XML Design Principles
  • Parsing XML
  • Web Scraping
Lesson 2

Data in More Complex Formats

  • XML Design Principles
  • Parsing XML
  • Web Scraping
Lesson 3

Data Quality

  • Sources of Dirty Data
  • A Blueprint for Cleaning
  • Auditing Data
Lesson 3

Data Quality

  • Sources of Dirty Data
  • A Blueprint for Cleaning
  • Auditing Data
Lesson 4

Working with MongoDB

  • Data Modelling in MongoDB
  • Introduction to PyMongo
  • Field Queries
Lesson 4

Working with MongoDB

  • Data Modelling in MongoDB
  • Introduction to PyMongo
  • Field Queries
Lesson 5

Analyzing Data

  • Examples of Aggregation Framework
  • The Aggregation Pipeline
  • Aggregation Operators: $match, $project, $unwind, $group
Lesson 5

Analyzing Data

  • Examples of Aggregation Framework
  • The Aggregation Pipeline
  • Aggregation Operators: $match, $project, $unwind, $group
Lesson 6

Case Study - OpenStreetMap Data

  • Using iterative parsing for large datafiles
  • Open Street Map XML Overview
  • Exercises around OpenStreetMap data
Lesson 6

Case Study - OpenStreetMap Data

  • Using iterative parsing for large datafiles
  • Open Street Map XML Overview
  • Exercises around OpenStreetMap data

Prerequisites and Requirements

The ideal student should have the following skills:

  • Programming experience in Python or a willingness to read a little documentation to understand examples and exercises throughout the course.
  • The ability to perform rudimentary system administration on Windows or Unix

At least some experience using a unix shell or Windows PowerShell will be helpful, but is not required.

No prior experience with databases is needed.

About MongoDB
This course is developed in conjunction with MongoDB, Inc., the originator and primary contributor to the open source database MongoDB. MongoDB is the leading NoSQL database. Designed for how we build and run applications today, MongoDB empowers organizations to be more agile and scalable. It enables new types of applications, better customer experience, faster time to market and lower costs.

See the Technology Requirements for using Udacity.

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.

What do I get?
  • Instructor videos
  • Learn by doing exercises
  • Taught by industry professionals
Icon globe e82eae5d45465aba4fbe4bb746905ce55dc3324f310b79c60e4a20089057d347

Udacity 现已提供中文版本! A Udacity tem uma página em português para você! There's a local version of Udacity for you!

前往优达学城中文网站 Ir para a página brasileira Go to Indian Site or continue to Global Site