Working with dataFree

Pandas

Reading, inspecting, filtering and summarising real data with Python. From a CSV file to a grouped total — six steps and a ten-question quiz in every chapter.

The six steps in every chapter

1Encounter
2Understand
3Worked
4Predict
5Apply
6Stretch

01Installing pandas, and your first table25 min10 questionsRead Play· 8 min
02Series and DataFrame — the two things in pandas30 min10 questionsRead Play· 8 min
03Reading a CSV, and checking what arrived30 min10 questionsRead Play· 8 min
04Selecting columns and rows — by name or by place45 min10 questionsRead Play· 9 min
05Filtering rows — asking every row the same question45 min10 questionsRead Play· 9 min
06Missing data — finding the gaps, then deciding what they mean45 min10 questionsRead Play· 9 min
07Sorting rows — and deciding what happens to ties40 min10 questionsRead Play· 9 min
08Grouping and aggregation — one answer per group45 min10 questionsRead Play· 9 min
09Adding columns — making the numbers the file does not have50 min10 questionsRead Play· 9 min
10Combining DataFrames — stacking with concat, matching with merge50 min10 questionsRead Play· 10 min