Dataset: Airbnb-NYC-Cleaned

About this Dataset

Airbnb-NYC-Cleaned

IF YOU WANT TO START WITH DATA VISUALIZATION DIRECTLY, USE THIS DATASET

But if you want to start with data cleaning, find the original dataset below:
This is a cleaned version of the Airbnb open data found at the following link:
https://www.kaggle.com/datasets/arianazmoudeh/airbnbopendata

The original message from Arian:
"This dataset is part of Airbnb Inside but I tried to make new columns and many data inconsistency issue to create a new dataset to practice data cleaning. The original source can be found here http://insideairbnb.com/explore/

Arian Azmoudeh"

Tables

Airbnb Nyc Clean

@kaggle.sandeepmajumdar_airbnbnyccleaned.airbnb_nyc_clean

4.39 MB
69305 rows
23 columns


CREATE TABLE airbnb_nyc_clean (
  "id" BIGINT,
  "name" VARCHAR,
  "host_id" BIGINT,
  "host_identity_verified" VARCHAR,
  "host_name" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "instant_bookable" BOOLEAN,
  "cancellation_policy" VARCHAR,
  "room_type" VARCHAR,
  "construction_year" DOUBLE,
  "price" DOUBLE,
  "service_fee" DOUBLE,
  "minimum_nights" DOUBLE,
  "number_of_reviews" DOUBLE,
  "last_review" TIMESTAMP,
  "reviews_per_month" DOUBLE,
  "review_rate_number" DOUBLE,
  "calculated_host_listings_count" DOUBLE,
  "availability_365" DOUBLE,
  "house_rules" VARCHAR
);