Task 10

Detailed summary report

With all this data cleaning, analysis, and visualization, let's create detailed summary tables of my training.

To do this, we'll create two tables. The first table will be a summary of the distance (km) and climb (m) variables for each training activity. The second table will list the summary statistics for the average speed (km/hr), climb (m), and distance (km) variables for each training activity.

Create a summary report.

  • Concatenate the df_run DataFrame with df_walk and df_cycle using append(), then sort based on the index in descending order. Assign the result to df_run_walk_cycle.

  • Group df_run_walk_cycle by activity type, then select the columns in dist_climb_cols. Sum the result using sum(). Assign the result to df_totals.

  • Use the stack() method on df_summary to show a compact reshaped form of the full summary report.

Last updated