From the course: Data Analysis with Python and Pandas
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Challenge: Aggregation and sorting
From the course: Data Analysis with Python and Pandas
Challenge: Aggregation and sorting
- [Instructor] All right, everybody. We got a new message in from Ross Retail. Subject line is top tier products. He writes us. Hey there, thank you for all your hard work. I know we're working with small sample sizes, but we're proving that analysis can be done in Python. Can you calculate the mean, min, max, and median of our three most expensive product prices? Then calculate the number of unique price tiers we have. Thanks. Once again, we'll be working out of our section one NumPy assignments notebook. We'll also be provided with a price tiers array in our notebook. Let's take a quick look. All right, so we're going to be working with the same array of prices that we created in assignment four. So if you're still working in the same session, you're working through this all at once, you won't need to recreate this array. But if you are, you'll need to go ahead and grab that array from up in assignment four. Once you've created the price array, we're going to want to grab the three…
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.
Contents
-
-
-
(Locked)
pandas and NumPy intro2m 53s
-
(Locked)
NumPy arrays and array properties7m 41s
-
(Locked)
Challenge: Array basics1m 47s
-
(Locked)
Solution: Array basics2m 2s
-
(Locked)
Array creation8m 13s
-
(Locked)
Random number generation5m 58s
-
(Locked)
Challenge: Array creation1m 30s
-
(Locked)
Solution: Array creation4m 22s
-
(Locked)
Indexing and slicing arrays9m 9s
-
(Locked)
Challenge: Indexing and slicing arrays1m 6s
-
(Locked)
Solution: Indexing and slicing arrays2m 23s
-
(Locked)
Array operations7m 45s
-
(Locked)
Challenge: Array operations2m 6s
-
(Locked)
Solution: Array operations4m 16s
-
(Locked)
Filtering arrays and modifying array values10m 56s
-
(Locked)
The where() function4m
-
(Locked)
Challenge: Filtering and modifying arrays1m 57s
-
(Locked)
Solution: Filtering and modifying arrays3m 11s
-
(Locked)
Array aggregation6m 51s
-
(Locked)
Array functions7m 41s
-
(Locked)
Sorting arrays3m 51s
-
(Locked)
Challenge: Aggregation and sorting1m 11s
-
(Locked)
Solution: Aggregation and sorting1m 35s
-
(Locked)
Vectorization4m 19s
-
(Locked)
Broadcasting7m 8s
-
(Locked)
Challenge: Bringing it all together2m 45s
-
(Locked)
Solution: Bringing it all together6m 18s
-
(Locked)
Key takeaways1m 56s
-
(Locked)
-
-
-
-
-
-
-
-
-