Programming for Data Science with Python

Welcome to the Nanodegree

Welcome to the Programming for Data Science Nanodegree program! In this lesson, you will learn more about the structure of the program and meet the team.

Getting Help

You are starting a challenging but rewarding journey! Take 5 minutes to read how to get help with projects and content.

Get Help with Your Account

What to do if you have questions about your account or general questions about the program.

The Life of a Data Scientist

In this lesson, you'll hear from a few data analysts and data scientists about what it's like to work in data analytics.

Basic SQL

In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.

SQL Joins

In this lesson, you will learn how to combine data from multiple tables together.

SQL Aggregations

In this lesson, you will learn how to aggregate data using SQL functions

SQL Subqueries & Temporary Tables

In this lesson, you will learn about subqueries, a fundamental advanced SQL topic. This lesson will walk you through the appropriate applications of subqueries, the different types of subqueries, and review subquery syntax and examples.

SQL Data Cleaning

Cleaning data is an important part of the data analysis process. You will be learning how to perform data cleaning using SQL in this lesson.

SQL Window Functions

Window functions allow users to compare one row to another without doing any joins using one of the most powerful concepts in SQL data analysis.

SQL Advanced JOINS & Performance Tuning

Learn advanced joins and how to make queries that run quickly across giant datasets. Most of the examples in the lesson involve edge cases, some of which come up in interviews.

Project: Investigate a Relational Database

The **Sakila Movie database** is a SQL database of online DVD rentals . You will query the database to answer questions about business decisions.

Shell Workshop

The Unix shell is a powerful tool for developers of all sorts. In this lesson, you'll get a quick introduction to the very basics of using it on your own computer.

Why Python Programming

Welcome to Introduction to Python! Here's an overview of the course.

Data Types and Operators

Familiarize yourself with the building blocks of Python! Learn about data types and operators, built-in functions, type conversion, whitespace, and style guidelines.

Data Structures in Python

Use data structures to order and group different data types together! Learn about the types of data structures in Python, along with more useful built-in functions and operators.

Control Flow

Build logic into your code with control flow tools! Learn about conditional statements, repeating code with loops and useful built-in functions, and list comprehensions.

Functions

Learn how to use functions to improve and reuse your code! Learn about functions, variable scope, documentation, lambda expressions, iterators, and generators.

Scripting

Set up your own programming environment to write and run Python scripts locally! Learn good scripting practices, interact with different inputs, and discover awesome tools.

NumPy

Learn the basics of NumPy and how to use it to create and manipulate arrays.

Pandas

Learn the basics of Pandas Series and DataFrames and how to use them to load and process data.

Advanced Topics

In this lesson we cover some advanced topics of iterators and generators. You are not required to complete this but we have provided these to give you a taste of these.

Explore US Bikeshare Data

Use Python to understand U.S. bikeshare data. Calculate statistics and build an interactive environment where a user chooses the data and filter for a dataset to analyze.

What is Version Control

Version control is an incredibly important part of a professional programmer's life. In this lesson, you'll learn about the benefits of version control and install the version control tool Git!

Create a Git Repo

Now that you've learned the benefits of Version Control and gotten Git installed, it's time you learn how to create a repository.

Commits, Tags, Conflicts

Knowing how to review an existing Git repository's history of commits is extremely important. You'll learn how to do just that in this lesson.

Remotes and Developer Repos

In this lesson, you'll learn how to fork another developer's project. Collaborating with other developers can be a tricky process, so you'll learn how to contribute to a public project.

Writing READMEs for Repos

Learn the importance of well documented code and see how to craft meaningful READMEs.

Project: Post Your Work on GitHub

Use your local git repository and your GitHub repository. Fork a repository, work on files, stage files and commit them to GitHub. You will also demonstrate how to hide files using .gitignore files.

Congratulations!

Congratulations on completing all your projects!

Industry Research

You're building your online presence. Now learn how to share your story, understand the tech landscape better, and meet industry professionals.

Optimize Your GitHub Profile

Other professionals are collaborating on GitHub and growing their network. Submit your profile to ensure your profile is on par with leaders in your field.

Take 30 Min to Improve your LinkedIn

Find your next job or connect with industry peers on LinkedIn. Ensure your profile attracts relevant leads that will grow your professional network.

Descriptive Statistics - Part I

In this lesson, you will learn about data types, measures of center, and the basics of statistical notation.

Descriptive Statistics - Part II

In this lesson, you will learn about measures of spread, shape, and outliers as associated with quantitative data. You will also get a first look at inferential statistics.

Spreadsheets 1: Getting Started

In this lesson, you will learn about the basic functionality for spreadsheet software, use cell referencing and menu shortcuts.

Spreadsheets 2: Manipulate Data

In this lesson, you will learn basic spreadsheet function: sort and filter data, use text and math functions, split columns and remove duplicates.

Spreadsheets 3: Analyze Data

In this lesson, you will learn how to summarize data with aggregation and conditional functions. You will learn how to use pivot tables and lookup functions.

Spreadsheets 4: Visualize Data

In this lesson you will build data visualizations for quantitative and categorical data; create pie, bar, line, scatter, histogram, and boxplot charts, and build professional presentations.

Data Visualization Fundamentals

In this lesson you learn to evaluate the quality of data visualizations and build high quality visualizations, starting with the fundamentals of data dashboards.

Design Principles

In this lesson you learn to implement the best design practices, and to use the most appropriate chart for a particular situation.

Creating Visualizations in Tableau

This lesson teaches you how to build data visualizations in Tableau using data hierarchies, filters, groups, sets, and calculated fields, as well as create map-based data visualizations in Tableau.

Telling Stories with Tableau

In this lesson you learn how to build interactive Tableau dashboards and tell impactful stories using data.

HTML Syntax

Set up your development environment for writing HTML and learn basic tags and syntax.

HTML Syntax Problem Set

Get practice creating HTML documents and writing tags with this collection of fun challenges.

CSS Syntax

Learn the basics of CSS syntax and get started adding style to your websites.

CSS Syntax Problem Set

Practice writing CSS and styling websites while exploring new properties in this problem set.