ratneshpasi03's picture
Update questions data
707521a
raw
history blame contribute delete
881 Bytes
def true_code():
import pandas as pd
df = pd.read_csv('data/raw_data/Data.csv', sep=",")
df['Timestamp'] = pd.to_datetime(df['Timestamp'])
df['Year'] = df['Timestamp'].dt.year
df['Month'] = df['Timestamp'].dt.month
data = df[df['Year'] == 2018]
data = data[data['station'] == 'Lal Bahadur Shastri Nagar, Kalaburagi - KSPCB']
winter_data = data[(data['Month'] == 12) | (data['Month'] <= 2)]
summer_data = data[(data['Month'] >= 3) & (data['Month'] <= 5)]
monsoon_data = data[(data['Month'] >= 6) & (data['Month'] <= 9)]
summer_avg = summer_data['PM2.5'].mean()
winter_avg = winter_data['PM2.5'].mean()
monsoon_avg = monsoon_data['PM2.5'].mean()
print("Winter Average PM2.5:", winter_avg)
print("Monsoon Average PM2.5:", monsoon_avg)
print("Summer Average PM2.5:", summer_avg)
true_code()