Hello im trying to do a dataframe and get the min values of a column "electric consum"i have a counter for each hour of the day and by groupying into same date i want to get the minimum electric consum hour of each day
datas={'date': date,'year': year, 'season': season, 'day': day, 'month': month, 'hour': hour, 'electric consum':consum}
df = pd.DataFrame(data=datas, index=ind)
mini = datas.groupby(['date'])['electric consum'].min()
with this i get a data frame sorted by day and the minimum consum for each day but i cant see the hour how can i get that
date
2010-05-25 6.321167
2010-05-26 6.518963
2010-05-27 6.423513