Recently, I accidently encountered a new online service called EarSketch for music creation and mixing using Python. I had to of course check it out in more detail and was very impressed with the simplicity and effort put into the overall UI, API, and technical documentation. They are definitely worth checking out! Kudos to EarSketch […]
Tag: STEM
Putting together our Presidents (Infographic in Excel)
In several of my earlier blogs, I demonstrated working with raw data from multiple sources to generate visual and statistical analysis. You can find them in the following posts: Let’s Play With All The Presidents (Excel)-Part1 Let’s Play With All The Presidents (Excel)-Part2 Getting To Know Our Presidents In this blog, I share the combined […]
When you’re going “blank”! (Excel, Python)
You have data (of course, you do) and you have data that have something missing (of course, you do). The question is multi-fold around that…do we ignore the data, do we remove them from your analysis, or do we interpolate to fill in the missing data? And if so, what type of interpolation is best? […]
Word Cloud III – Python & Excel together
In two my earlier blogs, I shared two methods & codes in Excel and Python on how to create Word Clouds from any text or document. You can find them here: How To Find The Most Occurring Words In A Document? (python) and Creating Word Cloud Accurately And Easily In Excel (Excel) Now, I’ll turn […]
Be the right kind of ‘Mean’
No, I’m not talking about stingy, spiteful kind…rather mathematical mean: arithmetic and statistical means to be exact. In fact, a handful of mean functions and applications. In most common situations, when we say ‘Mean’ even the statisticians mean the Average…or the arithmetic mean we all know since early childhood. We continue use it because while […]
A Very Simple Etch A Sketch Type Program (Python)
Here’s a fun, little application using Python. In this post, I demonstrate drawing lines using just the arrow keys on the keyboard (up/down/left/right). The drawing direction is determined by the arrow key pressed as shown in the clip below: With each keypress a line is drawn in the direction of the arrow head, which is […]
Generating Polygon Data With Mouse (Python)
In one of my previous posts, related to this topic, I shared the code and concept of reading polygon data and how to render them on screen with additional user-interaction. The post is linked below: Working with Polygon Data (Python) In this post, I share how to generate the data points for a polygon easily […]
Working with Polygon Data (Python)
In this post, I’ll show how to write a program that reads x,y coordinates for a complex shape (Polygon) from an external source. Then recreate the shape on a canvas with some interactivity. The application’s action clip is below: In the above clip, I’m reading datafiles that contain the coordinates as a series of contiguous […]
Color Codes Datafile and Dynamic, Interactive Patterns-Making (Python)
UPDATE: BONUS animation added at end of this post. In this post, I’ll demonstrate how to read color values (stored as Hex) from a data file and create dynamic patterns using those colors. Additionally, user can interact with it to choose different patterns, and even shuffle the same colors in different orders as they were […]
Bars within bars: Creating an Effectual Custom Chart
In this post, I’ll share some tips on how to create a visually impactful bar chart, rather bars within a bar in Excel that does not come out of the box, that can convey much information in an uncluttered way. There are several steps we need to take in order to take Excel’s built-in charts […]