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