analyse_spreadsheet

analyse_spreadsheet.get_spreadsheet_columns(file_loc, print_columns=False)

Gets and prints the spreadsheet’s header columns

Parameters

• file_loc (str) – The file location of the spreadsheet

• print_columns (bool, optional) – A flag used to print the columns to the console (default is False)

Returns

a list of strings used that are the header columns

analyse_spreadsheet.main()

Analyse a spreadsheet file with temperatures.

Prompt the user for the file name, print the columns in the spreadsheet, and print the mean temperature.

analyse_spreadsheet.mean_temperature(data)

Get the mean temperature

Parameters

data (pandas.DataFrame) – A pandas dataframe with air temperature measurements.

Returns

The mean air temperature (float)