Python Business Intelligence Cookbook

Getting the minimum and maximum values of a single column

One simple operation that we can perform on our dataset is to view the minimum and maximum values for a single column.

How to do it…

1. To get the minimum and maximum values of a single column, 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, print out the minimum and maximum values for ...