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 the selected column:
    print("Min Value: {}".format(accidents['Number_of_Vehicles'].min()))
print("Max Value: {}".format(accidents['Number_of_Vehicles'].max()))

How it works…

We begin by importing the Python libraries we need and by creating a DataFrame from the source data. We then use the min() and max() functions on the 'Number_of_Vehicles' column of the accidents DataFrame in order to view the numbers.

How it works…
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset