.ipynb .pdf

repository open issue suggest edit

Contents

Pandas Notebook 6: GroupBy + Split/Apply/Combine

---

Overview

1. Read in and customize a DataFrame, using default row index

2. Split/Apply/Combine

3. Analyze DataFrames produced by the S/A/C technique

Prerequisites

Concepts	Importance	Notes
Pandas notebooks 1-8	Necessary

• Time to learn: 20 minutes

Imports

import pandas as pd
import numpy as np
from datetime import datetime

Read in NYSM 5-minute data from a particular day. Use the default row and column index names, but convert the date/time data from String to datetime. Explicitly set the timezone.

nysm_data_file = '/spare11/atm533/data/nysm_data_20210902.csv'

timeFormat = "%Y-%m-%d %H:%M:%S UTC"
parseTime = lambda x: datetime.strptime(x, timeFormat)

nysm_data = pd.read_csv(nysm_data_file,parse_dates=['time'], date_parser=parseTime)
nysm_data['time'].dt.tz_localize(tz='UTC')

0       2021-09-02 00:00:00+00:00
1       2021-09-02 00:05:00+00:00
2       2021-09-02 00:10:00+00:00
3       2021-09-02 00:15:00+00:00
4       2021-09-02 00:20:00+00:00
                   ...           
36283   2021-09-02 23:35:00+00:00
36284   2021-09-02 23:40:00+00:00
36285   2021-09-02 23:45:00+00:00
36286   2021-09-02 23:50:00+00:00
36287   2021-09-02 23:55:00+00:00
Name: time, Length: 36288, dtype: datetime64[ns, UTC]

Remove unwanted columns

nysm_data.drop(['temp_9m [degC]',
       'avg_wind_speed_prop [m/s]', 'max_wind_speed_prop [m/s]','wind_speed_stddev_prop [m/s]', 'wind_direction_prop [degrees]',
       'wind_direction_stddev_prop [degrees]','wind_speed_stddev_sonic [m/s]','wind_direction_stddev_sonic [degrees]', 'solar_insolation [W/m^2]','snow_depth [cm]', 'frozen_soil_05cm [bit]',
       'frozen_soil_25cm [bit]', 'frozen_soil_50cm [bit]',
       'soil_temp_05cm [degC]', 'soil_temp_25cm [degC]',
       'soil_temp_50cm [degC]', 'soil_moisture_05cm [m^3/m^3]',
       'soil_moisture_25cm [m^3/m^3]', 'soil_moisture_50cm [m^3/m^3]'],inplace=True,axis='columns')

Each dataframe has varying column names. Let’s standardize by creating a dictionary that will map current column names to common (and in some cases, much shorter) names.

column_mapping = {'station' : 'STID',
                  'time': 'TIME',
                  'temp_2m [degC]': 'TMPC',
                  'relative_humidity [percent]': 'RELH',
                  'precip_incremental [mm]': 'PRCP',
                  'precip_local [mm]': 'PTOT',
                  'precip_max_intensity [mm/min]': 'PRAT',
                  'avg_wind_speed_sonic [m/s]': 'SPED',
                  'max_wind_speed_sonic [m/s]': 'GUMS',
                  'wind_direction_sonic [degrees]': 'DRCT', 
                  'station_pressure [mbar]': 'PRES',
                  'stid': 'STID',
                  'name': 'NAME',
                  'lat': 'SLAT',
                  'lon': 'SLON',
                  'elevation': 'SELV',
                  'STN':  'STID',
                  'YYMMDD/HHMM': 'TIME'}

Rename the columns according to our dictionary. Then examine each Dataframe to see how they look.

nysm_data.rename(columns=column_mapping, inplace=True)

nysm_data.head()

	STID	TIME	TMPC	RELH	PRCP	PTOT	PRAT	SPED	GUMS	DRCT	PRES
0	ADDI	2021-09-02 00:00:00	14.8	93.1	0.0	9.56	0.0	3.3	6.8	350.0	951.16
1	ADDI	2021-09-02 00:05:00	14.6	93.3	0.0	0.00	0.0	3.2	5.0	355.0	951.20
2	ADDI	2021-09-02 00:10:00	14.6	93.6	0.0	0.00	0.0	3.2	5.6	350.0	951.25
3	ADDI	2021-09-02 00:15:00	14.6	93.7	0.0	0.00	0.0	3.3	6.1	345.0	951.27
4	ADDI	2021-09-02 00:20:00	14.5	93.9	0.0	0.00	0.0	2.9	5.4	347.0	951.24

The NYSM data does not contain dewpoint nor sea-level pressure yet. Calculate and create a column for dewpoint; for the purposes of this notebook, we’ll not do the SLP conversion.

tmpc = nysm_data['TMPC']
rh = nysm_data['RELH']

nysm_data['DWPC'] = 243.04*(np.log(rh/100)+((17.625*tmpc)/(243.04+tmpc)))/(17.625-np.log(rh/100)-((17.625*tmpc)/(243.04+tmpc)))

Let’s rearrange the columns into a more logical order.

colOrder = ['STID','TIME','TMPC','DWPC','RELH','PRES','DRCT','SPED','GUMS','PRCP','PTOT','PRAT']

nysm_data = nysm_data.reindex(columns=colOrder)

nysm_data

	STID	TIME	TMPC	DWPC	RELH	PRES	DRCT	SPED	GUMS	PRCP	PTOT	PRAT
0	ADDI	2021-09-02 00:00:00	14.8	13.695132	93.1	951.16	350.0	3.3	6.8	0.0	9.56	0.0
1	ADDI	2021-09-02 00:05:00	14.6	13.529815	93.3	951.20	355.0	3.2	5.0	0.0	0.00	0.0
2	ADDI	2021-09-02 00:10:00	14.6	13.579158	93.6	951.25	350.0	3.2	5.6	0.0	0.00	0.0
3	ADDI	2021-09-02 00:15:00	14.6	13.595575	93.7	951.27	345.0	3.3	6.1	0.0	0.00	0.0
4	ADDI	2021-09-02 00:20:00	14.5	13.529116	93.9	951.24	347.0	2.9	5.4	0.0	0.00	0.0
...	...	...	...	...	...	...	...	...	...	...	...	...
36283	YORK	2021-09-02 23:35:00	15.9	10.391971	69.8	997.14	348.0	2.4	4.2	0.0	0.21	0.0
36284	YORK	2021-09-02 23:40:00	15.9	10.477679	70.2	997.25	352.0	2.6	3.8	0.0	0.21	0.0
36285	YORK	2021-09-02 23:45:00	15.6	10.486061	71.6	997.28	351.0	1.9	3.7	0.0	0.21	0.0
36286	YORK	2021-09-02 23:50:00	15.5	10.494359	72.1	997.31	346.0	2.5	3.8	0.0	0.21	0.0
36287	YORK	2021-09-02 23:55:00	15.1	10.438479	73.7	997.33	335.0	1.6	2.8	0.0	0.21	0.0

36288 rows × 12 columns

Split-Apply-Combine

Now go through the Split-Apply-Combine methodology, as defined by Wickham, 2011 and illustrated by McKinney, 2017 (see refs at end of notebook)

Split: Group by station id

grouped = nysm_data.groupby(['STID'])

grouped

<pandas.core.groupby.generic.DataFrameGroupBy object at 0x154cef5b5660>

This has split the DataFrame into a Pandas groupby object.

Apply and Combine:

Now we apply a function on the now-split groups, which then combines the group and the values returned by the function into a new DataFrame.

One built-in groupby function is describe. It returns a DataFrame containing summary statistics, grouped by station, for each column that contains numerical values:

%time df_stns = grouped.describe() # Depending on the size of your DataFrame, this may take a while

CPU times: user 1.3 s, sys: 2.63 ms, total: 1.3 s
Wall time: 1.34 s

df_stns

	TMPC								DWPC		...	PTOT		PRAT
	count	mean	std	min	25%	50%	75%	max	count	mean	...	75%	max	count	mean	std	min	25%	50%	75%	max
STID
ADDI	288.0	14.271528	3.125854	9.7	11.100	13.95	17.300	19.6	288.0	9.204249	...	0.00	9.56	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00
ANDE	288.0	13.407986	2.235563	8.4	12.000	13.90	14.925	17.2	288.0	10.810978	...	17.75	17.75	288.0	0.006215	0.027760	0.0	0.0	0.0	0.0	0.16
BATA	288.0	15.638194	2.343974	11.5	13.600	15.25	18.000	19.4	288.0	9.227600	...	0.00	0.00	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00
BEAC	288.0	17.753819	3.013903	13.8	15.500	16.70	20.600	23.5	288.0	12.641771	...	79.67	79.67	288.0	0.067465	0.152948	0.0	0.0	0.0	0.0	0.73
BELD	288.0	13.853819	2.040834	10.1	11.875	14.25	15.700	17.4	288.0	10.136218	...	1.16	21.18	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
WFMB	288.0	12.269097	1.371683	8.7	11.500	12.70	13.000	15.5	288.0	7.849320	...	0.00	0.00	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00
WGAT	288.0	12.063542	1.969053	7.4	11.200	12.75	13.500	15.2	288.0	9.174838	...	0.00	0.00	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00
WHIT	288.0	16.662500	2.213480	11.0	15.700	16.60	18.500	20.9	288.0	12.435882	...	0.00	0.00	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00
WOLC	288.0	16.313542	2.074129	11.2	15.800	17.25	17.700	18.9	288.0	10.668820	...	0.08	1.14	288.0	0.005521	0.030267	0.0	0.0	0.0	0.0	0.33
YORK	288.0	14.451389	4.553384	7.9	10.000	13.60	19.125	21.2	288.0	9.824237	...	0.21	0.21	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00

126 rows × 80 columns

Analyze DataFrames produced by the S/A/C technique

Tip: This is just another Pandas DataFrame, but with a multiple (i.e. hierarchical) column index ("under the hood", the Multiindexing we demonstrated in Pandas_06 uses `groupby`), and thus we could subset on selected rows and columns / sub-columns from it.

Five-minute and daily accumulated precip:

df_stns[['PRCP','PTOT']]

	PRCP								PTOT
	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max
STID
ADDI	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00	288.0	0.033194	0.563328	0.00	0.00	0.00	0.00	9.56
ANDE	288.0	0.062743	0.148921	0.0	0.0	0.0	0.0	0.72	288.0	16.469479	3.515075	0.31	17.75	17.75	17.75	17.75
BATA	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00	288.0	0.000000	0.000000	0.00	0.00	0.00	0.00	0.00
BEAC	288.0	0.280833	0.619803	0.0	0.0	0.0	0.0	2.99	288.0	72.594826	17.891962	1.00	79.67	79.67	79.67	79.67
BELD	288.0	0.004792	0.029217	0.0	0.0	0.0	0.0	0.26	288.0	1.218507	1.183041	0.21	1.16	1.16	1.16	21.18
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
WFMB	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00	288.0	0.000000	0.000000	0.00	0.00	0.00	0.00	0.00
WGAT	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00	288.0	0.000000	0.000000	0.00	0.00	0.00	0.00	0.00
WHIT	288.0	0.000000	0.000000	0.0	0.0	0.0	0.0	0.00	288.0	0.000000	0.000000	0.00	0.00	0.00	0.00	0.00
WOLC	288.0	0.000278	0.004714	0.0	0.0	0.0	0.0	0.08	288.0	0.072292	0.069063	0.00	0.08	0.08	0.08	1.14
YORK	288.0	0.000729	0.012374	0.0	0.0	0.0	0.0	0.21	288.0	0.102326	0.104986	0.00	0.00	0.00	0.21	0.21

126 rows × 16 columns

Temperature

df_stns ['TMPC']

	count	mean	std	min	25%	50%	75%	max
STID
ADDI	288.0	14.271528	3.125854	9.7	11.100	13.95	17.300	19.6
ANDE	288.0	13.407986	2.235563	8.4	12.000	13.90	14.925	17.2
BATA	288.0	15.638194	2.343974	11.5	13.600	15.25	18.000	19.4
BEAC	288.0	17.753819	3.013903	13.8	15.500	16.70	20.600	23.5
BELD	288.0	13.853819	2.040834	10.1	11.875	14.25	15.700	17.4
...	...	...	...	...	...	...	...	...
WFMB	288.0	12.269097	1.371683	8.7	11.500	12.70	13.000	15.5
WGAT	288.0	12.063542	1.969053	7.4	11.200	12.75	13.500	15.2
WHIT	288.0	16.662500	2.213480	11.0	15.700	16.60	18.500	20.9
WOLC	288.0	16.313542	2.074129	11.2	15.800	17.25	17.700	18.9
YORK	288.0	14.451389	4.553384	7.9	10.000	13.60	19.125	21.2

126 rows × 8 columns

What’s the maximum 5-minute precip value for the entire NYSM network for that day?

df_stns['PRCP']['max'].max()

14.5

Next we’ll select just a couple of rows. We’ll re-set the Pandas’ defaults so all rows and columns are displayed as a result of this selection; scroll to the right to see all columns:

pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)

df_stns.loc[['VOOR','WOLC']]

	TMPC								DWPC								RELH								PRES								DRCT								SPED								GUMS								PRCP								PTOT								PRAT
	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max	count	mean	std	min	25%	50%	75%	max
STID
VOOR	288.0	16.076042	2.513521	12.5	13.675	15.90	18.1	21.2	288.0	11.520086	1.795896	8.887021	9.916742	11.254950	13.049831	15.711168	288.0	76.529514	17.826809	48.6	59.275	67.9	96.7	99.1	288.0	996.646875	1.892703	994.40	994.8375	996.41	997.9800	1001.12	288.0	304.784722	12.623281	253.0	297.0	303.0	310.00	353.0	288.0	3.140278	1.220660	0.8	2.3	3.0	3.9	7.0	288.0	5.699306	2.293636	1.3	4.000	5.25	7.225	11.7	288.0	0.109514	0.230679	0.0	0.0	0.0	0.07	1.51	288.0	27.885139	7.634629	0.35	30.7425	31.15	31.15	31.15	288.0	0.018333	0.053014	0.0	0.0	0.0	0.0	0.39
WOLC	288.0	16.313542	2.074129	11.2	15.800	17.25	17.7	18.9	288.0	10.668820	0.818597	8.768647	10.058470	10.700071	11.290379	13.010016	288.0	70.224306	12.048258	56.4	62.575	65.1	73.5	98.4	288.0	999.155278	2.071128	996.36	996.9650	999.22	1001.2575	1002.51	288.0	225.000000	140.878132	0.0	29.0	307.0	330.25	360.0	288.0	1.989931	1.208882	0.1	0.9	1.9	3.0	5.3	288.0	4.421181	2.475286	0.5	2.175	4.40	6.525	10.3	288.0	0.000278	0.004714	0.0	0.0	0.0	0.00	0.08	288.0	0.072292	0.069063	0.00	0.0800	0.08	0.08	1.14	288.0	0.005521	0.030267	0.0	0.0	0.0	0.0	0.33

Next, split by station again, apply the max/min functions, and combine into two DataFrames which contain max and min values for all measured variables:

df_maxes = nysm_data.groupby(['STID']).max()

df_mins = nysm_data.groupby(['STID']).min()

df_maxes

	TIME	TMPC	DWPC	RELH	PRES	DRCT	SPED	GUMS	PRCP	PTOT	PRAT
