Pandas Workout Version 6

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