top of page
horizontal lines
Gigasheet Primary logo
  • Apoorva Pachori

Black Friday Data Analysis

Is your Black Friday wishlist ready?

Black Friday is a shopper’s delight. It is a day full of special shopping deals and big discounts and is considered the beginning of the holiday shopping season. On the flipside, businesses look at this day as an opportunity to win new customers, boost sales, and increase profits. The name ‘Black Friday’ is a reference to the black ink which was used to record profits!(Unfortunately it's often the time of year when e-commerce fraud also peaks.)

To make the most of the Black Friday sale, business owners can look at past data. That way, they can decide which products to offer at high discounts, which demographics to market to, and more.

In this blog post, we will use Gigasheet for exploring a Black Friday dataset, and answer some questions. Let's get started!

Black Friday Data Analysis

About the Dataset

We are using the dataset ‘BlackFriday.csv’ from Kaggle.

Explore this data in Gigasheet ↗️ No login required

This CSV file contains 550,000 records about Black Friday purchases in a retail store. The dataset has the following attributes:

User_ID : A unique value identifying each buyer

Product_ID: A unique value identifying each product

● Gender : The gender of the buyer (M or F)

Age: The buyer's age

Occupation: The buyer's occupation, specified as a numeric value

City_Category: The city category in which the purchase was made

Stay_In_Current_City_Years: The number of years that a buyer has lived in their city

Marital_Status: The marital status of the buyer. 0 denotes single, 1 denotes married.

Product_Category_1: The main category of the product, specified as a number.

● Product_Category_2: The first subcategory of the product

● Product_Category_3: The second subcategory of the product

● Purchase: The amount spent by a user for a purchase, in dollars

Data Exploration With Gigasheet

Gigasheet is the perfect tool to make sense of massive datasets like these. It is a free, no-code data exploration tool that can open large CSV files with ease. Gigasheet is more than an online CSV viewer, it's really a spreadsheet backed by a big data analytics platform.

So, if you aren’t a coder, don’t worry. You can still enjoy exploring data, with just a few clicks.

  • First, create a free Gigasheet account.

  • Next, click on 'New'.

  • Then, navigate to your file location on your device, or a cloud drive.

  • That's it. Gigasheet will open your dataset for you, no matter the size.

Let us now explore the dataset and try to answer some burning questions about Black Friday.

A. Who Spends More: Men or Women?

Hold your guesses. Let use see what the dataset has to say. We will use Gigasheet’s Group feature to answer this question.

Here, we are grouping the dataset by gender. Next, we are using the ‘Sum’ aggregate function on the column ‘Purchases’ to calculate the total amount spent by each of these groups.

Adding a Group By clause on the column Gender

The results of grouping by gender