<jupyter_start><jupyter_text>GLERL Water Temperature Data Parser--- <NAME>Email: [<EMAIL>](mailto:<EMAIL>) | GitHub:[@HumphreysCarter](https://github.com/HumphreysCarter) | Website: [carterhumphreys.com](http://carterhumphreys.com/)<jupyter_code>import pandas as pd
from datetime import datetime
dataDir='../data/WATER_TEMP/'
df = pd.DataFrame()
for year in range(2015, 2020):  
    tmp_df = pd.read_csv(f'{dataDir}/glsea-temps{year}_1024.dat', skiprows=[0,1,2,3,4,5,6,8,9], delim_whitespace=True) 
    
    if len(df.values) == 0:
        df = tmp_df
    else:
        df=df.append(tmp_df)

#df.to_csv('GreatLakesWaterTemp_2015-2019', index=False) 
years = df['Year'].values
days = df['Day'].values
dates = []

for year, day in zip(years, days):
    dates.append(datetime.strptime(f'{year}_{day}', '%Y_%j'))

df.insert(0, 'Date', dates)
df=df.drop(['Year', 'Day'], axis=1)
df=df.rename(columns={'Sup.':'Superior Lake', 'Mich.':'Lake Michigan', 'Huron':'Lake Huron', 'Erie':'Lake Erie', 'Ont.':'Lake Ontario', 'St.Clr':'Lake Saint Clair'})
df<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.20149253731343283, 'fraction_numerical': 0.029850746268656716, 'mean_word_length': 5.6234567901234565, 'pattern_counts': {'":': 0, '<': 8, '<?xml version=': 0, '>': 8, 'https://': 1, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '282594', 'license': 'BSD-3-Clause', 'n_tokens_mistral': 455, 'n_tokens_neox': 426, 'n_words': 71, 'path': 'LES-Band-Position-Prediction/scripts/ReadWaterTemperatureData.ipynb', 'repo_name': 'carterhumphreys/LES-Machine-Learning', 'size': '1109'}