filmov
tv
Strava Data Uploaded to MySQL Using Python
Показать описание
I extensively use Strava to record all my workouts. Unfortunately, Strava website does not allow me to run all the analysis I would like to on my activities or download all my activities easily. Fortunately, Strava does provide an API to access all Strava data.
I used a Python script and the Strava Bulk Download to extract my data from Strava. The data was then transformed/split into five tables: athlete, type, gear, activity and details. A relational database schema was designed in MySQL to match the data. And finally, the data was loaded into the schema using Python.
Timeline:
0:00 Introduction
0:09 Project Details
0:34 Extract and Transform (ET)
1:14 Create Schema in MySQL
1:51 Load Data using Python
2:59 Sample Queries
3:45 Questions and Thank you
I used a Python script and the Strava Bulk Download to extract my data from Strava. The data was then transformed/split into five tables: athlete, type, gear, activity and details. A relational database schema was designed in MySQL to match the data. And finally, the data was loaded into the schema using Python.
Timeline:
0:00 Introduction
0:09 Project Details
0:34 Extract and Transform (ET)
1:14 Create Schema in MySQL
1:51 Load Data using Python
2:59 Sample Queries
3:45 Questions and Thank you
0:03:52
Strava Data Uploaded to MySQL Using Python
0:10:36
Collecting Strava Data Periodically
0:23:14
Strava Fitness Project | SQL
0:10:26
Use Flink and Python to download and analyze Strava data
0:03:58
Big Data Processing for Strava Activity Data
0:04:37
Strava Data Management application
0:21:09
MySQL | insert into, select
0:07:06
Data Science for Cycling #5 - How to Visualize Gradient Ranges of a GPX Route
0:21:46
STRAVA PHP - GET API STRAVA WITH PHP APP
0:00:55
How to Sync Step Data on Web
0:15:19
Strava + Alooma
0:15:10
MySQL | Definition, key features, create, read only, drop database
0:06:54
ScyllaDB at Strava
0:29:12
Data Engineer Appreciation Day: Building a Data Platform to Scale Data Culture at Strava
0:02:36
Plotting Multiple Strava Activites on One Map
0:17:38
MySQL | rename move table columns
0:12:05
Strava API | NextJS Crash Course
0:10:51
Data Science for Cycling #1 - Read GPX Strava Routes With Python | Better Data Science
0:11:55
MySQL | create, rename, and drop table. create, rename, move, modify, and drop column.
0:32:21
Snowflake Office Hours: Strava
0:04:54
Basic Elixir/Phoenix app with MySQL database - Part 1 - Elixir/Phoenix on Digital Ocean
2:46:44
Power BI & SQL Project | Data Analyst Portfolio | End to End | Beginner to Expert | #powerbi #s...
0:02:59
How to import your HealthKit (Workout) data into Sownata
0:23:20
Lessons Learned in Scaling Strava’s Infrastructure
Комментарии