Guest User

Untitled

a guest
Jul 18th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. df = pd.read_csv('t.csv')
  2. max_df = df[['city', 'temperature']].groupby('city').max().reset_index()
  3. pd.merge(max_df, df[['city', 'temperature', 'windspeed']], how='inner', on=['city', 'temperature'])
  4.  
  5. city_and_max_temp = data.groupby('city').agg('max')[['temperature']]
  6. data.merge( right=city_and_max_temp ,how='inner')[['city','windspeed']]
Add Comment
Please, Sign In to add comment