Hands-On Exploratory Data Analysis with Python

Grouping columns

We have already discussed several ways in which we can group columns and rows using the pandas dataframe in Chapter 6, Grouping Dataset. In this section, we will use the same technique to group different columns together:

1. Let's use the combined dataframe and group them using the columns, alcohol, density, pH, and quality.
2. Next, we can apply the pd.describe() method to get the most frequently used descriptive statistics:

subset_attr = ['alcohol', 'density', 'pH', 'quality']low = round(df_wines[df_wines['quality_label'] == 'low'][subset_attr].describe(), 2)medium = round(df_wines[df_wines['quality_label'] == 'medium'][subset_attr].describe(), 2)high = round(df_wines[df_wines['quality_label'] == 'high'][subset_attr].describe(), ...