STID
ADDI	2021-09-02 23:55:00	19.6	13.695132	94.5	958.30	359.0	7.0	10.7	0.00	9.56	0.00
ANDE	2021-09-02 23:55:00	17.2	14.200000	100.0	955.66	360.0	5.6	11.4	0.72	17.75	0.16
BATA	2021-09-02 23:55:00	19.4	11.194830	82.2	985.72	359.0	8.2	11.0	0.00	0.00	0.00
BEAC	2021-09-02 23:55:00	23.5	16.809561	99.2	1003.97	359.0	7.6	13.8	2.99	79.67	0.73
BELD	2021-09-02 23:55:00	17.4	14.566033	96.3	961.83	358.0	6.0	11.3	0.26	21.18	0.00
BELL	2021-09-02 23:55:00	16.5	13.132048	95.7	999.67	359.0	3.8	7.5	0.00	0.00	0.00
BELM	2021-09-02 23:55:00	20.3	12.298404	100.0	969.10	358.0	4.8	9.3	0.00	0.11	0.00
BERK	2021-09-02 23:55:00	18.3	14.896881	99.2	971.05	356.0	8.3	13.5	0.00	15.52	0.00
BING	2021-09-02 23:55:00	17.2	14.600000	100.0	954.73	359.0	4.0	9.0	0.05	22.34	0.00
BKLN	2021-09-02 23:55:00	24.3	23.191944	98.1	1010.07	360.0	10.9	19.5	13.33	116.76	3.17
BRAN	2021-09-02 23:55:00	21.8	12.752799	99.9	992.30	360.0	6.2	9.5	0.00	0.00	0.00
BREW	2021-09-02 23:55:00	22.7	16.768449	100.0	992.50	360.0	7.0	12.5	4.30	94.13	1.10
BROC	2021-09-02 23:55:00	19.0	12.541923	90.9	997.71	360.0	6.6	10.2	0.00	0.00	0.00
BRON	2021-09-02 23:55:00	24.2	18.744858	99.2	1007.32	360.0	11.5	22.9	13.13	155.16	2.86
BROO	2021-09-02 23:55:00	15.0	13.583061	98.8	957.59	360.0	5.6	10.4	0.00	10.15	0.00
BSPA	2021-09-02 23:55:00	20.6	15.362104	98.3	1000.47	356.0	4.7	9.8	0.23	5.55	0.00
BUFF	2021-09-02 23:55:00	20.5	12.480205	100.0	997.33	360.0	6.2	10.5	0.00	0.00	0.00
BURD	2021-09-02 23:55:00	17.8	13.740585	95.3	951.51	358.0	7.2	11.5	0.00	3.96	0.00
BURT	2021-09-02 23:55:00	20.4	15.605228	98.5	1007.21	360.0	6.8	11.0	0.00	0.00	0.00
CAMD	2021-09-02 23:55:00	10.1	8.680722	100.0	999.07	360.0	3.9	8.0	0.00	0.00	0.00
CAPE	2021-09-02 23:55:00	17.8	12.379212	96.5	1006.81	360.0	6.5	11.2	0.00	0.00	0.00
CHAZ	2021-09-02 23:55:00	20.1	13.379573	98.1	1007.33	359.0	5.9	10.7	0.00	0.00	0.00
CHES	2021-09-02 23:55:00	18.9	14.706633	100.0	976.04	360.0	7.1	11.0	0.00	0.00	0.00
CINC	2021-09-02 23:55:00	17.7	14.302445	98.9	967.20	360.0	5.1	9.7	0.00	11.38	0.00
CLAR	2021-09-02 23:55:00	18.2	13.835605	99.6	947.87	358.0	4.4	11.0	0.91	37.57	0.21
CLIF	2021-09-02 23:55:00	19.4	12.513277	99.6	994.68	359.0	6.3	10.1	0.00	0.00	0.10
CLYM	2021-09-02 23:55:00	19.3	12.800000	100.0	965.80	359.0	6.2	10.3	0.00	0.26	0.00
COBL	2021-09-02 23:55:00	18.3	15.127782	98.9	977.41	360.0	5.5	10.4	0.33	12.71	0.00
COHO	2021-09-02 23:55:00	18.3	11.863577	89.8	948.48	360.0	7.6	11.2	0.00	0.00	0.00
COLD	2021-09-02 23:55:00	15.8	14.743991	99.7	965.47	360.0	6.5	9.9	0.00	0.00	0.00
COPA	2021-09-02 23:55:00	19.8	14.934646	95.2	990.11	360.0	6.4	12.3	1.00	25.31	0.25
COPE	2021-09-02 23:55:00	14.8	13.314366	96.2	987.20	359.0	4.4	7.3	0.00	0.00	0.00
CROG	2021-09-02 23:55:00	14.3	11.947060	100.0	967.41	360.0	1.5	6.2	0.00	0.00	0.00
CSQR	2021-09-02 23:55:00	17.8	14.030840	97.8	1000.66	356.0	4.9	8.6	0.00	0.00	0.00
DELE	2021-09-02 23:55:00	18.1	10.759115	96.7	946.15	359.0	7.6	11.3	0.00	0.00	0.00
DEPO	2021-09-02 23:55:00	19.2	14.913019	99.6	980.01	360.0	6.7	11.7	0.32	18.70	0.00
DOVE	2021-09-02 23:55:00	23.1	15.910144	96.4	999.48	359.0	4.6	9.9	3.71	70.97	0.94
DUAN	2021-09-02 23:55:00	17.8	14.000000	100.0	966.43	358.0	5.6	13.0	0.38	10.69	0.12
EAUR	2021-09-02 23:55:00	19.6	12.469449	100.0	974.12	360.0	6.8	11.4	0.00	0.00	0.00
EDIN	2021-09-02 23:55:00	18.8	14.843871	99.0	977.12	360.0	5.7	9.6	0.00	0.39	0.12
EDWA	2021-09-02 23:55:00	16.8	12.700763	100.0	991.56	360.0	3.9	7.1	0.00	0.00	0.00
ELDR	2021-09-02 23:55:00	21.2	15.148749	98.9	974.90	347.0	3.9	9.0	1.27	106.17	0.37
ELLE	2021-09-02 23:55:00	16.5	11.317003	99.2	979.49	355.0	6.5	9.7	0.00	0.00	0.00
ELMI	2021-09-02 23:55:00	21.5	15.148796	99.5	978.27	360.0	7.0	11.6	0.00	11.99	0.00
ESSX	2021-09-02 23:55:00	19.3	15.430542	96.7	1007.70	360.0	6.7	12.8	0.00	0.00	0.00
FAYE	2021-09-02 23:55:00	18.3	15.859420	97.3	995.66	NaN	NaN	NaN	0.00	0.00	0.00
FRED	2021-09-02 23:55:00	20.7	13.728024	98.5	989.94	360.0	5.3	9.9	0.11	0.60	0.00
GABR	2021-09-02 23:55:00	13.5	10.473895	98.2	952.98	360.0	4.0	7.9	0.00	0.00	0.00
GFAL	2021-09-02 23:55:00	20.6	16.202171	98.7	1002.82	360.0	6.8	10.1	0.00	0.30	0.00
GFLD	2021-09-02 23:55:00	15.5	12.283859	99.4	986.32	359.0	5.0	8.9	0.00	0.00	0.00
GROT	2021-09-02 23:55:00	17.7	13.879160	91.0	971.50	360.0	7.0	10.6	0.22	4.05	0.11
GROV	2021-09-02 23:55:00	17.8	10.718761	87.7	947.42	360.0	7.2	10.9	0.00	0.00	0.00
HAMM	2021-09-02 23:55:00	16.3	12.262303	99.0	1002.81	360.0	5.0	8.7	0.00	0.00	0.00
HARP	2021-09-02 23:55:00	17.6	14.056276	99.7	955.60	359.0	4.7	11.6	0.79	14.46	0.19
HARR	2021-09-02 23:55:00	13.3	10.041336	98.5	958.99	360.0	4.1	7.6	0.00	0.00	0.00
HART	2021-09-02 23:55:00	17.9	10.706362	92.5	933.83	358.0	7.8	12.1	0.00	3.06	0.00
HERK	2021-09-02 23:55:00	18.2	15.057600	99.4	990.69	348.0	6.6	12.1	0.00	0.00	0.00
HFAL	2021-09-02 23:55:00	21.8	16.021442	99.6	992.48	360.0	5.2	10.8	1.67	52.00	0.50
ILAK	2021-09-02 23:55:00	15.4	12.670875	100.0	957.98	359.0	3.3	7.4	0.00	0.00	0.00
JOHN	2021-09-02 23:55:00	20.0	15.064739	99.7	988.52	356.0	6.1	10.5	0.11	6.91	0.00
JORD	2021-09-02 23:55:00	19.5	13.370167	99.8	1002.48	359.0	4.4	9.3	0.00	0.00	0.00
KIND	2021-09-02 23:55:00	21.3	17.057141	99.2	1005.98	360.0	8.9	13.0	0.83	29.66	0.22
LAUR	2021-09-02 23:55:00	16.9	14.366012	98.5	958.71	351.0	5.2	9.6	0.14	15.51	0.00
LOUI	2021-09-02 23:55:00	17.3	13.537956	99.1	1005.65	360.0	4.5	8.0	0.00	0.00	0.00
MALO	2021-09-02 23:55:00	16.2	11.683290	97.4	987.29	334.0	7.2	9.5	0.00	0.00	0.00
MANH	2021-09-02 23:55:00	23.3	20.618629	100.0	1002.88	360.0	10.7	20.0	10.64	156.08	3.64
MEDI	2021-09-02 23:55:00	18.9	12.652424	97.4	999.07	359.0	5.0	9.4	0.00	0.00	0.00
MEDU	2021-09-02 23:55:00	18.4	14.662592	96.9	970.70	340.0	6.4	11.8	1.00	22.99	0.22
MORR	2021-09-02 23:55:00	17.0	14.422341	100.0	972.02	357.0	7.0	12.6	0.00	0.00	0.00
NBRA	2021-09-02 23:55:00	18.9	14.151898	96.2	962.70	360.0	5.2	12.9	0.73	55.49	0.17
NEWC	2021-09-02 23:55:00	14.7	11.947060	100.0	956.88	358.0	1.8	6.2	0.00	0.00	0.00
NHUD	2021-09-02 23:55:00	18.8	14.686997	95.1	979.49	360.0	5.0	9.6	0.00	0.00	0.00
OLDF	2021-09-02 23:55:00	13.9	11.711701	100.0	953.85	360.0	3.0	8.2	0.00	0.00	0.00
OLEA	2021-09-02 23:55:00	19.7	11.357176	99.7	964.52	360.0	4.9	10.3	0.08	0.24	0.00
ONTA	2021-09-02 23:55:00	20.2	12.698147	83.4	1005.64	360.0	6.8	12.5	0.00	0.00	0.00
OPPE	2021-09-02 23:55:00	17.5	14.900000	100.0	973.67	357.0	4.0	9.7	0.06	1.79	0.10
OSCE	2021-09-02 23:55:00	15.8	12.785476	100.0	977.69	360.0	2.8	8.7	0.00	0.00	0.00
OSWE	2021-09-02 23:55:00	19.4	12.833514	90.3	1005.80	360.0	7.6	12.6	0.00	0.00	0.00
OTIS	2021-09-02 23:55:00	21.6	15.579671	98.8	987.19	360.0	5.0	11.6	1.66	90.97	0.44
OWEG	2021-09-02 23:55:00	19.0	14.859546	99.9	964.64	360.0	6.0	11.0	0.00	19.13	0.00
PENN	2021-09-02 23:55:00	20.6	12.863784	90.4	988.00	360.0	7.5	11.1	0.00	0.00	0.00
PHIL	2021-09-02 23:55:00	10.8	8.572347	99.9	1000.92	360.0	4.5	7.7	0.00	0.00	0.00
PISE	2021-09-02 23:55:00	15.6	13.032878	98.3	953.36	359.0	5.0	9.2	0.00	0.00	0.00
POTS	2021-09-02 23:55:00	16.0	14.834731	98.8	1000.51	360.0	4.8	7.6	0.00	0.00	0.00
QUEE	2021-09-02 23:55:00	24.3	23.253007	98.8	1007.62	360.0	9.8	17.0	14.50	124.04	4.39
RAND	2021-09-02 23:55:00	19.6	12.001380	100.0	965.86	359.0	5.4	11.4	0.00	0.00	0.00
RAQU	2021-09-02 23:55:00	13.7	12.171970	99.5	953.20	360.0	1.7	8.1	0.00	0.00	0.00
REDF	2021-09-02 23:55:00	15.1	11.452580	95.9	972.19	360.0	3.5	8.3	0.00	0.00	0.00
REDH	2021-09-02 23:55:00	23.0	16.481959	98.3	1007.31	360.0	6.4	11.9	1.30	45.41	0.29
ROXB	2021-09-02 23:55:00	17.6	14.107067	99.8	949.20	360.0	7.1	11.0	0.79	24.04	0.20
RUSH	2021-09-02 23:55:00	20.4	12.950674	100.0	996.55	343.0	5.5	9.2	0.00	0.00	0.00
SARA	2021-09-02 23:55:00	18.4	11.432599	98.7	977.57	358.0	4.6	10.8	0.00	0.00	0.00
SBRI	2021-09-02 23:55:00	19.6	11.543706	80.7	976.80	354.0	6.4	10.5	0.00	0.00	0.00
SCHA	2021-09-02 23:55:00	21.0	16.158127	99.9	1002.66	359.0	3.0	6.9	0.98	30.54	0.22
SCHO	2021-09-02 23:55:00	21.6	17.100000	100.0	1002.23	359.0	6.0	12.9	1.39	32.81	0.33
SCHU	2021-09-02 23:55:00	22.1	16.123836	99.8	1010.63	360.0	2.8	7.3	0.50	11.14	0.12
SCIP	2021-09-02 23:55:00	17.9	13.920623	90.7	970.96	360.0	7.5	10.8	0.00	0.00	0.00
SHER	2021-09-02 23:55:00	17.9	14.431345	99.8	975.25	359.0	7.9	12.0	0.00	13.14	0.00
SOME	2021-09-02 23:55:00	22.5	16.948494	98.6	992.52	358.0	5.0	13.4	5.51	101.70	1.61
SOUT	2021-09-02 23:55:00	24.4	23.616003	99.3	1011.99	360.0	12.4	23.5	8.76	91.09	2.87
SPRA	2021-09-02 23:55:00	18.8	15.290516	99.8	992.33	354.0	7.1	12.7	0.09	8.88	0.14
SPRI	2021-09-02 23:55:00	16.2	13.442164	98.2	963.48	360.0	4.7	9.1	0.07	11.52	0.00
STAT	2021-09-02 23:55:00	24.4	22.964125	98.3	1010.27	359.0	9.4	16.7	14.44	146.66	3.07
STEP	2021-09-02 23:55:00	19.4	15.615995	99.0	980.22	360.0	8.5	12.6	1.11	37.46	0.26
STON	2021-09-02 23:55:00	24.1	23.490577	99.3	1008.33	360.0	7.3	13.9	10.80	134.96	2.58
SUFF	2021-09-02 23:55:00	22.4	17.240954	99.6	993.49	360.0	8.0	16.3	5.18	88.83	1.33
TANN	2021-09-02 23:55:00	17.2	13.130437	99.9	933.37	358.0	3.8	12.2	0.92	39.24	0.23
TICO	2021-09-02 23:55:00	20.3	15.529949	96.8	1004.43	360.0	8.1	13.5	0.00	0.00	0.00
TULL	2021-09-02 23:55:00	16.9	14.100603	99.4	972.55	359.0	5.8	10.3	0.00	0.00	0.00
TUPP	2021-09-02 23:55:00	13.6	10.219102	100.0	956.97	359.0	3.6	7.5	0.00	0.00	0.00
TYRO	2021-09-02 23:55:00	20.0	13.364128	99.6	974.69	358.0	5.2	9.2	0.00	1.02	0.00
VOOR	2021-09-02 23:55:00	21.2	15.711168	99.1	1001.12	353.0	7.0	11.7	1.51	31.15	0.39
WALL	2021-09-02 23:55:00	23.8	16.382204	98.4	1002.16	359.0	6.5	13.1	1.77	75.82	0.45
WALT	2021-09-02 23:55:00	16.6	13.538872	96.5	951.21	360.0	6.7	12.3	0.35	21.92	0.00
WANT	2021-09-02 23:55:00	25.0	24.321507	100.0	1012.59	360.0	11.7	18.5	6.03	37.21	1.53
WARS	2021-09-02 23:55:00	18.4	10.946772	89.1	955.35	358.0	5.9	11.2	0.00	0.00	0.00
WARW	2021-09-02 23:55:00	22.5	17.300000	100.0	995.50	360.0	7.6	13.1	4.22	69.95	1.01
WATE	2021-09-02 23:55:00	20.5	13.961589	97.4	999.98	360.0	5.6	10.7	0.12	0.34	0.00
WBOU	2021-09-02 23:55:00	19.7	14.537907	99.6	964.79	360.0	6.6	10.6	1.29	63.35	0.32
WELL	2021-09-02 23:55:00	16.7	13.238532	100.0	1006.03	360.0	4.5	8.4	0.00	0.00	0.00
WEST	2021-09-02 23:55:00	17.9	14.735628	100.0	993.16	354.0	5.3	8.7	0.00	0.00	0.00
WFMB	2021-09-02 23:55:00	15.5	9.565762	92.7	943.47	355.0	2.3	7.3	0.00	0.00	0.00
WGAT	2021-09-02 23:55:00	15.2	13.377706	100.0	964.52	360.0	3.5	7.6	0.00	0.00	0.00
WHIT	2021-09-02 23:55:00	20.9	15.327376	98.7	1009.92	358.0	5.6	10.9	0.00	0.00	0.00
WOLC	2021-09-02 23:55:00	18.9	13.010016	98.4	1002.51	360.0	5.3	10.3	0.08	1.14	0.33
YORK	2021-09-02 23:55:00	21.2	13.702460	99.7	997.33	358.0	5.8	10.2	0.21	0.21	0.00

Tip: Assign new names for these two series; else they will both be labeled TMPC!

maxT = df_maxes['TMPC'].rename('TMax')

minT = df_mins['TMPC'].rename('TMin')

Create a DataFrame out of these two Series, using Pandas’ concat function.

pd.concat([maxT,minT],axis='columns')

	TMax	TMin
STID
ADDI	19.6	9.7
ANDE	17.2	8.4
BATA	19.4	11.5
BEAC	23.5	13.8
BELD	17.4	10.1
BELL	16.5	9.8
BELM	20.3	7.9
BERK	18.3	9.5
BING	17.2	10.2
BKLN	24.3	16.3
BRAN	21.8	8.4
BREW	22.7	13.5
BROC	19.0	10.8
BRON	24.2	15.9
BROO	15.0	9.6
BSPA	20.6	10.7
BUFF	20.5	8.4
BURD	17.8	10.9
BURT	20.4	11.2
CAMD	10.1	7.8
CAPE	17.8	8.9
CHAZ	20.1	10.1
CHES	18.9	8.3
CINC	17.7	8.6
CLAR	18.2	8.8
CLIF	19.4	11.5
CLYM	19.3	7.1
COBL	18.3	9.0
COHO	18.3	10.5
COLD	15.8	7.8
COPA	19.8	15.2
COPE	14.8	9.6
CROG	14.3	5.5
CSQR	17.8	9.5
DELE	18.1	9.2
DEPO	19.2	9.0
DOVE	23.1	13.8
DUAN	17.8	9.0
EAUR	19.6	7.1
EDIN	18.8	7.6
EDWA	16.8	4.4
ELDR	21.2	11.0
ELLE	16.5	4.8
ELMI	21.5	9.5
ESSX	19.3	13.4
FAYE	18.3	9.3
FRED	20.7	10.5
GABR	13.5	6.2
GFAL	20.6	11.1
GFLD	15.5	8.7
GROT	17.7	11.0
GROV	17.8	10.4
HAMM	16.3	10.1
HARP	17.6	6.8
HARR	13.3	7.0
HART	17.9	9.5
HERK	18.2	9.6
HFAL	21.8	12.4
ILAK	15.4	5.6
JOHN	20.0	9.0
JORD	19.5	9.1
KIND	21.3	12.6
LAUR	16.9	9.9
LOUI	17.3	8.9
MALO	16.2	6.9
MANH	23.3	15.6
MEDI	18.9	8.9
MEDU	18.4	10.1
MORR	17.0	7.3
NBRA	18.9	10.6
NEWC	14.7	7.2
NHUD	18.8	8.7
OLDF	13.9	5.6
OLEA	19.7	5.6
ONTA	20.2	15.1
OPPE	17.5	7.7
OSCE	15.8	6.4
OSWE	19.4	13.2
OTIS	21.6	13.6
OWEG	19.0	8.7
PENN	20.6	11.1
PHIL	10.8	6.5
PISE	15.6	7.3
POTS	16.0	7.3
QUEE	24.3	16.0
RAND	19.6	7.2
RAQU	13.7	7.8
REDF	15.1	8.3
REDH	23.0	13.0
ROXB	17.6	9.7
RUSH	20.4	6.9
SARA	18.4	10.3
SBRI	19.6	12.5
SCHA	21.0	11.1
SCHO	21.6	12.0
SCHU	22.1	11.8
SCIP	17.9	10.1
SHER	17.9	7.6
SOME	22.5	13.3
SOUT	24.4	15.6
SPRA	18.8	9.6
SPRI	16.2	9.5
STAT	24.4	16.3
STEP	19.4	11.0
STON	24.1	15.8
SUFF	22.4	14.2
TANN	17.2	8.9
TICO	20.3	12.7
TULL	16.9	7.7
TUPP	13.6	6.3
TYRO	20.0	8.1
VOOR	21.2	12.5
WALL	23.8	11.5
WALT	16.6	8.4
WANT	25.0	16.3
WARS	18.4	10.5
WARW	22.5	13.7
WATE	20.5	10.0
WBOU	19.7	11.3
WELL	16.7	9.2
WEST	17.9	7.6
WFMB	15.5	8.7
WGAT	15.2	7.4
WHIT	20.9	11.0
WOLC	18.9	11.2
YORK	21.2	7.9

Group by date/time instead of station id, and then apply/combine.

grouped = nysm_data.groupby(['TIME'])

df_Maxes = grouped.max()
df_Mins = grouped.min()

df_Maxes

	STID	TMPC	DWPC	RELH	PRES	DRCT	SPED	GUMS	PRCP	PTOT	PRAT
TIME
2021-09-02 00:00:00	YORK	21.0	20.700000	100.0	1007.35	359.0	9.1	15.2	3.36	106.17	1.28
2021-09-02 00:05:00	YORK	21.1	20.800000	100.0	1007.45	359.0	8.0	15.1	3.19	3.19	0.97
2021-09-02 00:10:00	YORK	21.0	21.000000	100.0	1007.44	358.0	9.7	15.4	4.37	6.11	1.62
2021-09-02 00:15:00	YORK	21.6	21.600000	100.0	1007.40	359.0	11.5	18.7	3.85	9.96	1.29
2021-09-02 00:20:00	YORK	22.2	22.200000	100.0	1007.40	359.0	9.1	14.9	2.67	11.67	0.84
2021-09-02 00:25:00	YORK	22.0	21.917825	100.0	1007.35	360.0	8.9	15.8	4.43	13.22	1.49
2021-09-02 00:30:00	YORK	23.1	22.816784	100.0	1007.30	360.0	8.4	16.3	3.13	16.07	1.00
2021-09-02 00:35:00	YORK	23.4	22.964125	100.0	1007.25	360.0	8.8	18.6	2.74	17.36	0.83
2021-09-02 00:40:00	YORK	23.4	22.862093	100.0	1007.18	359.0	10.7	18.0	4.33	21.48	1.37
2021-09-02 00:45:00	YORK	23.5	22.694218	100.0	1007.15	360.0	10.9	21.3	4.52	24.97	1.12
2021-09-02 00:50:00	YORK	23.5	22.460210	100.0	1006.99	360.0	10.9	19.1	4.29	29.26	1.24
2021-09-02 00:55:00	YORK	23.5	22.599889	100.0	1006.88	360.0	9.4	15.9	7.68	33.41	1.77
2021-09-02 01:00:00	YORK	23.7	23.200000	100.0	1006.90	359.0	10.2	19.5	12.95	46.36	2.79
2021-09-02 01:05:00	YORK	23.8	23.400000	100.0	1006.96	359.0	10.0	20.0	14.44	60.80	3.07
2021-09-02 01:10:00	YORK	23.8	23.450179	100.0	1006.90	359.0	11.1	18.2	13.09	73.89	2.84
2021-09-02 01:15:00	YORK	23.8	23.350143	100.0	1006.81	359.0	10.0	22.9	9.87	81.01	2.98
2021-09-02 01:20:00	YORK	23.8	23.299925	100.0	1006.85	358.0	11.2	21.6	10.64	81.99	2.66
2021-09-02 01:25:00	YORK	23.9	23.283157	100.0	1006.71	360.0	9.3	16.5	9.07	84.87	2.23
2021-09-02 01:30:00	YORK	24.0	23.382994	100.0	1006.63	360.0	8.4	16.3	8.51	86.61	2.40
2021-09-02 01:35:00	YORK	23.7	23.499625	100.0	1006.57	360.0	10.3	20.8	9.97	87.23	3.64
2021-09-02 01:40:00	YORK	23.7	23.499625	100.0	1006.45	360.0	8.8	13.6	8.34	88.57	2.45
2021-09-02 01:45:00	YORK	23.7	23.466022	100.0	1006.25	359.0	9.5	15.3	13.33	93.50	3.17
2021-09-02 01:50:00	YORK	23.7	23.482831	100.0	1006.50	357.0	7.9	14.9	12.08	101.83	2.93
2021-09-02 01:55:00	YORK	23.9	23.699325	100.0	1006.48	359.0	8.3	13.6	8.80	106.39	1.95
2021-09-02 02:00:00	YORK	24.1	23.882180	100.0	1006.36	359.0	9.5	17.0	11.95	111.03	2.68
2021-09-02 02:05:00	YORK	24.1	23.848446	100.0	1006.33	359.0	7.9	12.0	14.50	115.06	3.67
2021-09-02 02:10:00	YORK	24.1	23.865320	100.0	1006.34	356.0	8.1	14.8	14.07	119.33	4.39
2021-09-02 02:15:00	YORK	24.3	24.081854	100.0	1006.17	358.0	8.7	15.2	5.05	121.82	1.25
2021-09-02 02:20:00	YORK	24.5	24.264617	100.0	1005.95	359.0	10.5	16.4	7.83	122.15	1.77
2021-09-02 02:25:00	YORK	24.5	24.213798	100.0	1005.90	360.0	9.9	16.8	8.70	122.59	2.20
2021-09-02 02:30:00	YORK	24.6	24.296602	100.0	1005.84	359.0	10.4	15.2	5.68	123.86	2.08
2021-09-02 02:35:00	YORK	24.6	24.262591	100.0	1005.66	355.0	10.3	16.5	3.87	125.82	1.36
2021-09-02 02:40:00	YORK	24.5	24.145827	100.0	1005.60	359.0	9.3	14.7	5.75	128.05	1.70
2021-09-02 02:45:00	YORK	24.6	24.262591	100.0	1005.56	356.0	8.4	14.9	4.53	132.50	1.05
2021-09-02 02:50:00	YORK	24.7	24.294084	100.0	1005.51	359.0	8.3	14.6	3.45	135.95	0.94
2021-09-02 02:55:00	YORK	24.7	24.225584	100.0	1005.37	360.0	9.7	14.5	2.88	138.15	0.92
2021-09-02 03:00:00	YORK	24.7	24.174046	100.0	1005.33	359.0	8.9	14.6	4.09	140.05	1.15
2021-09-02 03:05:00	YORK	24.7	24.191241	100.0	1005.36	359.0	10.9	18.2	2.22	142.27	0.74
2021-09-02 03:10:00	YORK	24.9	24.321507	100.0	1005.31	358.0	10.5	16.0	2.26	144.53	0.73
2021-09-02 03:15:00	YORK	24.4	23.840864	100.0	1005.08	360.0	10.7	16.3	2.06	145.41	0.97
2021-09-02 03:20:00	YORK	24.1	23.661833	100.0	1004.78	359.0	11.7	18.5	4.70	146.13	1.23
2021-09-02 03:25:00	YORK	24.1	23.490577	100.0	1004.61	360.0	9.4	16.0	6.03	146.74	1.53
2021-09-02 03:30:00	YORK	23.9	23.170861	100.0	1004.53	360.0	7.7	13.5	1.66	147.35	1.52
2021-09-02 03:35:00	YORK	23.1	23.100000	100.0	1004.53	359.0	7.7	14.1	2.32	148.06	0.60
2021-09-02 03:40:00	YORK	23.0	22.966925	100.0	1004.46	359.0	8.9	13.0	2.05	148.44	0.67
2021-09-02 03:45:00	YORK	23.1	22.983896	100.0	1004.42	360.0	8.9	15.1	9.48	149.28	2.14
2021-09-02 03:50:00	YORK	23.2	22.950138	100.0	1004.27	359.0	8.2	13.6	9.95	151.22	2.10
2021-09-02 03:55:00	YORK	23.2	22.747837	100.0	1004.16	360.0	8.3	13.6	10.80	151.78	2.23
2021-09-02 04:00:00	YORK	22.9	22.415001	100.0	1004.08	360.0	8.3	14.2	8.53	152.29	1.91
2021-09-02 04:05:00	YORK	22.4	22.101566	100.0	1004.15	359.0	8.0	13.8	4.59	152.79	1.29
2021-09-02 04:10:00	YORK	21.8	21.585913	100.0	1004.13	360.0	8.0	13.9	7.90	153.03	1.90
2021-09-02 04:15:00	YORK	21.8	21.619010	100.0	1004.04	359.0	8.4	15.1	7.52	153.26	2.43
2021-09-02 04:20:00	YORK	22.8	22.684158	100.0	1003.98	359.0	8.5	15.4	4.34	153.26	1.43
2021-09-02 04:25:00	YORK	23.4	23.149762	100.0	1003.97	359.0	8.0	14.0	7.26	153.26	2.02
2021-09-02 04:30:00	YORK	23.8	23.277573	100.0	1003.99	359.0	8.9	16.7	9.32	153.48	2.58
2021-09-02 04:35:00	YORK	24.0	23.166227	100.0	1004.00	359.0	9.3	15.9	6.70	153.70	1.88
2021-09-02 04:40:00	YORK	24.1	23.020292	100.0	1004.04	360.0	10.0	17.8	6.09	153.70	1.90
2021-09-02 04:45:00	YORK	24.2	23.137127	100.0	1003.97	358.0	9.0	16.6	2.04	153.70	0.81
2021-09-02 04:50:00	YORK	24.3	23.236333	100.0	1004.00	359.0	9.8	17.6	1.84	154.08	0.64
2021-09-02 04:55:00	YORK	24.3	23.271593	100.0	1003.92	359.0	9.3	16.0	1.06	154.37	0.25
2021-09-02 05:00:00	YORK	24.3	23.341916	100.0	1003.95	360.0	9.3	18.6	3.63	154.76	1.14
2021-09-02 05:05:00	YORK	24.4	23.528803	100.0	1004.01	359.0	11.0	18.6	1.29	155.37	0.34
2021-09-02 05:10:00	YORK	24.4	23.616003	100.0	1004.00	360.0	9.0	15.8	1.55	155.85	1.02
2021-09-02 05:15:00	YORK	24.1	23.335111	100.0	1004.17	360.0	10.1	15.1	1.05	155.85	0.32
2021-09-02 05:20:00	YORK	21.9	20.523034	100.0	1004.27	359.0	9.0	16.7	2.55	155.85	0.81
2021-09-02 05:25:00	YORK	20.1	18.130466	100.0	1004.48	359.0	10.0	19.0	8.76	156.08	2.87
2021-09-02 05:30:00	YORK	19.8	17.965238	100.0	1004.63	359.0	12.4	23.5	3.34	156.08	1.24
2021-09-02 05:35:00	YORK	19.7	18.790414	100.0	1004.51	360.0	9.4	17.1	0.73	156.08	0.27
2021-09-02 05:40:00	YORK	19.8	19.654273	100.0	1004.37	360.0	8.7	14.8	3.95	156.08	1.54
2021-09-02 05:45:00	YORK	19.5	18.792629	100.0	1004.27	360.0	8.2	14.4	3.20	156.08	1.13
2021-09-02 05:50:00	YORK	19.5	18.377294	100.0	1004.27	360.0	8.7	14.5	5.36	156.08	1.33
2021-09-02 05:55:00	YORK	19.7	17.382240	100.0	1004.14	359.0	9.2	18.7	8.72	156.08	2.31
2021-09-02 06:00:00	YORK	19.6	17.125106	100.0	1003.83	358.0	11.5	18.2	6.47	156.08	2.01
2021-09-02 06:05:00	YORK	19.5	17.025240	100.0	1003.66	360.0	10.9	16.6	4.64	156.08	1.07
2021-09-02 06:10:00	YORK	19.4	17.009268	100.0	1003.98	360.0	10.2	16.6	8.61	156.08	1.97
2021-09-02 06:15:00	YORK	19.5	16.793600	100.0	1004.28	360.0	8.9	14.7	0.83	156.08	0.72
2021-09-02 06:20:00	YORK	19.4	16.693758	100.0	1004.46	360.0	8.9	14.3	0.35	156.08	0.13
2021-09-02 06:25:00	YORK	19.4	16.601548	100.0	1004.47	359.0	9.0	15.3	0.58	156.08	0.13
2021-09-02 06:30:00	YORK	19.3	16.609854	100.0	1004.26	360.0	8.5	14.4	0.79	156.08	0.22
2021-09-02 06:35:00	YORK	19.4	16.510000	100.0	1004.25	360.0	9.0	15.7	0.67	156.08	0.16
2021-09-02 06:40:00	YORK	19.4	16.446216	100.0	1004.31	359.0	9.3	14.3	1.02	156.08	0.27
2021-09-02 06:45:00	YORK	19.3	16.398228	100.0	1004.12	360.0	10.9	16.1	0.87	156.08	0.22
2021-09-02 06:50:00	YORK	19.4	16.310586	100.0	1004.05	360.0	9.8	16.1	1.09	156.08	0.32
2021-09-02 06:55:00	YORK	19.3	16.276042	100.0	1004.03	359.0	9.5	16.5	0.35	156.08	0.15
2021-09-02 07:00:00	YORK	19.2	16.228959	100.0	1004.01	359.0	9.4	15.5	0.11	156.08	0.13
2021-09-02 07:05:00	YORK	19.2	16.233061	100.0	1003.98	359.0	8.2	14.4	0.11	156.08	0.00
2021-09-02 07:10:00	YORK	19.0	16.175731	100.0	1003.98	359.0	8.7	16.7	0.40	156.08	0.16
2021-09-02 07:15:00	YORK	19.1	16.159298	100.0	1003.93	359.0	8.7	15.3	0.78	156.08	0.21
2021-09-02 07:20:00	YORK	19.1	16.154365	100.0	1003.82	358.0	11.3	17.0	0.21	156.08	0.17
2021-09-02 07:25:00	YORK	19.0	16.069294	100.0	1003.96	359.0	9.1	16.2	0.00	156.08	0.00
2021-09-02 07:30:00	YORK	18.9	15.966672	100.0	1003.98	359.0	8.1	14.3	0.25	156.08	0.10
2021-09-02 07:35:00	YORK	18.8	15.897926	100.0	1003.94	359.0	8.0	13.6	0.47	156.08	0.15
2021-09-02 07:40:00	YORK	18.6	15.776980	100.0	1004.03	358.0	8.1	13.4	0.06	156.08	0.00
2021-09-02 07:45:00	YORK	18.5	15.845910	100.0	1004.08	359.0	10.5	16.9	0.00	156.08	0.00
2021-09-02 07:50:00	YORK	18.4	15.810675	100.0	1004.03	358.0	10.7	15.9	0.17	156.08	0.00
2021-09-02 07:55:00	YORK	18.4	15.974494	100.0	1003.97	357.0	9.5	15.9	0.06	156.08	0.00
2021-09-02 08:00:00	YORK	18.3	15.968684	100.0	1004.09	359.0	9.9	15.6	0.07	156.08	0.00
2021-09-02 08:05:00	YORK	18.3	15.957122	100.0	1004.16	360.0	9.6	15.4	0.00	156.08	0.00
2021-09-02 08:10:00	YORK	18.2	16.107970	100.0	1004.23	360.0	9.4	14.4	0.51	156.08	0.12
2021-09-02 08:15:00	YORK	18.1	16.206752	100.0	1004.31	359.0	9.2	15.6	0.11	156.08	0.00
2021-09-02 08:20:00	YORK	18.1	16.297729	100.0	1004.35	359.0	9.1	16.8	0.02	156.08	0.00
2021-09-02 08:25:00	YORK	18.2	16.400390	100.0	1004.30	360.0	8.1	15.0	0.00	156.08	0.00
2021-09-02 08:30:00	YORK	18.1	16.465214	100.0	1004.31	360.0	8.8	15.5	0.06	156.08	0.00
2021-09-02 08:35:00	YORK	18.1	16.332015	100.0	1004.35	360.0	8.9	15.5	0.06	156.08	0.00
2021-09-02 08:40:00	YORK	17.9	16.177207	100.0	1004.32	360.0	9.0	15.3	0.02	156.08	0.00
2021-09-02 08:45:00	YORK	17.8	16.055865	100.0	1004.28	360.0	9.3	13.6	0.00	156.08	0.00
2021-09-02 08:50:00	YORK	17.8	16.014807	100.0	1004.27	360.0	8.4	15.0	0.00	156.08	0.00
2021-09-02 08:55:00	YORK	17.7	15.845910	100.0	1004.23	359.0	9.2	16.5	0.00	156.08	0.00
2021-09-02 09:00:00	YORK	17.8	15.909231	100.0	1004.15	360.0	8.8	13.0	0.00	156.08	0.00
2021-09-02 09:05:00	YORK	17.7	15.775371	100.0	1004.15	360.0	8.5	14.4	0.00	156.08	0.00
2021-09-02 09:10:00	YORK	17.8	15.767483	100.0	1004.14	360.0	9.6	14.8	0.00	156.08	0.00
2021-09-02 09:15:00	YORK	17.8	15.714035	100.0	1004.09	360.0	8.1	14.7	0.00	156.08	0.00
2021-09-02 09:20:00	YORK	17.8	15.606655	100.0	1004.10	360.0	7.8	13.1	0.00	156.08	0.00
2021-09-02 09:25:00	YORK	17.8	15.552720	100.0	1004.15	359.0	7.9	13.9	0.00	156.08	0.00
2021-09-02 09:30:00	YORK	17.7	15.436434	100.0	1004.23	359.0	9.8	15.7	0.00	156.08	0.00
2021-09-02 09:35:00	YORK	17.7	15.237207	100.0	1004.27	360.0	8.1	13.3	0.00	156.08	0.00
2021-09-02 09:40:00	YORK	17.7	15.182482	100.0	1004.37	359.0	7.6	13.7	0.00	156.08	0.00
2021-09-02 09:45:00	YORK	17.7	15.237207	100.0	1004.40	359.0	8.4	14.9	0.00	156.08	0.00
2021-09-02 09:50:00	YORK	17.6	15.229854	100.0	1004.40	359.0	8.5	13.6	0.00	156.08	0.00
2021-09-02 09:55:00	YORK	17.3	15.132894	100.0	1004.43	360.0	7.8	13.6	0.00	156.08	0.00
2021-09-02 10:00:00	YORK	17.4	14.993567	100.0	1004.49	360.0	8.2	13.8	0.00	156.08	0.00
2021-09-02 10:05:00	YORK	17.3	14.986905	100.0	1004.58	359.0	8.5	14.3	0.00	156.08	0.00
2021-09-02 10:10:00	YORK	17.6	14.939722	100.0	1004.64	360.0	7.8	13.3	0.00	156.08	0.00
2021-09-02 10:15:00	YORK	17.5	14.974024	100.0	1004.73	360.0	7.2	11.7	0.00	156.08	0.00
2021-09-02 10:20:00	YORK	17.5	14.888143	100.0	1004.78	359.0	7.4	14.0	0.00	156.08	0.00
2021-09-02 10:25:00	YORK	17.4	14.784312	100.0	1004.84	360.0	7.3	12.1	0.00	156.08	0.00
2021-09-02 10:30:00	YORK	17.3	14.789381	100.0	1004.89	359.0	7.3	13.2	0.00	156.08	0.00
2021-09-02 10:35:00	YORK	17.0	14.690619	100.0	1004.94	358.0	7.0	10.4	0.00	156.08	0.00
2021-09-02 10:40:00	YORK	16.9	14.604450	100.0	1005.01	357.0	7.9	13.2	0.00	156.08	0.00
2021-09-02 10:45:00	YORK	17.0	14.511931	100.0	1005.09	359.0	8.0	13.0	0.00	156.08	0.00
2021-09-02 10:50:00	YORK	16.9	14.542830	100.0	1005.09	359.0	8.2	12.5	0.00	156.08	0.00
2021-09-02 10:55:00	YORK	16.9	14.515419	100.0	1005.14	358.0	7.8	13.6	0.00	156.08	0.00
2021-09-02 11:00:00	YORK	17.0	14.346137	100.0	1005.19	360.0	7.8	13.3	0.00	156.08	0.00
2021-09-02 11:05:00	YORK	17.0	14.353923	100.0	1005.23	360.0	8.2	13.4	0.00	156.08	0.00
2021-09-02 11:10:00	YORK	17.2	14.424324	100.0	1005.22	360.0	7.8	11.9	0.00	156.08	0.00
2021-09-02 11:15:00	YORK	17.2	14.343384	100.0	1005.33	359.0	7.5	11.8	0.00	156.08	0.00
2021-09-02 11:20:00	YORK	17.2	14.175899	100.0	1005.46	359.0	7.9	13.4	0.00	156.08	0.00
2021-09-02 11:25:00	YORK	17.2	14.085450	100.0	1005.61	359.0	8.7	12.6	0.00	156.08	0.00
2021-09-02 11:30:00	YORK	17.2	14.135144	100.0	1005.72	360.0	7.8	13.0	0.00	156.08	0.00
2021-09-02 11:35:00	YORK	17.1	14.037715	100.0	1005.88	359.0	9.0	14.8	0.00	156.08	0.00
2021-09-02 11:40:00	YORK	17.1	14.025435	100.0	1005.97	360.0	7.9	13.3	0.00	156.08	0.00
2021-09-02 11:45:00	YORK	17.1	14.100295	100.0	1006.05	359.0	7.2	11.6	0.00	156.08	0.00
2021-09-02 11:50:00	YORK	17.2	14.049373	100.0	1006.21	357.0	7.9	11.0	0.00	156.08	0.00
2021-09-02 11:55:00	YORK	17.2	13.926645	100.0	1006.28	360.0	8.3	13.2	0.00	156.08	0.00
2021-09-02 12:00:00	YORK	17.2	14.051530	100.0	1006.34	359.0	8.0	12.1	0.00	156.08	0.00
2021-09-02 12:05:00	YORK	17.4	14.005490	100.0	1006.39	359.0	8.4	12.0	0.00	156.08	0.00
2021-09-02 12:10:00	YORK	17.6	13.853048	100.0	1006.52	360.0	7.8	12.8	0.00	156.08	0.00
2021-09-02 12:15:00	YORK	17.8	13.914736	100.0	1006.57	360.0	7.5	11.4	0.00	156.08	0.00
2021-09-02 12:20:00	YORK	17.9	13.896528	100.0	1006.59	358.0	8.1	13.5	0.21	156.08	0.00
2021-09-02 12:25:00	YORK	17.8	13.888288	100.0	1006.72	359.0	7.8	11.6	0.00	156.08	0.00
2021-09-02 12:30:00	YORK	17.8	13.976292	100.0	1006.89	360.0	7.7	12.2	0.00	156.08	0.00
2021-09-02 12:35:00	YORK	18.0	13.903140	100.0	1006.86	359.0	7.9	12.3	0.00	156.08	0.00
2021-09-02 12:40:00	YORK	18.0	13.872220	100.0	1006.91	359.0	7.3	11.7	0.00	156.08	0.00
2021-09-02 12:45:00	YORK	18.1	13.970054	100.0	1006.96	359.0	6.8	11.9	0.00	156.08	0.00
2021-09-02 12:50:00	YORK	18.2	13.975124	100.0	1007.05	358.0	7.9	11.8	0.00	156.08	0.00
2021-09-02 12:55:00	YORK	18.3	13.998263	100.0	1007.11	360.0	7.7	11.1	0.00	156.08	0.00
2021-09-02 13:00:00	YORK	18.5	13.960832	99.8	1007.15	355.0	8.0	12.5	0.00	156.08	0.00
2021-09-02 13:05:00	YORK	18.5	13.777528	99.8	1007.33	359.0	7.8	13.3	0.00	156.08	0.00
2021-09-02 13:10:00	YORK	18.6	13.791397	99.9	1007.40	360.0	8.5	12.1	0.00	156.08	0.00
2021-09-02 13:15:00	YORK	18.7	14.062112	99.6	1007.36	360.0	8.2	11.9	0.00	156.08	0.00
2021-09-02 13:20:00	YORK	18.9	13.912553	99.5	1007.34	359.0	7.9	12.6	0.00	156.08	0.00
2021-09-02 13:25:00	YORK	18.8	13.971602	99.3	1007.40	360.0	8.2	12.4	0.00	156.08	0.00
2021-09-02 13:30:00	YORK	19.0	13.972979	98.6	1007.52	359.0	7.9	12.0	0.00	156.08	0.00
2021-09-02 13:35:00	YORK	19.0	14.070215	97.4	1007.61	359.0	7.4	11.4	0.00	156.08	0.00
2021-09-02 13:40:00	YORK	19.2	14.069801	94.7	1007.64	359.0	7.9	11.2	0.00	156.08	0.00
2021-09-02 13:45:00	YORK	19.3	13.816717	85.9	1007.71	356.0	7.3	11.6	0.00	156.08	0.00
2021-09-02 13:50:00	YORK	19.4	13.797911	82.4	1007.81	358.0	7.4	12.4	0.00	156.08	0.00
2021-09-02 13:55:00	YORK	19.8	14.262270	82.3	1007.89	360.0	7.8	12.9	0.00	156.08	0.00
2021-09-02 14:00:00	YORK	19.9	14.594862	81.2	1008.02	358.0	7.6	10.6	0.00	156.08	0.00
2021-09-02 14:05:00	YORK	19.8	13.883757	80.3	1008.10	359.0	6.7	11.7	0.00	156.08	0.00
2021-09-02 14:10:00	YORK	19.9	14.104235	82.8	1008.17	360.0	6.7	11.4	0.00	156.08	0.00
2021-09-02 14:15:00	YORK	20.0	14.238213	80.2	1008.25	360.0	6.8	12.6	0.00	156.08	0.00
2021-09-02 14:20:00	YORK	20.1	14.541018	79.0	1008.27	359.0	6.9	11.0	0.16	156.08	0.00
2021-09-02 14:25:00	YORK	20.3	14.385508	80.7	1008.28	360.0	7.9	11.5	0.00	156.08	0.00
2021-09-02 14:30:00	YORK	20.4	13.778546	80.7	1008.27	360.0	7.6	13.2	0.00	156.08	0.00
2021-09-02 14:35:00	YORK	20.6	13.823365	78.7	1008.28	360.0	7.7	11.4	0.22	156.08	0.00
2021-09-02 14:40:00	YORK	20.6	13.971388	80.4	1008.34	359.0	7.3	11.0	0.00	156.08	0.00
2021-09-02 14:45:00	YORK	20.6	14.486971	80.1	1008.41	357.0	7.1	11.0	0.00	156.08	0.00
2021-09-02 14:50:00	YORK	20.7	14.296867	81.1	1008.46	357.0	7.5	11.8	0.00	156.08	0.00
2021-09-02 14:55:00	YORK	20.7	13.997036	80.5	1008.45	359.0	7.4	12.2	0.00	156.08	0.00
2021-09-02 15:00:00	YORK	20.9	14.243709	80.1	1008.45	360.0	7.5	10.9	0.00	156.08	0.00
2021-09-02 15:05:00	YORK	21.0	14.390064	79.9	1008.44	359.0	7.0	12.1	0.12	156.08	0.00
2021-09-02 15:10:00	YORK	21.1	14.089032	79.4	1008.42	359.0	7.6	12.6	0.09	156.08	0.00
2021-09-02 15:15:00	YORK	21.3	14.184660	78.8	1008.40	359.0	7.6	10.9	0.00	156.08	0.00
2021-09-02 15:20:00	YORK	21.3	14.620104	79.6	1008.40	359.0	7.2	11.9	0.10	156.08	0.00
2021-09-02 15:25:00	YORK	21.4	14.471534	79.6	1008.48	358.0	7.2	11.3	0.03	156.08	0.00
2021-09-02 15:30:00	YORK	21.5	14.291652	79.4	1008.56	359.0	7.1	10.6	0.00	156.08	0.00
2021-09-02 15:35:00	YORK	22.0	14.391855	79.0	1008.60	359.0	6.7	10.6	0.00	156.08	0.00
2021-09-02 15:40:00	YORK	22.1	14.673594	78.0	1008.59	359.0	6.5	12.3	0.12	156.08	0.00
2021-09-02 15:45:00	YORK	21.8	14.559888	77.8	1008.58	360.0	7.2	11.5	0.00	156.08	0.00
2021-09-02 15:50:00	YORK	22.0	14.070412	78.5	1008.52	357.0	7.1	12.8	0.00	156.08	0.00
2021-09-02 15:55:00	YORK	22.1	13.955640	78.6	1008.62	358.0	7.1	11.5	0.00	156.08	0.00
2021-09-02 16:00:00	YORK	21.9	14.264206	77.6	1008.72	359.0	7.0	11.7	0.00	156.08	0.00
2021-09-02 16:05:00	YORK	22.3	14.761730	79.4	1008.76	358.0	7.3	13.0	0.00	156.08	0.00
2021-09-02 16:10:00	YORK	22.4	14.261418	79.2	1008.83	359.0	6.8	10.6	0.22	156.08	0.11
2021-09-02 16:15:00	YORK	22.5	14.953401	79.2	1008.84	359.0	7.0	11.1	0.00	156.08	0.00
2021-09-02 16:20:00	YORK	22.4	14.307539	79.5	1008.86	359.0	7.6	12.0	0.00	156.08	0.00
2021-09-02 16:25:00	YORK	22.5	14.402174	79.2	1008.88	359.0	6.9	11.5	0.00	156.08	0.00
2021-09-02 16:30:00	YORK	22.7	14.712836	77.0	1008.96	358.0	7.0	12.7	0.10	156.08	0.00
2021-09-02 16:35:00	YORK	22.7	14.707347	76.9	1009.04	359.0	6.7	11.7	0.00	156.08	0.00
2021-09-02 16:40:00	YORK	22.7	14.310907	76.8	1009.08	360.0	7.2	11.8	0.12	156.08	0.00
2021-09-02 16:45:00	YORK	23.0	13.384749	77.2	1009.07	358.0	8.3	12.1	0.00	156.08	0.00
2021-09-02 16:50:00	YORK	22.9	13.662455	77.9	1009.03	359.0	7.6	11.0	0.00	156.08	0.00
2021-09-02 16:55:00	YORK	22.9	13.999301	76.5	1009.01	360.0	7.5	10.6	0.00	156.08	0.00
2021-09-02 17:00:00	YORK	23.0	13.677470	77.3	1009.04	360.0	6.9	11.2	0.07	156.08	0.00
2021-09-02 17:05:00	YORK	23.3	13.251524	78.2	1009.09	358.0	6.8	10.3	0.00	156.08	0.10
2021-09-02 17:10:00	YORK	23.5	13.599437	75.3	1009.10	359.0	7.6	11.7	0.00	156.08	0.10
2021-09-02 17:15:00	YORK	23.6	13.176921	75.5	1009.19	359.0	8.2	11.7	0.00	156.08	0.00
2021-09-02 17:20:00	YORK	23.3	12.883408	75.9	1009.22	359.0	7.4	11.9	0.09	156.08	0.00
2021-09-02 17:25:00	YORK	23.3	12.757241	76.4	1009.25	357.0	7.2	11.1	0.00	156.08	0.00
2021-09-02 17:30:00	YORK	23.6	12.305922	76.5	1009.30	356.0	7.9	10.9	0.06	156.08	0.00
2021-09-02 17:35:00	YORK	23.5	12.305922	78.2	1009.38	358.0	7.0	11.8	0.08	156.08	0.00
2021-09-02 17:40:00	YORK	23.4	12.607131	77.4	1009.44	357.0	7.3	11.8	0.06	156.08	0.13
2021-09-02 17:45:00	YORK	23.8	12.572524	77.0	1009.46	359.0	7.5	12.9	0.02	156.08	0.00
2021-09-02 17:50:00	YORK	23.6	13.363545	78.7	1009.44	359.0	8.0	12.5	0.00	156.08	0.00
2021-09-02 17:55:00	YORK	23.5	12.965938	76.1	1009.36	356.0	7.6	11.3	0.00	156.08	0.00
2021-09-02 18:00:00	YORK	24.0	13.108708	75.3	1009.40	356.0	7.9	11.1	0.00	156.08	0.00
2021-09-02 18:05:00	YORK	23.9	12.499141	75.7	1009.45	360.0	7.4	12.5	0.00	156.08	0.00
2021-09-02 18:10:00	YORK	24.0	12.675499	76.8	1009.49	359.0	8.3	12.1	0.00	156.08	0.00
2021-09-02 18:15:00	YORK	23.8	13.315213	77.8	1009.46	359.0	7.2	13.0	0.00	156.08	0.00
2021-09-02 18:20:00	YORK	23.6	13.172841	77.9	1009.51	356.0	8.0	12.5	0.10	156.08	0.00
2021-09-02 18:25:00	YORK	23.9	12.930284	77.7	1009.47	356.0	7.6	12.4	0.00	156.08	0.14
2021-09-02 18:30:00	YORK	23.8	12.556717	77.8	1009.45	359.0	6.9	12.9	0.00	156.08	0.00
2021-09-02 18:35:00	YORK	23.9	12.051340	79.0	1009.45	356.0	7.5	11.8	0.00	156.08	0.00
2021-09-02 18:40:00	YORK	24.1	12.888818	78.2	1009.47	360.0	7.2	11.4	0.15	156.08	0.00
2021-09-02 18:45:00	YORK	24.2	12.092530	77.9	1009.51	359.0	8.9	13.5	0.11	156.08	0.12
2021-09-02 18:50:00	YORK	24.1	11.996865	77.2	1009.51	358.0	7.9	12.3	0.08	156.08	0.00
2021-09-02 18:55:00	YORK	24.2	12.074315	77.2	1009.50	357.0	8.4	11.3	0.00	156.08	0.00
2021-09-02 19:00:00	YORK	24.4	12.286021	77.7	1009.48	360.0	8.2	11.1	0.08	156.08	0.00
2021-09-02 19:05:00	YORK	24.3	12.433347	79.1	1009.49	351.0	8.3	11.1	0.00	156.08	0.00
2021-09-02 19:10:00	YORK	24.2	12.286021	76.7	1009.49	359.0	7.2	11.7	0.07	156.08	0.00
2021-09-02 19:15:00	YORK	24.2	12.433347	76.6	1009.43	360.0	6.9	11.3	0.00	156.08	0.00
2021-09-02 19:20:00	YORK	24.2	12.381396	75.9	1009.49	360.0	7.1	11.0	0.00	156.08	0.00
2021-09-02 19:25:00	YORK	24.3	12.759472	76.6	1009.54	357.0	7.1	11.5	0.00	156.08	0.00
2021-09-02 19:30:00	YORK	24.2	13.247845	77.5	1009.49	359.0	7.2	12.0	0.00	156.08	0.00
2021-09-02 19:35:00	YORK	24.2	12.555328	77.8	1009.48	353.0	7.2	11.7	0.00	156.08	0.00
2021-09-02 19:40:00	YORK	24.5	12.157650	77.8	1009.53	359.0	7.8	11.9	0.00	156.08	0.00
2021-09-02 19:45:00	YORK	24.2	12.375797	78.3	1009.63	358.0	8.1	12.3	0.09	156.08	0.00
2021-09-02 19:50:00	YORK	24.4	12.860393	79.4	1009.64	359.0	8.1	11.7	0.08	156.08	0.00
2021-09-02 19:55:00	YORK	24.5	11.928080	80.4	1009.70	359.0	7.4	11.8	0.00	156.08	0.00
2021-09-02 20:00:00	YORK	24.3	11.710490	80.1	1009.74	358.0	7.5	11.0	0.00	156.08	0.00
2021-09-02 20:05:00	YORK	24.3	11.875080	80.6	1009.72	359.0	7.5	10.6	0.06	156.08	0.00
2021-09-02 20:10:00	YORK	24.5	11.680445	80.1	1009.72	357.0	7.5	10.5	0.02	156.08	0.00
2021-09-02 20:15:00	YORK	24.6	12.010809	80.4	1009.72	358.0	8.0	13.0	0.00	156.08	0.00
2021-09-02 20:20:00	YORK	24.6	11.839542	81.3	1009.81	360.0	7.6	10.6	0.00	156.08	0.00
2021-09-02 20:25:00	YORK	24.9	12.224971	81.4	1009.87	355.0	6.9	10.8	0.00	156.08	0.00
2021-09-02 20:30:00	YORK	24.8	12.342440	82.5	1009.91	359.0	7.7	11.6	0.00	156.08	0.00
2021-09-02 20:35:00	YORK	25.0	12.584026	82.0	1009.97	357.0	6.6	11.0	0.00	156.08	0.00
2021-09-02 20:40:00	YORK	24.8	12.342024	81.6	1009.94	357.0	6.4	10.1	0.00	156.08	0.00
2021-09-02 20:45:00	YORK	24.5	12.712134	82.8	1009.97	358.0	6.6	11.3	0.00	156.08	0.00
2021-09-02 20:50:00	YORK	24.3	11.811845	82.4	1009.98	357.0	6.7	12.1	0.00	156.08	0.00
2021-09-02 20:55:00	YORK	24.1	11.889721	80.9	1010.07	360.0	6.8	10.4	0.00	156.08	0.00
2021-09-02 21:00:00	YORK	24.2	12.296676	82.4	1010.14	359.0	7.0	10.4	0.00	156.08	0.00
2021-09-02 21:05:00	YORK	24.3	12.056831	81.3	1010.12	356.0	6.5	10.6	0.00	156.08	0.00
2021-09-02 21:10:00	YORK	24.2	11.980422	82.2	1010.17	359.0	6.8	11.4	0.00	156.08	0.00
2021-09-02 21:15:00	YORK	24.1	12.130892	83.8	1010.26	358.0	7.0	11.4	0.00	156.08	0.00
2021-09-02 21:20:00	YORK	23.8	12.797370	82.9	1010.37	357.0	6.4	10.8	0.00	156.08	0.00
2021-09-02 21:25:00	YORK	24.1	12.265186	82.4	1010.40	357.0	7.5	10.4	0.00	156.08	0.00
2021-09-02 21:30:00	YORK	24.2	12.170042	82.7	1010.51	359.0	7.5	11.0	0.00	156.08	0.00
2021-09-02 21:35:00	YORK	23.9	12.028932	84.2	1010.64	359.0	7.2	10.8	0.00	156.08	0.00
2021-09-02 21:40:00	YORK	23.9	12.172998	83.3	1010.64	359.0	7.0	10.3	0.00	156.08	0.00
2021-09-02 21:45:00	YORK	24.1	12.056831	84.4	1010.61	358.0	6.3	9.9	0.00	156.08	0.00
2021-09-02 21:50:00	YORK	24.1	12.106677	83.3	1010.63	360.0	6.2	10.3	0.00	156.08	0.00
2021-09-02 21:55:00	YORK	24.1	12.268072	83.6	1010.74	355.0	6.8	10.5	0.00	156.08	0.00
2021-09-02 22:00:00	YORK	24.0	11.959756	83.6	1010.87	360.0	6.6	10.8	0.00	156.08	0.00
2021-09-02 22:05:00	YORK	24.0	12.120737	85.6	1010.94	357.0	6.1	10.3	0.00	156.08	0.00
2021-09-02 22:10:00	YORK	24.0	12.002667	86.0	1011.01	356.0	6.9	10.6	0.00	156.08	0.00
2021-09-02 22:15:00	YORK	23.8	12.032792	85.9	1011.08	359.0	5.7	9.6	0.00	156.08	0.00
2021-09-02 22:20:00	YORK	23.6	12.317664	87.1	1011.12	355.0	6.8	10.4	0.00	156.08	0.00
2021-09-02 22:25:00	YORK	23.4	12.089627	86.8	1011.12	355.0	6.4	9.8	0.00	156.08	0.00
2021-09-02 22:30:00	YORK	23.2	12.234811	85.5	1011.16	359.0	6.2	9.7	0.00	156.08	0.00
2021-09-02 22:35:00	YORK	23.1	12.314262	86.4	1011.22	359.0	6.5	10.1	0.00	156.08	0.00
2021-09-02 22:40:00	YORK	23.1	12.139544	88.3	1011.27	360.0	6.6	10.1	0.00	156.08	0.00
2021-09-02 22:45:00	YORK	23.1	12.139179	90.2	1011.32	359.0	6.6	10.9	0.00	156.08	0.00
2021-09-02 22:50:00	YORK	23.1	12.070371	91.7	1011.36	360.0	6.1	9.7	0.00	156.08	0.00
2021-09-02 22:55:00	YORK	22.9	12.152003	92.7	1011.42	360.0	6.8	9.8	0.00	156.08	0.00
2021-09-02 23:00:00	YORK	22.7	12.226493	91.9	1011.54	360.0	6.6	10.4	0.00	156.08	0.00
2021-09-02 23:05:00	YORK	22.6	12.553736	90.7	1011.66	359.0	6.8	10.8	0.00	156.08	0.00
2021-09-02 23:10:00	YORK	22.5	12.767488	90.0	1011.72	358.0	6.3	10.3	0.00	156.08	0.00
2021-09-02 23:15:00	YORK	22.4	12.785671	89.8	1011.79	360.0	6.5	10.8	0.00	156.08	0.00
2021-09-02 23:20:00	YORK	22.3	12.913432	91.4	1011.87	358.0	6.2	10.8	0.00	156.08	0.00
2021-09-02 23:25:00	YORK	22.2	13.076745	91.1	1011.94	360.0	6.9	10.5	0.00	156.08	0.00
2021-09-02 23:30:00	YORK	22.1	13.205726	91.3	1012.07	360.0	6.4	10.8	0.00	156.08	0.00
2021-09-02 23:35:00	YORK	22.0	13.007121	91.1	1012.20	359.0	6.6	10.4	0.00	156.08	0.00
2021-09-02 23:40:00	YORK	21.9	12.830514	91.5	1012.29	359.0	6.6	10.0	0.00	156.08	0.00
2021-09-02 23:45:00	YORK	21.8	12.834640	91.8	1012.43	355.0	7.3	11.7	0.00	156.08	0.00
2021-09-02 23:50:00	YORK	21.7	13.211478	92.7	1012.51	356.0	6.8	11.6	0.00	156.08	0.00
2021-09-02 23:55:00	YORK	21.6	13.370167	93.4	1012.59	359.0	7.0	10.8	0.00	156.08	0.00

