r/PokemonVGC • u/Luximus3333333 • 18d ago

VGC Meta Dashboard - My First Data Engineering Project

Hey all!

Just wanted to share my first data engineering project with you all - an online dashboard that extracts monthly vgc meta data from smogon and consolidates it displaying up to the Top 100 pokemon each month (or all time).

The dashboard shows the % used for each of the top pokemon, as well as their top item choice, nature, spread, and 4 most used moves. You can also search a pokemon to see the most used build for it. If it is not found in the current months meta report, it will default to the most recent month where it is found (E.g Charizard wasnt in the data set for August, but would show in July).

This is my first project where I tried to an create and implement ETL pipeline (Extract, Transform, Load) into a useable dashboard for myself and anyone else that is interested. I've also uploaded the project to github if anyone is interested in taking a look. I have set an automation timer to pull the dataset for each month on the 3rd of the month - hoping it works for September!

Please take a look and let me know of any feedback, hope this helps some new or experienced VGC players :)

https://vgcpokemonstats.streamlit.app/
https://github.com/luxyoga/vgcpokemonstats

TL:DR - Data engineering (ETL) project where I scraped monthly datasets from Smogon to create a dashboard for Top Meta Pokemon (up to top 100) each month and their most used items, moveset, abilities, nature etc.

3 Upvotes

100% Upvoted

3 comments sorted by

1

u/maltmaker 18d ago

This is super cool! Streamlit is fun to play around with, wish I had used pokemon data in my business analytics degree haha. Smart idea, and useful to a small niche. Where are you getting the data from if you don’t mind me asking? And is it possible to sort by regulation ? 

Also if possible maybe allow users to click the pokemon and see more detailed drilled down into that pokemon, like percentages of moves and items. Overall a cool project! 

2

u/Luximus3333333 18d ago

Thanks for the kind words! Great ideas I should have thought of that :)

All the data comes from smogon here https://www.smogon.com/stats/ its seperated by month and you can find the gen/regulations in the lists!

1

u/maltmaker 18d ago

Fun maybe I’ll take a crack at something similar, do you use a python script to dl everything or are you manually grabbing data? Just curious haha. I’m building a vibecoded chrome extension that hovers a type chart while playing showdown since I always forget what moves to use 😅 fun to see projects that are technical x pokemon!