I still remember the week I stopped tracking leave in a shared Excel file. I once helped a 10-person U.S. team whose HR tracker kept breaking, since someone overwrote someone else’s row or forgot to update a formula every month. So I built a tiny Python command-line app to log leave requests, backed by a … Read more >>
I recently built a small HR leave tracker for a 10-person team in Austin, Texas. The team previously tracked leave requests in Excel, but they needed a simple Python app with a local SQLite database. While processing requests, I often needed to find an employee, leave type, or approval status inside an array. Finding the … Read more >>
If you build anything that stores data in bulk, sooner or later you need to check if an array is empty in Python before you act on it. I ran into this exact problem last month while cleaning up a small leave-request app I built for my team here in Austin, Texas. The app tracks … Read more >>
I once built a small leave tracker for a 10-person team in Austin, Texas. HR still kept requests in Excel, but a local Python script made daily checks much faster. Before listing or approving requests, the script needed to know how many records its array contained. The quickest way to check the length of an … Read more >>
Emily Carter runs HR for a 10-person marketing team in Austin, Texas. She tracked PTO in Excel until simultaneous edits broke a formula. I built her a local Python app that used a 2D array for active leave data and a SQLite database for storage. If you have ever wondered how to create a 2D … Read more >>
Employee scheduling, spreadsheets, and game boards all share one shape: rows and columns. I once built a weekly leave grid for a 10-person team after their HR spreadsheet became hard to maintain. That project showed me why you must initialize a 2D array in Python correctly before touching a single value. A 2D array is … Read more >>
Last year, a small HR team I worked with was still tracking employee leave in a shared Excel sheet. Every time someone requested vacation or sick time, someone had to open the file, scroll through rows, and manually check for overlaps. It worked until three people requested the same week off, and it wasn’t caught … Read more >>
Last month, I was helping a 10-person remote team clean up their leave tracker. The HR lead had a small local Python script that pulled leave requests into a list, and every few weeks a duplicate or a bad entry would sneak in. My first real job was figuring out how to remove elements from … Read more >>
I ran into the ValueError: can only convert an array of size 1 to a Python scalar error while building a local leave request app for my 10-person team. We are a small US company, and HR had been tracking PTO in a giant Excel sheet for years. I moved everything into a lightweight Python … Read more >>
I recently built a small leave request tool for a 10-person U.S. team. HR tracked paid time off in Excel, but duplicate employee IDs made reports difficult to maintain. I needed to create an array from 1 to N in Python so every employee received a predictable numeric ID. The tool ran locally, stored requests … Read more >>
Download a FREE PDF (112 Pages) Containing 51 Useful Python Programs.
Download a FREE PDF on how to become a Python developer.