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.
Solution: Bringing it all together
From the course: Data Analysis with Python and Pandas
Solution: Bringing it all together
- [Instructor] All right, everybody. Our solution code is up on the right. This was definitely more involved than any of the other assignments. So if you got tripped up, hopefully you were able to take a peek at the solution code and get back on the track. But let's go ahead and walk through this step by step. We had our data read in for us. We have our family array and our sales array. The first step was to filter sales array to include only transactions where family array was equal to produce. So we need to specify sales array. Then we want to filter it to family array equals produce. It's all caps in the data. And then let's... All right, so we have, it looks like, about 30 sales. Let's just take a quick look at the size of this array. And it is indeed 30. So if you got 30 here, that means we're working with the exact same data. So let's go ahead and call this produce array. And we'll store that array here. The next piece was sampling this down to be roughly half of the current…
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)
-
-
-
-
-
-
-
-
-