Note: This is a bit deceptive since it looks like YORK had the maximum values for all parameters. But that is because the station ID, STID got sorted as well.

We could construct a DataFrame containing just the max/mins for some selected parameters for each time.

maxT = df_Maxes[['TMPC','DWPC','SPED','GUMS','PRCP','PTOT','PRAT']]

maxT

	TMPC	DWPC	SPED	GUMS	PRCP	PTOT	PRAT
TIME
2021-09-02 00:00:00	21.0	20.700000	9.1	15.2	3.36	106.17	1.28
2021-09-02 00:05:00	21.1	20.800000	8.0	15.1	3.19	3.19	0.97
2021-09-02 00:10:00	21.0	21.000000	9.7	15.4	4.37	6.11	1.62
2021-09-02 00:15:00	21.6	21.600000	11.5	18.7	3.85	9.96	1.29
2021-09-02 00:20:00	22.2	22.200000	9.1	14.9	2.67	11.67	0.84
2021-09-02 00:25:00	22.0	21.917825	8.9	15.8	4.43	13.22	1.49
2021-09-02 00:30:00	23.1	22.816784	8.4	16.3	3.13	16.07	1.00
2021-09-02 00:35:00	23.4	22.964125	8.8	18.6	2.74	17.36	0.83
2021-09-02 00:40:00	23.4	22.862093	10.7	18.0	4.33	21.48	1.37
2021-09-02 00:45:00	23.5	22.694218	10.9	21.3	4.52	24.97	1.12
2021-09-02 00:50:00	23.5	22.460210	10.9	19.1	4.29	29.26	1.24
2021-09-02 00:55:00	23.5	22.599889	9.4	15.9	7.68	33.41	1.77
2021-09-02 01:00:00	23.7	23.200000	10.2	19.5	12.95	46.36	2.79
2021-09-02 01:05:00	23.8	23.400000	10.0	20.0	14.44	60.80	3.07
2021-09-02 01:10:00	23.8	23.450179	11.1	18.2	13.09	73.89	2.84
2021-09-02 01:15:00	23.8	23.350143	10.0	22.9	9.87	81.01	2.98
2021-09-02 01:20:00	23.8	23.299925	11.2	21.6	10.64	81.99	2.66
2021-09-02 01:25:00	23.9	23.283157	9.3	16.5	9.07	84.87	2.23
2021-09-02 01:30:00	24.0	23.382994	8.4	16.3	8.51	86.61	2.40
2021-09-02 01:35:00	23.7	23.499625	10.3	20.8	9.97	87.23	3.64
2021-09-02 01:40:00	23.7	23.499625	8.8	13.6	8.34	88.57	2.45
2021-09-02 01:45:00	23.7	23.466022	9.5	15.3	13.33	93.50	3.17
2021-09-02 01:50:00	23.7	23.482831	7.9	14.9	12.08	101.83	2.93
2021-09-02 01:55:00	23.9	23.699325	8.3	13.6	8.80	106.39	1.95
2021-09-02 02:00:00	24.1	23.882180	9.5	17.0	11.95	111.03	2.68
2021-09-02 02:05:00	24.1	23.848446	7.9	12.0	14.50	115.06	3.67
2021-09-02 02:10:00	24.1	23.865320	8.1	14.8	14.07	119.33	4.39
2021-09-02 02:15:00	24.3	24.081854	8.7	15.2	5.05	121.82	1.25
2021-09-02 02:20:00	24.5	24.264617	10.5	16.4	7.83	122.15	1.77
2021-09-02 02:25:00	24.5	24.213798	9.9	16.8	8.70	122.59	2.20
2021-09-02 02:30:00	24.6	24.296602	10.4	15.2	5.68	123.86	2.08
2021-09-02 02:35:00	24.6	24.262591	10.3	16.5	3.87	125.82	1.36
2021-09-02 02:40:00	24.5	24.145827	9.3	14.7	5.75	128.05	1.70
2021-09-02 02:45:00	24.6	24.262591	8.4	14.9	4.53	132.50	1.05
2021-09-02 02:50:00	24.7	24.294084	8.3	14.6	3.45	135.95	0.94
2021-09-02 02:55:00	24.7	24.225584	9.7	14.5	2.88	138.15	0.92
2021-09-02 03:00:00	24.7	24.174046	8.9	14.6	4.09	140.05	1.15
2021-09-02 03:05:00	24.7	24.191241	10.9	18.2	2.22	142.27	0.74
2021-09-02 03:10:00	24.9	24.321507	10.5	16.0	2.26	144.53	0.73
2021-09-02 03:15:00	24.4	23.840864	10.7	16.3	2.06	145.41	0.97
2021-09-02 03:20:00	24.1	23.661833	11.7	18.5	4.70	146.13	1.23
2021-09-02 03:25:00	24.1	23.490577	9.4	16.0	6.03	146.74	1.53
2021-09-02 03:30:00	23.9	23.170861	7.7	13.5	1.66	147.35	1.52
2021-09-02 03:35:00	23.1	23.100000	7.7	14.1	2.32	148.06	0.60
2021-09-02 03:40:00	23.0	22.966925	8.9	13.0	2.05	148.44	0.67
2021-09-02 03:45:00	23.1	22.983896	8.9	15.1	9.48	149.28	2.14
2021-09-02 03:50:00	23.2	22.950138	8.2	13.6	9.95	151.22	2.10
2021-09-02 03:55:00	23.2	22.747837	8.3	13.6	10.80	151.78	2.23
2021-09-02 04:00:00	22.9	22.415001	8.3	14.2	8.53	152.29	1.91
2021-09-02 04:05:00	22.4	22.101566	8.0	13.8	4.59	152.79	1.29
2021-09-02 04:10:00	21.8	21.585913	8.0	13.9	7.90	153.03	1.90
2021-09-02 04:15:00	21.8	21.619010	8.4	15.1	7.52	153.26	2.43
2021-09-02 04:20:00	22.8	22.684158	8.5	15.4	4.34	153.26	1.43
2021-09-02 04:25:00	23.4	23.149762	8.0	14.0	7.26	153.26	2.02
2021-09-02 04:30:00	23.8	23.277573	8.9	16.7	9.32	153.48	2.58
2021-09-02 04:35:00	24.0	23.166227	9.3	15.9	6.70	153.70	1.88
2021-09-02 04:40:00	24.1	23.020292	10.0	17.8	6.09	153.70	1.90
2021-09-02 04:45:00	24.2	23.137127	9.0	16.6	2.04	153.70	0.81
2021-09-02 04:50:00	24.3	23.236333	9.8	17.6	1.84	154.08	0.64
2021-09-02 04:55:00	24.3	23.271593	9.3	16.0	1.06	154.37	0.25
2021-09-02 05:00:00	24.3	23.341916	9.3	18.6	3.63	154.76	1.14
2021-09-02 05:05:00	24.4	23.528803	11.0	18.6	1.29	155.37	0.34
2021-09-02 05:10:00	24.4	23.616003	9.0	15.8	1.55	155.85	1.02
2021-09-02 05:15:00	24.1	23.335111	10.1	15.1	1.05	155.85	0.32
2021-09-02 05:20:00	21.9	20.523034	9.0	16.7	2.55	155.85	0.81
2021-09-02 05:25:00	20.1	18.130466	10.0	19.0	8.76	156.08	2.87
2021-09-02 05:30:00	19.8	17.965238	12.4	23.5	3.34	156.08	1.24
2021-09-02 05:35:00	19.7	18.790414	9.4	17.1	0.73	156.08	0.27
2021-09-02 05:40:00	19.8	19.654273	8.7	14.8	3.95	156.08	1.54
2021-09-02 05:45:00	19.5	18.792629	8.2	14.4	3.20	156.08	1.13
2021-09-02 05:50:00	19.5	18.377294	8.7	14.5	5.36	156.08	1.33
2021-09-02 05:55:00	19.7	17.382240	9.2	18.7	8.72	156.08	2.31
2021-09-02 06:00:00	19.6	17.125106	11.5	18.2	6.47	156.08	2.01
2021-09-02 06:05:00	19.5	17.025240	10.9	16.6	4.64	156.08	1.07
2021-09-02 06:10:00	19.4	17.009268	10.2	16.6	8.61	156.08	1.97
2021-09-02 06:15:00	19.5	16.793600	8.9	14.7	0.83	156.08	0.72
2021-09-02 06:20:00	19.4	16.693758	8.9	14.3	0.35	156.08	0.13
2021-09-02 06:25:00	19.4	16.601548	9.0	15.3	0.58	156.08	0.13
2021-09-02 06:30:00	19.3	16.609854	8.5	14.4	0.79	156.08	0.22
2021-09-02 06:35:00	19.4	16.510000	9.0	15.7	0.67	156.08	0.16
2021-09-02 06:40:00	19.4	16.446216	9.3	14.3	1.02	156.08	0.27
2021-09-02 06:45:00	19.3	16.398228	10.9	16.1	0.87	156.08	0.22
2021-09-02 06:50:00	19.4	16.310586	9.8	16.1	1.09	156.08	0.32
2021-09-02 06:55:00	19.3	16.276042	9.5	16.5	0.35	156.08	0.15
2021-09-02 07:00:00	19.2	16.228959	9.4	15.5	0.11	156.08	0.13
2021-09-02 07:05:00	19.2	16.233061	8.2	14.4	0.11	156.08	0.00
2021-09-02 07:10:00	19.0	16.175731	8.7	16.7	0.40	156.08	0.16
2021-09-02 07:15:00	19.1	16.159298	8.7	15.3	0.78	156.08	0.21
2021-09-02 07:20:00	19.1	16.154365	11.3	17.0	0.21	156.08	0.17
2021-09-02 07:25:00	19.0	16.069294	9.1	16.2	0.00	156.08	0.00
2021-09-02 07:30:00	18.9	15.966672	8.1	14.3	0.25	156.08	0.10
2021-09-02 07:35:00	18.8	15.897926	8.0	13.6	0.47	156.08	0.15
2021-09-02 07:40:00	18.6	15.776980	8.1	13.4	0.06	156.08	0.00
2021-09-02 07:45:00	18.5	15.845910	10.5	16.9	0.00	156.08	0.00
2021-09-02 07:50:00	18.4	15.810675	10.7	15.9	0.17	156.08	0.00
2021-09-02 07:55:00	18.4	15.974494	9.5	15.9	0.06	156.08	0.00
2021-09-02 08:00:00	18.3	15.968684	9.9	15.6	0.07	156.08	0.00
2021-09-02 08:05:00	18.3	15.957122	9.6	15.4	0.00	156.08	0.00
2021-09-02 08:10:00	18.2	16.107970	9.4	14.4	0.51	156.08	0.12
2021-09-02 08:15:00	18.1	16.206752	9.2	15.6	0.11	156.08	0.00
2021-09-02 08:20:00	18.1	16.297729	9.1	16.8	0.02	156.08	0.00
2021-09-02 08:25:00	18.2	16.400390	8.1	15.0	0.00	156.08	0.00
2021-09-02 08:30:00	18.1	16.465214	8.8	15.5	0.06	156.08	0.00
2021-09-02 08:35:00	18.1	16.332015	8.9	15.5	0.06	156.08	0.00
2021-09-02 08:40:00	17.9	16.177207	9.0	15.3	0.02	156.08	0.00
2021-09-02 08:45:00	17.8	16.055865	9.3	13.6	0.00	156.08	0.00
2021-09-02 08:50:00	17.8	16.014807	8.4	15.0	0.00	156.08	0.00
2021-09-02 08:55:00	17.7	15.845910	9.2	16.5	0.00	156.08	0.00
2021-09-02 09:00:00	17.8	15.909231	8.8	13.0	0.00	156.08	0.00
2021-09-02 09:05:00	17.7	15.775371	8.5	14.4	0.00	156.08	0.00
2021-09-02 09:10:00	17.8	15.767483	9.6	14.8	0.00	156.08	0.00
2021-09-02 09:15:00	17.8	15.714035	8.1	14.7	0.00	156.08	0.00
2021-09-02 09:20:00	17.8	15.606655	7.8	13.1	0.00	156.08	0.00
2021-09-02 09:25:00	17.8	15.552720	7.9	13.9	0.00	156.08	0.00
2021-09-02 09:30:00	17.7	15.436434	9.8	15.7	0.00	156.08	0.00
2021-09-02 09:35:00	17.7	15.237207	8.1	13.3	0.00	156.08	0.00
2021-09-02 09:40:00	17.7	15.182482	7.6	13.7	0.00	156.08	0.00
2021-09-02 09:45:00	17.7	15.237207	8.4	14.9	0.00	156.08	0.00
2021-09-02 09:50:00	17.6	15.229854	8.5	13.6	0.00	156.08	0.00
2021-09-02 09:55:00	17.3	15.132894	7.8	13.6	0.00	156.08	0.00
2021-09-02 10:00:00	17.4	14.993567	8.2	13.8	0.00	156.08	0.00
2021-09-02 10:05:00	17.3	14.986905	8.5	14.3	0.00	156.08	0.00
2021-09-02 10:10:00	17.6	14.939722	7.8	13.3	0.00	156.08	0.00
2021-09-02 10:15:00	17.5	14.974024	7.2	11.7	0.00	156.08	0.00
2021-09-02 10:20:00	17.5	14.888143	7.4	14.0	0.00	156.08	0.00
2021-09-02 10:25:00	17.4	14.784312	7.3	12.1	0.00	156.08	0.00
2021-09-02 10:30:00	17.3	14.789381	7.3	13.2	0.00	156.08	0.00
2021-09-02 10:35:00	17.0	14.690619	7.0	10.4	0.00	156.08	0.00
2021-09-02 10:40:00	16.9	14.604450	7.9	13.2	0.00	156.08	0.00
2021-09-02 10:45:00	17.0	14.511931	8.0	13.0	0.00	156.08	0.00
2021-09-02 10:50:00	16.9	14.542830	8.2	12.5	0.00	156.08	0.00
2021-09-02 10:55:00	16.9	14.515419	7.8	13.6	0.00	156.08	0.00
2021-09-02 11:00:00	17.0	14.346137	7.8	13.3	0.00	156.08	0.00
2021-09-02 11:05:00	17.0	14.353923	8.2	13.4	0.00	156.08	0.00
2021-09-02 11:10:00	17.2	14.424324	7.8	11.9	0.00	156.08	0.00
2021-09-02 11:15:00	17.2	14.343384	7.5	11.8	0.00	156.08	0.00
2021-09-02 11:20:00	17.2	14.175899	7.9	13.4	0.00	156.08	0.00
2021-09-02 11:25:00	17.2	14.085450	8.7	12.6	0.00	156.08	0.00
2021-09-02 11:30:00	17.2	14.135144	7.8	13.0	0.00	156.08	0.00
2021-09-02 11:35:00	17.1	14.037715	9.0	14.8	0.00	156.08	0.00
2021-09-02 11:40:00	17.1	14.025435	7.9	13.3	0.00	156.08	0.00
2021-09-02 11:45:00	17.1	14.100295	7.2	11.6	0.00	156.08	0.00
2021-09-02 11:50:00	17.2	14.049373	7.9	11.0	0.00	156.08	0.00
2021-09-02 11:55:00	17.2	13.926645	8.3	13.2	0.00	156.08	0.00
2021-09-02 12:00:00	17.2	14.051530	8.0	12.1	0.00	156.08	0.00
2021-09-02 12:05:00	17.4	14.005490	8.4	12.0	0.00	156.08	0.00
2021-09-02 12:10:00	17.6	13.853048	7.8	12.8	0.00	156.08	0.00
2021-09-02 12:15:00	17.8	13.914736	7.5	11.4	0.00	156.08	0.00
2021-09-02 12:20:00	17.9	13.896528	8.1	13.5	0.21	156.08	0.00
2021-09-02 12:25:00	17.8	13.888288	7.8	11.6	0.00	156.08	0.00
2021-09-02 12:30:00	17.8	13.976292	7.7	12.2	0.00	156.08	0.00
2021-09-02 12:35:00	18.0	13.903140	7.9	12.3	0.00	156.08	0.00
2021-09-02 12:40:00	18.0	13.872220	7.3	11.7	0.00	156.08	0.00
2021-09-02 12:45:00	18.1	13.970054	6.8	11.9	0.00	156.08	0.00
2021-09-02 12:50:00	18.2	13.975124	7.9	11.8	0.00	156.08	0.00
2021-09-02 12:55:00	18.3	13.998263	7.7	11.1	0.00	156.08	0.00
2021-09-02 13:00:00	18.5	13.960832	8.0	12.5	0.00	156.08	0.00
2021-09-02 13:05:00	18.5	13.777528	7.8	13.3	0.00	156.08	0.00
2021-09-02 13:10:00	18.6	13.791397	8.5	12.1	0.00	156.08	0.00
2021-09-02 13:15:00	18.7	14.062112	8.2	11.9	0.00	156.08	0.00
2021-09-02 13:20:00	18.9	13.912553	7.9	12.6	0.00	156.08	0.00
2021-09-02 13:25:00	18.8	13.971602	8.2	12.4	0.00	156.08	0.00
2021-09-02 13:30:00	19.0	13.972979	7.9	12.0	0.00	156.08	0.00
2021-09-02 13:35:00	19.0	14.070215	7.4	11.4	0.00	156.08	0.00
2021-09-02 13:40:00	19.2	14.069801	7.9	11.2	0.00	156.08	0.00
2021-09-02 13:45:00	19.3	13.816717	7.3	11.6	0.00	156.08	0.00
2021-09-02 13:50:00	19.4	13.797911	7.4	12.4	0.00	156.08	0.00
2021-09-02 13:55:00	19.8	14.262270	7.8	12.9	0.00	156.08	0.00
2021-09-02 14:00:00	19.9	14.594862	7.6	10.6	0.00	156.08	0.00
2021-09-02 14:05:00	19.8	13.883757	6.7	11.7	0.00	156.08	0.00
2021-09-02 14:10:00	19.9	14.104235	6.7	11.4	0.00	156.08	0.00
2021-09-02 14:15:00	20.0	14.238213	6.8	12.6	0.00	156.08	0.00
2021-09-02 14:20:00	20.1	14.541018	6.9	11.0	0.16	156.08	0.00
2021-09-02 14:25:00	20.3	14.385508	7.9	11.5	0.00	156.08	0.00
2021-09-02 14:30:00	20.4	13.778546	7.6	13.2	0.00	156.08	0.00
2021-09-02 14:35:00	20.6	13.823365	7.7	11.4	0.22	156.08	0.00
2021-09-02 14:40:00	20.6	13.971388	7.3	11.0	0.00	156.08	0.00
2021-09-02 14:45:00	20.6	14.486971	7.1	11.0	0.00	156.08	0.00
2021-09-02 14:50:00	20.7	14.296867	7.5	11.8	0.00	156.08	0.00
2021-09-02 14:55:00	20.7	13.997036	7.4	12.2	0.00	156.08	0.00
2021-09-02 15:00:00	20.9	14.243709	7.5	10.9	0.00	156.08	0.00
2021-09-02 15:05:00	21.0	14.390064	7.0	12.1	0.12	156.08	0.00
2021-09-02 15:10:00	21.1	14.089032	7.6	12.6	0.09	156.08	0.00
2021-09-02 15:15:00	21.3	14.184660	7.6	10.9	0.00	156.08	0.00
2021-09-02 15:20:00	21.3	14.620104	7.2	11.9	0.10	156.08	0.00
2021-09-02 15:25:00	21.4	14.471534	7.2	11.3	0.03	156.08	0.00
2021-09-02 15:30:00	21.5	14.291652	7.1	10.6	0.00	156.08	0.00
2021-09-02 15:35:00	22.0	14.391855	6.7	10.6	0.00	156.08	0.00
2021-09-02 15:40:00	22.1	14.673594	6.5	12.3	0.12	156.08	0.00
2021-09-02 15:45:00	21.8	14.559888	7.2	11.5	0.00	156.08	0.00
2021-09-02 15:50:00	22.0	14.070412	7.1	12.8	0.00	156.08	0.00
2021-09-02 15:55:00	22.1	13.955640	7.1	11.5	0.00	156.08	0.00
2021-09-02 16:00:00	21.9	14.264206	7.0	11.7	0.00	156.08	0.00
2021-09-02 16:05:00	22.3	14.761730	7.3	13.0	0.00	156.08	0.00
2021-09-02 16:10:00	22.4	14.261418	6.8	10.6	0.22	156.08	0.11
2021-09-02 16:15:00	22.5	14.953401	7.0	11.1	0.00	156.08	0.00
2021-09-02 16:20:00	22.4	14.307539	7.6	12.0	0.00	156.08	0.00
2021-09-02 16:25:00	22.5	14.402174	6.9	11.5	0.00	156.08	0.00
2021-09-02 16:30:00	22.7	14.712836	7.0	12.7	0.10	156.08	0.00
2021-09-02 16:35:00	22.7	14.707347	6.7	11.7	0.00	156.08	0.00
2021-09-02 16:40:00	22.7	14.310907	7.2	11.8	0.12	156.08	0.00
2021-09-02 16:45:00	23.0	13.384749	8.3	12.1	0.00	156.08	0.00
2021-09-02 16:50:00	22.9	13.662455	7.6	11.0	0.00	156.08	0.00
2021-09-02 16:55:00	22.9	13.999301	7.5	10.6	0.00	156.08	0.00
2021-09-02 17:00:00	23.0	13.677470	6.9	11.2	0.07	156.08	0.00
2021-09-02 17:05:00	23.3	13.251524	6.8	10.3	0.00	156.08	0.10
2021-09-02 17:10:00	23.5	13.599437	7.6	11.7	0.00	156.08	0.10
2021-09-02 17:15:00	23.6	13.176921	8.2	11.7	0.00	156.08	0.00
2021-09-02 17:20:00	23.3	12.883408	7.4	11.9	0.09	156.08	0.00
2021-09-02 17:25:00	23.3	12.757241	7.2	11.1	0.00	156.08	0.00
2021-09-02 17:30:00	23.6	12.305922	7.9	10.9	0.06	156.08	0.00
2021-09-02 17:35:00	23.5	12.305922	7.0	11.8	0.08	156.08	0.00
2021-09-02 17:40:00	23.4	12.607131	7.3	11.8	0.06	156.08	0.13
2021-09-02 17:45:00	23.8	12.572524	7.5	12.9	0.02	156.08	0.00
2021-09-02 17:50:00	23.6	13.363545	8.0	12.5	0.00	156.08	0.00
2021-09-02 17:55:00	23.5	12.965938	7.6	11.3	0.00	156.08	0.00
2021-09-02 18:00:00	24.0	13.108708	7.9	11.1	0.00	156.08	0.00
2021-09-02 18:05:00	23.9	12.499141	7.4	12.5	0.00	156.08	0.00
2021-09-02 18:10:00	24.0	12.675499	8.3	12.1	0.00	156.08	0.00
2021-09-02 18:15:00	23.8	13.315213	7.2	13.0	0.00	156.08	0.00
2021-09-02 18:20:00	23.6	13.172841	8.0	12.5	0.10	156.08	0.00
2021-09-02 18:25:00	23.9	12.930284	7.6	12.4	0.00	156.08	0.14
2021-09-02 18:30:00	23.8	12.556717	6.9	12.9	0.00	156.08	0.00
2021-09-02 18:35:00	23.9	12.051340	7.5	11.8	0.00	156.08	0.00
2021-09-02 18:40:00	24.1	12.888818	7.2	11.4	0.15	156.08	0.00
2021-09-02 18:45:00	24.2	12.092530	8.9	13.5	0.11	156.08	0.12
2021-09-02 18:50:00	24.1	11.996865	7.9	12.3	0.08	156.08	0.00
2021-09-02 18:55:00	24.2	12.074315	8.4	11.3	0.00	156.08	0.00
2021-09-02 19:00:00	24.4	12.286021	8.2	11.1	0.08	156.08	0.00
2021-09-02 19:05:00	24.3	12.433347	8.3	11.1	0.00	156.08	0.00
2021-09-02 19:10:00	24.2	12.286021	7.2	11.7	0.07	156.08	0.00
2021-09-02 19:15:00	24.2	12.433347	6.9	11.3	0.00	156.08	0.00
2021-09-02 19:20:00	24.2	12.381396	7.1	11.0	0.00	156.08	0.00
2021-09-02 19:25:00	24.3	12.759472	7.1	11.5	0.00	156.08	0.00
2021-09-02 19:30:00	24.2	13.247845	7.2	12.0	0.00	156.08	0.00
2021-09-02 19:35:00	24.2	12.555328	7.2	11.7	0.00	156.08	0.00
2021-09-02 19:40:00	24.5	12.157650	7.8	11.9	0.00	156.08	0.00
2021-09-02 19:45:00	24.2	12.375797	8.1	12.3	0.09	156.08	0.00
2021-09-02 19:50:00	24.4	12.860393	8.1	11.7	0.08	156.08	0.00
2021-09-02 19:55:00	24.5	11.928080	7.4	11.8	0.00	156.08	0.00
2021-09-02 20:00:00	24.3	11.710490	7.5	11.0	0.00	156.08	0.00
2021-09-02 20:05:00	24.3	11.875080	7.5	10.6	0.06	156.08	0.00
2021-09-02 20:10:00	24.5	11.680445	7.5	10.5	0.02	156.08	0.00
2021-09-02 20:15:00	24.6	12.010809	8.0	13.0	0.00	156.08	0.00
2021-09-02 20:20:00	24.6	11.839542	7.6	10.6	0.00	156.08	0.00
2021-09-02 20:25:00	24.9	12.224971	6.9	10.8	0.00	156.08	0.00
2021-09-02 20:30:00	24.8	12.342440	7.7	11.6	0.00	156.08	0.00
2021-09-02 20:35:00	25.0	12.584026	6.6	11.0	0.00	156.08	0.00
2021-09-02 20:40:00	24.8	12.342024	6.4	10.1	0.00	156.08	0.00
2021-09-02 20:45:00	24.5	12.712134	6.6	11.3	0.00	156.08	0.00
2021-09-02 20:50:00	24.3	11.811845	6.7	12.1	0.00	156.08	0.00
2021-09-02 20:55:00	24.1	11.889721	6.8	10.4	0.00	156.08	0.00
2021-09-02 21:00:00	24.2	12.296676	7.0	10.4	0.00	156.08	0.00
2021-09-02 21:05:00	24.3	12.056831	6.5	10.6	0.00	156.08	0.00
2021-09-02 21:10:00	24.2	11.980422	6.8	11.4	0.00	156.08	0.00
2021-09-02 21:15:00	24.1	12.130892	7.0	11.4	0.00	156.08	0.00
2021-09-02 21:20:00	23.8	12.797370	6.4	10.8	0.00	156.08	0.00
2021-09-02 21:25:00	24.1	12.265186	7.5	10.4	0.00	156.08	0.00
2021-09-02 21:30:00	24.2	12.170042	7.5	11.0	0.00	156.08	0.00
2021-09-02 21:35:00	23.9	12.028932	7.2	10.8	0.00	156.08	0.00
2021-09-02 21:40:00	23.9	12.172998	7.0	10.3	0.00	156.08	0.00
2021-09-02 21:45:00	24.1	12.056831	6.3	9.9	0.00	156.08	0.00
2021-09-02 21:50:00	24.1	12.106677	6.2	10.3	0.00	156.08	0.00
2021-09-02 21:55:00	24.1	12.268072	6.8	10.5	0.00	156.08	0.00
2021-09-02 22:00:00	24.0	11.959756	6.6	10.8	0.00	156.08	0.00
2021-09-02 22:05:00	24.0	12.120737	6.1	10.3	0.00	156.08	0.00
2021-09-02 22:10:00	24.0	12.002667	6.9	10.6	0.00	156.08	0.00
2021-09-02 22:15:00	23.8	12.032792	5.7	9.6	0.00	156.08	0.00
2021-09-02 22:20:00	23.6	12.317664	6.8	10.4	0.00	156.08	0.00
2021-09-02 22:25:00	23.4	12.089627	6.4	9.8	0.00	156.08	0.00
2021-09-02 22:30:00	23.2	12.234811	6.2	9.7	0.00	156.08	0.00
2021-09-02 22:35:00	23.1	12.314262	6.5	10.1	0.00	156.08	0.00
2021-09-02 22:40:00	23.1	12.139544	6.6	10.1	0.00	156.08	0.00
2021-09-02 22:45:00	23.1	12.139179	6.6	10.9	0.00	156.08	0.00
2021-09-02 22:50:00	23.1	12.070371	6.1	9.7	0.00	156.08	0.00
2021-09-02 22:55:00	22.9	12.152003	6.8	9.8	0.00	156.08	0.00
2021-09-02 23:00:00	22.7	12.226493	6.6	10.4	0.00	156.08	0.00
2021-09-02 23:05:00	22.6	12.553736	6.8	10.8	0.00	156.08	0.00
2021-09-02 23:10:00	22.5	12.767488	6.3	10.3	0.00	156.08	0.00
2021-09-02 23:15:00	22.4	12.785671	6.5	10.8	0.00	156.08	0.00
2021-09-02 23:20:00	22.3	12.913432	6.2	10.8	0.00	156.08	0.00
2021-09-02 23:25:00	22.2	13.076745	6.9	10.5	0.00	156.08	0.00
2021-09-02 23:30:00	22.1	13.205726	6.4	10.8	0.00	156.08	0.00
2021-09-02 23:35:00	22.0	13.007121	6.6	10.4	0.00	156.08	0.00
2021-09-02 23:40:00	21.9	12.830514	6.6	10.0	0.00	156.08	0.00
2021-09-02 23:45:00	21.8	12.834640	7.3	11.7	0.00	156.08	0.00
2021-09-02 23:50:00	21.7	13.211478	6.8	11.6	0.00	156.08	0.00
2021-09-02 23:55:00	21.6	13.370167	7.0	10.8	0.00	156.08	0.00

