Reshaping and Pivot Tables

Take a look at the wine dataset:

df.head()

Output:

+-------+--------------------------+---------+----------+
|       | variety                  |   price |   points |
|-------+--------------------------+---------+----------|
| 26762 | Cabernet Sauvignon       |      45 |       91 |
| 15006 | Pinot Noir               |      41 |       94 |
| 25680 | Pinot Noir               |      40 |       91 |
| 16316 | Bordeaux-style Red Blend |      32 |       88 |
|  2916 | Pinot Noir               |      28 |       91 |
+-------+--------------------------+---------+----------+

Print one instruction to find the mean points by the variety and price. As the price varies, divide them into 4 categories. The easiest way to achieve it is to use pd.cut() with the proper parameters:

pd.cut(df.price, bins=[10, 20, 30, 40, 50])

The first argument here is the series we divide, and the second — an array of border values for the categories.

You can pass it directly to the columns argument.

Tip: look into the index and values parameters of the .pivot_table() method.