Oyo Rental Price Prediction In China

Oyo Rental Price Prediction in Shenzhen,China

@kaggle.ramjasmaurya_oyo_rental_price_prediction_in_china

Table List

2 tables(310.6 KB)

Rating Features

@kaggle.ramjasmaurya_oyo_rental_price_prediction_in_china.rating_features

300.05 KB
5834 rows
25 columns

accommodates Accommodates	amenities Amenities	availability_30 Availability 30	bathrooms Bathrooms	bed_type Bed Type	bedrooms Bedrooms	beds Beds	calculated_host_listings_count Calculated Host Listings Count	cancellation_policy Cancellation Policy	guests_included Guests Included	has_availability Has Availability	host_is_superhost Host Is Superhost	host_listings_count Host Listings Count	instant_bookable Instant Bookable	latitude_north Latitude(North)	longitude_east Longitude(East)	maximum_nights Maximum Nights	number_of_reviews Number Of Reviews	property_type Property Type	review_scores_checkin Review Scores Checkin	review_scores_communication Review Scores Communication	review_scores_location Review Scores Location	review_scores_rating Review Scores Rating	review_scores_value Review Scores Value	room_type Room Type
6	{"Cable TV",Internet,"Wireless Internet","Air Conditioning",Kitchen,"Pets live on this property",Dog(s),"Other pet(s)","Hot Tub","Indoor Fireplace",Heating,"Family/Kid Friendly",Washer,Dryer,"Smoke Detector","Fire Extinguisher",Essentials}		2.5	Real Bed	1	3	1	moderate	1	t	f	1	f	22.5429	114.0596	10	1	House	10	10	10	100	10	Private room
2	{"Air Conditioning",Heating,"Family/Kid Friendly","Smoke Detector","First Aid Kit","Fire Extinguisher"}	29		Futon	1	1	1	moderate	1	t	f	1	f	22.53949026	114.0432254	7		Camper/RV						Private room
2	{TV,"Cable TV",Internet,"Wireless Internet","Air Conditioning",Pool,Kitchen,"Free Parking on Premises","Indoor Fireplace",Heating,Washer,Dryer,"Smoke Detector","Safety Card","Fire Extinguisher",Essentials,Shampoo,"Lock on Bedroom Door"}	30	1.5	Real Bed	1	1	2	flexible	1	t	f	2	f	22.50857255	114.079426	1125		House						Private room
2	{TV,"Cable TV",Internet,"Wireless Internet","Air Conditioning",Pool,Kitchen,"Free Parking on Premises","Indoor Fireplace",Heating,Washer,Dryer,"Smoke Detector","First Aid Kit","Fire Extinguisher",Essentials,Shampoo,"Lock on Bedroom Door"}	30	1.5	Real Bed	1	1	2	flexible	1	t	f	2	f	22.50869749	114.0790348	1125		House						Private room
6	{TV,"Cable TV",Internet,"Wireless Internet","Air Conditioning",Kitchen,"Free Parking on Premises","Indoor Fireplace",Heating,"Family/Kid Friendly",Washer,Dryer,"Smoke Detector","Fire Extinguisher",Essentials,Shampoo}	27	2	Real Bed	3	3	2	strict	1	t	f	301	f	22.50950177	114.0555903	1125		House						Entire home/apt
2	{TV,"Cable TV",Internet,"Wireless Internet","Air Conditioning",Kitchen,"Free Parking on Premises","Pets live on this property",Dog(s),Heating,"Smoke Detector","Carbon Monoxide Detector","First Aid Kit","Fire Extinguisher",Essentials}	30	1	Real Bed	1	1	1	flexible	1	t	f	1	f	22.52683988	114.036466	1125		House						Private room
2	{"Wireless Internet","Air Conditioning","Pets live on this property",Heating,"Family/Kid Friendly"}		1	Futon	1	1	1	flexible	2	t	f	1	f	22.52777147	114.0236918	1125		Bed & Breakfast						Private room
2	{TV,Internet,"Wireless Internet","Air Conditioning",Kitchen,"Free Parking on Premises","Indoor Fireplace",Heating,"Family/Kid Friendly",Washer,Dryer,"Smoke Detector","Carbon Monoxide Detector","First Aid Kit","Safety Card","Fire Extinguisher",Essentials,Shampoo}	16	1	Real Bed	1	1	1	moderate	2	t	f	1	t	22.52325961	114.0529223	7	2	House	10	10	10	100	10	Private room
6	{TV,"Cable TV",Internet,"Wireless Internet","Air Conditioning",Kitchen,"Free Parking on Premises","Pets Allowed","Pets live on this property",Dog(s),Heating,"Family/Kid Friendly",Washer,Dryer,Essentials,Shampoo}	29	1	Real Bed	1	3	1	flexible	2	t	f	2	t	22.52936805	114.0745361	1125		House						Private room
2	{TV,"Cable TV","Wireless Internet","Air Conditioning",Kitchen,"Free Parking on Premises","Pets Allowed","Pets live on this property",Dog(s),Heating,Washer,Dryer,"Smoke Detector","Fire Extinguisher",Essentials,Shampoo}	29	1	Real Bed	1	1	1	moderate	2	t	t	1	f	22.51049991	114.0739115	1125	20	House	10	10	10	99	10	Private room


CREATE TABLE rating_features (
  "accommodates" BIGINT,
  "amenities" VARCHAR,
  "availability_30" BIGINT,
  "bathrooms" DOUBLE,
  "bed_type" VARCHAR,
  "bedrooms" DOUBLE,
  "beds" DOUBLE,
  "calculated_host_listings_count" BIGINT,
  "cancellation_policy" VARCHAR,
  "guests_included" BIGINT,
  "has_availability" VARCHAR,
  "host_is_superhost" VARCHAR,
  "host_listings_count" DOUBLE,
  "instant_bookable" VARCHAR,
  "latitude_north" DOUBLE,
  "longitude_east" DOUBLE,
  "maximum_nights" BIGINT,
  "number_of_reviews" BIGINT,
  "property_type" VARCHAR,
  "review_scores_checkin" DOUBLE,
  "review_scores_communication" DOUBLE,
  "review_scores_location" DOUBLE,
  "review_scores_rating" DOUBLE,
  "review_scores_value" DOUBLE,
  "room_type" VARCHAR
);