Data Cleaning and Preprocessing with pandas
pandas is one of today’s most successful data analysis libraries out there. A favorite to many, its versatile functionalities can be leveraged for manipulation of many types of data - numeric, text, Boolean, and more. That’s one of the features that make pandas the go-to choice for analysts, especially during the data cleaning and preprocessing stages. Technically, pandas has been built on NumPy because the former needs the computational power and abilities of the latter. But what makes pandas truly great is its ability to operate with the data in an easy-to-use way, allowing you to focus almost entirely on your analytic task. And in this course, you will learn how to work with this powerful Python library and its core data structures – the pandas Series and DataFrames.
3 hours 
105 exercises 
10 downloadables
Sign up to
preview the program
for FREE!
Create a free account and start learning data science today.
create free account
Our graduates work at exciting places:
Section 1
pandas - Basics
In this section, you will develop a basic understanding of the pandas library and practice with fundamental programming tools such as methods, parameters, arguments, attributes, and index values. You will also learn how to work with the pandas Series and DataFrame objects. In the end, we will present the pandas documentation and will show how you can navigate through it.
Introduction to the pandas Library
Installing and Running pandas
Introduction to pandas Series
Working with Attributes in Python
Using an Index in pandas
Label-based vs Position-based Indexing
More on Working with Indices in Python
Using Methods in Python - Part I
Using Methods in Python - Part II
Parameters vs Arguments
The pandas Documentation
Introduction to pandas DataFrames
Creating DataFrames from Scratch - Part I
Creating DataFrames from Scratch - Part II
Additional Notes on Using DataFrames
pandas Basics - Conclusion (ARTICLE)
Section 2
Data Cleaning and Data Preprocessing
Only about 20% of the work of a data analytics or science team goes to statistical analysis, making visualization or predictive models. The bulk of the time is consumed by collecting, cleaning, and preprocessing data. That is why in this section, we’ve provided a single lecture that aims at clarifying the meaning of and difference between the data cleaning and data preprocessing stages.
Data Cleaning and Data Preprocessing
Section 3
pandas Series
Here, we will introduce you to working with one of the two core data structures of pandas – the pandas Series object. You will also discover several common methods and learn how to apply them to a pandas Series.
.unique(), .nunique()
Converting Series into Arrays
.sort_values()
Attribute and Method Chaining
.sort_index()
Section 4
pandas DataFrames
This section focuses on the other fundamental object in pandas - the DataFrame. The DataFrame is the most important structure in this library. Here, we will revise its characteristics as well as comment on several popular related methods. In addition, we will show you how to deal with various techniques for data selection in a DataFrame.
A Revision to pandas DataFrames
Common Attributes for Working with DataFrames
Data Selection in pandas DataFrames
Data Selection - Indexing Data with .iloc[]
Data Selection - Indexing Data with .loc[]
A Few Comments on Using .loc[] and .iloc[]
Programming for Data Science
This course is part of Module 2 of the 365 Data Science Program. The complete training consists of four modules, each building upon your knowledge from the previous one. In contrast to the introductory nature of Module 1, Module 2 is designed to tackle all aspects of programming for data science. You will learn how to work with relational databases and SQL, as well as how to code in Python and R. By the end of this Module, you will have a versatile programming skill set.
See All Modules
Why Choose the 365 Data Science Program?
Practice
Real-life project and data. Solve them on your own computer as you would in the office.
Q&A Hub
Our expert instructors are happy to help. Post a question and get a personal answer by one of our instructors.
Certificates
Earn a verifiable certificate after each completed course. Celebrate your successes and share your progress with your professional network!
Trust the other 500,000 students
The course is in-depth and is delivered at a steady pace with eye catching visuals. The instructors go through all the basics really well. They try not to over-simplify the material, you get a good sense Đ°of how deep Data Science is in the course. Great job!!!
This course is amazing! After watching the video carefully and doing all the exercises, I am even capable of having discussions with Machine learning major Master’s students! High standard course with reasonable pricing.
Very clear and in-depth explanation of data science and how all the inter-related concepts apply in real life business environment. Absolutely great for beginners! Best data science course I have come across so far!
I would highly recommend the course to any beginner who wants to venture into the world of Data Science. The concepts are very well explained and there is an emphasis on practical application which really helps create a better understanding of the concepts.
Ready to start?
Sign up today for FREE!
