Concatenate and Transform data using Jupyter notebook
Goal:
- Read 51 CSV files that are currently in Google Cloud Storage into Jupyter Notebook
- Append, Concat, and Transform Data using Python Pandas
- Write the transformed dataframe to BigQuery
CREATE A LABEL COLUMN USING SQL UNION ALL
Goal:
Create a SQL Query using a UNION ALL statement that accomplishes the following:
- Changes Column names
- Creates 2 rows pf data per game, 1 for each team (Currently, 1 row of data per game)
- Creates a new column that labels if a team won or lost a game
ANDROID APP DEVELOPMENT
Completed Android App
Android App: Injury Prevention App
Target SDK: 28
Min SDK: 21
Created with Android Studio, Java, XML, Gradle, and Android third-party libraries