In my ESO Crafting Materials project for Code Kentucky Data Analysis 1, I found that most furnishing material price increases began in the weeks between the start of public testing and the official release of new content patches in The Elder Scrolls Online.
For my Data Analysis 2 project, I'm going to focus on the relationship between past content updates in The Elder Scrolls Online and the furnishing materials required to craft new plans added by each, and the impact each patch would likely have on demand.
Objective: analyze the likely impact of furnishing plans added per patch on the price of furnishing materials in The Elder Scrolls Online.
Statement of Work: Create a dataframe of furnishing plans from The Elder Scrolls Online. For each plan, find which patch added it to the game, which housing materials it requires, and the furnishing category of the item crafted. Compare the impact of past patches on housing material demand.
This project uses Python 3.9.15
Packages:
- pandas
- matplotlib
- beautifulsoup4
- requests
- jupyter notebook
- Download zip or clone ESO-Plan-Mats repository:
git clone https://github.com/racheldelong/ESO-Plan-Mats.git
- To set up conda environment, navigate to the ESO-Plan-Mats folder in Anaconda Prompt and enter:
conda env create -f environment.yml
- After environment is created, activate by entering:
conda activate esoplans
- Start Jupyter notebook from Anaconda Prompt by entering:
jupyter notebook
- Click 'ESOPlanMats.ipynb' to open project notebook.
-
Tsu's Magical Pricing Assistant, Furniture Catalog link
-
ESO Furnishings Helper by Sapphire_Ocelot, Plans link
-
The Unofficial Elder Scrolls Pages UESP.net
-
ESO-Hub.com (new plan details) ESO-Hub.com
Read three spreadsheets from Google Sheets, and scrape data from UESP.net and ESO-HUB.com to get a list of newly added furnishing plans and fill out the data for each.
Merge the patch data from ESO Furnishings Helper with the plan materials in Tsu's Magical Pricing Assistant.
Remove any duplicate plans, and use pandas concatenate to combine with web scraped plan data.
Find the sum of housing materials required to craft each plan and the total plans added per content patch, and merge with the patch information dataframe.
Create three figures with matplotlib:
- a horizontal bar graph of the number of plans released per update & year
- pie charts for the ratio of housing materials required to craft plans added in each update
- pie charts for crafting materials per plan category
Use a conda environment and included instructions for setup.
Changes to Project Plan:
Original project was going to analyze Tales of Tribute card game matches. Changed project to ESO Furnishing Plan Materials to build on Data 1 project topic and have more options for datasets to meet project requirements.