Jan 17 路 5 min read 路 Why We Preprocess the CSV The CSV file is an external input.External inputs are always the least reliable part of any system. Before we introduce Flow, we want to answer three questions: Is the file
Join discussionSep 15, 2025 路 4 min read 路 Most expense tracking apps either feel too basic or overwhelmingly complex. After trying dozens of solutions, I ended up creating something different - a hybrid system that combines C++ for data processing with Flask for web access. The Technology Mi...
Join discussion
Sep 9, 2025 路 6 min read 路 Auditing the SharePoint Recycle Bin is difficult without PowerShell or administrative permissions. This guide offers a simple, non-destructive method to download a complete list of deleted items as a CSV, using just a small JavaScript code snippet in...
Join discussionJul 20, 2025 路 2 min read 路 When I want to use recent data from SimFin or when I have to do data cleanup at work, if the CSV files are too big (+300MB) and if there are several million records, the only way to work with this much data is to do it in command line. No spreadsheet...
Join discussion
Jul 18, 2025 路 3 min read 路 馃 Why I Built This I wanted to automate the process of monitoring product listings on Jumia Kenya's Flash Sales section. Manually checking prices, discounts, and stock every few minutes isn鈥檛 practical. So I built a Python script that scrapes flash ...
Join discussionJul 18, 2025 路 4 min read 路 Introduction Today, I worked on an exciting Python project: automating the collection of cryptocurrency data from CoinGecko, saving it in a CSV file, and emailing it to myself automatically. It started as a simple script but ended up teaching me a lo...
Join discussionApr 8, 2025 路 3 min read 路 Many-a-times, we come across processes that do not need user intervention, yet take up a lot of server time. This time could have been used, otherwise, to do multiple other tasks. Let鈥檚 take the example of downloading a large file as a csv. In such a...
Join discussion
Feb 6, 2025 路 2 min read 路 There are plenty of online tools to combine multiple csv files into a single one. But I could not find any to create multiple smaller (controlled) batches from a large csv file. Manually doing it is hectics, then found a way to automatically create s...
Join discussion
Feb 2, 2025 路 2 min read 路 Introduction After building the CSV Viewer App with pure HTML, CSS, and JavaScript, I decided to take things a step further by creating a CSV Parsing API using Next.js and the csv-parser npm package. This API allows users to upload a CSV file, which ...
Join discussion