text_html_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

df = pd.read_csv('/kaggle/input/airbnb-user-pathways/airbnb.csv')
df.drop('id_visitor', axis=1, inplace=True)
df.drop('id_session', axis=1, inplace=True)
df.drop('next_id_session', axis=1, inplace=True)
df.drop('dim_user_agent', axis=1, inplace=True)

df.isnull().sum()

df.corr() * 100

sending = df.groupby('dim_device_app_combo').sum()
sending.sort_values('sent_message', ascending=False, inplace=True)
sending

df['time_spend'] = df['ts_max'] - df['ts_min']
df['time_spend'] = df['time_spend'].dt.total_seconds()
time_spend = sending = df.groupby('dim_device_app_combo').mean().sort_values('time_spend')
time_spend.plot.bar(y='time_spend')