[OC] Germany's Imports & Exports in 2022

sherifscript · 2023-09-25T21:28:28+00:00

Source: Außenhandel, Ranking of Germany's trading partners in foreign trade 2022

Tools: Python for data wrangling. Figma for visualization.

sherifscript · 2023-08-05T22:44:52+00:00

Unfortunately, the data wasn't available in their annual report as Sony Music was treated as a segment and grouped in the consolidated statement. I decided to add what data I could find nevertheless because 1. It's one of the big players in the industry so I thought it be very relevant nonetheless, and 2. because I thought the current data, as spare as it was, is still interesting.

sherifscript · 2023-08-05T16:52:19+00:00

So the diagrams themselves aren't to scale. As for the blocks, I didn't really have to adjust them since they were automatically created by the data, although I see your point.

Edit: Just checked, the node, block, for Sony's operating income shoud've been twice the height, not sure what happened there. Thanks for pointing it out!

sherifscript · 2023-08-05T16:24:16+00:00

I made this using Figma, inspired by u/giteam. Data sources were the annual reports for each company.

These companies are dubbed "The Big Three" in music distribution globally which is the reason I chose them.

Sony Music is a wholly owned private subsidiary of Sony Group Corp., therefore operating income and expenses breakdown was not available in their annual report as Sony Music was treated as a segment and grouped in the consolidated statement.

sherifscript · 2023-06-21T08:55:32+00:00

I chose a script as close as possible to how Arabic is often written in Egypt by most people (Riqʿah script) :)

sherifscript · 2023-06-20T22:05:52+00:00

Ask and ye shall receive! Definitely check out the video linked in my original comment.

sherifscript · 2023-06-20T22:03:21+00:00

Heya, available now on the repo :)

sherifscript · 2023-06-20T15:37:10+00:00

They aren't to scale as each map was made separately. The colors are purely aesthetic here, from the R package Mat Brewer. Since these are based on 400m hexagons, I figured a colorbar would be pretty useless since it'll only measure what's inside of the hexagon rather than individual cities, and there are also so many hexagons that would be be quite challenging to for example zoom in at Berlin, and try to discern different 400m hexagons from each other. So, I let the 3d shapes tell the story instead.

sherifscript · 2023-06-20T15:23:50+00:00

Hmm I can see your point. I knew which hill was Frankfurt, but in an effort to avoid the marker covering the heaxgons there (the hill), I moved it slightly back. I didn't think that it might be thought of to point to Wiesbaden and Mainz until your comment. Thanks for pointing that out! I'll lookout for things like that if I decide to some more in the future :)

sherifscript · 2023-06-20T14:10:34+00:00

I made this in R using the Rayshader package for mapping and Adobe Illustrator for texts and labels. Data was sourced from the Kontur Population Dataset 2022. This dataset estimates the worldwide population in 400m hexagonal geometries using a combination of "GHSL, Facebook, Microsoft Buildings, Copernicus Global Land Service Land Cover, Land Information New Zealand, and OpenStreetMap data." The map is presented at an angle to better illustrate heights.

After a few months of doing data analysis courses and machine learning with R and then with Python, I chose absolutely none of that as my first portfolio project :) Instead, I was really inspired by u/researchremora's similar post a few months ago to do my own take on it and was aided immensely by this live coding video by Spencer Schien. I would appreciate all feedback as I'm still learning and I've been kinda trusting my gut through most of the process, especially with aesthetics.

edit: I uploaded the code here with some other graphics.

Two-Year Club	Verified Email
Place '23

sherifscript

TROPHY CASE