import pandas as pd
import matplotlib.pyplot as plt

data = pd.read_csv("ugz_luftqualitaetsmessungen_seit-2012.csv")
newdata = data.iloc[5:,0:3]
newdata = newdata.rename(columns={"Zürich Stampfenbachstrasse" : "SO2", "Zürich Stampfenbachstrasse.1": "CO"})

newdata["SO2"] = newdata["SO2"].astype(float)
newdata["CO"] = newdata["CO"].astype(float)

newdata = newdata.loc[(newdata["SO2"] < 0.1) | (newdata["SO2"] > 0.25), "CO"]
datalist = list(newdata)
plt.plot(datalist)
plt.savefig("cx_out/out.png")
#print(newdata)