Time to re-sort!: If we do not re-sort the index of this DataFrame, the next cell won't work right!

maxT = maxT.sort_index()

columnMap = {'TMPC': 'TMax',
             'DWPC': 'TdMax',
             'SPED': 'SPDMax',
             'GUMS': 'GUSTMax',
             'PRCP': 'P5MinMax',
             'PTOT': 'PDayMax',
             'PRAT': 'PRateMax'}
maxT.rename(columns=columnMap, inplace=True)

maxT

	TMax	TdMax	SPDMax	GUSTMax	P5MinMax	PDayMax	PRateMax
TIME
2021-09-02 00:00:00	21.0	20.700000	9.1	15.2	3.36	106.17	1.28
2021-09-02 00:05:00	21.1	20.800000	8.0	15.1	3.19	3.19	0.97
2021-09-02 00:10:00	21.0	21.000000	9.7	15.4	4.37	6.11	1.62
2021-09-02 00:15:00	21.6	21.600000	11.5	18.7	3.85	9.96	1.29
2021-09-02 00:20:00	22.2	22.200000	9.1	14.9	2.67	11.67	0.84
2021-09-02 00:25:00	22.0	21.917825	8.9	15.8	4.43	13.22	1.49
2021-09-02 00:30:00	23.1	22.816784	8.4	16.3	3.13	16.07	1.00
2021-09-02 00:35:00	23.4	22.964125	8.8	18.6	2.74	17.36	0.83
2021-09-02 00:40:00	23.4	22.862093	10.7	18.0	4.33	21.48	1.37
2021-09-02 00:45:00	23.5	22.694218	10.9	21.3	4.52	24.97	1.12
2021-09-02 00:50:00	23.5	22.460210	10.9	19.1	4.29	29.26	1.24
2021-09-02 00:55:00	23.5	22.599889	9.4	15.9	7.68	33.41	1.77
2021-09-02 01:00:00	23.7	23.200000	10.2	19.5	12.95	46.36	2.79
2021-09-02 01:05:00	23.8	23.400000	10.0	20.0	14.44	60.80	3.07
2021-09-02 01:10:00	23.8	23.450179	11.1	18.2	13.09	73.89	2.84
2021-09-02 01:15:00	23.8	23.350143	10.0	22.9	9.87	81.01	2.98
2021-09-02 01:20:00	23.8	23.299925	11.2	21.6	10.64	81.99	2.66
2021-09-02 01:25:00	23.9	23.283157	9.3	16.5	9.07	84.87	2.23
2021-09-02 01:30:00	24.0	23.382994	8.4	16.3	8.51	86.61	2.40
2021-09-02 01:35:00	23.7	23.499625	10.3	20.8	9.97	87.23	3.64
2021-09-02 01:40:00	23.7	23.499625	8.8	13.6	8.34	88.57	2.45
2021-09-02 01:45:00	23.7	23.466022	9.5	15.3	13.33	93.50	3.17
2021-09-02 01:50:00	23.7	23.482831	7.9	14.9	12.08	101.83	2.93
2021-09-02 01:55:00	23.9	23.699325	8.3	13.6	8.80	106.39	1.95
2021-09-02 02:00:00	24.1	23.882180	9.5	17.0	11.95	111.03	2.68
2021-09-02 02:05:00	24.1	23.848446	7.9	12.0	14.50	115.06	3.67
2021-09-02 02:10:00	24.1	23.865320	8.1	14.8	14.07	119.33	4.39
2021-09-02 02:15:00	24.3	24.081854	8.7	15.2	5.05	121.82	1.25
2021-09-02 02:20:00	24.5	24.264617	10.5	16.4	7.83	122.15	1.77
2021-09-02 02:25:00	24.5	24.213798	9.9	16.8	8.70	122.59	2.20
2021-09-02 02:30:00	24.6	24.296602	10.4	15.2	5.68	123.86	2.08
2021-09-02 02:35:00	24.6	24.262591	10.3	16.5	3.87	125.82	1.36
2021-09-02 02:40:00	24.5	24.145827	9.3	14.7	5.75	128.05	1.70
2021-09-02 02:45:00	24.6	24.262591	8.4	14.9	4.53	132.50	1.05
2021-09-02 02:50:00	24.7	24.294084	8.3	14.6	3.45	135.95	0.94
2021-09-02 02:55:00	24.7	24.225584	9.7	14.5	2.88	138.15	0.92
2021-09-02 03:00:00	24.7	24.174046	8.9	14.6	4.09	140.05	1.15
2021-09-02 03:05:00	24.7	24.191241	10.9	18.2	2.22	142.27	0.74
2021-09-02 03:10:00	24.9	24.321507	10.5	16.0	2.26	144.53	0.73
2021-09-02 03:15:00	24.4	23.840864	10.7	16.3	2.06	145.41	0.97
2021-09-02 03:20:00	24.1	23.661833	11.7	18.5	4.70	146.13	1.23
2021-09-02 03:25:00	24.1	23.490577	9.4	16.0	6.03	146.74	1.53
2021-09-02 03:30:00	23.9	23.170861	7.7	13.5	1.66	147.35	1.52
2021-09-02 03:35:00	23.1	23.100000	7.7	14.1	2.32	148.06	0.60
2021-09-02 03:40:00	23.0	22.966925	8.9	13.0	2.05	148.44	0.67
2021-09-02 03:45:00	23.1	22.983896	8.9	15.1	9.48	149.28	2.14
2021-09-02 03:50:00	23.2	22.950138	8.2	13.6	9.95	151.22	2.10
2021-09-02 03:55:00	23.2	22.747837	8.3	13.6	10.80	151.78	2.23
2021-09-02 04:00:00	22.9	22.415001	8.3	14.2	8.53	152.29	1.91
2021-09-02 04:05:00	22.4	22.101566	8.0	13.8	4.59	152.79	1.29
2021-09-02 04:10:00	21.8	21.585913	8.0	13.9	7.90	153.03	1.90
2021-09-02 04:15:00	21.8	21.619010	8.4	15.1	7.52	153.26	2.43
2021-09-02 04:20:00	22.8	22.684158	8.5	15.4	4.34	153.26	1.43
2021-09-02 04:25:00	23.4	23.149762	8.0	14.0	7.26	153.26	2.02
2021-09-02 04:30:00	23.8	23.277573	8.9	16.7	9.32	153.48	2.58
2021-09-02 04:35:00	24.0	23.166227	9.3	15.9	6.70	153.70	1.88
2021-09-02 04:40:00	24.1	23.020292	10.0	17.8	6.09	153.70	1.90
2021-09-02 04:45:00	24.2	23.137127	9.0	16.6	2.04	153.70	0.81
2021-09-02 04:50:00	24.3	23.236333	9.8	17.6	1.84	154.08	0.64
2021-09-02 04:55:00	24.3	23.271593	9.3	16.0	1.06	154.37	0.25
2021-09-02 05:00:00	24.3	23.341916	9.3	18.6	3.63	154.76	1.14
2021-09-02 05:05:00	24.4	23.528803	11.0	18.6	1.29	155.37	0.34
2021-09-02 05:10:00	24.4	23.616003	9.0	15.8	1.55	155.85	1.02
2021-09-02 05:15:00	24.1	23.335111	10.1	15.1	1.05	155.85	0.32
2021-09-02 05:20:00	21.9	20.523034	9.0	16.7	2.55	155.85	0.81
2021-09-02 05:25:00	20.1	18.130466	10.0	19.0	8.76	156.08	2.87
2021-09-02 05:30:00	19.8	17.965238	12.4	23.5	3.34	156.08	1.24
2021-09-02 05:35:00	19.7	18.790414	9.4	17.1	0.73	156.08	0.27
2021-09-02 05:40:00	19.8	19.654273	8.7	14.8	3.95	156.08	1.54
2021-09-02 05:45:00	19.5	18.792629	8.2	14.4	3.20	156.08	1.13
2021-09-02 05:50:00	19.5	18.377294	8.7	14.5	5.36	156.08	1.33
2021-09-02 05:55:00	19.7	17.382240	9.2	18.7	8.72	156.08	2.31
2021-09-02 06:00:00	19.6	17.125106	11.5	18.2	6.47	156.08	2.01
2021-09-02 06:05:00	19.5	17.025240	10.9	16.6	4.64	156.08	1.07
2021-09-02 06:10:00	19.4	17.009268	10.2	16.6	8.61	156.08	1.97
2021-09-02 06:15:00	19.5	16.793600	8.9	14.7	0.83	156.08	0.72
2021-09-02 06:20:00	19.4	16.693758	8.9	14.3	0.35	156.08	0.13
2021-09-02 06:25:00	19.4	16.601548	9.0	15.3	0.58	156.08	0.13
2021-09-02 06:30:00	19.3	16.609854	8.5	14.4	0.79	156.08	0.22
2021-09-02 06:35:00	19.4	16.510000	9.0	15.7	0.67	156.08	0.16
2021-09-02 06:40:00	19.4	16.446216	9.3	14.3	1.02	156.08	0.27
2021-09-02 06:45:00	19.3	16.398228	10.9	16.1	0.87	156.08	0.22
2021-09-02 06:50:00	19.4	16.310586	9.8	16.1	1.09	156.08	0.32
2021-09-02 06:55:00	19.3	16.276042	9.5	16.5	0.35	156.08	0.15
2021-09-02 07:00:00	19.2	16.228959	9.4	15.5	0.11	156.08	0.13
2021-09-02 07:05:00	19.2	16.233061	8.2	14.4	0.11	156.08	0.00
2021-09-02 07:10:00	19.0	16.175731	8.7	16.7	0.40	156.08	0.16
2021-09-02 07:15:00	19.1	16.159298	8.7	15.3	0.78	156.08	0.21
2021-09-02 07:20:00	19.1	16.154365	11.3	17.0	0.21	156.08	0.17
2021-09-02 07:25:00	19.0	16.069294	9.1	16.2	0.00	156.08	0.00
2021-09-02 07:30:00	18.9	15.966672	8.1	14.3	0.25	156.08	0.10
2021-09-02 07:35:00	18.8	15.897926	8.0	13.6	0.47	156.08	0.15
2021-09-02 07:40:00	18.6	15.776980	8.1	13.4	0.06	156.08	0.00
2021-09-02 07:45:00	18.5	15.845910	10.5	16.9	0.00	156.08	0.00
2021-09-02 07:50:00	18.4	15.810675	10.7	15.9	0.17	156.08	0.00
2021-09-02 07:55:00	18.4	15.974494	9.5	15.9	0.06	156.08	0.00
2021-09-02 08:00:00	18.3	15.968684	9.9	15.6	0.07	156.08	0.00
2021-09-02 08:05:00	18.3	15.957122	9.6	15.4	0.00	156.08	0.00
2021-09-02 08:10:00	18.2	16.107970	9.4	14.4	0.51	156.08	0.12
2021-09-02 08:15:00	18.1	16.206752	9.2	15.6	0.11	156.08	0.00
2021-09-02 08:20:00	18.1	16.297729	9.1	16.8	0.02	156.08	0.00
2021-09-02 08:25:00	18.2	16.400390	8.1	15.0	0.00	156.08	0.00
2021-09-02 08:30:00	18.1	16.465214	8.8	15.5	0.06	156.08	0.00
2021-09-02 08:35:00	18.1	16.332015	8.9	15.5	0.06	156.08	0.00
2021-09-02 08:40:00	17.9	16.177207	9.0	15.3	0.02	156.08	0.00
2021-09-02 08:45:00	17.8	16.055865	9.3	13.6	0.00	156.08	0.00
2021-09-02 08:50:00	17.8	16.014807	8.4	15.0	0.00	156.08	0.00
2021-09-02 08:55:00	17.7	15.845910	9.2	16.5	0.00	156.08	0.00
2021-09-02 09:00:00	17.8	15.909231	8.8	13.0	0.00	156.08	0.00
2021-09-02 09:05:00	17.7	15.775371	8.5	14.4	0.00	156.08	0.00
2021-09-02 09:10:00	17.8	15.767483	9.6	14.8	0.00	156.08	0.00
2021-09-02 09:15:00	17.8	15.714035	8.1	14.7	0.00	156.08	0.00
2021-09-02 09:20:00	17.8	15.606655	7.8	13.1	0.00	156.08	0.00
2021-09-02 09:25:00	17.8	15.552720	7.9	13.9	0.00	156.08	0.00
2021-09-02 09:30:00	17.7	15.436434	9.8	15.7	0.00	156.08	0.00
2021-09-02 09:35:00	17.7	15.237207	8.1	13.3	0.00	156.08	0.00
2021-09-02 09:40:00	17.7	15.182482	7.6	13.7	0.00	156.08	0.00
2021-09-02 09:45:00	17.7	15.237207	8.4	14.9	0.00	156.08	0.00
2021-09-02 09:50:00	17.6	15.229854	8.5	13.6	0.00	156.08	0.00
2021-09-02 09:55:00	17.3	15.132894	7.8	13.6	0.00	156.08	0.00
2021-09-02 10:00:00	17.4	14.993567	8.2	13.8	0.00	156.08	0.00
2021-09-02 10:05:00	17.3	14.986905	8.5	14.3	0.00	156.08	0.00
2021-09-02 10:10:00	17.6	14.939722	7.8	13.3	0.00	156.08	0.00
2021-09-02 10:15:00	17.5	14.974024	7.2	11.7	0.00	156.08	0.00
2021-09-02 10:20:00	17.5	14.888143	7.4	14.0	0.00	156.08	0.00
2021-09-02 10:25:00	17.4	14.784312	7.3	12.1	0.00	156.08	0.00
2021-09-02 10:30:00	17.3	14.789381	7.3	13.2	0.00	156.08	0.00
2021-09-02 10:35:00	17.0	14.690619	7.0	10.4	0.00	156.08	0.00
2021-09-02 10:40:00	16.9	14.604450	7.9	13.2	0.00	156.08	0.00
2021-09-02 10:45:00	17.0	14.511931	8.0	13.0	0.00	156.08	0.00
2021-09-02 10:50:00	16.9	14.542830	8.2	12.5	0.00	156.08	0.00
2021-09-02 10:55:00	16.9	14.515419	7.8	13.6	0.00	156.08	0.00
2021-09-02 11:00:00	17.0	14.346137	7.8	13.3	0.00	156.08	0.00
2021-09-02 11:05:00	17.0	14.353923	8.2	13.4	0.00	156.08	0.00
2021-09-02 11:10:00	17.2	14.424324	7.8	11.9	0.00	156.08	0.00
2021-09-02 11:15:00	17.2	14.343384	7.5	11.8	0.00	156.08	0.00
2021-09-02 11:20:00	17.2	14.175899	7.9	13.4	0.00	156.08	0.00
2021-09-02 11:25:00	17.2	14.085450	8.7	12.6	0.00	156.08	0.00
2021-09-02 11:30:00	17.2	14.135144	7.8	13.0	0.00	156.08	0.00
2021-09-02 11:35:00	17.1	14.037715	9.0	14.8	0.00	156.08	0.00
2021-09-02 11:40:00	17.1	14.025435	7.9	13.3	0.00	156.08	0.00
2021-09-02 11:45:00	17.1	14.100295	7.2	11.6	0.00	156.08	0.00
2021-09-02 11:50:00	17.2	14.049373	7.9	11.0	0.00	156.08	0.00
2021-09-02 11:55:00	17.2	13.926645	8.3	13.2	0.00	156.08	0.00
2021-09-02 12:00:00	17.2	14.051530	8.0	12.1	0.00	156.08	0.00
2021-09-02 12:05:00	17.4	14.005490	8.4	12.0	0.00	156.08	0.00
2021-09-02 12:10:00	17.6	13.853048	7.8	12.8	0.00	156.08	0.00
2021-09-02 12:15:00	17.8	13.914736	7.5	11.4	0.00	156.08	0.00
2021-09-02 12:20:00	17.9	13.896528	8.1	13.5	0.21	156.08	0.00
2021-09-02 12:25:00	17.8	13.888288	7.8	11.6	0.00	156.08	0.00
2021-09-02 12:30:00	17.8	13.976292	7.7	12.2	0.00	156.08	0.00
2021-09-02 12:35:00	18.0	13.903140	7.9	12.3	0.00	156.08	0.00
2021-09-02 12:40:00	18.0	13.872220	7.3	11.7	0.00	156.08	0.00
2021-09-02 12:45:00	18.1	13.970054	6.8	11.9	0.00	156.08	0.00
2021-09-02 12:50:00	18.2	13.975124	7.9	11.8	0.00	156.08	0.00
2021-09-02 12:55:00	18.3	13.998263	7.7	11.1	0.00	156.08	0.00
2021-09-02 13:00:00	18.5	13.960832	8.0	12.5	0.00	156.08	0.00
2021-09-02 13:05:00	18.5	13.777528	7.8	13.3	0.00	156.08	0.00
2021-09-02 13:10:00	18.6	13.791397	8.5	12.1	0.00	156.08	0.00
2021-09-02 13:15:00	18.7	14.062112	8.2	11.9	0.00	156.08	0.00
2021-09-02 13:20:00	18.9	13.912553	7.9	12.6	0.00	156.08	0.00
2021-09-02 13:25:00	18.8	13.971602	8.2	12.4	0.00	156.08	0.00
2021-09-02 13:30:00	19.0	13.972979	7.9	12.0	0.00	156.08	0.00
2021-09-02 13:35:00	19.0	14.070215	7.4	11.4	0.00	156.08	0.00
2021-09-02 13:40:00	19.2	14.069801	7.9	11.2	0.00	156.08	0.00
2021-09-02 13:45:00	19.3	13.816717	7.3	11.6	0.00	156.08	0.00
2021-09-02 13:50:00	19.4	13.797911	7.4	12.4	0.00	156.08	0.00
2021-09-02 13:55:00	19.8	14.262270	7.8	12.9	0.00	156.08	0.00
2021-09-02 14:00:00	19.9	14.594862	7.6	10.6	0.00	156.08	0.00
2021-09-02 14:05:00	19.8	13.883757	6.7	11.7	0.00	156.08	0.00
2021-09-02 14:10:00	19.9	14.104235	6.7	11.4	0.00	156.08	0.00
2021-09-02 14:15:00	20.0	14.238213	6.8	12.6	0.00	156.08	0.00
2021-09-02 14:20:00	20.1	14.541018	6.9	11.0	0.16	156.08	0.00
2021-09-02 14:25:00	20.3	14.385508	7.9	11.5	0.00	156.08	0.00
2021-09-02 14:30:00	20.4	13.778546	7.6	13.2	0.00	156.08	0.00
2021-09-02 14:35:00	20.6	13.823365	7.7	11.4	0.22	156.08	0.00
2021-09-02 14:40:00	20.6	13.971388	7.3	11.0	0.00	156.08	0.00
2021-09-02 14:45:00	20.6	14.486971	7.1	11.0	0.00	156.08	0.00
2021-09-02 14:50:00	20.7	14.296867	7.5	11.8	0.00	156.08	0.00
2021-09-02 14:55:00	20.7	13.997036	7.4	12.2	0.00	156.08	0.00
2021-09-02 15:00:00	20.9	14.243709	7.5	10.9	0.00	156.08	0.00
2021-09-02 15:05:00	21.0	14.390064	7.0	12.1	0.12	156.08	0.00
2021-09-02 15:10:00	21.1	14.089032	7.6	12.6	0.09	156.08	0.00
2021-09-02 15:15:00	21.3	14.184660	7.6	10.9	0.00	156.08	0.00
2021-09-02 15:20:00	21.3	14.620104	7.2	11.9	0.10	156.08	0.00
2021-09-02 15:25:00	21.4	14.471534	7.2	11.3	0.03	156.08	0.00
2021-09-02 15:30:00	21.5	14.291652	7.1	10.6	0.00	156.08	0.00
2021-09-02 15:35:00	22.0	14.391855	6.7	10.6	0.00	156.08	0.00
2021-09-02 15:40:00	22.1	14.673594	6.5	12.3	0.12	156.08	0.00
2021-09-02 15:45:00	21.8	14.559888	7.2	11.5	0.00	156.08	0.00
2021-09-02 15:50:00	22.0	14.070412	7.1	12.8	0.00	156.08	0.00
2021-09-02 15:55:00	22.1	13.955640	7.1	11.5	0.00	156.08	0.00
2021-09-02 16:00:00	21.9	14.264206	7.0	11.7	0.00	156.08	0.00
2021-09-02 16:05:00	22.3	14.761730	7.3	13.0	0.00	156.08	0.00
2021-09-02 16:10:00	22.4	14.261418	6.8	10.6	0.22	156.08	0.11
2021-09-02 16:15:00	22.5	14.953401	7.0	11.1	0.00	156.08	0.00
2021-09-02 16:20:00	22.4	14.307539	7.6	12.0	0.00	156.08	0.00
2021-09-02 16:25:00	22.5	14.402174	6.9	11.5	0.00	156.08	0.00
2021-09-02 16:30:00	22.7	14.712836	7.0	12.7	0.10	156.08	0.00
2021-09-02 16:35:00	22.7	14.707347	6.7	11.7	0.00	156.08	0.00
2021-09-02 16:40:00	22.7	14.310907	7.2	11.8	0.12	156.08	0.00
2021-09-02 16:45:00	23.0	13.384749	8.3	12.1	0.00	156.08	0.00
2021-09-02 16:50:00	22.9	13.662455	7.6	11.0	0.00	156.08	0.00
2021-09-02 16:55:00	22.9	13.999301	7.5	10.6	0.00	156.08	0.00
2021-09-02 17:00:00	23.0	13.677470	6.9	11.2	0.07	156.08	0.00
2021-09-02 17:05:00	23.3	13.251524	6.8	10.3	0.00	156.08	0.10
2021-09-02 17:10:00	23.5	13.599437	7.6	11.7	0.00	156.08	0.10
2021-09-02 17:15:00	23.6	13.176921	8.2	11.7	0.00	156.08	0.00
2021-09-02 17:20:00	23.3	12.883408	7.4	11.9	0.09	156.08	0.00
2021-09-02 17:25:00	23.3	12.757241	7.2	11.1	0.00	156.08	0.00
2021-09-02 17:30:00	23.6	12.305922	7.9	10.9	0.06	156.08	0.00
2021-09-02 17:35:00	23.5	12.305922	7.0	11.8	0.08	156.08	0.00
2021-09-02 17:40:00	23.4	12.607131	7.3	11.8	0.06	156.08	0.13
2021-09-02 17:45:00	23.8	12.572524	7.5	12.9	0.02	156.08	0.00
2021-09-02 17:50:00	23.6	13.363545	8.0	12.5	0.00	156.08	0.00
2021-09-02 17:55:00	23.5	12.965938	7.6	11.3	0.00	156.08	0.00
2021-09-02 18:00:00	24.0	13.108708	7.9	11.1	0.00	156.08	0.00
2021-09-02 18:05:00	23.9	12.499141	7.4	12.5	0.00	156.08	0.00
2021-09-02 18:10:00	24.0	12.675499	8.3	12.1	0.00	156.08	0.00
2021-09-02 18:15:00	23.8	13.315213	7.2	13.0	0.00	156.08	0.00
2021-09-02 18:20:00	23.6	13.172841	8.0	12.5	0.10	156.08	0.00
2021-09-02 18:25:00	23.9	12.930284	7.6	12.4	0.00	156.08	0.14
2021-09-02 18:30:00	23.8	12.556717	6.9	12.9	0.00	156.08	0.00
2021-09-02 18:35:00	23.9	12.051340	7.5	11.8	0.00	156.08	0.00
2021-09-02 18:40:00	24.1	12.888818	7.2	11.4	0.15	156.08	0.00
2021-09-02 18:45:00	24.2	12.092530	8.9	13.5	0.11	156.08	0.12
2021-09-02 18:50:00	24.1	11.996865	7.9	12.3	0.08	156.08	0.00
2021-09-02 18:55:00	24.2	12.074315	8.4	11.3	0.00	156.08	0.00
2021-09-02 19:00:00	24.4	12.286021	8.2	11.1	0.08	156.08	0.00
2021-09-02 19:05:00	24.3	12.433347	8.3	11.1	0.00	156.08	0.00
2021-09-02 19:10:00	24.2	12.286021	7.2	11.7	0.07	156.08	0.00
2021-09-02 19:15:00	24.2	12.433347	6.9	11.3	0.00	156.08	0.00
2021-09-02 19:20:00	24.2	12.381396	7.1	11.0	0.00	156.08	0.00
2021-09-02 19:25:00	24.3	12.759472	7.1	11.5	0.00	156.08	0.00
2021-09-02 19:30:00	24.2	13.247845	7.2	12.0	0.00	156.08	0.00
2021-09-02 19:35:00	24.2	12.555328	7.2	11.7	0.00	156.08	0.00
2021-09-02 19:40:00	24.5	12.157650	7.8	11.9	0.00	156.08	0.00
2021-09-02 19:45:00	24.2	12.375797	8.1	12.3	0.09	156.08	0.00
2021-09-02 19:50:00	24.4	12.860393	8.1	11.7	0.08	156.08	0.00
2021-09-02 19:55:00	24.5	11.928080	7.4	11.8	0.00	156.08	0.00
2021-09-02 20:00:00	24.3	11.710490	7.5	11.0	0.00	156.08	0.00
2021-09-02 20:05:00	24.3	11.875080	7.5	10.6	0.06	156.08	0.00
2021-09-02 20:10:00	24.5	11.680445	7.5	10.5	0.02	156.08	0.00
2021-09-02 20:15:00	24.6	12.010809	8.0	13.0	0.00	156.08	0.00
2021-09-02 20:20:00	24.6	11.839542	7.6	10.6	0.00	156.08	0.00
2021-09-02 20:25:00	24.9	12.224971	6.9	10.8	0.00	156.08	0.00
2021-09-02 20:30:00	24.8	12.342440	7.7	11.6	0.00	156.08	0.00
2021-09-02 20:35:00	25.0	12.584026	6.6	11.0	0.00	156.08	0.00
2021-09-02 20:40:00	24.8	12.342024	6.4	10.1	0.00	156.08	0.00
2021-09-02 20:45:00	24.5	12.712134	6.6	11.3	0.00	156.08	0.00
2021-09-02 20:50:00	24.3	11.811845	6.7	12.1	0.00	156.08	0.00
2021-09-02 20:55:00	24.1	11.889721	6.8	10.4	0.00	156.08	0.00
2021-09-02 21:00:00	24.2	12.296676	7.0	10.4	0.00	156.08	0.00
2021-09-02 21:05:00	24.3	12.056831	6.5	10.6	0.00	156.08	0.00
2021-09-02 21:10:00	24.2	11.980422	6.8	11.4	0.00	156.08	0.00
2021-09-02 21:15:00	24.1	12.130892	7.0	11.4	0.00	156.08	0.00
2021-09-02 21:20:00	23.8	12.797370	6.4	10.8	0.00	156.08	0.00
2021-09-02 21:25:00	24.1	12.265186	7.5	10.4	0.00	156.08	0.00
2021-09-02 21:30:00	24.2	12.170042	7.5	11.0	0.00	156.08	0.00
2021-09-02 21:35:00	23.9	12.028932	7.2	10.8	0.00	156.08	0.00
2021-09-02 21:40:00	23.9	12.172998	7.0	10.3	0.00	156.08	0.00
2021-09-02 21:45:00	24.1	12.056831	6.3	9.9	0.00	156.08	0.00
2021-09-02 21:50:00	24.1	12.106677	6.2	10.3	0.00	156.08	0.00
2021-09-02 21:55:00	24.1	12.268072	6.8	10.5	0.00	156.08	0.00
2021-09-02 22:00:00	24.0	11.959756	6.6	10.8	0.00	156.08	0.00
2021-09-02 22:05:00	24.0	12.120737	6.1	10.3	0.00	156.08	0.00
2021-09-02 22:10:00	24.0	12.002667	6.9	10.6	0.00	156.08	0.00
2021-09-02 22:15:00	23.8	12.032792	5.7	9.6	0.00	156.08	0.00
2021-09-02 22:20:00	23.6	12.317664	6.8	10.4	0.00	156.08	0.00
2021-09-02 22:25:00	23.4	12.089627	6.4	9.8	0.00	156.08	0.00
2021-09-02 22:30:00	23.2	12.234811	6.2	9.7	0.00	156.08	0.00
2021-09-02 22:35:00	23.1	12.314262	6.5	10.1	0.00	156.08	0.00
2021-09-02 22:40:00	23.1	12.139544	6.6	10.1	0.00	156.08	0.00
2021-09-02 22:45:00	23.1	12.139179	6.6	10.9	0.00	156.08	0.00
2021-09-02 22:50:00	23.1	12.070371	6.1	9.7	0.00	156.08	0.00
2021-09-02 22:55:00	22.9	12.152003	6.8	9.8	0.00	156.08	0.00
2021-09-02 23:00:00	22.7	12.226493	6.6	10.4	0.00	156.08	0.00
2021-09-02 23:05:00	22.6	12.553736	6.8	10.8	0.00	156.08	0.00
2021-09-02 23:10:00	22.5	12.767488	6.3	10.3	0.00	156.08	0.00
2021-09-02 23:15:00	22.4	12.785671	6.5	10.8	0.00	156.08	0.00
2021-09-02 23:20:00	22.3	12.913432	6.2	10.8	0.00	156.08	0.00
2021-09-02 23:25:00	22.2	13.076745	6.9	10.5	0.00	156.08	0.00
2021-09-02 23:30:00	22.1	13.205726	6.4	10.8	0.00	156.08	0.00
2021-09-02 23:35:00	22.0	13.007121	6.6	10.4	0.00	156.08	0.00
2021-09-02 23:40:00	21.9	12.830514	6.6	10.0	0.00	156.08	0.00
2021-09-02 23:45:00	21.8	12.834640	7.3	11.7	0.00	156.08	0.00
2021-09-02 23:50:00	21.7	13.211478	6.8	11.6	0.00	156.08	0.00
2021-09-02 23:55:00	21.6	13.370167	7.0	10.8	0.00	156.08	0.00

