This project visualizes Beau's strava data in a Dash App designed to answer some questions
- First we hit the Strava API, grabbing activity data
- Then we put that activity data into a Google Sheet via API (first - one time then periodically)
- Next we use Pandas to format several dataframes convenient for our viz - Is this necessary?
- Lastly we had Dash point to those dataframes for a sweet viz
- Technical Learning
- Great opportunity to practice getting data from a modern API - Strava
- Given we use Google Sheets so much personally & professionally, learning to use its API makes a lot of sense
- Dash adds another powerful data visualization tool to the toolkit & is an introduction to making web apps
- This project incentivizes use of Strava which means more exercise which means better health!
- Curiosity about some activity questions:
- Beau moved from California to Colorado in 2020, how did activity vary between 2019 and 2020? Or really any two years...
- What are the characteristics of activities that people give more kudos to?
- What does monthly seasonality of activities look like?
- Use branches and PRs with code reviews before merging with main
Read Strava data from Gsheets and put into Dash
- Learn Gsheets API authentication & Hello World reading data
- Read Beau's faked Strava from GSheets
- Learn Dash & Hello World (most basic viz)
- Determine Gsheets -> Dash pipeline (ex: intermediate Pandas required?)
- Read from Gsheets into Dash & Basic Dash app
- Iterate on Dash visualizations
Pull Strava Data & put it into GSheets
- Learn Strava API activity data format to put in fake data into GSheet
- Learn about Strava API authentication & Hello World
- Get JSON Strava API activity data
- Learn GSheets API authentication & Hello World
- Write Strava JSON data into Gsheets
Last Milestone: Schedule refreshes OR give Dash users the option refreshing of data from Strava to Gsheets to Dash
- So much
Thank you Nathan Hoover for your guidance on this project.