Pandas Workout Version 6

Description

Pandas Workout MEAP V06 Copyright welcome brief contents Chapter 1: Series 1.1 Useful references 1.2 Exercise 1: Test scores 1.2.1 Solution 1.2.2 Discussion 1.2.3 Beyond the exercise 1.3 Exercise 2: Scaling test scores 1.3.1 Solution 1.3.2 Discussion 1.3.3 Beyond the exercise 1.4 Exercise 3: Counting 10s digits 1.4.1 Solution 1.4.2 Discussion 1.4.3 Beyond the exercise 1.5 Exercise 4: Descriptive statistics 1.5.1 Solution 1.5.2 Discussion 1.5.3 Beyond the exercise 1.6 Exercise 5: Monday temperatures 1.6.1 Solution 1.6.2 Discussion 1.6.3 Beyond the exercise 1.7 Exercise 6: Passenger frequency 1.7.1 Solution 1.7.2 Discussion 1.7.3 Beyond the exercise 1.8 Exercise 7: Long, medium, and short taxi rides 1.8.1 Solution 1.8.2 Discussion 1.8.3 Beyond the exercise 1.9 Summary Chapter 2: Data frames 2.1 Useful references 2.2 Exercise 8: Net revenue 2.2.1 Solution 2.2.2 Discussion 2.2.3 Beyond the exercise 2.3 Exercise 9: Tax planning 2.3.1 Solution 2.3.2 Discussion 2.3.3 Beyond the exercise 2.4 Exercise 10: Adding new products 2.4.1 Solution 2.4.2 Discussion 2.4.3 Beyond the exercise 2.5 Exercise 11: Best sellers 2.5.1 Solution 2.5.2 Discussion 2.5.3 Beyond the exercise 2.6 Exercise 12: Finding outliers 2.6.1 Solution 2.6.2 Discussion 2.6.3 Beyond the exercise 2.7 Exercise 13: Interpolation 2.7.1 Solution 2.7.2 Discussion 2.7.3 Beyond the exercise 2.8 Exercise 14: Selective updating 2.8.1 Solution 2.8.2 Discussion 2.8.3 Beyond the exercise 2.9 Summary Chapter 3: Importing and exporting data 3.1 Useful references 3.2 Exercise 15: Weird taxi rides 3.2.1 Solution 3.2.2 Discussion 3.2.3 Beyond the exercise 3.3 Exercise 16: Pandemic taxis 3.3.1 Solution 3.3.2 Discussion 3.3.3 Beyond the exercise 3.4 Exercise 17: Setting column types 3.4.1 Solution 3.4.2 Discussion 3.4.3 Beyond the exercise 3.5 Exercise 18: passwd to df 3.5.1 Solution 3.5.2 Discussion 3.5.3 Beyond the exercise 3.6 Exercise 19: Bitcoin values 3.6.1 Solution 3.6.2 Discussion 3.6.3 Beyond the exercise 3.7 Exercise 20: Big cities 3.7.1 Solution 3.7.2 Discussion 3.7.3 Beyond the exercise 3.8 Summary Chapter 4: Indexes 4.1 Useful references 4.2 Exercise 21: Parking tickets 4.2.1 Discussion 4.2.2 Solution 4.2.3 Beyond the exercise 4.3 Exercise 22: State SAT scores (learning goal: setting and using a multi-index) 4.3.1 Discussion 4.3.2 Solution 4.3.3 Beyond the exercise 4.4 Exercise 23: Olympic games 4.4.1 Discussion 4.4.2 Solution 4.4.3 Beyond the exercise 4.5 Exercise 24: Olympic pivots 4.5.1 Discussion 4.5.2 Solution 4.5.3 Beyond the exercise 4.6 Summary Chapter 5: Cleaning data 5.1 Useful references 5.2 Exercise 25: Parking cleanup 5.2.1 Discussion 5.2.2 Solution 5.2.3 Beyond the exercise 5.3 Exercise 26: Celebrity deaths 5.3.1 Discussion 5.3.2 Solution 5.3.3 Beyond the exercise 5.4 Exercise 27: Titanic interpolation 5.4.1 Discussion 5.4.2 Solution 5.4.3 Beyond the exercise 5.5 Exercise 28: Inconsistent data 5.5.1 Discussion 5.5.2 Solution 5.5.3 Beyond the exercise 5.6 Summary Chapter 6: Grouping, joining, and sorting 6.1 Useful references 6.2 Exercise 29: Longest taxi rides 6.2.1 Discussion 6.2.2 Solution 6.2.3 Beyond the exercise 6.3 Exercise 30: Taxi ride comparisons 6.3.1 Discussion 6.3.2 Solution 6.3.3 Beyond the exercise 6.4 Exercise 31: Tourist spending per country 6.4.1 Discussion 6.4.2 Solution 6.4.3 Beyond the exercise 6.5 Exercise 32: Multi-city temperatures 6.5.1 Discussion 6.5.2 Solution 6.5.3 Beyond the exercise 6.6 Exercise 33: SAT scores, revisited 6.6.1 Discussion 6.6.2 Solution 6.6.3 Beyond the exercise 6.7 Exercise 34: Snowy, rainy cities 6.7.1 Discussion 6.7.2 Solution 6.7.3 Beyond the exercise 6.8 Exercise 35: Wine scores and tourism spending 6.8.1 Discussion 6.8.2 Solution 6.8.3 Beyond the exercise 6.9 Summary