Makeup Product Data Exploration

This dataset explores a range of makeup and fragrance products. It includes information such as product names, brands, sizes, ratings, and customer engagement. The purpose of this analysis is to provide insight into trends in product popularity, consumer preferences, and brand performance, helping users make informed decisions and/or explore market patterns.

Core Dataset: Makeup & Fragrance Products

Product ID Product Name Brand Name Loves Count Rating Reviews Size
P473668La Habana Eau de Parfum19-6938274.15133.4 oz / 100 mL
P473662Rainbow Bar Eau de Parfum19-6932534.25163.4 oz / 100 mL
P473660Kasbah Eau de Parfum19-6930184.48213.4 oz / 100 mL
P473658Purple Haze Eau de Parfum19-6926913.23133.4 oz / 100 mL
P473661Kasbah Eau de Parfum Travel Spray19-6924484.48210.25 oz / 7.5 mL
P473659Purple Haze Eau de Parfum Travel Spray19-6916193.23130.25 oz / 7.5 mL
P473666Invisible Post Eau de Parfum19-6915423.6383.4 oz / 100 mL
P472300Capri Eau de Parfum19-6915423.5773.4 oz / 100 mL
P473667Invisible Post Eau de Parfum Travel Spray19-6913773.6380.25 oz / 7.5 mL
P473663Rainbow Bar Eau de Parfum Travel Spray19-6913714.25160.25 oz / 7.5 mL
P473670Capri Eau de Parfum Travel Spray19-6912063.5770.25 oz / 7.5 mL
P473664L'air Barbes Eau de Parfum19-699813.0043.4 oz / 100 mL
P473665L'air Barbes Eau de Parfum Travel Spray19-697213.0040.25 oz / 7.5 mL
P476416African Beauty Butter – Intensive Dry Skin Treatment54 Thrones190284.332586 oz / 180 mL
P503832Mini AFRICAN Beauty Butter- Intensive Dry Skin Treatment54 Thrones33924.517511 oz / 30 mL
P483139The Cape PerfumeABBOTT31184.611111.7 oz / 50 mL
P483080Crescent Beach Perfume Travel SprayABBOTT19574.777810.33 oz / 10 mL
P483079Crescent Beach PerfumeABBOTT16084.588211.7 oz / 50 mL
P483131Seqouia Eau de Parfum Travel SprayABBOTT14584.166710.34 oz / 10 mL
P483130Sequoia PerfumeABBOTT13224.61911.7 oz / 50 mL
P483108Mojave Perfume Travel SprayABBOTT11374.714310.33 oz / 10 mL
P483140The Cape Perfume Travel SprayABBOTT10923.833310.34 oz / 10 mL
P483072Big Sky Eau de Parfum Travel SprayABBOTT9754.2510.27 oz / 8 mL
P483071Big Sky Eau de ParfumABBOTT9664.62511.7 oz / 50 mL
P483110Montecito Perfume Travel SprayABBOTT8973.714310.33 oz / 10 mL
P483109Montecito PerfumeABBOTT8284.111111.7 oz / 50 mL
P483107Mojave PerfumeABBOTT8254.090911.7 oz / 50 mL
P443401Blu Mediterraneo Mini Eau de Toilette SetAcqua di Parma72903.333355 x 0.16 oz / 5 mL
P307804Mirto di PanareaAcqua di Parma56584.435911 oz / 30 mL
P375388Arancia di CapriAcqua di Parma48123.945911 oz / 30 mL
P163604ColoniaAcqua di Parma41574.212513.4 oz / 100 mL
P252213Magnolia NobileAcqua di Parma33784.279113.4 oz / 101 mL
P456550Yuzu Eau de ParfumAcqua di Parma19534.666710.7 oz / 20 mL
Dataset sourced from Kaggle and a publicly available Sephora product dataset online.
 
 

Glossary of Terms

Loves Count
The number of people who have marked this product as a favorite
Brand ID
The unique identifier for the product brand from the site
Product ID
The unique identifier for the product from the site
Rating
The average rating of the product based on user reviews (out of 5)

Focused Data Breakdown: Highest Rated Products

Product Name Brand Rating Loves
Crescent Beach Perfume Travel Spray ABBOTT 4.78 1957
Yuzu Eau de Parfum Acqua di Parma 4.67 1953
Crescent Beach Perfume Out of Stock Perfume

What This Subset Shows

This focused selection highlights some of the highest-rated products in the dataset. Despite relatively low review counts, these fragrances maintain strong average ratings, suggesting high customer satisfaction among an engaged group of users.

Notably, ABBOTT appears multiple times in this subset, indicating consistent product performance and strong brand perception within the fragrance category.

Further more, online they are consistently "out of stock", signalling a high demand for the product!    

Yuzu Eau de Parfum Aqua Di Parma Parfum price

What This Shows

The Yuzu Parfum from Acqua di Parma is significantly more expensive than a same sized bottle from Abbott. Despite the price contrast causing the Yuzu Parfum to appear more desirable, it is still lower ranked, less "loved" and less purchased than the Crescent Beach Perfume.

This should help consumers gain knowledge that price does not always = quality! It is important to look at reviews online such as those on this site for more accurate information.