import pandas as pd

import seaborn as sns

import matplotlib.pyplot as plt

$\%$matplotlib inline

pd$.$options.display.float$\_$format $=\text{'}\{$:$\mathrm{.}2$f$\}\text{'}.$format

def produce$\_$summary$\_$table$($dfraw $=$ pd$.$read$\_$excel$(\text{'}$WHR$2018$Chapter$2$OnlineData.xls$\text{'},$ sheet$\_$name$=$'Table$2\mathrm{.}1\text{'})$

$)$:

cols$\_$to$\_$include $=[\text{'}$country$\text{'},$ 'year', 'Life Ladder',

'Positive affect','Negative affect',

'Log GDP per capita', 'Social support',

'Healthy life expectancy at birth',

'Freedom to make life choices',

'Generosity', 'Perceptions of corruption'$]$

df $=$ dfraw$[$cols$\_$to$\_$include$]$

column$\_$renaming $=\{\text{'}$count$\text{'}$: $\text{'}$N$\text{'},$ 'mean': 'Mean', $\text{'}$std$\text{'}$: $\text{'}$Std$.$ Dev.$\text{'},$ 'min': 'Min.$\text{'},$ 'max': 'Max.$\text{'}\}$

column$\_$order $=[\text{'}$Mean$\text{'},\text{'}$Std$.$ Dev.$\text{'},$ 'Min.$\text{'},$ 'Max.$\text{'},\text{'}$N$\text{'}]$

df$\_$transposed$2=$ df$.$describe$().$T

df$\_$transposed$2$

df$\_$transposed$2=$ df$\_$transposed$2.$drop$(\text{'}$year$\text{'})$

df$\_$transposed$2$

df$\_$dropped$2=$ df$\_$transposed$2.$drop$([\text{'}25\%\text{'},\text{'}50\%\text{'},\text{'}75\%\text{'}],$ axis$=1)$

df$\_$dropped$2$

df$\_$renamed$2=$ df$\_$dropped$2.$rename$($columns$=$column$\_$renaming$)$

dfsummary$2=$ df$\_$renamed$2$

dfsummary$2[\text{'}$N$\text{'}]=$ dfsummary$2[\text{'}$N$\text{'}].$astype$($int$)$

return dfsummary$2$

df$\_$summary$\_$new $=$ produce$\_$summary$\_$table$()$

df $=$ df$\_$summary$\_$new$[$column$\_$order$]$

df

In the empty code cell below, do the following:

Create three new dataframes for each of the year ranges associated with Tables $5,6,$ and $7,$ by extracting the appropriate set of years. Using the function you wrote above, create a summary table for each dataframe $($your function takes a dataframe as input$).$ Assign the resulting summary tables to the names dfsummary$0507,$ dfsummary$0810,$ and dfsummary$1517.$

The remaining three code cells below are populated with the table names dfsummary$0507,$ dfsummary$0810,$ and dfsummary$1517.$ Once you have created these summary tables as outlined above, execute these cells to compare your tables with the corresponding tables in WHR Appendix $1.$