Advertisement
Guest User

Untitled

a guest
Jan 26th, 2020
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.47 KB | None | 0 0
  1. area_K = data.groupby('rooms').agg({'living_area' : 'mean', 'total_area' : 'mean'})
  2.  
  3. area_K['K'] = area_K['living_area']/area_K['total_area']
  4.  
  5.  
  6.  
  7. def fill_living_area(row):
  8.     rooms = row['rooms']
  9.     total_area = row['total_area']
  10.     living_area = row['living_area']
  11.    
  12.     if rooms in area_K.index:
  13.         return area_K.loc[rooms, 'K']*total_area
  14.     return living_area
  15.  
  16. data.loc[data['living_area'].isnull(),'living_area'] = data.apply(fill_living_area, axis = 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement