Indexing, grouping, reshaping and merging, with the traps that cost people days.
Before this guide: NumPy, Deep Dive.
The notebooks
None of these notebooks is written yet. This is the plan, in reading order.
| 1 | Why PandasTables with labels, and what that buys you | not yet written |
| 2 | SeriesThe labeled array, and the index you did not ask for | not yet written |
| 3 | DataFrameConstruction, and looking at the shape of your data | not yet written |
| 4 | Reading Dataread_csv, and the arguments that actually matter | not yet written |
| 5 | Inspectinghead, info, describe, dtypes, and reading them properly | not yet written |
| 6 | Selecting ColumnsThe two syntaxes, and which one to prefer | not yet written |
| 7 | loc and ilocLabel against position, and the error you keep hitting | not yet written |
| 8 | Boolean FilteringMasks, and combining conditions without a subtle bug | not yet written |
| 9 | The IndexWhat it is for, setting it, resetting it, and multi-level | not yet written |
| 10 | Missing DataNaN against None, and what dropna actually drops | not yet written |
| 11 | Adding and Changing Columnsassign, and SettingWithCopyWarning finally explained | not yet written |
| 12 | groupbySplit, apply, combine, and what the object before .agg is | not yet written |
| 13 | AggregatingMultiple functions, named output, and transform against agg | not yet written |
| 14 | Reshapingpivot, melt, and long against wide as a decision | not yet written |
| 15 | MergingThe four joins, and the duplicate key that invents rows | not yet written |
| 16 | Dates and TimesParsing, time zones, and resampling a series | not yet written |
| 17 | StringsThe .str accessor, and vectorized text work | not yet written |
| 18 | Performance and Memorydtypes, categories, and reading a file too big for memory | not yet written |