Advertisement
Guest User

Untitled

a guest
Apr 9th, 2020
240
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.37 KB | None | 0 0
  1. data['kitchen_k'] = data['kitchen_area'] / data['total_area']
  2. kitchen_mean_k = data.groupby('rooms').agg({'kitchen_k' : 'mean'})
  3.  
  4.  
  5. for room in kitchen_mean_k.index:
  6.     data.loc[(data['rooms'] == room) & (data['kitchen_area'].isnull()), 'kitchen_area'] = data.loc[(data['rooms'] == room) & (data['kitchen_area'].isnull()), 'total_area'] * kitchen_mean_k.loc[room, 'kitchen_k']
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement