Data Analysis with Python in Excel: Data Cleaning and Wrangling (Day 4)

Data Analysis with Python in Excel: Data Cleaning and Wrangling (Day 4)

Leverage the power of Python to analyze data.

rate limit

Code not recognized.

About this course

In this course, Dave covers how to define a function in Python in Excel. You'll then apply this knowledge to mutate or change DataFrames using the assign() method and also learn how to use a lambda with this method. 

This course is Part 4 of the five-course series in the Data Analysis with Python in Excel learning path.

Curriculum01:32:04

  • Day 4: Data Wrangling and Cleaning
  • Recap of Day 3 00:07:57
  • Functions in Excel 00:08:15
  • Your First Function: Part I 00:18:14
  • Your First Function: Part II 00:11:45
  • Mutating Data with assign() 00:17:33
  • Using Lambdas with assign() 00:12:16
  • Data Wrangling 00:16:04

About this course

In this course, Dave covers how to define a function in Python in Excel. You'll then apply this knowledge to mutate or change DataFrames using the assign() method and also learn how to use a lambda with this method. 

This course is Part 4 of the five-course series in the Data Analysis with Python in Excel learning path.

Curriculum01:32:04

  • Day 4: Data Wrangling and Cleaning
  • Recap of Day 3 00:07:57
  • Functions in Excel 00:08:15
  • Your First Function: Part I 00:18:14
  • Your First Function: Part II 00:11:45
  • Mutating Data with assign() 00:17:33
  • Using Lambdas with assign() 00:12:16
  • Data Wrangling 00:16:04