HomeCoursesAdvanced pandas—Going Beyond the Basics

AI-powered learning

Save

Advanced pandas—Going Beyond the Basics

Explore advanced pandas techniques for reshaping, manipulating, and handling data. Use unique features and extended libraries to optimize workflows and improve data analysis efficiency.

5.0

94 Lessons

2 Projects

16h

Join 2.9 million developers at

LEARNING OBJECTIVES

Understanding of pandas’ extensive capabilities in reading data from different sources
Working knowledge of how to effectively handle different types of data in pandas
Hands-on experience using data reshaping and manipulation techniques in pandas
Ability to leverage extended pandas libraries for advanced capabilities in handling and analyzing data
Familiarity with less conventional yet useful features of pandas
Knowledge of efficiency boosting techniques

Learning Roadmap

94 Lessons10 Quizzes

Before We Begin

Get familiar with advanced pandas for data manipulation, transformation, and visualization skills.

Course Introduction

Reading Data into pandas

Get started with reading diverse data formats into pandas for efficient analysis.

Importance of Data Ingestion

Read Data from the Web

Read Data from HTML Files

Read Data from XML Files

Read Data from Statistical Software Files

Read Data from SQL Databases

Read Data from Binary Files (Feather, HDF5, ORC, Parquet)

Quiz

Combining Data

7 Lessons

Examine methods for combining and merging pandas DataFrames to enhance data manipulation.

Reshaping and Manipulating Data

13 Lessons

Enhance your skills in reshaping and manipulating data for effective analysis in pandas.

Encoding Data Types

2 Lessons

Take a closer look at inspecting, converting, and encoding data types in pandas.

Handling Numerical Data

10 Lessons

Focus on advanced arithmetic, comparison, filtering, and statistical methods using pandas.

Handling Categorical Data

6 Lessons

Master handling and transforming categorical data for efficient and meaningful analysis using pandas.

Handling Text Data

7 Lessons

Learn how to use pandas methods for transforming and managing complex text data efficiently.

Handling Time Series Data

17 Lessons

Unpack the core of advanced pandas techniques for time series analysis, manipulation, and resampling.

10.

Handling Sparse Data Structures

2 Lessons

Break apart the techniques for handling and optimizing sparse data structures using pandas.

11.

Handling Missing Data

4 Lessons

Grasp the fundamentals of representing, detecting, and managing missing data in pandas.

Data Analysis and Visualization with sidetable and Bokeh

Project

Premium

12.

Leveraging Further Features of pandas

6 Lessons

Solve problems in advanced pandas features like function chaining, assertions, styling, settings, and efficiency.

13.

Utilizing Extended Libraries

5 Lessons

Follow the process of leveraging advanced libraries to enhance data analysis with pandas.

14.

Wrap Up

Build on essential pandas skills for advanced data handling and real-world applications.

Conclusion

15.

Appendix

5 Lessons

Learn how to use setups, prerequisites, and updates for advanced pandas functionalities.

Time Series Analysis and Visualization Using Python and Plotly

Project

Premium

Certificate of Completion

Showcase your accomplishment by sharing your certificate of completion.

Developed by MAANG Engineers

ABOUT THIS COURSE

Pandas is an easy-to-use and performant Python library for data manipulation and analysis. It is an important toolkit in a world where the volume of data created and captured is growing exponentially. In this course, you’ll discover an in-depth exploration of the pandas library. The course covers advanced techniques to reshape data, manipulate data, and handle various data types. You will also learn how to use less conventional pandas features to streamline workflows, while also leveraging extended pandas libraries for enhanced data analysis. Whether you are an aspiring data scientist, a researcher, or a seasoned professional looking to sharpen your skills, this course is your pathway to becoming proficient in using pandas to analyze and manipulate data effectively and efficiently.

ABOUT THE AUTHOR

Kenneth Leung

Kenneth is a data scientist and technical author, currently working at Boston Consulting Group where he blends advanced technical expertise with deep domain knowledge to solve complex business challenges.

Learn more about Kenneth

Trusted by 2.9 million developers working at companies

These are high-quality courses. Trust me the price is worth it for the content quality. Educative came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks

Anthony Walker

@_webarchitect_

Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!

Evan Dunbar

ML Engineer

You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it.

Software Developer

Carlos Matias La Borde

I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site

Souvik Kundu

Front-end Developer

Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content.

Vinay Krishnaiah

Software Developer

Course

Data Analysis & Processing with Pandas

Gain insights into Pandas' powerful tools for data analysis. Learn about Series, DataFrames, and optimize performance for data operations, filtering, and file uploads.

4 h

intermediate

Course

Pandas Brain Teasers

Explore puzzles designed to enhance your critical thinking and problem-solving skills using pandas. Gain insights into common pitfalls and sharpen your data manipulation techniques.

1 h 20 m

intermediate

Course

Machine Learning with NumPy, pandas, scikit-learn, and More

Learn practical machine learning with NumPy, pandas, scikit-learn, and more. Learn data analysis, feature engineering, and deep learning using industry-standard frameworks. Basic Python required.

15 h

intermediate

Course

Mastering Data Analysis with Python Pandas

Gain insights into using Python Pandas for efficient data analysis and manipulation. Delve into detailed functions, parameters, and methods to elevate your data handling skills.

2 h 25 m

beginner

Course

Effective Data Manipulation with pandas

Learn effective data manipulation with pandas. Discover filtering, merging, grouping, and reshaping techniques through hands-on examples, best practices, and performance tips for real-world analysis.

24 h

beginner

Course

A Practical Guide to Machine Learning with Python

Explore practical coding of basic machine learning models using Python. Gain insights into algorithms like linear regression, logistic regression, SVM, KNN, and decision trees.

72 h 30 m

beginner

Course

Data Analysis & Processing with Pandas

Machine Learning with NumPy, pandas, scikit-learn, and More