Skip to content

karenwky/Tableau_Airbnb_LA

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Tableau: Airbnb(Los Angeles)

With data provided by Inside Airbnb, an interactive dashboard is created for customers based on accommodation features.
dashboard1

Data Source

  1. listings.csv.gz
    Detailed listings data such as amenities, zip code and room type.

  2. listings.csv
    Summary information and metrics for listings sucha as name, price and number of reviews.

  3. reviews.csv
    Date of review and listing id.

Data Preprocessing

  1. Create new boolean features for amenities.
    amenities

  2. Select features from each dataset. listing2_features listings_features reviews

  3. Narrow down the dataset by selecting zip codes of 2 different areas.

    Hollywood Boulevard
    90019, 90035, 90036 South Robertson
    90046, 90069 West Hollywood
    90048 Carthay
    90068 Hollywood Dell
    Bay side
    90058 Vernon
    90066, 90230, 90292, 90293 Marina del Rey
    90291 Venice
    90401, 90402, 90403, 90404, 90405 Santa Monica

Interactive Dashboard

dashboard2 Customers can easily find the ideal accommodation by selecting different criterias, such as amenities, room type, bed type and price.

Detailed Presentation

Skills Acquired

  • Pandas: e.g. cleaning data, creating new tables and features
  • Tableau: e.g. using filters, parameters and pages to create interactive dashboard

About

data analysis with interactive dashboard

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published