Dataset: TripAdvisor European Restaurants

About this Dataset

TripAdvisor European Restaurants

Context

TripAdvisor is the most popular travel website and it stores data for almost all restaurants, showing locations (even latitude and longitude coordinates), restaurant descriptions, user ratings and reviews, and many more aspects.

The website is well known for displaying user ratings and reviews for restaurants, hotels, b&b, touristic attractions, and other places, with a total word count of all reviews is more than 10 billion.

Content

The TripAdvisor dataset includes 1,083,397 restaurants with attributes such as location data, average rating, number of reviews, open hours, cuisine types, awards, etc.

The dataset combines the restaurants from the main European countries.

Acknowledgements

Data has been retrieved from the publicly available website https://tripadvisor.com/.

All the restaurants from the main European countries have been scraped in early May 2021.

Inspiration

To provide further information in regards to the restaurants details that make them successful and appreciated by the users, with the possibility to compare the common features of different European countries regarding the average ratings, awards, open hours, reviews count, etc.

Tables

Tripadvisor European Restaurants

@kaggle.stefanoleone992_tripadvisor_european_restaurants.tripadvisor_european_restaurants

130.06 MB
1083397 rows
42 columns


CREATE TABLE tripadvisor_european_restaurants (
  "restaurant_link" VARCHAR,
  "restaurant_name" VARCHAR,
  "original_location" VARCHAR,
  "country" VARCHAR,
  "region" VARCHAR,
  "province" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "claimed" VARCHAR,
  "awards" VARCHAR,
  "popularity_detailed" VARCHAR,
  "popularity_generic" VARCHAR,
  "top_tags" VARCHAR,
  "price_level" VARCHAR,
  "price_range" VARCHAR,
  "meals" VARCHAR,
  "cuisines" VARCHAR,
  "special_diets" VARCHAR,
  "features" VARCHAR,
  "vegetarian_friendly" VARCHAR,
  "vegan_options" VARCHAR,
  "gluten_free" VARCHAR,
  "original_open_hours" VARCHAR,
  "open_days_per_week" DOUBLE,
  "open_hours_per_week" DOUBLE,
  "working_shifts_per_week" DOUBLE,
  "avg_rating" DOUBLE,
  "total_reviews_count" DOUBLE,
  "default_language" VARCHAR,
  "reviews_count_in_default_language" DOUBLE,
  "excellent" DOUBLE,
  "very_good" DOUBLE,
  "average" DOUBLE,
  "poor" DOUBLE,
  "terrible" DOUBLE,
  "food" DOUBLE,
  "service" DOUBLE,
  "value" DOUBLE,
  "atmosphere" DOUBLE,
  "keywords" VARCHAR
);