Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Dive into a fast-paced 23-minute video tutorial covering the core functionalities of Pandas, an essential library for data wrangling in Python. Gain a solid foundation in data manipulation techniques, starting with importing Pandas and exploring data I/O operations. Learn to read from and write to files, understand DataFrame basics, and master various methods for subsetting and filtering data. Discover how to perform summary statistics, use aggregation functions, and handle categorical data. Explore advanced concepts like ranking, shifting, and cumulative sums, as well as rolling methods and data clipping. Delve into groupby operations, creating new columns, sorting, and managing missing data. Finally, learn techniques for combining data through concatenation and merging DataFrames. Perfect for beginners and those looking to refresh their Pandas skills quickly.
Syllabus
Intro
Importing Pandas
Data I/O
Reading From Files
Writing to Files
DataFrame Basics
DataFrame Summary
Subsetting Columns
Select dtypes
Select as Series vs DataFrame
.loc and .iloc
.loc Filter Expressions
.query
Summary Statistics
.agg
Sumarizing Categoricals
rank, shift, cumsum
Rolling methods
Clip
Groupby
New Columns
Sorting
Missing Data
Combining Data
concat
Merge DataFrames
Merge Suffixes
Bonus
Taught by
Rob Mulla