Skip to content

Latest commit

 

History

History
96 lines (81 loc) · 3.68 KB

File metadata and controls

96 lines (81 loc) · 3.68 KB

La Mer Product Selection and Price Analysis: Chicago O'Hare Airport

Overview

How much do we really save by shopping duty-free at the airport? These were my thoughts during a flight delay while travelling back home from the Chicago O'Hare International Airport. Skincare and cosmetics rank among the highest-selling categories in terms of volume at airport duty-free stores, especially sought after by travelers seeking in-demand products from luxury brands. La Mer stands out as one of the top high-end skincare brands, renowned for its beloved anti-aging cream: Crème de La Mer. To all skincare enthusiast and La Mer lovers, I will be comparing product selection, availability and pricing at three different purchase locations: Chicago O’Hare Terminal 3 duty-free store, Chicago O’Hare duty-free website and La Mer’s official USA website.


Repository Contents

Folder: data

Raw data

File Name Data Description
lamer_bestsellers.json best-seller products on La Mer's website
lamer_face_products.json all face products on La Mer's website
lamer_official_website.xlsx best-seller and face products with multiple sizes available
lamer_ord_data.xlsx La Mer product information collected from Chicago O'Hare International Airport duty-free store and website

Final cleaned data

File Name Data Description
df_dutyfree_ord.csv all products from Chicago O'Hare International Airport Terminal 3 duty-free store
df_dutyfree_website.csv all products on the Chicago O'Hare International Airport duty-free website
df_lamer_bestsellers.csv all best-seller products from La Mer's official USA website
df_lamer_face_products.csv all face products from La Mer's official USA website

Python Script: lamer_data.py

  • Web scraping program
  • Key libraries: requests, BeautifulSoup, re and json

Jupyter Notebook: la_mer_skincare_data_transformation.ipynb

  • Jupyter notebook with annotations detailing each stage of preprocessing web scraped data
  • Catalogue of La Mer products using HTML
  • Seaborn + Plotly visualizations

Notion: La Mer Products at the Chicago O’Hare Airport Duty Free public web page

A report with a brief history of the brand alongside a comprehensive comparison of product selection, availability, and pricing at three different purchase locations:

  1. Chicago O'Hare International Airport Duty-Free Store (1 store - Terminal 3)
  2. Chicago O'Hare International Airport Duty-Free Website (3 stores)
  3. La Mer Official USA Website
Preview

Report