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

data = pd.read_csv('../input/airbnbnewyork/listings.csv')

data.shape

data.isnull().sum()

data.drop(['id', 'host_name', 'last_review'], axis=1, inplace=True)

data.fillna({'reviews_per_month': 0}, inplace=True)
data.reviews_per_month.isnull().sum()

data.neighbourhood_group.unique()

len(data.neighbourhood.unique())

data.room_type.unique()

#we will skip first column for now and begin from host_id

#let's see what hosts (IDs) have the most listings on Airbnb platform and taking advantage of this service
top_host=data.host_id.value_counts().head(10)
top_host

top_host_check = data.calculated_host_listings_count.max()
top_host_check