Instead of using a bunch of equations to memorize, Yi Zhe Ang visually explains matrix transformations to provide some intuition behind the math. Make it to the end so that you can transform a 3-D image of a cat.

Excel is getting a bump in capabilities with Python integration. From Microsoft:

Excel users now have access to powerful analytics via Python for visualizations, cleaning data, machine learning, predictive analytics, and more. Users can now create end to end solutions that seamlessly combine Excel and Python – all within Excel. Using Excel’s built-in connectors and Power Query, users can easily bring external data into Python in Excel workflows. Python in Excel is compatible with the tools users already know and love, such as formulas, PivotTables, and Excel charts.

Sounds fun for both Excel users and Python developers.

It’s headed to the Beta Channel in Excel for Windows and then Excel for Windows proper. They didn’t announce a timeline for Mac.

There are buildings in Toronto, Canada that make use of a deep lake water cooling (DLWC) system, including Scotiabank Arena, home of the Toronto Raptors. Cold water pumps from nearby Lake Ontario and then flows through pipes in buildings to absorb heat. For The Washington Post, Tik Root, with graphics by Daisy Chung and photos by Ian Willms, describes the system.

It sounds a lot like the system I use to cool my beer, well, wort at that point, when I’m brewing.

Sometimes passenger planes get a little too close to each other on takeoff and landing due to miscommunication and understaffing from air traffic control. From The New York Times, near collisions might happen more often than the steady flight captain’s overhead voice would have you believe.

A series of animated flight paths, albeit sped up, show the close calls.

xkcd has an informative reference for what do in case of mountain lion encounter, lightning, fire alarm, and bleeding. Very informative.

Hip-hop music producers often sample from previous works. They remake, restructure, and repurpose the samples to create a new sound. Tracklib broke down iconic hip-hop sampling over the past fifty years, using musical frequency charts to show where the bits of popular songs came from.

Visualizing time series data often assumes that your data points are evenly spaced over time, which is not always the case.

For The New York Times, Miles Marshall Lewis highlights the etymology of five words in the English language heavily influenced by hip-hop: dope, woke, cake, wildin’, and ghost. A fun design using GIFs, images, and rotating discs you can click for music take you through the history.

It keeps getting hotter around the world. Not every single day. But over time, there are increasingly more hot days and fewer cold days.
For Bloomberg, Zahra Hirji, Rachael Dottle and Denise Lu lean into layered density plots to show the shift and the path towards extreme climates.

They show distributions, which can be a challenge for non-data people to understand. So they take their time in the beginning to explain what the chart type shows, with a combination of color, animation, and labeling that stays consistent through the article.

A supermarket chain in New Zealand offered an AI-based recipe generator, and of course people started throwing in random household items to see what it would make. For The Guardian, Tess McClure reports:

The app, created by supermarket chain Pak ‘n’ Save, was advertised as a way for customers to creatively use up leftovers during the cost of living crisis. It asks users to enter in various ingredients in their homes, and auto-generates a meal plan or recipe, along with cheery commentary. It initially drew attention on social media for some unappealing recipes, including an “oreo vegetable stir-fry”.

When customers began experimenting with entering a wider range of household shopping list items into the app, however, it began to make even less appealing recommendations. One recipe it dubbed “aromatic water mix” would create chlorine gas. The bot recommends the recipe as “the perfect nonalcoholic beverage to quench your thirst and refresh your senses”.

The U.S. Census Bureau defines the Midwest as the region of twelve states cornered by North Dakota, Kansas, Ohio, and Michigan. Comedian Luke Capasso convincingly argues that while that is technically correct, regions should be defined by culture and your dad’s spirit vehicle.

[via kottke]

Most of the Maui town Lahaina was destroyed by wildfire. The Wall Street Journal reports. The map shows the buildings that were destroyed in red.

Terrible. Here is a list of reputable sources to donate to help people affected.

A long bar chart can be a bit much, so here are simple options to make it less jumble-ish.

In this chart from The Economist that shows ice extent from 1972 up to present, that falling line for 2023 looks not good.

Almost half of wasted food comes from homes, and almost half of that goes to landfills. The rotting food then produces methane. For Reuters, Ally J. Levine and Daisy Chung illustrate why that’s an issue and why we should minimize the amount of food we throw away:

Methane produced by food decomposing in landfills makes up 1.6% of all human-made Greenhouse Gas emissions. While that may not sound like much, it’s a large percentage for such a specific pollutant. When scientists look at hyper-specific categories, Karl says, anything over 1% is significant.

“Any action that can prevent food waste from sitting in untreated piles will directly lead to climate impacts being reduced.”

I appreciate the illustrations that make the data less abstract, which have become standard from Reuters Graphics.

It’s common to see singers who are women, but the people who write the songs that end up in the Billboard Hot 100 are still mostly men. For The Pudding, Chris Dalla Riva, with design by Ashley Cai, highlights the rarity of women on songwriting teams over the past decade.

A troll kept leaving comments on a woman’s TikTok videos, so she figured out who he was by following bits of public information.

The sleuthing genre of videos that find something by tracing digital footprints continues to fascinate. Plus, this one is really satisfying. Although it also makes me wonder about privacy and people using the bits of information for bad things.

Yums, by Matthew Phillips, is a quick and simple way to save recipes via email:

Yums is a recipe storage system built on top of email. Content on the web disappears with time, but email you have control over forever.

To use Yums, find a recipe you like and send an email to [email protected]. In the body paste the link to the recipe you want to save. You can paste as many links as you like, separated by new lines.

Super easy and the email is just the recipe without the backstory. I understand why people include all the wordage and pictures before the actual recipe, but it’s gotten out of hand.

Instead of using dating apps, some have turned to the date-me doc, which is a single, view-only page about the individual. It’s appealing, because it’s a flexible format that lets you include what you want and how you want. With the surge in interest, of course someone started to tabulate the docs.

In Statistics, analysis is more often about finding a range of possible answers than it is about finding a precise one.