import pandas as pd
import csv

df = pd.read_csv('/Users/liamcolless/Dropbox/Uni/DATA1002/project/data/Basel.csv') 
df = df.drop(['Basel', 'Basel.1'], axis = 1)
df2 = df.drop([0, 1, 2, 3, 4, 5, 6, 7, 8]).reset_index(drop=True).rename(columns={"location": "Timestamp", "Basel.2": "Mean Temperature"})
df2["Round"] = df2['Mean Temperature'].round(decimals=2)
print(df2)