import this
import numpy as np
import pandas as pd
df = pd.read_csv('try2_6stations.csv')
# 1)
parse_dates = ["Datetime"],index_col=('Datetime'))
# or
# 2) df['Datetime'] = pd.to_datetime(df.Datetime)
print(df.info())
print(df.describe())
df['year'] = pd.DatetimeIndex(air_quality_raw_df.Datetime).year
df['month'] = pd.DatetimeIndex(air_quality_raw_df.Datetime).month
df['day'] = pd.DatetimeIndex(air_quality_raw_df.Datetime).day
df['Category1'] = df['Category1'].astype('category')
df['Category2'] = df['Category2'].astype('category')
df['Category3'] = df['Category3'].astype('category')
I get wrong answers, when I apply groupby or resample function !
TIA for suggestions to handle such data !