SourcesWrangleAnalyzeDashboard
SpaceX Launch Data Pipeline & Landing Prediction
Multi-source ETL and landing-outcome prediction for Falcon 9 launches
An idempotent data pipeline that collects, transforms, and analyzes Falcon 9 launch data from three independent sources, then feeds an analyst dashboard with dynamic visualizations and a landing-outcome classifier.
- Consolidated launch records from the SpaceX REST API, Wikipedia scraping, and a SQL database into one standardized dataset of 180+ launches across 10+ validated fields
- Balanced the training set with SMOTE before building an ETL pipeline (collection → wrangling → EDA/SQL → ML → dashboard), with Supabase as the storage layer and Plotly/Streamlit for the analyst-facing dashboard
- Trained a landing-outcome classifier and surfaced launch-site geospatial patterns with Folium, translating results into trend summaries for reporting
PythonSQLREST APIsSQLiteSupabasePlotlyStreamlit