I just stumbled on this video that I made this a few years ago and thought it would be fun to share. I recorded about 20 minutes of practice (MIDI data) and plotted the frequency of the keys I played on the bar chart. I played 9,100 notes. The F# Major ending of the Hungarian Rhapsody is funny to see at the very end of this!
Trump has bragged frequently about how he has selflessly declined to take a salary for being President of the United States. (The Constitution actually requires him to take it, but he donates it.)
But because of his financial disclosure forms, we know that he earned $1.4 billion in crypto alone last year. It would take 3,500 years of making his presidential salary to reach that number.
The tiny dot (it's not a speck of dust on your screen) represents the $400k scaled down from the $1.4billion.
Just another POTUS channel listener here and I've been following Smerconish for quite a while. I certainly don't agree with him all the time, but generally I like to hear his perspectives.
I've also been getting his newsletter for a few years now and thought it would be fun to do an analysis on these 1,000+ emails I've gotten. I think it's probably interesting or entertaining to any listeners of Smerconish. I can't be the only nerd that listens to his program.
There's no ads or sales pitch or anything and you don't need to subscribe. This is a fun "passion project" as Michael might say and I just wanted to share with some like-minded people!
Let me know your thoughts! :)
Is the end of the war soon? Maybe in a few days or two or three weeks? Here's what Trump himself has said about when the war will end.
https://artofnodeal.com : Compiled from news reports, White House transcripts, and Truth Social.
I think a lot of people have seen CNN's article, How many times has Trump claimed an Iran deal is around the corner?
I got the idea after reading that to visualize the many times Trump has predicted/promised/pontificated on the ending of the war in Iran so did some digging myself. I used the CNN article as a jumping off point and then tried to find all times where the President made statements on the ending of the war and turned it into a big, interactive time.
There's absolutely no pitch, ads, spam, etc. I just wanted to share with others who probably saw Aaron Blake's reporting and would get some enjoyment (or anger/angst/rage) out of it! :)
The past few days I saw a few news reports from various sources about the many times President Trump has told us the war in Iran would be over "soon" or in "days" or "two to three weeks" so I decided to make an interactive timeline of these ongoing promises and predictions.
CNN and Fox News both have had segments on this, so I started from there and then dug around manually to find a bunch of these statements from the President.
Let me know what you think and if there are any notable statements by the President that I'm missing and should add!
PS. There's no ads or sales pitch on the website--it just made more sense to use a custom website to make it interactive and editable rather than create it with a static tool like Tableau, Excel, etc.
The past few days I saw a few news reports from various sources about the many times President Trump has told us the war in Iran would be over "soon" or in "days" or "two to three weeks" so I decided to make a timeline of these ongoing promises and predictions.
CNN and Fox News both have had segments on this, so I started from there and then dug around to find a bunch of these statements from the President. The timeline is vanilla JS and the data is just embedded in an object directly in the script.
Let me know what you think and if there are any notable statements by the President that I'm missing and should add!
PS. There's no ads or sales pitch on the website--it just made more sense to use a custom website rather than Flourish, Tableau, DataWrapper, etc. which are more static and not as interactive.
I made a second-by-second breakdown of the first episode of Family Guy so you can see on a timeline who is speaking through the 22 minute episode.
I made a timestamped transcript and built everything around that. For this first go-around, I grouped everybody that isn't a Griffin into the "Other" category.
From this dataset, you can see the total duration spoken by each character and how many lines they spoke.
| speaker | lines | mm:ss |
|---|---|---|
| Brian | 24 | 0:51 |
| Chris | 7 | 0:12 |
| Lois | 59 | 3:14 |
| Meg | 12 | 0:22 |
| Peter | 105 | 6:15 |
| Stewie | 20 | 1:18 |
A "line" here is uninterrupted speech (there's a bit more to it, but that's the gist). A single row of the data, with timestamps (in seconds) from the audio transcription looks like this:
| start | end | duration_in_sec | line | character |
|---|---|---|---|---|
| 221.82 | 225.76 | 03.9 | Lois, honey, I promise not a drop of alcohol is going to touch these lips tonight. | Peter |
It took a bit longer to clean up the transcription, but otherwise it was a great waste/use of my time!
Data is transcribed audio of the episode itself (I just converted it to mp3 and fed through turboscribe). I used Excel to clean up things and manually tag the speaker, and then Python/Pandas to clean it up and additional processing. The dashboard is in Tableau.
My kid stumbled on the mini-episodes yesterday and it reminded me of an analysis I did a few years of the main series.
Part of that analysis looked at the scripts and character dialogue. I looked back and really liked what this word count chart showed:
Bluey‘s most mentioned person is Bingo, Bingo’s is Bluey, Bandit’s is Bingo, and Chilli’s is Bluey. Very well rounded!
Hi again! I posted another chart the other day (here) and a lot of people got a kick out of it so I thought I would share just one more that I spent way too much time on. 😅
This is the amount of profanity each character has said throughout the series and then a percentage of profanity of their overall dialogue. It's sorted from left to right by the total number of lines if it seems a little wonky. I kept it to characters that have had 400 or more lines. (And even though Chef hasn't been in an episode in literally TWENTY YEARS, he still made the cut easily.)
Cartman curses the most, but it's because he has roughly 30% more dialogue than any other character on the show. Kenny has the dirtiest mouth. Jesus has dropped the F-Bomb 7 times.
The interactive version is here if you want to see the full numbers: https://www.datawrapper.de/_/kRxFv/
Let me know what you think!
P.S. I had to really rack my brain to place the name Stephen in South Park the first time I saw it on my chart. (It's Butters' dad.)
Hi there! I made this as part of a bigger project of South Park analysis and thought it was pretty cool. There's an interactive version below if you want to see exact percentages, but I thought this was pretty illustrative. Seems Donald and JD took up some air time this past season that is usually reserved for Cartman.
Apologies to Butters.
https://www.datawrapper.de/_/wZWoA/
ETA. Thanks for love everyone. If you want to see my full analysis, it's here: https://shinycharts.substack.com/p/southpark
Totally free, no-ads, and no need to sign up for anything.
The interactive version is here: https://rjarosh.github.io/timewithkids/
I read recently that by the time your child has left the house after high school, you will have spent 90% of all the time with them that you'll ever spend. What a depressing stat. It makes sense, though. Tim Urban, the author (and Ted Talk guy on procrastination) popularized this: https://waitbutwhy.com/2015/12/the-tail-end.html
I had the thought to visualize where in that window of 18 years you are. I also took into account one other stat: that you'll have spent 75% of all the time with your kids you'll ever spend with them by the age of 12. Even more depressing.
These stats are, of course, pretty generalized and can vary wildly based on whether you get to stay home with your kids when they're toddlers, if they're home schooled, if they decide to be on a traveling soccer team, if your kid never moves out of their home town, if they join your family business, whether you're apart of a cult, if your kids don't like you, or if you die young. Hopefully the latter two aren't in your equation.
But I thought it was interesting to put everything into perspective.
If this seems interesting, check out Tim Urban's original post from a decade ago above: it has several cool visualizations.
P.S. Yes, I made this while my kids were at school so I couldn't see them anyway.
Hi there. I'm a pretend data analyst when I'm not working and since I started watching South Park more than 20 years ago, I thought it would be a fun project to dive into South Park. I know there have been a few analyses over the years, but I think there's more to explore!
Some things I've got planned include things like profanity and who uses the most from season to season, if a character has gotten "dirtier" since season 1, if certain words have actually become less-PC and died out since 1998 (imagine that!), etc.
Other things on the todo list are finding out who has the highest level of speech, when certain characters went from background to foreground characters (does Randy count?)...and I'm looking for more ideas!
I like to make charts and graphs and tables and analyses and such and thought this group would have some pretty cool ideas on other topics and questions to answer for this project.
I'm 100% not selling or promoting anything. Whatever I eventually "publish" just goes on a personal substack page that is really just a way for me to keep tabs of my fun projects (and there's zero ads or any attempt to make money or do anything other than entertain...mostly myself). But I'd be just as happy to share any "findings" here so you don't even have to click a link.
Thanks for sharing any ideas or questions that I can try and tackle!
I'm trying unsuccessfully to connect a micro SD card module to an ESP32-S3. I'm very new to all of this, but I think I did a good job soldering header pins to my ESP32-S3. Here's what I have so far. I bought a 2 pack of these boards: https://www.amazon.com/dp/B0CKXJKQ1F And I have these SD card modules: https://www.amazon.com/dp/B0B779R5TZ Then I'm using dupont female-to-female cables connecting the GPIOs to the micro SD adapter. Physically, everything is connected:
#define SD_MOSI 13
#define SD_MISO 12
#define SD_SCLK 14
#define SD_CS 15
Plus GND to GND and VCC to 3V3 on the ESP32S3. But honestly, I've tried many other variations of this above (with the assistance of Claude/Gemini/ChatGPT) and all have the same issues...
#include "SD.h"
#include "SPI.h"
#define SD_MOSI 13
#define SD_MISO 12
#define SD_SCLK 14
#define SD_CS 15
SPIClass spi = SPIClass(FSPI);
void setup() {
Serial.begin(115200);
delay(2000);
Serial.println("Starting SPI bus...");
spi.begin(SD_SCLK, SD_MISO, SD_MOSI, SD_CS);
Serial.println("SPI bus started.");
// Manually set CS high before init
pinMode(SD_CS, OUTPUT);
digitalWrite(SD_CS, HIGH);
delay(100);
Serial.println("Attempting SD.begin()...");
for (int freq = 400000; freq <= 4000000; freq += 400000) {
Serial.print("Trying frequency: ");
Serial.println(freq);
if (SD.begin(SD_CS, spi, freq)) {
Serial.println("SUCCESS at this frequency!");
Serial.print("Card size: ");
Serial.print(SD.cardSize() / (1024 * 1024));
Serial.println(" MB");
return;
}
SD.end();
delay(200);
}
Serial.println("FAILED at all frequencies.");
// Check if card is physically detected
Serial.print("Card type raw: ");
Serial.println(SD.cardType());
}
void loop() {}
It fails at all the frequencies every time. I've tried 2 different SD boards (it was a 3-pack I bought), I've correctly formatted 2 different brands of 32GB (FAT32) micro SD cards that otherwise work, and tried multiple cables. I've then followed blindly the advice of different chat bots above just to see if I could get any response from the SD card...and I'm sure there is plenty that I don't understand. But I thought this should be a fairly straightforward application of the ESP32S3: connecting some external storage. Any tips or hints or pushes in the right direction? Thanks.
I wanted to be able to see when and where you could "meet" the characters at Walt Disney World. All the information is available on the official app, but for more visual people like myself, I wanted to SEE everything. So I made this chart. (The interactive version is here: https://whereismickey.com)
Some of the characters are "continuous" throughout the day (eg. you can meet Mickey at any point during that period). Some characters are only listed to be out for a single point in time. Hence the long bars and the short blips.
My first iteration used Flourish for a timeline/Gantt-style chart, but it was a little buggy and lacked customization (and automation was crude and relied on Selenium since Flourish doesn't provide access to an API unless you have an enterprise plan).
This new version uses D3.js and renders everything in the browser when you load the webpage. (There is also a text-table on the website above that uses the DataWrapper API.)
The interactive version on the website lets you hover over each time and the popup includes a description and specific location. The data is updated daily.
"I would say this, they've got to stop with the windmills."
-Donald Trump in response to Britain's economy being hurt by the Iran war
Donald Trump has had a fascination--some may some a strange obsession--with windmills. Whether talking about how "ugly" they are, how "dangerous" they might be for our health, or the many "millions" of birds that he purports they kill a year, he is arguably as inseparable from the windmill as is the entire country of the Netherlands.
So I found the data to share.
I used Roll Call's archive of speeches and interviews to map out all of those events where he pivots to talk about the mighty windmill. Then using Tableau, I made a bar chart to track this data.
Not included are the 158 Tweets or Truth Social posts (since 2016) about windmills, wind turbines, and the wind (posts about the actual weather for things like hurricanes were excluded in that count).
The "South Park" font choice seemed pretty dumb, which is how I felt after having spent the time researching this important subject.