Dataset Overview
The dataset university_of_oxford_tripadvisor_reviews.csv comprises 1119 reviews from TripAdvisor on the University of Oxford. Each review includes details like the date of publication, the platform used for publishing, and the type of trip.
Data Science Applications
Despite its small size, the dataset offers opportunities for practical data science applications:
Sentiment Analysis: Analyze the review text to understand public opinion about the University of Oxford.
Trend Analysis: Visualize the trend of ratings over time to identify periods of high or low visitor satisfaction.
Word Cloud: Create a word cloud to identify the most frequent words used in the reviews, providing insights into key discussion points.
Dataset Columns
The dataset contains the following columns:
helpfulVotes: The number of votes the review received for being helpful.
publishedDate: The date the review was published.
publishedPlatform: The platform used to publish the review (e.g., mobile, tablet, desktop).
rating: The rating given in the review.
text: The actual text of the review.
title: The title of the review.
tripType: The type of trip (e.g., business, family, solo).
Ethically Mined Data
The data was ethically mined from TripAdvisor using Apify, ensuring no personally identifiable information was collected and respecting TripAdvisor's terms of service.
Acknowledgements
Thanks to TripAdvisor for providing the reviews, Apify for enabling the ethical data mining, and Google Gemini for dataset image.