Exporting Data to CSV and Excel

import pandas as pd  # import the pandas library
# define the url where the data is located and read it into a pandas dataframe
url = 'https://github.com/mattharrison/datasets/raw/master/data/dirtydevil.txt'
df = pd.read_csv(url, skiprows=lambda num: num <34 or num == 35, sep='\t')
# define a function to convert the timezone to America/Denver
def to_denver_time(df_, time_col, tz_col):
    return (df_  # the input dataframe
       .assign(**{tz_col: df_[tz_col].replace('MDT', 'MST7MDT')})  # replace 'MDT' with 'MST7MDT' in the timezone column
       .groupby(tz_col)[time_col]  # group the dataframe by the timezone column and select the time column
       .transform(lambda s: pd.to_datetime(s)  # convert the time column to datetime format
           .dt.tz_localize(s.name, ambiguous=True)  # localize the datetime to the timezone column
           .dt.tz_convert('America/Denver')))  # convert the timezone to America/Denver
# define a function to tweak the river data
def tweak_river(df_):
    return (df_  # the input dataframe
     .assign(datetime=to_denver_time(df_, 'datetime', 'tz_cd'))  # add a new column of datetime in the America/Denver timezone
     .rename(columns={'144166_00060': 'cfs', '144167_00065': 'gage_height'})  # rename two columns
     .set_index('datetime')  # set the datetime column as the index
    )
# apply the function to tweak the river data
dd = tweak_river(df)
print(dd)  # print the resulting dataframe