Python Business Intelligence Cookbook

Generating summary statistics for object type columns

By default, the describe() function restricts the stats to numerical or categorical columns. Use the following to include object columns:

How to do it…

1. To generate the summary statistics for object type columns in a Pandas DataFrame, begin by importing the libraries needed:

   import pandas as pd

2. Next, import the dataset from the CSV file:

   accidents_data_file = '/Users/robertdempsey/Dropbox/private/Python Business Intelligence Cookbook/Data/Stats19-Data1979-2004/Accidents7904.csv'
   accidents = pd.read_csv(accidents_data_file,
                           sep=',',
                           header=0,
                           index_col=False,
                           parse_dates=['Date'],
                           dayfirst=True,
                           tupleize_cols=False,
                           error_bad_lines=True,
                           warn_bad_lines=True,
                           skip_blank_lines=True
                           )

3. Finally, use the ...