How andron1dze/texas-holdem-etl works
This is a reproducible Texas Hold’em ETL and player-analytics project. The documented workflow generates simulated hand histories, transforms and validates them, loads normalized SQLite tables, then produces SQL metrics, reports and notebook-based EDA/clustering. The README also describes PCA and bankroll analysis. The tree contains a parallel sql/ copy; its substantial source files are represented separately, but their runtime wiring is not asserted. Some detailed stage boundaries and notebook inputs are documented rather than fully visible in the excerpts.
Main entry points: eda_and_clustering.py EDA Notebook · analytics.py Analytics Runner · data_loader.py SQLite Loader · raw Raw Hand Data
Components 16
Hand ETL
- Hand Simulator
src/data_loader.py - Normalize Records
src/data_loader.py - Quality Checks
src/data_loader.py - Raw Hand Data
data/raw - SQLite Loader
src/data_loader.py - SQL Copy ETL
sql/src/data_loader.py
SQLite Analytics
- Database Schema
sql/database_setup.sql - Analytics Database
- SQL Metrics Views
sql/analytics_queries.sql
Reports
- Analytics Runner
src/analytics.py - Charts And Stats
reports - SQL Copy Analytics
sql/src/analytics.py
EDA And ML
- EDA Notebook
notebooks/eda_and_clustering.py - Player Ground Truth
data/raw - SQL Copy Notebook
sql/notebooks/eda_and_clustering.py
Other components
- Analyst
Connections 14
- Analyst → Hand Simulator: runs ETL
README.md - Hand Simulator → Raw Hand Data: writes logs
README.md - Raw Hand Data → Normalize Records: normalizes
README.md - Normalize Records → Quality Checks: checks invariants
README.md - Quality Checks → SQLite Loader: loads data
README.md - SQLite Loader → Database Schema: installs schema
README.md - SQLite Loader → Analytics Database: writes tables
README.md - Analytics Runner → SQL Metrics Views: installs views
src/analytics.py - Analytics Runner → Analytics Database: queries data
src/analytics.py - Analytics Runner → Charts And Stats: writes outputs
README.md - EDA Notebook → Analytics Database: queries metrics
notebooks/eda_and_clustering.py - EDA Notebook → SQL Metrics Views: installs views
notebooks/eda_and_clustering.py - EDA Notebook → Player Ground Truth: reads profiles
notebooks/eda_and_clustering.py - EDA Notebook → Charts And Stats: saves figures
README.md