combining rows in pandas,df.reset_index().groupby('city_id').sum()