Data Managment

World Bank Indicators and Covid - via Python (Pandas), Excel
 Beginning with three datasets: COVID-19 cases, country populations, and World Bank indicators, I cleaned and organized them in order to combine them into a single dataset, then manipulated columns to get COVID-19 rates by country and general formatting work. Since the indicators had data for multiple years, I wanted to filter it down to only the single year of data I wanted for each, then saved it out as a csv file to use later in Tableau to visualize.

Python code

Sell Short Trades File Clean-up - via Python

Original messy text file
 This task was to take this original messy text file and clean it using Python. First, unwanted lines such as blank lines, page number lines, and repeated headers were removed by matching regex patterns. Next, as data for a single trade was spread across 2-4 lines (as opposed to only a single line), I grouped them together into single lines per trade. Then the next step was to split up the data into columns, done via regex, and fix some data errors and finally, reorder the columns to match the header.

Python code

Resulting csv file

Database Work

mySQL and Java JDBC

Projects on GitHub - via SQL (mySQL), Java
 A collection of SQL practices facilitated through Java JDBC, including basic SQL syntax like select, where, etc. as well as stored procedures, prepared statements, and transactions. Projects included table creation and updates/deletes, pulling data from multiple tables, joins, and others.

Gym DataBase; Front Desk

Code on GitHub - via PHP, HTML, SQL
 A small scale database self created to experiment with web programming interaction through PHP and SQL. There is a login page (which uses frontDesk, frontDesk_pw to login for this example) that sends information to a page in the background to verify login details, which, if successful, then takes you to the main page for a pretend front desk employee. There, they can fill out forms to add new customers, schedule appointments with personal trainers, and delete appointments all while updating the tables in the SQL database.