Skip to content

Instantly share code, notes, and snippets.

@arianaescobar

arianaescobar/usingcarto-1.md

Created March 14, 2018 11:07
Show Gist options
  • Save arianaescobar/51260f5ebda49528ce1696f917b8f1c1 to your computer and use it in GitHub Desktop.
Save arianaescobar/51260f5ebda49528ce1696f917b8f1c1 to your computer and use it in GitHub Desktop.
Download ZIP
Using CARTO - Exercise 1
Raw
usingcarto-1.md

Airbnb

Finding the data

I found the data easily. I googled “airbnb data” and the second result was Inside Airbnb with all the data. I doubted a bit between the listings and the reviews CSV files so I downloaded both to check the data. I finally went with listings.csv.

Uploading data to Builder

  • First, I renamed listings.csv to airbnb_listings_madrid_2018.csv so I would know in the future what that dataset was about.
  • The dataset uploaded quite fast and it got automatically geocoded which is great. I thought I would had to perform a geocode analysis.

Finding out average price in Madrid

  • I just added a Formula widget with the price column, switched it to AVG and added “ €” as suffix.
  • The dropdown on the Operation input field on the Formula widget options wasn’t selecting the price column when I switched to AVG and typed price. Had to close the dropdown, switch to COUNT and try again with AVG and then it let me.
@arianaescobar
Copy link
Author

Map: https://team.carto.com/u/arianaescobar/builder/0aa5fd6d-9865-4ddf-ae52-ef5aed66c1b6/embed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment