Loading...

Data Science

1,052 learners

Data Transformation Techniques in Pandas

This course focuses on transforming your data to better suit analysis needs, including handling categorical data, performing date and time manipulations, and applying advanced filtering and sorting techniques. Through hands-on examples, you'll learn to reshape your datasets for optimized analysis.

Pandas

Python

See path

4 lessons

16 practices

2 hours

Data Cleaning and Preprocessing

Lessons and practices

Lesson 1: Handling Categorical Data

Converting 'embarked' to Categorical in Titanic Dataset

Fix the Titanic Data Transformation

Handle and Encode Categorical Data

One-Hot Encode the Embarked Column

Lesson 2: Working with Dates and Times

Analyzing Monthly Sales Trends

Extract Year from Sale Date

Analyzing Sales Data Over Time

Analyze Retail Sales Data Using Datetime Operations

Lesson 3: Sorting and Ranking Data

Organizing a Library by Publication Year

Sorting Books in Descending Order

Ranking Library Books Based on Ratings

Sorting Library Books by Pages

Lesson 4: Introduction to Pivot Tables

Analyzing Toy Prices with Pivot Tables

Change the Aggregation Function

Toy Store Sales Pivot Table

Pivot Table Analysis for Toy Store Data

Meet Cosmo:

The smartest AI guide in the universe

Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.

From our community

Hear what our customers have to say about CodeSignal Learn

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

I love that it's personalized. When I'm stuck, I don't have to hope my Google searches come out successful. The AI mentor Cosmo knows exactly what I need.

Faith Yim

Software Engineer

+14

It's an amazing product and exceeded my expectations, helping me prepare for my job interviews. Hands-on learning requires you to actually know what you are doing.