Video-cropping bot
A lot of Youtube downloader services do not provide the complete set of resolutions when you try to download a video. The reason is that most higher resolutions use adaptive streams instead of progressive and that complicates things somewhat for the downloading party. So a lot of services deal with it by just not dealing with it at all and only allowing you to download in lower resolutions (or without sound/sound only). At first, this project was an attempt to solve that issue while also bringing in the convenience of being a telegram bot.
However, it quickly became apparent that @utubebot already implemented that pretty well. That and the fact that I tried to bring in the crop feature which collided with the adaptive streams conversion feature and became resource-intensive. Being resource-intensive was not in my plans at all, since I used free Heroku hours to deploy this project and was fairly limited in that regard. So instead I dialed the whole thing down and now this is a simple service for cropping small portions of youtube videos (I limited it to 1-minute portions).
Crafting calculator
I love Barotrauma, it is a very atmospheric horror indie game with a vast amount of side activities. One of those activities is crafting. It has a good wiki describing various game items and recipes. But the wiki is often outdated and sometimes doesn't have important bits of information. You are also not always sure what best to do with your resources, since there is a lot of ways to spend them. So I often had to code-dive (this game is partly open-source) to figure out the game mechanics.
At some point, I got tired of digging through XML files in search of good recipes and decided to create my own tool to quickly look up profitable ways to spend money and resources. I wrote a Python parser that collects all the relevant data from the game folder and a React app to display this info in various useful ways. I'm quite proud of this project since I did it while learning React and having to figure out how game mechanics work to recreate that in my calculator.
Online lingerie store
This may still be in the works as I am writing this, but most of the functionality should already be working. This was done in collaboration with my friend as we learned GraphQL and how to work with API in React applications. I provided API and Django admin back-end endpoints as the means to work with the customer orders while my friend wrote the React application that consumes said API. I also wrote parts of it too as this is the first web project for my friend.
While we were just a team of two, it was still an interesting experience, as we had to figure out work priorities and our team roles along the way. I got to teach my friend a lot of things about developing a web app while also learning some new things myself. It wasn't the fastest development process because I tried not to rush things too much and we basically built our own web store engine (if a bit simplistic) from scratch.
Excel parser
A relative of mine works in a government company with a somewhat outdated consumable material accounting system. They were tasked with the incredibly routine work of moving contents from order spreadsheets to a registry spreadsheet, one at a time. I've made this not terribly sophisticated program to automate large chunks of their work for them.
With this project, I have improved my skill of working with spreadsheets programmatically. As well as learning to format them using only Python. I may have to finalize my parser at some point later, since, there are still things that my relative has to do manually, but for now I am fairly limited in the necessary data I have access to.