Pandas Workout: 200 exercises to make you a stronger data analyst

Pandas Workout
brief contents
contents
preface
acknowledgments
about this book
	Who should read this book
	How this book is organized: A road map
	About the code
	Software/hardware requirements
	liveBook discussion forum
about the author
about the cover illustration
1 Series
	Useful references
	Exercise 1 - Test scores
		Working it out
		Solution
		Beyond the exercise
	Exercise 2 - Scaling test scores
		Working it out
		Solution
		Beyond the exercise
	Exercise 3 - Counting tens digits
		Working it out
		Solution
		Beyond the exercise
	Exercise 4 - Descriptive statistics
		Working it out
		Solution
		Beyond the exercise
	Exercise 5 - Monday temperatures
		Working it out
		Solution
		Beyond the exercise
	Exercise 6 - Passenger frequency
		Working it out
		Solution
		Beyond the exercise
	Exercise 7 - Long, medium, and short taxi rides
		Working it out
		Solution
		Beyond the exercise
	Summary
2 Data frames
	Exercise 8 - Net revenue
		Working it out
		Solution
		Beyond the exercise
	Exercise 9 - Tax planning
		Working it out
		Solution
		Beyond the exercise
	Exercise 10 - Adding new products
		Working it out
		Solution
		Beyond the exercise
	Exercise 11 - Bestsellers
		Working it out
		Solution
		Beyond the exercise
	Exercise 12 - Finding outliers
		Working it out
		Solution
		Beyond the exercise
	Exercise 13 - Interpolation
		Working it out
		Solution
		Beyond the exercise
	Exercise 14 - Selective updating
		Working it out
		Solution
		Beyond the exercise
	Summary
3 Importing and exporting data
	Exercise 15 - Weird taxi rides
		Working it out
		Solution
		Beyond the exercise
	Exercise 16 - Pandemic taxis
		Working it out
		Solution
		Beyond the exercise
	Exercise 17 - Setting column types
		Working it out
		Beyond the exercise
	Exercise 18 - passwd to df
		Working it out
		Solution
		Beyond the exercise
	Exercise 19 - Bitcoin values
		Working it out
		Solution
		Beyond the exercise
	Exercise 20 - Big cities
		Working it out
		Solution
		Beyond the exercise
	Summary
4 Indexes
	Exercise 21 - Parking tickets
		Working it out
		Solution
		Beyond the exercise
	Exercise 22 - State SAT scores
		Working it out
		Solution
		Beyond the exercise
	Exercise 23 - Olympic games
		Working it out
		Solution
		Beyond the exercise
	Exercise 24 - Olympic pivots
		Working it out
		Solution
		Beyond the exercise
	Summary
5 Cleaning data
	Exercise 25 - Parking cleanup
		Working it out
		Solution
		Beyond the exercise
	Exercise 26 - Celebrity deaths
		Working it out
		Solution
		Beyond the exercise
	Exercise 27 - Titanic interpolation
		Working it out
		Solution
		Beyond the exercise
	Exercise 28 - Inconsistent data
		Working it out
		Solution
		Beyond the exercise
	Summary
6 Grouping, joining, and sorting
	Exercise 29 - Longest taxi rides
		Working it out
		Solution
		Beyond the exercise
	Exercise 30 - Taxi ride comparison
		Working it out
		Solution
		Beyond the exercise
	Exercise 31 - Tourist spending per country
		Working it out
		Solution
		Beyond the exercise
	Summary
7 Advanced grouping, joining, and sorting
	Exercise 32 - Multicity temperatures
		Working it out
		Solution
		Beyond the exercise
	Exercise 33 - SAT scores, revisited
		Working it out
		Solution
		Beyond the exercise
	Exercise 34 - Snowy, rainy cities
		Working it out
		Solution
		Beyond the exercise
	Exercise 35 - Wine scores and tourism spending
		Working it out
		Solution
		Beyond the exercise
	Summary
8 Midway project
	Problem
		Working it out
	Solution
	Summary
9 Strings
	Exercise 36 - Analyzing Alice
		Working it out
		Solution
		Beyond the exercise
	Exercise 37 - Wine words
		Working it out
		Solution
		Beyond the exercise
	Exercise 38 - Programmer salaries
		Working it out
		Solution
		Beyond the exercise
	Summary
10 Dates and times
	Exercise 39 - Short, medium, and long taxi rides
		Working it out
		Solution
		Beyond the exercise
	Exercise 40 - Writing dates, reading dates
		Working it out
		Solution
		Beyond the exercise
	Exercise 41 - Oil prices
		Working it out
		Solution
		Beyond the exercise
	Exercise 42 - Best tippers
		Working it out
		Solution
		Beyond the exercise
	Summary
11 Visualization
	Exercise 43 - Cities
		Working it out
		Solution
		Beyond the exercise
	Exercise 44 - Boxplotting weather
		Working it out
		Solution
		Beyond the exercise
	Exercise 45 - Taxi fare breakdown
		Working it out
		Solution
		Beyond the exercise
	Exercise 46 - Cars, oil, and ice cream
		Working it out
		Solution
		Beyond the exercise
	Exercise 47 - Seaborn taxi plots
		Working it out
		Solution
		Beyond the exercise
	Summary
12 Performance
	Exercise 48 - Categories
		Working it out
		Solution
		Beyond the exercise
	Exercise 49 - Faster reading and writing
		Working it out
		Solution
		Beyond the exercise
	Exercise 50 - “query” and “eval”
		Working it out
		Solution
		Beyond the exercise
	Summary
13 Final project
	Problem
	Column names and meanings
		Working it out
	Summary
index
	Symbols
	A
	B
	C
	D
	E
	F
	G
	H
	I
	J
	K
	L
	M
	N
	O
	P
	Q
	R
	S
	T
	U
	V
	W
	X
Pandas Workout - back