adamamer20/yelp-04-2024

Yelp Complete Open Dataset 04.2024

Dataset Description

This dataset contains the complete Yelp Open Dataset, a rich collection of user reviews, business information, and user data. It is a valuable resource for tasks such as sentiment analysis, recommendation systems, and other natural language processing (NLP) projects.

Source

The dataset is provided by Yelp and is publicly available under the Yelp Dataset Terms of Use.

Dataset Structure

The dataset includes the following files:

• —business.json: contains business data including location data, attributes, and categories.
• —review.json: contains full review text data including the userid that wrote the review and the businessid the review is written for.
• —user.json: user data including the user's friend mapping and all the metadata associated with the user.
• —tip.json: tips written by a user on a business. Tips are shorter than reviews and tend to convey quick suggestions.
• —checkin.json: Business check-in data
• —photo.json: Contains photo data including the caption and classification (one of "food", "drink", "menu", "inside" or "outside").

Columns and Data

business.json

• —business_id: Unique identifier for each business
• —name: Name of the business
• —address: Address of the business
• —city, state, postal_code: Location details
• —stars: Average star rating
• —review_count: Number of reviews
• —categories: Categories the business belongs to

review.json

• —review_id: Unique identifier for each review
• —user_id: User who wrote the review
• —business_id: Business being reviewed
• —stars: Star rating provided in the review
• —text: Text of the review
• —date: Date of the review

user.json

• —user_id: Unique identifier for each user
• —name: Name of the user
• —review_count: Number of reviews by the user
• —yelping_since: Date when the user joined Yelp
• —friends: List of friends (other users)
• —useful, funny, cool: Number of times the user's reviews were marked useful, funny, or cool

tip.json

• —text: Text of the tip
• —business_id: Business the tip is about
• —user_id: User who wrote the tip
• —date: Date of the tip

checkin.json

• —business_id: Business the check-in is for
• —date: Date and time of check-ins

Use Cases

This dataset can be used for various machine learning and data analysis tasks including:

• —Sentiment analysis
• —Building recommendation systems
• —Natural language processing tasks
• —Social network analysis based on user friendships and interactions

How to Use

To use the dataset, download the files and load them into your preferred data analysis environment (e.g., Python with Pandas). The data is in JSON format, so you can easily read it using Python libraries like json or pandas.

License

Please review the Yelp Dataset Terms of Use before using the dataset.

Acknowledgments

This dataset is provided by Yelp as part of their open data initiative to support academic research and non-commercial projects.