summarizing dataframe into a dictionary,df.groupby('date')['level'].first().apply(np.ceil).to_dict()