From the course: Data Cleaning and Manipulating with Python in Excel
Join today to access over 24,900 courses taught by industry experts.
Grouping data
From the course: Data Cleaning and Manipulating with Python in Excel
Grouping data
- [Instructor] I don't know if it's just me, but I'm able to come up with some amazing insights from grouping data. It's an awesome feeling. In my personal opinion, being able to properly group data can elevate your analysis to some pretty insightful levels. So, in this video we'll dive into the insights we can get from grouping data. We also learn how to group data by using Python in Excel. Finally, will look into different ways into grouping data and how Python can allow the flexibility we need to do so. Okay, enough talking, let's get right into this. So, let's open up the exercise file for this video. We'll use the Chapter 3, 03_03 tab. Okay, so we got a little bit of information here. We have some Dates, Cities, Profit, Quarter and Sales_Count. So, there's a lot going on here, and especially because the dates, I mean we could see, they're all over the place, they are not in a good order, so we definitely want to try to group some information here to pull out some insights. So…
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.