Solving Python Data Analysis Interview Questions - Airbnb

In this series, I will be solving python data analysis interview questions in Stratascratch. In this particular video, I'm solving Google's interview question.

My solutions to the mentioned questions are:
City With Most Amenities:
df = airbnb_search_details[['city', 'amenities']]

Ranking Most Active Guests:
df = airbnb_contacts[['id_guest', 'n_messages']]
df['rank'] = df['n_messages'].rank(ascending = False, method = 'dense')
df

Timestamps:
0:00 City With Most Amenities
6:40 Ranking Most Active Guests