{"id":36613,"date":"2023-04-11T11:32:19","date_gmt":"2023-04-11T15:32:19","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infovis\/?p=36613"},"modified":"2023-04-11T11:33:38","modified_gmt":"2023-04-11T15:33:38","slug":"visualisation-of-airbnb-data-in-paris","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/visualisation-of-airbnb-data-in-paris\/","title":{"rendered":"Visualisation of Airbnb data in Paris"},"content":{"rendered":"\n

Introduction<\/strong><\/p>\n\n\n\n

This visualisation is an exploration of the Airbnb data in Paris. It analysis the spread of the Airbnb\u2019s as per locality and then further explores proximity to the metro as a parameter. The overlay of the road network map gives idea of proximity to roads and not just the metro. Finally the overlay of the arrondissements map gives an idea of the spread of these Airbnb\u2019s across different localities with transportation as a key data point.<\/p>\n\n\n

\n
\"\"
Road Network Paris<\/figcaption><\/figure>\n<\/div>\n\n\n
\"\"
Airbnb and metro proximity<\/figcaption><\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"\"
Airbnb data with metro proximity and road network<\/figcaption><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Dataset<\/strong><\/p>\n\n\n\n

Airbnb csv data for Paris<\/strong> – <\/a>https:\/\/www.kaggle.com\/datasets\/thedevastator\/airbnb-prices-in-european-cities<\/a><\/p>\n\n\n\n

Paris road network shapefile<\/strong> – <\/a>https:\/\/geodata.lib.utexas.edu\/catalog\/stanford-db591kz1574<\/a><\/p>\n\n\n\n

Paris arrondissements shapefile<\/strong> – <\/a>https:\/\/data.metabolismofcities.org\/library\/maps\/38838\/<\/a><\/p>\n\n\n\n

The data sheet explores Airbnb data in Europe in terms of prices and has city-wise data available as csv files. The data was accessed using Kaggle. The datasheet was a fairly tidy one and didn\u2019t require much cleaning. The data covers the following attributes.<\/p>\n\n\n\n

Column name<\/strong><\/td>Description<\/strong><\/td><\/tr>
realSum<\/strong><\/td>The total price of the Airbnb listing. (Numeric)<\/td><\/tr>
room_type<\/strong><\/td>The type of room being offered (e.g. private, shared, etc.). (Categorical)<\/td><\/tr>
room_shared<\/strong><\/td>Whether the room is shared or not. (Boolean)<\/td><\/tr>
room_private<\/strong><\/td>Whether the room is private or not. (Boolean)<\/td><\/tr>
person_capacity<\/strong><\/td>The maximum number of people that can stay in the room. (Numeric)<\/td><\/tr>
host_is_superhost<\/strong><\/td>Whether the host is a superhost or not. (Boolean)<\/td><\/tr>
multi<\/strong><\/td>Whether the listing is for multiple rooms or not. (Boolean)<\/td><\/tr>
biz<\/strong><\/td>Whether the listing is for business purposes or not. (Boolean)<\/td><\/tr>
cleanliness_rating<\/strong><\/td>The cleanliness rating of the listing. (Numeric)<\/td><\/tr>
guest_satisfaction_overall<\/strong><\/td>The overall guest satisfaction rating of the listing. (Numeric)<\/td><\/tr>
bedrooms<\/strong><\/td>The number of bedrooms in the listing. (Numeric)<\/td><\/tr>
dist<\/strong><\/td>The distance from the city centre. (Numeric)<\/td><\/tr>
metro_dist<\/strong><\/td>The distance from the nearest metro station. (Numeric)<\/td><\/tr>
lng<\/strong><\/td>The longitude of the listing. (Numeric)<\/td><\/tr>
lat<\/strong><\/td>The latitude of the listing. (Numeric)<\/td><\/tr><\/tbody><\/table>
Data Attributes Airbnb<\/em><\/figcaption><\/figure>\n\n\n\n

The shape files for mapping were obtained from 2 different sources, one with the roadway mapping and one with the region\/arrondissement mapping.<\/p>\n\n\n\n

Tools -used<\/strong><\/p>\n\n\n\n

Tools that were used to make this visualisation were Excel, Open Refine, QGIS and Figma. The report was made and published using WordPress.<\/p>\n\n\n\n

Process<\/strong><\/p>\n\n\n\n

The making of this visualisation required tools like OpenRefine, excel, QGIS and Figma. Each tool served a separate purpose<\/p>\n\n\n\n

Research<\/em><\/p>\n\n\n\n

The first phase of my process involved researching for data sources that had geographic attributes as a key parameter. I started looking at housing data and then found travel and bnb data in this domain which further intrigued my interest.<\/p>\n\n\n\n

My second phase of research involved looking for open-source shapefiles for maps of Paris and I came across a road-network file which I thought could add a lot of perspective to my visualisation and finally found a locality map as well.<\/p>\n\n\n\n

Open-Refine- Data Cleaning<\/em><\/p>\n\n\n\n

I used Open Refine to clean the data. The data was fairly clean, hence I just exported it as a csv<\/p>\n\n\n\n

QGIS Data Representation<\/em><\/p>\n\n\n\n

I had to import the csv in QGIS and add layers of the road network shape file and arrondissements shape file.<\/p>\n\n\n\n

Visualisations & Observations<\/em><\/p>\n\n\n\n

1.<\/strong> Airbnb locations <\/strong>– I overlaid the Airbnb locations over the arrondissement map to get a visualisation of the spread. I used dots to represent the location
2. Metro proximity<\/strong> – I used an expression to highlight metro areas and specifically mark airbnb\u2019s with proximity less than 200 mts to the metro.
if( \"metro_dist\" <0.2, \"metro_dist\",0)<\/code><\/p>\n\n\n\n

3.<\/strong> Metro proximity and road network <\/strong>– I overlaid the above mappings on the road-network map by exporting files in the same dimensions and using Figma to overlay them.<\/p>\n\n\n\n

Reflection and Critique<\/strong><\/p>\n\n\n\n

Limitations<\/em><\/p>\n\n\n\n

QGIS is an open-source software with documentation that is quite detailed for a few cases and minimal for a few others. The software sometimes crashes and I had challenges with importing .shp files. It also sometimes renders .shx in different co-ordinates which again was a challenge while producing this visualisation.<\/p>\n\n\n\n

Positives<\/em><\/p>\n\n\n\n

QGIS is a good tool for geo-spatial visualisations, simple expressions can help generate a lot of insightful data. The layering feature is quite powerful for geographic visualisation of data.<\/p>\n\n\n\n

Peer Critique and changes<\/em><\/p>\n\n\n\n

My final chart had some issues with overlay and it was suggested to me that I find a way to overlay a map without which the visualisation looks incomplete. I worked on it using Figma as a tool and I also eventually found a locality map which matched the co-ordinate system of my data thus improving the visualisation.<\/p>\n\n\n\n

Bibliography<\/strong><\/p>\n\n\n\n

Airbnb Prices in European Cities<\/em>. (n.d.). Retrieved April 11, 2023, from https:\/\/www.kaggle.com\/datasets\/thedevastator\/airbnb-prices-in-european-cities<\/a><\/p>\n\n\n\n

Vasserot Road Network (1810-1836) – University of Texas Libraries GeoData<\/em>. (n.d.). Retrieved April 11, 2023, from https:\/\/geodata.lib.utexas.edu\/catalog\/stanford-db591kz1574<\/a><\/p>\n\n\n\n

Arrondissements de Paris | Metabolism of Cities Data Hub<\/em>. (n.d.). Retrieved April 11, 2023, from https:\/\/data.metabolismofcities.org\/library\/maps\/38838\/<\/a><\/p>\n\n\n\n

QGIS Tutorials and Tips \u2014 QGIS Tutorials and Tips<\/em>. (n.d.). Retrieved April 11, 2023, from https:\/\/www.qgistutorials.com\/en\/index.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction This visualisation is an exploration of the Airbnb data in Paris. It analysis the spread of the Airbnb\u2019s as per locality and then further explores proximity to the metro as a parameter. The overlay of the road network map gives idea of proximity to roads and not just the metro. Finally the overlay of…<\/p>\n","protected":false},"author":4041,"featured_media":36614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[5,31,186],"coauthors":[1843],"class_list":["post-36613","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization","tag-information-visualization","tag-maps","tag-qgis"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/04\/map-view-paris.png?fit=842%2C638&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-9wx","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/36613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/4041"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=36613"}],"version-history":[{"count":2,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/36613\/revisions"}],"predecessor-version":[{"id":36620,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/36613\/revisions\/36620"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/36614"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=36613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=36613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=36613"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=36613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}