{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "ad7592e7", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_2459435/230780042.py:2: DtypeWarning: Columns (25) have mixed types. Specify dtype option on import or set low_memory=False.\n", " data = pd.read_csv('/home/xj/toolAugEnv/code/toolConstraint/database/hotels/Airbnb_Open_Data.csv')\n" ] } ], "source": [ "import pandas as pd\n", "data = pd.read_csv('/home/xj/toolAugEnv/code/toolConstraint/database/hotels/Airbnb_Open_Data.csv')" ] }, { "cell_type": "code", "execution_count": 2, "id": "f97916a9", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | id | \n", "NAME | \n", "host id | \n", "host_identity_verified | \n", "host name | \n", "neighbourhood group | \n", "neighbourhood | \n", "lat | \n", "long | \n", "country | \n", "... | \n", "service fee | \n", "minimum nights | \n", "number of reviews | \n", "last review | \n", "reviews per month | \n", "review rate number | \n", "calculated host listings count | \n", "availability 365 | \n", "house_rules | \n", "license | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1001254 | \n", "Clean & quiet apt home by the park | \n", "80014485718 | \n", "unconfirmed | \n", "Madaline | \n", "Brooklyn | \n", "Kensington | \n", "40.64749 | \n", "-73.97237 | \n", "United States | \n", "... | \n", "$193 | \n", "10.0 | \n", "9.0 | \n", "10/19/2021 | \n", "0.21 | \n", "4.0 | \n", "6.0 | \n", "286.0 | \n", "Clean up and treat the home the way you'd like... | \n", "NaN | \n", "
1 | \n", "1002102 | \n", "Skylit Midtown Castle | \n", "52335172823 | \n", "verified | \n", "Jenna | \n", "Manhattan | \n", "Midtown | \n", "40.75362 | \n", "-73.98377 | \n", "United States | \n", "... | \n", "$28 | \n", "30.0 | \n", "45.0 | \n", "5/21/2022 | \n", "0.38 | \n", "4.0 | \n", "2.0 | \n", "228.0 | \n", "Pet friendly but please confirm with me if the... | \n", "NaN | \n", "
2 | \n", "1002403 | \n", "THE VILLAGE OF HARLEM....NEW YORK ! | \n", "78829239556 | \n", "NaN | \n", "Elise | \n", "Manhattan | \n", "Harlem | \n", "40.80902 | \n", "-73.94190 | \n", "United States | \n", "... | \n", "$124 | \n", "3.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "5.0 | \n", "1.0 | \n", "352.0 | \n", "I encourage you to use my kitchen, cooking and... | \n", "NaN | \n", "
3 | \n", "1002755 | \n", "NaN | \n", "85098326012 | \n", "unconfirmed | \n", "Garry | \n", "Brooklyn | \n", "Clinton Hill | \n", "40.68514 | \n", "-73.95976 | \n", "United States | \n", "... | \n", "$74 | \n", "30.0 | \n", "270.0 | \n", "7/5/2019 | \n", "4.64 | \n", "4.0 | \n", "1.0 | \n", "322.0 | \n", "NaN | \n", "NaN | \n", "
4 | \n", "1003689 | \n", "Entire Apt: Spacious Studio/Loft by central park | \n", "92037596077 | \n", "verified | \n", "Lyndon | \n", "Manhattan | \n", "East Harlem | \n", "40.79851 | \n", "-73.94399 | \n", "United States | \n", "... | \n", "$41 | \n", "10.0 | \n", "9.0 | \n", "11/19/2018 | \n", "0.10 | \n", "3.0 | \n", "1.0 | \n", "289.0 | \n", "Please no smoking in the house, porch or on th... | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
102594 | \n", "6092437 | \n", "Spare room in Williamsburg | \n", "12312296767 | \n", "verified | \n", "Krik | \n", "Brooklyn | \n", "Williamsburg | \n", "40.70862 | \n", "-73.94651 | \n", "United States | \n", "... | \n", "$169 | \n", "1.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "3.0 | \n", "1.0 | \n", "227.0 | \n", "No Smoking No Parties or Events of any kind Pl... | \n", "NaN | \n", "
102595 | \n", "6092990 | \n", "Best Location near Columbia U | \n", "77864383453 | \n", "unconfirmed | \n", "Mifan | \n", "Manhattan | \n", "Morningside Heights | \n", "40.80460 | \n", "-73.96545 | \n", "United States | \n", "... | \n", "$167 | \n", "1.0 | \n", "1.0 | \n", "7/6/2015 | \n", "0.02 | \n", "2.0 | \n", "2.0 | \n", "395.0 | \n", "House rules: Guests agree to the following ter... | \n", "NaN | \n", "
102596 | \n", "6093542 | \n", "Comfy, bright room in Brooklyn | \n", "69050334417 | \n", "unconfirmed | \n", "Megan | \n", "Brooklyn | \n", "Park Slope | \n", "40.67505 | \n", "-73.98045 | \n", "United States | \n", "... | \n", "$198 | \n", "3.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "5.0 | \n", "1.0 | \n", "342.0 | \n", "NaN | \n", "NaN | \n", "
102597 | \n", "6094094 | \n", "Big Studio-One Stop from Midtown | \n", "11160591270 | \n", "unconfirmed | \n", "Christopher | \n", "Queens | \n", "Long Island City | \n", "40.74989 | \n", "-73.93777 | \n", "United States | \n", "... | \n", "$109 | \n", "2.0 | \n", "5.0 | \n", "10/11/2015 | \n", "0.10 | \n", "3.0 | \n", "1.0 | \n", "386.0 | \n", "NaN | \n", "NaN | \n", "
102598 | \n", "6094647 | \n", "585 sf Luxury Studio | \n", "68170633372 | \n", "unconfirmed | \n", "Rebecca | \n", "Manhattan | \n", "Upper West Side | \n", "40.76807 | \n", "-73.98342 | \n", "United States | \n", "... | \n", "$206 | \n", "1.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "3.0 | \n", "1.0 | \n", "69.0 | \n", "NaN | \n", "NaN | \n", "
102599 rows × 26 columns
\n", "\n", " | NAME | \n", "room type | \n", "price | \n", "minimum nights | \n", "review rate number | \n", "house_rules | \n", "maximum occupancy | \n", "city | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Clean & quiet apt home by the park | \n", "Private room | \n", "$966 | \n", "10.0 | \n", "4.0 | \n", "Clean up and treat the home the way you'd like... | \n", "1 | \n", "Des Moines | \n", "
1 | \n", "Skylit Midtown Castle | \n", "Entire home/apt | \n", "$142 | \n", "30.0 | \n", "4.0 | \n", "Pet friendly but please confirm with me if the... | \n", "2 | \n", "Wilmington | \n", "
2 | \n", "THE VILLAGE OF HARLEM....NEW YORK ! | \n", "Private room | \n", "$620 | \n", "3.0 | \n", "5.0 | \n", "I encourage you to use my kitchen, cooking and... | \n", "2 | \n", "St. George | \n", "
3 | \n", "NaN | \n", "Entire home/apt | \n", "$368 | \n", "30.0 | \n", "4.0 | \n", "NaN | \n", "2 | \n", "Kalamazoo | \n", "
4 | \n", "Entire Apt: Spacious Studio/Loft by central park | \n", "Entire home/apt | \n", "$204 | \n", "10.0 | \n", "3.0 | \n", "Please no smoking in the house, porch or on th... | \n", "3 | \n", "Cheyenne | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
102594 | \n", "Spare room in Williamsburg | \n", "Private room | \n", "$844 | \n", "1.0 | \n", "3.0 | \n", "No Smoking No Parties or Events of any kind Pl... | \n", "1 | \n", "White Plains | \n", "
102595 | \n", "Best Location near Columbia U | \n", "Private room | \n", "$837 | \n", "1.0 | \n", "2.0 | \n", "House rules: Guests agree to the following ter... | \n", "2 | \n", "Mosinee | \n", "
102596 | \n", "Comfy, bright room in Brooklyn | \n", "Private room | \n", "$988 | \n", "3.0 | \n", "5.0 | \n", "NaN | \n", "2 | \n", "Amarillo | \n", "
102597 | \n", "Big Studio-One Stop from Midtown | \n", "Entire home/apt | \n", "$546 | \n", "2.0 | \n", "3.0 | \n", "NaN | \n", "4 | \n", "Binghamton | \n", "
102598 | \n", "585 sf Luxury Studio | \n", "Entire home/apt | \n", "$1,032 | \n", "1.0 | \n", "3.0 | \n", "NaN | \n", "7 | \n", "Flint | \n", "
102599 rows × 8 columns
\n", "\n", " | Unnamed: 0 | \n", "NAME | \n", "room type | \n", "price | \n", "minimum nights | \n", "review rate number | \n", "house_rules | \n", "maximum occupancy | \n", "city | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "Clean & quiet apt home by the park | \n", "Private room | \n", "$966 | \n", "10.0 | \n", "4.0 | \n", "Clean up and treat the home the way you'd like... | \n", "1 | \n", "Des Moines | \n", "
1 | \n", "1 | \n", "Skylit Midtown Castle | \n", "Entire home/apt | \n", "$142 | \n", "30.0 | \n", "4.0 | \n", "Pet friendly but please confirm with me if the... | \n", "2 | \n", "Wilmington | \n", "
2 | \n", "2 | \n", "THE VILLAGE OF HARLEM....NEW YORK ! | \n", "Private room | \n", "$620 | \n", "3.0 | \n", "5.0 | \n", "I encourage you to use my kitchen, cooking and... | \n", "2 | \n", "St. George | \n", "
3 | \n", "3 | \n", "NaN | \n", "Entire home/apt | \n", "$368 | \n", "30.0 | \n", "4.0 | \n", "NaN | \n", "2 | \n", "Kalamazoo | \n", "
4 | \n", "4 | \n", "Entire Apt: Spacious Studio/Loft by central park | \n", "Entire home/apt | \n", "$204 | \n", "10.0 | \n", "3.0 | \n", "Please no smoking in the house, porch or on th... | \n", "3 | \n", "Cheyenne | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
102594 | \n", "102594 | \n", "Spare room in Williamsburg | \n", "Private room | \n", "$844 | \n", "1.0 | \n", "3.0 | \n", "No Smoking No Parties or Events of any kind Pl... | \n", "1 | \n", "White Plains | \n", "
102595 | \n", "102595 | \n", "Best Location near Columbia U | \n", "Private room | \n", "$837 | \n", "1.0 | \n", "2.0 | \n", "House rules: Guests agree to the following ter... | \n", "2 | \n", "Mosinee | \n", "
102596 | \n", "102596 | \n", "Comfy, bright room in Brooklyn | \n", "Private room | \n", "$988 | \n", "3.0 | \n", "5.0 | \n", "NaN | \n", "2 | \n", "Amarillo | \n", "
102597 | \n", "102597 | \n", "Big Studio-One Stop from Midtown | \n", "Entire home/apt | \n", "$546 | \n", "2.0 | \n", "3.0 | \n", "NaN | \n", "4 | \n", "Binghamton | \n", "
102598 | \n", "102598 | \n", "585 sf Luxury Studio | \n", "Entire home/apt | \n", "$1,032 | \n", "1.0 | \n", "3.0 | \n", "NaN | \n", "7 | \n", "Flint | \n", "
102599 rows × 9 columns
\n", "