dan3moshe / aromatics_essential_oils

Aromatics Essential Oils Dynamic Data Summary

Aromatics Essential Oils

Aromatics Essential Oils Dynamic Data Summary - Personal Project

Aromatics is a family-owned and operated business with a growing team of people who share their dedication to support natural wellness for all.

 Founded by expert aromatherapists, is the of the best places to start exploring
 about essential oils using the wide variety of data the website has to offer.

The project Currently features 3 stages:

 1. Extraction of essential oils data from aromtics.com website using a python script. 
 2. "Flattening" data to make it more accessible for visual presentation. 
 3. Tablaue dashboard containing a summary of the essential oils data extracted -
 can be filtered by 6 parameters.

Table of Contents

1. extract_data_aromatics.ipynb - Python script to extract data from the website and saving data onto a csv file.
2. flattening_aromatics_data.ipynb - Script to "flatten" the data extracted so it can be better represented in Tablue or any other BI tool.
3. sort_gcms_analysis_aromtics.ipynb - Script to sort all of the gcms results, constituents vs essential oil name.
4. Work in progress...

Link to Tableau Dashboard:

Aromatics Essential Oils Summary