From the course: Data Cleaning and Manipulating with Python in Excel
Join today to access over 24,900 courses taught by industry experts.
Solution: Data cleaning
From the course: Data Cleaning and Manipulating with Python in Excel
Solution: Data cleaning
(bright rhythmic music) (bright rhythmic music ending) - [Instructor] I hope you enjoyed working on your first assignment with Python, in Excel. I'll be alongside you as we go through each step to ensure all of our work is accurate and correct. You just finished working in the Challenge tab, now let's open this Solution tab in the chapter one exercise file. So what we got over here is a few things. The first thing I want to look at really quickly is the DataFrame, which once again, taking everything from A1 to D14. And underneath that, you'll see the Removed Duplicates. And what this is doing, it's removing all duplicated rows within the dataset. Everything that we see in here, we're going to be applying to this specific DataFrame. So for now on, for the rest of the challenge, we are referencing to the "new_df," for our DataFrame. So the first thing we want to do, like I said, is taking that Date column from the short date into a log date. So let's head over to I1, click on Insert…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.