Do the same but for minima (obviously, most of the columns will have 0 as a minimum)

minT = df_Mins[['TMPC','DWPC','SPED','GUMS','PRCP','PTOT','PRAT']].sort_index()
columnMap = {'TMPC': 'TMin',
             'DWPC': 'TdMin',
             'SPED': 'SPDMin',
             'GUMS': 'GUSTMin',
             'PRCP': 'P5MinMin',
             'PTOT': 'PDayMin',
             'PRAT': 'PRateMin'}
minT.rename(columns=columnMap, inplace=True)

minT

	TMin	TdMin	SPDMin	GUSTMin	P5MinMin	PDayMin	PRateMin
TIME
2021-09-02 00:00:00	12.3	9.077978	0.0	0.3	0.0	0.0	0.0
2021-09-02 00:05:00	12.2	9.076350	0.1	0.4	0.0	0.0	0.0
2021-09-02 00:10:00	12.2	9.076350	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:15:00	12.2	9.018794	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:20:00	12.2	9.037725	0.0	0.3	0.0	0.0	0.0
2021-09-02 00:25:00	12.0	9.001806	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:30:00	12.0	9.039935	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:35:00	12.0	8.925288	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:40:00	11.8	9.188417	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:45:00	11.8	9.281919	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:50:00	11.8	9.248113	0.0	0.0	0.0	0.0	0.0
2021-09-02 00:55:00	11.6	8.923814	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:00:00	11.6	8.460273	0.0	0.3	0.0	0.0	0.0
2021-09-02 01:05:00	11.4	8.401418	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:10:00	11.3	8.320128	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:15:00	11.0	8.039485	0.0	0.4	0.0	0.0	0.0
2021-09-02 01:20:00	10.4	8.100022	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:25:00	10.3	7.983522	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:30:00	10.8	7.983522	0.0	0.3	0.0	0.0	0.0
2021-09-02 01:35:00	10.5	8.246302	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:40:00	10.6	8.147228	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:45:00	10.8	8.266790	0.0	0.3	0.0	0.0	0.0
2021-09-02 01:50:00	10.1	8.303415	0.0	0.0	0.0	0.0	0.0
2021-09-02 01:55:00	9.9	7.899271	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:00:00	10.3	7.917196	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:05:00	10.6	7.858285	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:10:00	10.1	7.821633	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:15:00	10.0	7.913545	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:20:00	10.4	7.705562	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:25:00	10.0	7.769643	0.0	0.3	0.0	0.0	0.0
2021-09-02 02:30:00	9.3	7.727154	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:35:00	9.5	8.054493	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:40:00	9.0	8.186278	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:45:00	9.6	8.026964	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:50:00	9.4	7.743780	0.0	0.0	0.0	0.0	0.0
2021-09-02 02:55:00	8.9	7.477981	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:00:00	8.9	7.892296	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:05:00	9.0	8.112702	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:10:00	9.7	8.035122	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:15:00	9.2	7.976698	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:20:00	8.9	7.878868	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:25:00	9.1	7.918069	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:30:00	9.1	7.879979	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:35:00	8.3	7.916490	0.0	0.3	0.0	0.0	0.0
2021-09-02 03:40:00	9.0	7.693535	0.0	0.3	0.0	0.0	0.0
2021-09-02 03:45:00	9.5	7.975510	0.0	0.3	0.0	0.0	0.0
2021-09-02 03:50:00	8.9	7.936187	0.0	0.0	0.0	0.0	0.0
2021-09-02 03:55:00	8.5	7.657942	0.0	0.3	0.0	0.0	0.0
2021-09-02 04:00:00	8.8	7.684664	0.0	0.4	0.0	0.0	0.0
2021-09-02 04:05:00	8.9	7.582552	0.0	0.3	0.0	0.0	0.0
2021-09-02 04:10:00	8.3	7.558463	0.0	0.4	0.0	0.0	0.0
2021-09-02 04:15:00	8.1	7.996612	0.0	0.0	0.0	0.0	0.0
2021-09-02 04:20:00	8.4	7.430347	0.0	0.0	0.0	0.0	0.0
2021-09-02 04:25:00	8.6	7.698989	0.0	0.0	0.0	0.0	0.0
2021-09-02 04:30:00	8.4	7.971964	0.0	0.0	0.0	0.0	0.0
2021-09-02 04:35:00	8.3	7.902722	0.0	0.0	0.0	0.0	0.0
2021-09-02 04:40:00	8.3	7.775687	0.0	0.4	0.0	0.0	0.0
2021-09-02 04:45:00	8.0	7.691303	0.0	0.4	0.0	0.0	0.0
2021-09-02 04:50:00	7.7	7.626452	0.0	0.5	0.0	0.0	0.0
2021-09-02 04:55:00	8.2	7.263639	0.0	0.4	0.0	0.0	0.0
2021-09-02 05:00:00	7.3	7.113716	0.0	0.3	0.0	0.0	0.0
2021-09-02 05:05:00	7.7	7.274175	0.0	0.4	0.0	0.0	0.0
2021-09-02 05:10:00	7.7	7.136089	0.0	0.0	0.0	0.0	0.0
2021-09-02 05:15:00	7.9	7.269569	0.0	0.0	0.0	0.0	0.0
2021-09-02 05:20:00	7.5	7.017434	0.0	0.0	0.0	0.0	0.0
2021-09-02 05:25:00	7.6	7.106331	0.0	0.3	0.0	0.0	0.0
2021-09-02 05:30:00	7.8	7.037715	0.0	0.0	0.0	0.0	0.0
2021-09-02 05:35:00	7.5	7.181346	0.0	0.0	0.0	0.0	0.0
2021-09-02 05:40:00	6.5	6.456331	0.0	0.4	0.0	0.0	0.0
2021-09-02 05:45:00	7.2	7.120462	0.0	0.3	0.0	0.0	0.0
2021-09-02 05:50:00	7.5	7.029589	0.0	0.4	0.0	0.0	0.0
2021-09-02 05:55:00	6.7	6.685433	0.0	0.0	0.0	0.0	0.0
2021-09-02 06:00:00	6.8	6.770830	0.0	0.0	0.0	0.0	0.0
2021-09-02 06:05:00	7.0	6.985398	0.0	0.3	0.0	0.0	0.0
2021-09-02 06:10:00	7.4	6.706457	0.0	0.4	0.0	0.0	0.0
2021-09-02 06:15:00	7.0	6.617430	0.0	0.3	0.0	0.0	0.0
2021-09-02 06:20:00	7.0	6.975133	0.0	0.3	0.0	0.0	0.0
2021-09-02 06:25:00	7.0	6.477692	0.0	0.4	0.0	0.0	0.0
2021-09-02 06:30:00	7.1	6.427274	0.0	0.3	0.0	0.0	0.0
2021-09-02 06:35:00	6.4	5.887310	0.0	0.4	0.0	0.0	0.0
2021-09-02 06:40:00	6.1	5.883579	0.0	0.0	0.0	0.0	0.0
2021-09-02 06:45:00	6.3	5.877205	0.0	0.0	0.0	0.0	0.0
2021-09-02 06:50:00	6.3	5.578842	0.0	0.0	0.0	0.0	0.0
2021-09-02 06:55:00	6.4	5.668370	0.0	0.4	0.0	0.0	0.0
2021-09-02 07:00:00	6.9	5.368125	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:05:00	6.9	5.412783	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:10:00	7.0	5.407004	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:15:00	7.1	5.717278	0.0	0.4	0.0	0.0	0.0
2021-09-02 07:20:00	6.4	5.850084	0.0	0.3	0.0	0.0	0.0
2021-09-02 07:25:00	6.6	5.965045	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:30:00	6.3	6.094652	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:35:00	6.3	6.094652	0.0	0.3	0.0	0.0	0.0
2021-09-02 07:40:00	6.0	6.000000	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:45:00	6.8	6.209020	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:50:00	5.9	5.885526	0.0	0.0	0.0	0.0	0.0
2021-09-02 07:55:00	6.4	6.400000	0.0	0.0	0.0	0.0	0.0
2021-09-02 08:00:00	6.1	6.100000	0.0	0.0	0.0	0.0	0.0
2021-09-02 08:05:00	6.4	6.361540	0.0	0.4	0.0	0.0	0.0
2021-09-02 08:10:00	5.6	5.600000	0.0	0.5	0.0	0.0	0.0
2021-09-02 08:15:00	6.0	6.000000	0.0	0.0	0.0	0.0	0.0
2021-09-02 08:20:00	6.3	6.241842	0.0	0.4	0.0	0.0	0.0
2021-09-02 08:25:00	5.8	5.800000	0.0	0.4	0.0	0.0	0.0
2021-09-02 08:30:00	5.5	5.500000	0.0	0.0	0.0	0.0	0.0
2021-09-02 08:35:00	5.5	5.500000	0.0	0.0	0.0	0.0	0.0
2021-09-02 08:40:00	5.3	5.300000	0.0	0.0	0.0	0.0	0.0
2021-09-02 08:45:00	5.5	5.500000	0.0	0.0	0.0	0.0	0.0
2021-09-02 08:50:00	5.8	5.800000	0.0	0.4	0.0	0.0	0.0
2021-09-02 08:55:00	5.8	5.800000	0.0	0.4	0.0	0.0	0.0
2021-09-02 09:00:00	5.6	5.600000	0.0	0.4	0.0	0.0	0.0
2021-09-02 09:05:00	4.6	4.600000	0.0	0.3	0.0	0.0	0.0
2021-09-02 09:10:00	5.5	5.500000	0.0	0.3	0.0	0.0	0.0
2021-09-02 09:15:00	5.0	5.000000	0.0	0.0	0.0	0.0	0.0
2021-09-02 09:20:00	4.4	4.400000	0.0	0.4	0.0	0.0	0.0
2021-09-02 09:25:00	4.6	4.600000	0.0	0.3	0.0	0.0	0.0
2021-09-02 09:30:00	5.0	5.000000	0.1	0.4	0.0	0.0	0.0
2021-09-02 09:35:00	5.1	5.100000	0.0	0.5	0.0	0.0	0.0
2021-09-02 09:40:00	5.1	5.100000	0.0	0.4	0.0	0.0	0.0
2021-09-02 09:45:00	4.7	4.700000	0.0	0.4	0.0	0.0	0.0
2021-09-02 09:50:00	4.5	4.500000	0.0	0.0	0.0	0.0	0.0
2021-09-02 09:55:00	4.7	4.700000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:00:00	4.6	4.600000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:05:00	4.5	4.500000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:10:00	4.9	4.900000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:15:00	5.1	4.882942	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:20:00	5.0	4.812203	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:25:00	4.6	4.600000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:30:00	4.4	4.400000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:35:00	4.5	4.500000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:40:00	4.6	4.600000	0.0	0.0	0.0	0.0	0.0
2021-09-02 10:45:00	4.7	4.700000	0.0	0.3	0.0	0.0	0.0
2021-09-02 10:50:00	4.8	4.800000	0.0	0.3	0.0	0.0	0.0
2021-09-02 10:55:00	4.8	4.800000	0.0	0.4	0.0	0.0	0.0
2021-09-02 11:00:00	4.6	4.600000	0.0	0.0	0.0	0.0	0.0
2021-09-02 11:05:00	4.7	4.700000	0.0	0.3	0.0	0.0	0.0
2021-09-02 11:10:00	5.2	5.200000	0.0	0.0	0.0	0.0	0.0
2021-09-02 11:15:00	5.6	5.600000	0.0	0.0	0.0	0.0	0.0
2021-09-02 11:20:00	5.8	5.800000	0.0	0.4	0.0	0.0	0.0
2021-09-02 11:25:00	5.9	5.900000	0.0	0.4	0.0	0.0	0.0
2021-09-02 11:30:00	6.1	6.100000	0.0	0.3	0.0	0.0	0.0
2021-09-02 11:35:00	6.6	6.471358	0.0	0.0	0.0	0.0	0.0
2021-09-02 11:40:00	6.9	6.446048	0.0	0.4	0.0	0.0	0.0
2021-09-02 11:45:00	7.4	6.688499	0.1	0.4	0.0	0.0	0.0
2021-09-02 11:50:00	7.7	6.628944	0.0	0.3	0.0	0.0	0.0
2021-09-02 11:55:00	8.0	6.738125	0.1	0.5	0.0	0.0	0.0
2021-09-02 12:00:00	8.2	6.958153	0.1	0.6	0.0	0.0	0.0
2021-09-02 12:05:00	8.3	6.613535	0.1	0.4	0.0	0.0	0.0
2021-09-02 12:10:00	8.5	6.728617	0.1	0.4	0.0	0.0	0.0
2021-09-02 12:15:00	8.6	6.625871	0.2	0.7	0.0	0.0	0.0
2021-09-02 12:20:00	8.7	6.670168	0.3	0.7	0.0	0.0	0.0
2021-09-02 12:25:00	9.0	6.488283	0.1	0.7	0.0	0.0	0.0
2021-09-02 12:30:00	9.1	6.556621	0.2	0.7	0.0	0.0	0.0
2021-09-02 12:35:00	9.3	6.420453	0.3	0.7	0.0	0.0	0.0
2021-09-02 12:40:00	9.4	6.471798	0.3	0.8	0.0	0.0	0.0
2021-09-02 12:45:00	9.6	6.548516	0.4	0.9	0.0	0.0	0.0
2021-09-02 12:50:00	9.9	6.812102	0.4	0.9	0.0	0.0	0.0
2021-09-02 12:55:00	10.1	6.658792	0.4	0.8	0.0	0.0	0.0
2021-09-02 13:00:00	10.3	6.803585	0.5	1.1	0.0	0.0	0.0
2021-09-02 13:05:00	10.4	6.939264	0.5	0.9	0.0	0.0	0.0
2021-09-02 13:10:00	10.6	6.597418	0.6	1.1	0.0	0.0	0.0
2021-09-02 13:15:00	10.7	5.611855	0.5	1.3	0.0	0.0	0.0
2021-09-02 13:20:00	10.8	6.495972	0.7	1.5	0.0	0.0	0.0
2021-09-02 13:25:00	11.1	6.309914	0.7	1.4	0.0	0.0	0.0
2021-09-02 13:30:00	11.3	6.229525	0.9	1.8	0.0	0.0	0.0
2021-09-02 13:35:00	11.5	6.334530	0.7	1.9	0.0	0.0	0.0
2021-09-02 13:40:00	11.3	6.535285	0.6	1.6	0.0	0.0	0.0
2021-09-02 13:45:00	11.4	6.706076	0.8	1.5	0.0	0.0	0.0
2021-09-02 13:50:00	11.5	6.618016	0.6	1.7	0.0	0.0	0.0
2021-09-02 13:55:00	12.0	6.525341	1.0	2.1	0.0	0.0	0.0
2021-09-02 14:00:00	12.2	6.488534	0.8	1.5	0.0	0.0	0.0
2021-09-02 14:05:00	12.2	6.335436	0.8	1.6	0.0	0.0	0.0
2021-09-02 14:10:00	11.9	5.769207	0.7	1.5	0.0	0.0	0.0
2021-09-02 14:15:00	12.3	5.987683	0.8	1.8	0.0	0.0	0.0
2021-09-02 14:20:00	11.8	6.046957	0.8	1.9	0.0	0.0	0.0
2021-09-02 14:25:00	11.9	6.576044	0.7	2.1	0.0	0.0	0.0
2021-09-02 14:30:00	11.7	6.292690	0.5	1.5	0.0	0.0	0.0
2021-09-02 14:35:00	11.6	6.507202	0.9	1.5	0.0	0.0	0.0
2021-09-02 14:40:00	11.6	6.912520	0.6	1.3	0.0	0.0	0.0
2021-09-02 14:45:00	11.5	6.650255	0.4	1.1	0.0	0.0	0.0
2021-09-02 14:50:00	11.6	6.637808	0.5	1.2	0.0	0.0	0.0
2021-09-02 14:55:00	11.8	6.667029	0.8	2.1	0.0	0.0	0.0
2021-09-02 15:00:00	11.8	6.930255	0.5	1.0	0.0	0.0	0.0
2021-09-02 15:05:00	11.9	6.731381	0.7	1.6	0.0	0.0	0.0
2021-09-02 15:10:00	11.8	6.897237	0.8	2.7	0.0	0.0	0.0
2021-09-02 15:15:00	11.8	5.907758	0.9	2.0	0.0	0.0	0.0
2021-09-02 15:20:00	11.7	5.634208	0.7	2.4	0.0	0.0	0.0
2021-09-02 15:25:00	11.8	5.817417	0.8	1.8	0.0	0.0	0.0
2021-09-02 15:30:00	12.0	6.356081	0.6	1.6	0.0	0.0	0.0
2021-09-02 15:35:00	12.0	6.243003	0.6	2.3	0.0	0.0	0.0
2021-09-02 15:40:00	12.0	6.088728	0.7	2.3	0.0	0.0	0.0
2021-09-02 15:45:00	12.1	6.243442	0.8	2.1	0.0	0.0	0.0
2021-09-02 15:50:00	12.2	6.356081	0.8	2.3	0.0	0.0	0.0
2021-09-02 15:55:00	12.0	6.114187	0.8	1.8	0.0	0.0	0.0
2021-09-02 16:00:00	12.0	5.748016	0.7	2.2	0.0	0.0	0.0
2021-09-02 16:05:00	11.9	5.542757	0.5	1.5	0.0	0.0	0.0
2021-09-02 16:10:00	11.8	5.695182	0.5	1.6	0.0	0.0	0.0
2021-09-02 16:15:00	11.6	5.885071	0.8	2.3	0.0	0.0	0.0
2021-09-02 16:20:00	11.6	5.841711	0.9	2.7	0.0	0.0	0.0
2021-09-02 16:25:00	12.1	5.664830	0.8	2.5	0.0	0.0	0.0
2021-09-02 16:30:00	12.4	5.592896	0.8	2.0	0.0	0.0	0.0
2021-09-02 16:35:00	12.1	5.966082	0.7	2.2	0.0	0.0	0.0
2021-09-02 16:40:00	12.0	6.212631	0.8	2.8	0.0	0.0	0.0
2021-09-02 16:45:00	12.1	6.248679	0.7	1.9	0.0	0.0	0.0
2021-09-02 16:50:00	12.1	6.202796	0.6	1.7	0.0	0.0	0.0
2021-09-02 16:55:00	12.1	5.841943	0.6	1.8	0.0	0.0	0.0
2021-09-02 17:00:00	12.1	4.891047	0.6	1.5	0.0	0.0	0.0
2021-09-02 17:05:00	12.4	5.790289	0.6	1.5	0.0	0.0	0.0
2021-09-02 17:10:00	12.4	5.736051	0.5	1.5	0.0	0.0	0.0
2021-09-02 17:15:00	12.3	5.341797	0.6	1.4	0.0	0.0	0.0
2021-09-02 17:20:00	12.4	5.575943	0.8	2.0	0.0	0.0	0.0
2021-09-02 17:25:00	12.4	4.661590	0.6	1.7	0.0	0.0	0.0
2021-09-02 17:30:00	12.3	4.825809	0.6	2.0	0.0	0.0	0.0
2021-09-02 17:35:00	12.2	4.624785	0.8	1.9	0.0	0.0	0.0
2021-09-02 17:40:00	12.5	5.520937	0.5	1.2	0.0	0.0	0.0
2021-09-02 17:45:00	12.4	5.055825	0.5	1.7	0.0	0.0	0.0
2021-09-02 17:50:00	12.3	5.253784	0.4	0.9	0.0	0.0	0.0
2021-09-02 17:55:00	12.2	5.665615	0.7	2.0	0.0	0.0	0.0
2021-09-02 18:00:00	12.3	6.061347	0.7	2.3	0.0	0.0	0.0
2021-09-02 18:05:00	12.3	5.806722	0.6	2.2	0.0	0.0	0.0
2021-09-02 18:10:00	12.3	5.638781	0.7	2.0	0.0	0.0	0.0
2021-09-02 18:15:00	12.2	4.499593	0.8	2.2	0.0	0.0	0.0
2021-09-02 18:20:00	12.4	5.769207	0.8	2.0	0.0	0.0	0.0
2021-09-02 18:25:00	12.5	4.631086	0.7	2.2	0.0	0.0	0.0
2021-09-02 18:30:00	12.3	4.730455	0.7	2.1	0.0	0.0	0.0
2021-09-02 18:35:00	12.2	5.180528	0.5	2.2	0.0	0.0	0.0
2021-09-02 18:40:00	12.3	4.721588	0.6	2.0	0.0	0.0	0.0
2021-09-02 18:45:00	12.3	5.462188	0.8	2.4	0.0	0.0	0.0
2021-09-02 18:50:00	12.2	5.656649	0.7	1.9	0.0	0.0	0.0
2021-09-02 18:55:00	12.3	5.127527	0.7	2.0	0.0	0.0	0.0
2021-09-02 19:00:00	12.4	4.825603	0.8	1.7	0.0	0.0	0.0
2021-09-02 19:05:00	12.4	4.429576	0.4	1.5	0.0	0.0	0.0
2021-09-02 19:10:00	12.6	4.450958	0.8	2.2	0.0	0.0	0.0
2021-09-02 19:15:00	12.5	4.351650	0.8	2.4	0.0	0.0	0.0
2021-09-02 19:20:00	12.4	5.125821	0.7	1.9	0.0	0.0	0.0
2021-09-02 19:25:00	12.6	5.183298	0.5	1.8	0.0	0.0	0.0
2021-09-02 19:30:00	12.6	5.174033	0.6	2.1	0.0	0.0	0.0
2021-09-02 19:35:00	12.5	4.632749	0.5	1.7	0.0	0.0	0.0
2021-09-02 19:40:00	12.4	4.454208	0.6	1.8	0.0	0.0	0.0
2021-09-02 19:45:00	12.3	5.678218	0.6	1.7	0.0	0.0	0.0
2021-09-02 19:50:00	12.3	5.844679	0.3	1.2	0.0	0.0	0.0
2021-09-02 19:55:00	12.5	5.303677	0.5	1.7	0.0	0.0	0.0
2021-09-02 20:00:00	12.3	5.095387	0.8	2.5	0.0	0.0	0.0
2021-09-02 20:05:00	12.3	5.335927	0.6	1.9	0.0	0.0	0.0
2021-09-02 20:10:00	12.2	5.500589	0.4	1.4	0.0	0.0	0.0
2021-09-02 20:15:00	12.2	5.595395	0.6	1.4	0.0	0.0	0.0
2021-09-02 20:20:00	12.1	6.244079	0.5	1.4	0.0	0.0	0.0
2021-09-02 20:25:00	12.1	5.817101	0.5	1.1	0.0	0.0	0.0
2021-09-02 20:30:00	12.1	5.725656	0.5	1.2	0.0	0.0	0.0
2021-09-02 20:35:00	12.1	5.163991	0.5	0.9	0.0	0.0	0.0
2021-09-02 20:40:00	12.1	5.416011	0.0	0.5	0.0	0.0	0.0
2021-09-02 20:45:00	12.0	5.227363	0.6	1.3	0.0	0.0	0.0
2021-09-02 20:50:00	12.0	5.100371	0.6	2.0	0.0	0.0	0.0
2021-09-02 20:55:00	12.1	4.554389	0.6	1.8	0.0	0.0	0.0
2021-09-02 21:00:00	12.1	5.176923	0.5	1.6	0.0	0.0	0.0
2021-09-02 21:05:00	12.1	5.329392	0.6	1.5	0.0	0.0	0.0
2021-09-02 21:10:00	12.0	5.359125	0.6	2.5	0.0	0.0	0.0
2021-09-02 21:15:00	12.0	4.932160	0.5	1.5	0.0	0.0	0.0
2021-09-02 21:20:00	12.0	4.872015	0.5	1.1	0.0	0.0	0.0
2021-09-02 21:25:00	12.0	4.963340	0.6	1.3	0.0	0.0	0.0
2021-09-02 21:30:00	12.0	4.841459	0.6	1.8	0.0	0.0	0.0
2021-09-02 21:35:00	11.9	5.052810	0.6	2.0	0.0	0.0	0.0
2021-09-02 21:40:00	11.8	5.433822	0.5	1.6	0.0	0.0	0.0
2021-09-02 21:45:00	11.8	5.015528	0.4	1.1	0.0	0.0	0.0
2021-09-02 21:50:00	11.7	5.225012	0.3	1.3	0.0	0.0	0.0
2021-09-02 21:55:00	11.7	5.423316	0.5	1.3	0.0	0.0	0.0
2021-09-02 22:00:00	11.6	5.595006	0.5	1.2	0.0	0.0	0.0
2021-09-02 22:05:00	11.6	5.672511	0.2	1.5	0.0	0.0	0.0
2021-09-02 22:10:00	11.6	5.261280	0.5	1.2	0.0	0.0	0.0
2021-09-02 22:15:00	11.6	5.608730	0.4	1.2	0.0	0.0	0.0
2021-09-02 22:20:00	11.5	5.423448	0.1	0.6	0.0	0.0	0.0
2021-09-02 22:25:00	11.5	5.347637	0.3	1.3	0.0	0.0	0.0
2021-09-02 22:30:00	11.5	5.591313	0.2	1.0	0.0	0.0	0.0
2021-09-02 22:35:00	11.3	5.738311	0.1	0.6	0.0	0.0	0.0
2021-09-02 22:40:00	11.0	5.840210	0.2	0.6	0.0	0.0	0.0
2021-09-02 22:45:00	10.8	6.189074	0.2	0.7	0.0	0.0	0.0
2021-09-02 22:50:00	10.8	6.470802	0.2	0.6	0.0	0.0	0.0
2021-09-02 22:55:00	10.7	6.594209	0.0	0.4	0.0	0.0	0.0
2021-09-02 23:00:00	10.8	6.690868	0.1	0.7	0.0	0.0	0.0
2021-09-02 23:05:00	10.9	6.689045	0.1	0.6	0.0	0.0	0.0
2021-09-02 23:10:00	10.8	6.650600	0.1	0.5	0.0	0.0	0.0
2021-09-02 23:15:00	10.9	6.630584	0.1	0.8	0.0	0.0	0.0
2021-09-02 23:20:00	10.8	6.686247	0.0	0.0	0.0	0.0	0.0
2021-09-02 23:25:00	10.8	6.666071	0.0	0.4	0.0	0.0	0.0
2021-09-02 23:30:00	10.8	6.572652	0.0	0.5	0.0	0.0	0.0
2021-09-02 23:35:00	10.9	6.690295	0.0	0.4	0.0	0.0	0.0
2021-09-02 23:40:00	11.0	6.707497	0.0	0.4	0.0	0.0	0.0
2021-09-02 23:45:00	11.0	6.845968	0.0	0.4	0.0	0.0	0.0
2021-09-02 23:50:00	10.9	7.092187	0.0	0.0	0.0	0.0	0.0
2021-09-02 23:55:00	10.9	6.970620	0.0	0.4	0.0	0.0	0.0

Note: We don't see a station ID column, but that's because each max and min likely comes from a different station.

---

Summary

• Pandas’ groupby method forms the basis of this library’s split-apply-combine methodology.

What’s Next?

Next, we will look at Dataframes with multiple indices.

Resources and References

1. MetPy Monday 99

2. Split/Apply/Combine (Wickham, 2011)

3. Ch. 10 notebook from Github Repository for Wes McKinney’s Pandas for Data Analysis book

previous

Pandas 5: Combining and Writing

next

Pandas Notebook 7: Merging DataFrames