Chapter materials

The materials for this chapter can be found on GitHub at https://github.com/stefmolin/Hands-On-Data-Analysis-with-Pandas-2nd-edition/tree/master/ch_04. There are four notebooks that we will work through, each numbered according to when they will be used. The text will prompt you to switch. We will begin with the 1-querying_and_merging.ipynb notebook to learn about querying and merging dataframes. Then, we will move on to the 2-dataframe_operations.ipynb notebook to discuss data enrichment through operations such as binning, window functions, and pipes. For this section, we will also use the window_calc.py Python file, which contains a function for performing window calculations using pipes.

Tip

The understanding_window_calculations.ipynb notebook contains some interactive visualizations for understanding window functions. This may require some additional setup, but the instructions are in the notebook.

Next, in the 3-aggregations.ipynb notebook, we will discuss...