Pandas for Data Science

Learning PathSkills: Pandas, Data Science, Data Visualization

Pandas Tricks

In this learning path, you’ll get started with Pandas and get to know the ins and outs of how you can use it to analyze data with Python.

Pandas is a game-changer for data science and analytics, particularly if you came to Python because you were searching for something more powerful than Excel and VBA. Pandas uses fast, flexible, and expressive data structures designed to make working with relational or labeled data both easy and intuitive.

Pandas for Data Science

Learning Path ⋅ 13 Resources

Using Pandas and Python to Explore Your Dataset


Explore Your Dataset With Pandas

Learn how to start exploring a dataset with Pandas and Python. You'll learn how to access specific rows and columns to answer questions about your data. You'll also see how to handle missing values and prepare to visualize your dataset in a Jupyter Notebook.

The Pandas DataFrame: Make Working With Data Delightful


The Pandas DataFrame: Working With Data Efficiently

In this course, you'll get started with Pandas DataFrames, which are powerful and widely used two-dimensional data structures. You'll learn how to perform basic operations with data, handle missing values, work with time-series data, and visualize data from a Pandas DataFrame.

Pandas Sort: Your Guide to Sorting Data in Python


Sorting Data in Python With Pandas

Learn how to sort data in a pandas DataFrame using the pandas sort functions sort_values() and sort_index(). You'll learn how to sort by one or more columns and by index in ascending or descending order.

Pythonic Data Cleaning With Pandas and NumPy


Data Cleaning With pandas and NumPy

Learn how to clean up messy data using pandas and NumPy. You'll become equipped to deal with a range of problems, such as missing values, inconsistent formatting, malformed records, and nonsensical outliers.

Pandas: How to Read and Write Files


Reading and Writing Files With Pandas

Learn about the Pandas IO tools API and how you can use it to read and write files. You'll use the Pandas read_csv() function to work with CSV files. You'll also cover similar methods for efficiently working with Excel, CSV, JSON, HTML, SQL, pickle, and big data files.

SettingWithCopyWarning in Pandas: Views vs Copies


SettingWithCopyWarning in pandas: Views vs Copies

Learn about views and copies in NumPy and pandas. You'll see why the SettingWithCopyWarning occurs in pandas and how to properly write code that avoids it.

Plot With Pandas: Python Data Visualization for Beginners


Plot With Pandas: Python Data Visualization Basics

In this course, you'll get to know the basic plotting possibilities that Python provides in the popular data analysis library pandas. You'll learn about the different kinds of plots that pandas offers, how to use them for data exploration, and which types of plots are best for certain use cases.

Python & Pandas


Fast, Flexible, Easy and Intuitive: How to Speed Up Your pandas Projects

What is it about pandas that has data scientists, analysts, and engineers raving? This is a guide to using pandas Pythonically to get the most out of its powerful and easy-to-use built-in features. Additionally, you will learn a couple of practical time-saving tips.

Pandas GroupBy: Your Guide to Grouping Data in Python


pandas GroupBy: Your Guide to Grouping Data in Python

Learn how to work adeptly with the pandas GroupBy facility while mastering ways to manipulate, transform, and summarize data. You'll work with real-world datasets and chain GroupBy methods together to get data in an output that suits your purpose.

Combining Data in Pandas With merge(), .join(), and concat()


Combining Data in pandas With concat() and merge()

Learn two techniques for combining data in pandas: merge() and concat(). Combining Series and DataFrame objects in pandas is a powerful way to gain new insights into your data.

NumPy, SciPy, and Pandas: Correlation With Python


NumPy, SciPy, and pandas: Correlation With Python

Learn what correlation is and how you can calculate it with Python. You'll use SciPy, NumPy, and pandas correlation methods to calculate three different correlation coefficients. You'll also see how to visualize data, regression lines, and correlation matrices with Matplotlib.

Pandas Tricks


Idiomatic Pandas: Tricks & Features You May Not Know

In this course you'll see how to use some lesser-used but idiomatic Pandas capabilities that lend your code better readability, versatility, and speed.

Pandas Project: Make a Gradebook With Pandas


Using Pandas to Make a Gradebook in Python

With this course and Python project, you'll build a script to calculate grades for a class using pandas. The script will quickly and accurately calculate grades from a variety of data sources. You'll see examples of loading, merging, and saving data with pandas, as well as plotting some summary statistics.

Got feedback on this learning path?

Looking for real-time conversation? Visit the Real Python Community Chat or join the next “Office Hours” Live Q&A Session. Happy Pythoning!

« Browse All Learning Paths