Data entry is a part of my current job, an Excel sheet is used for tracking and updates. I look
through it to see who is and is not up to date on annual training requirements, and make updates as needed.
I also make new entries on the log for new employees. I noticed that this process could be executed
faster and wrote a script to expedite the work. Using a Pandas dataframe, I cut the time it took me to
accomplish the task in half. Cowworkers also used it for their own work. For this project, I used fake data
for demonstration purposes, but the idea is the same. Check it out: HERE
First Published Website
Published on March 30th, 2026
As I look to establish Charter Domain's brand, I planned to establish a website for it. I decided on plan html/css/javaScript
as my front end, Flask for the backend, and a MySQL database. This was a great experience in building a site for a real company.
I got to work closely with my business partner in establishing a well looking user interface. The site was deployed using
Render and TiDB as database provider. This was a great experience in establishing timelines, communicating technical concepts to
everyday language, and gathering deployment experience. Check it out: HERE
YouTube API
Published on April 1st, 2026
For context, I currently have two YouTube channels, @davidDFranco and @CQB-Dating. I read that Google has two APIs for content creators: the YouTube Data API and the YouTube Analytics API.
The Data API provides metadata about any video of my choosing, allowing to explore patterns of popular channels. The Analytics API provides
my personal Analytics data for my own channels, such as watch time, click through rate, and impressions. I created a project on Google Cloud to get started,
got my API keys and OAuth credentials, and started working with both using Python Pandas for exploratory data analysis. I also worked with a Kaggle dataset for
additional practice. This project taught me how to work with Jupyter Notebook for superior data analysis and using real world data to gather real insights.
Check it out: HERE