for column in ['living_area', 'kitchen_area', 'ceiling_height']:
    for room in data_pivot_rooms.index:
        df.loc[df['rooms'] == room, column] = df.loc[df['rooms'] == room, column].fillna(data_pivot_rooms.loc[room, column])