Data Manipulation using pandas
ADVANCED
#python
Author: Oleksandr Lomako
Course description
This course covers intermediate topics on pandas, a must-have tool for each data analyst. During the course, you will learn how to prepare data for further interactions and how to group it using different techniques. You will learn the easiest data visualization and be acquainted with data joining.
Complete all chapters to get certificate
0%
Preprocessing Data: Part I
The data received from different sources can be messy, and to use it in the future, you must ensure it is convenient. In the first section, you will learn what data preprocessing is and will deal with some logical inconsistencies.
What is Data Preprocessing?
Types consistency
Poor Data Presentation
Manipulating Strings
Challenge
Replacing Specific Elements
Simultaneous Replacement
Challenge
Preprocessing Data: Part II
Missing or NA values, outliers, and inconsistencies are other types of problematic data. Throughout the second section of the course, you will learn how to deal with such issues.
Logical Inconsistency
Removing Rows
Challenge
Outliers
Challenge
Missing Values
Filling NA values
Challenge
Grouping Data
As a data analyst, you will need to draw compact conclusions based on large amounts of data. In order to achieve that, you need to understand the data grouping idea and how to apply it to examples.
What is Grouping Data?
Grouping in pandas [1/2]
Challenge
Grouping in pandas [2/2]
Challenge
Grouping by Several Columns
Challenge
Aggregating and Visualizing Data
Sometimes one built-in function is not enough to draw a complete conclusion, so you need to use something more complex. This section will teach you how to apply multiple functions while grouping. Also, you will learn to visualize data using the pandas library only and will be acquainted with the main plot types. As a data analyst, you will need to draw compact conclusions based on large amounts of data. In order to achieve that, you need to understand the data grouping idea and how to apply it to examples.
Advanced Aggregation [1/2]
Challenge
Advanced Aggregation [2/2]
Challenge
Histograms
Challenge
Bar and Scatter Plots
Other Types of Graphs
Challenge 1
Challenge 2
Joining Data
As mentioned before, sometimes you may need to work with data received from multiple sources. This section will teach you how to join two dataframes using different techniques.
What is Joining Data?
Left Join
Right Join
Inner Join
Outer Join
Concatenation