This is Part 2 of the series “Network graphs explained with scenarios“. Please read Part 1 first for proper continuity. A few of the scenarios I cover in this blog series here: Project scheduling example – Shows how to compute critical path on a network of related tasks. Covered in Part 1.Routing example – Shows […]
Tag: programming
Network graphs explained with scenarios (Python) – Part 1
Network graphs are quite fascinating to me. They are all around us and used daily in a multitude of real-world applications from supply-chain, routing, mapping, social media, scheduling, to networking. In this two-part blog series, I’ll go over some real-world applications of graphs and how to generate them dynamically using Python. There are many complex […]
Complementary post to: Pop Quiz [And Solutions With Low Code!]
This post is a continuation of or complementary post to about using Excel and SQL for pop-quizes. Please read that first to get proper context…otherwise, this wouldn’t make much sense. As discussed in the post linked above, the SQL queries can be saved from Microsoft Query Editor to an external file. It’s really convenient because […]
Pop Quiz [and Solutions with Low Code!]
Every now and then I see some simple quizzes pop-up on Facebook such as: “Name a state without letter A in it.” The letter can be another, they just switch it around from time to time. This particular post is inspired by such posts. Sure we can go through all the states in our heads […]
BACTERIAL GROWTH SIMULATION (Binary Fission)
Here, I present a quick simulation application (runs in the browser) of population growth of bacteria that mutiplies following binary fission reproduction. Basically, it’s the division of a single cell into two or more cell and the regeneration of those parts to separate cells resembling the original. To play the simulation, just navigate to the […]
My SW Projects – a subset of many
This page is a single, nifty starting point for various projects (apps, utilities, research tools, games, etc.) I developed for desktop, webapps, and mobile devices for intellectual curiousity and fun. They are free, and ad-free. No gimmicks. These will run on any modern smartphone, tablet, PC (see each description below as some are made to […]
Combining multiple datasets into a single data file (Excel or CSV)
The Scenario I want to analyze data for New England Patriots over the past 10 seasons. The data files are downloaded as a file by year. So, for 2010 through 2019 NFL season, I have 10 separate data files. I need to combine them all into a single file so I can do an all-up […]
Working with clipboard, dataframe, and data files
In this blog, I’ll share tips on: How to read data into a dataframe, create a subset of dataset in memory Read/write curated subset from/to clipboard as Text/CSV or XLSX Create new data files CSV/Excel The Scenario I have a large dataset. Checking its shape via Python, I see it has 18241 records with 9 […]
Using Python, SQL, and Excel together for data shaping & analysis
There are times when I’d like to take a peek at my data CSV or XLS/X even before firing up Excel. Usually when the dataset is large and I want to quickly inspect it and modify it for my needs before even putting Excel to work. For that purpose, Python is very useful. Add its […]
Generating, plotting trajectory and…gamification (Excel)
Reminiscing the old tank game, I wanted to re-create a low-weight, low-code option of that simulation. The game depended on a canon (projectile) shot at your selected speed and angle to hit an enemy tank. The foundational formula is used in missile launch, sports, and many (you guessed it) military applications. Here, using the same […]