Data exploration of the Amazon review dataset using the free version of ChatGPT

ChatGPT premium version has a code interpreter, but first, we will use the free version of ChatGPT. We will craft our initial prompt carefully to include all the features, but we will instruct it to wait for user feedback after providing code for each feature.

Feature 1: Loading the dataset

Let’s craft our initial prompt to load the dataset.

[Prompt]

I want to explore the Amazon product review dataset thoroughly using various statistical and visualization techniques (TAG 1.1), which consists of the following fields (PIC 2.3):

• marketplace (string): The location of the product.
• customer_id (string): A unique identifier for customers.
• review_id (string): A unique identifier for reviews.
• product_id (string): A unique identifier for products.
• product_parent (string): A parent product identifier.
• product_title (string): The title of the reviewed...