Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Data Transformation Techniques in Pandas

via CodeSignal

Overview

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.

Syllabus

  • 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

Reviews

Start your review of Data Transformation Techniques in Pandas

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.