Python Business Intelligence Cookbook

Generating summary statistics for a single column

In addition to creating summary statistics for our entire dataset, we can use the same functions to create summary statistics for a single column.

How to do it…

1. To generate summary statistics for a single column of a Pandas DataFrame, begin by importing the required libraries:

   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, select the ...