Programming for Data Science with Python

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.

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

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

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

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.

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

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

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.

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.

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.

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.

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

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.

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

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

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.

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.

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

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.

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

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

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.

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.