Can anyone help me think of a better way to visualize the info in the attached?

I need to show the rankings by country for the various types of renewable energy. The key point to convey is the countries and their rankings.

https://imgur.com/a/prl9mDj

I have a bunch of rows that each contain a product name, and then the number of items sold for each of the last 12 months. How can I highlight which months are above average for the row? In excel that kind of conditional formatting gets applied to the entire dataset but each row needs it's own average calculation. I could apply a fresh conditional format to each row, but with more than 1,000 rows it's a big pain in the backside!

[deleted]

sometimes a table is the best visualization

I really want to make a data link table that’s webs out with all interlinked pieces of data. Specifically subjects on a podcast. Anyone have ideas if a place where I can make something like that

Is there a nice list of open data providers anywhere? There are so many nifty APIs providing open data across the Internet. I figure there must be a nice index listing a bunch of them but I'm not sure where to look for such a thing. This seemed like the kind of sub that would know.

Not really a proper answer, but a loophole/workaround:

• Make another copy of the whole table, but this time each row normalized (subtract minimum from the row then divide by (maximum - minimum)) so every row now goes 0 to 1.

• Apply a single conditional format to the entire thing, since now each row is apples to apples and you only need one

• Use this to visually navigate instead or to sort, and the left table to see the raw numbers

I am working on a project where I have been provided a data set of auto loans for a specific period of time with many loan parameters such as credit score, debt to income, loan to value, original term, interest rate, payment amount, vehicles year make and model, probability of default, unsecured DTI, etc.

I need to identify patterns in auto loan charge-offs (vehicle surrenders/repo) . Anything I want at all.

I’ve come up with some ideas: basic comparison of a number of parameters between charge-offs and non-charge-offs. Interest accrual on loans prior to charge off vs the calculated loss of the vehicle and how large the offset is. Number of months loan was working with collections prior to default and changes made to loan payments.

I am just looking for additional ideas on what I could show with this data. I’m happy to provide additional information if anyone is interested.

Thats a great idea, thank you! Some of my numbers are so vast in range it didn't occur to me to normalise. They're sales figures so in a poor month an item might sell 1, but in a good month it might sell 250, so when figuring out seasonality I am finding it tough to pick out some "winning" months for a given product.

Does anybody know a good (possibly free) tool for visualising interactions between people in a timeline?

Looking for something that kinda looks like this: https://www.chartgeek.com/wp-content/uploads/2019/04/timeline-game-of-thrones.jpg

Hey Folks! I am looking for help in visualizing theoretical public transportation routes for a given US metropolitan area.

We have pretty lackluster service and I want to poll the public and ask them where they commute to.

Questions would be something like:

1. What neighborhood do you live in (field/drop-down)
2. Enter up to 3 locations you frequent in a month that you would prefer to take public transportation on (address field) 2a. how often do you commute to location 1-3 (daily, weekly, monthly)
3. What is your current commute time in minutes (integer)

Given this data, how could I process/visualize these trends? I would like to say "wow! A lot of people need rapid transport from towns A <-> B and towns B <-> C but not so much for towns A<->C!"

Someone is trying to hurt and kill dogs in my home town! I need help!

A little bit of background: I live in a town in Sweden with around 340.000 people. Since December 2020 - Today, we've had over 150 known attempts to try to hurt and kill dogs.

The perpetrator, in most cases, deploys small baked bread buns containg sharp, hand made "stars" made out of pieces of tin can. Sometimes the buns are dropped in plain sight, sometimes near bushes / under leaves etc.

Now, I have collected all the police reports, gone through them all and entered them into excel with dates, time when reported (where applicable), on what address it happened etc.

Can someone help me to visualize this somehow? Maybe there is some kind of pattern? Maybe I'm grasping at straws here.. but maybe someone can help me?

Thank you

somebody can help me for how do I install my VE type1?? plz!

I am a fifth-grade teacher about to teach (extremely basic, obviously) statistics and probability concepts to kids. My student group includes many who respond well to visual approaches to math. Can anyone here recommend any beginner- or child-friendly websites that generate beautiful and intuitive graphs?

Hey everyone,

I recently tried to visualise some of my research findings in a classic two-dimensional plot in R. Problematically, some of my observations share the exact same values for both the X- and Y-dimension, leading to a perfect overlap in the graphic.

I would like to fix said overlap, making sure that all dots are clearly visible. Whilst this should not be too much of an issue, for some reason, I can't seem to find a workable solution that makes all dots visible.

Does anyone have any design ideas or similar how to plot my observations in a better way that makes all overlapping data points visible?

Many thanks in advance

Tab Bar Graph with animation when users change the tag. You can use its rank as the value. The higher bar is, the higher rank is. X-index shows countries’ flags. Use tag to control which renewable energy the bar graph considers.

I have data on an Excel file that has upstream and downstream content (data is in 3 columns left column has upstream name, 2nd column has current location and 3rd column has downstream location) that I'm hoping can be read and can be visualized to show the relationships (paths). I'm wondering if there are a few and very easy (no code) options for viewing the data (can be inactive or not) as a relationship map. Any suggestions would be appreciated.

What program/tool are people using for the data videos posted that include moving graphics along with the data?

[removed]

I'm afraid to make a new topic/discussion and be inappropriate for this sub. But, let me ask you guys... what software do you use to make these amazing-looking plots? I'm trying my best with python, but I'm not sure if I'm on the right path.

My goal is to make plots for business reports, but not sure about the quality.

Any help would be deeply appreciated! And thank you in advance.

Guys, I suck at data. Really want to improve this and the visualisation skill. Where to begin?

From what you’ve written, I think viewing this as a line chart over time would be helpful.

A step further, if your town is split into areas, I.e. up town, down town, east block, west block, etc & view that again as a time series you might see a pattern in events in different areas there

Edit: you might see that an event that occursed in the ‘west block’ often has an event in the ‘up town’

Not sure on what fifth grade is here, but I find khan academy super helpful, even now as an adult.

What are the most famous or well known methods to proper visualise data? I am willing to learn different methods or use different websites and explore various options. I am sorry if this question has been asked before but I really want to know better ways to show data besides normal charts. (Please link me to previous threads if this has been mentioned before)

Can we have the information visualized by height? https://en.m.wikipedia.org/wiki/Suspicious_deaths_of_Russian_businesspeople_(2022%E2%80%932023)

What's the best way to, on Android, make one of those charts where you color in days on a calendar to track events?

I created an interactive plot written in javascript and plotly that I'd like to post here. I have it hosted on a server. Is it possible to embed as an iframe or similar? Or will I have to just post a hyperlink?

I generally don't click off-site links when scrolling reddit, so I suspect others have the same habit.

I'm from an academic background and used to use a lot of R. There's a library called ggplot2 that is very formal and structured. Many other plotting libraries and methods are very disjoint, but ggplot2 gives you a good foundation because it's based on a lot of plotting theory. It depends if you program or not.

I found this PDF on datacamp that is very high level. I'm not sure I agree with all of them, but it's probably a good start.

https://s3.amazonaws.com/assets.datacamp.com/email/other/Data+Visualizations+-+DataCamp.pdf

Excel. I dislike Excel for many reasons, but it does allow you to quickly visualize data and get practice with the process. If you can program, R+ggplot2 or Python+Pandas+Seaborn.

This is common. There's a technical term for it (jitter). There's a balance between making your datapoints visible and changing their values too much.

It's not a very satisfying answer, but Excel might be your best bet. You likely already have it on your work computer and there are tons of resources for creative ideas. You can download tons of data already in a spreadsheet usable form (csv mostly). Most services will either have a steep learning curve, or be too basic to be useful.

Thanks! I will take a look at that. So I am assuming there are no particular website that can do all the plotting and you would have to program that? I am good at programming but definitely not at the high level. This might as well be a long procrastinated project for me when I get some free time. If there are some more libraries (because there seem to be alot of cool graphs in this subreddit) please do let me know!

This is awful to hear. If it's the same person or group, you might find some pattern based around weekdays, holidays, time of day, etc. Try labeling them based on date/time and see if you can run some summary statistics. If it's kids, it might increase during holidays. If it's someone jobless, there may be no pattern. This is all speculation, but it's a starting point.

Machine learning might be able to offer some insights as well, but that might be too steep a learning curve.

Good luck in finding them

The two most common stacks I see are Python+Pandas+Seaborn or R+ggplot2.

Python has the added advantage there's a big industry demand and would be more likely to find a job with python experience.

A network graph using something like graphviz might be a better method. The problem is, the result represents a snapshot in time. So you'd likely have to animate it or otherwise make it interactive with a timeline slider.

Does anyone know where to find the latest inflation data on all coutries?

similar to this: https://wisevoter.com/country-rankings/inflation-by-country/

but that's based on 2022 data I think.

Newbie here: Thoughts on maps where country are «bloated » based on data importance? (example here)

Does anyone else remember a graph where OP tracked their heart rate while in a cab ride to the airport with their girlfriend?

I distinctly remember it because I thought it was so bittersweet, but I can't seem to find it anymore.

How does one come up with good ideas to visualise? The key goal is to tell a story through data; but I am struggling to find out something interesting worth visualising - something that catches peoples' eyes - which hasn't been done before.

Can anyone give me any tips?

[deleted]

Stacked bar graph although not the best as it is hard to compare the amounts of each type across countries. A user would still get an impression of the overall makeup of each country's renewable energy usage. Stack Bars also do not convey the overall quantity of each countries energy usage and the total of each each renewable type.

Side by Side bars are another option as they allow you to have a uniform axis for the total amount of energy and then group the bars by either country or renewable type.

It feels like this sub has moved away from the “beautiful” part and seems to just upvote “is data” element. Many of the posts that get upvoted are the most basic graphs

Good morning; I am looking for a dataset of NCAAM basketball games including the timestamps for shots and, with hope, running scores.

This [http://academics.smcvt.edu/jtrono/BBallArchive.htm] is a great dataset but doesn't include the fidelity I'd need.

The NCAA-related datasets pointed to by Kaggle are also missing what I'd like.

I expect the AWS NCAA stats would have this (and tons more) data, but (a) I don't know how to get even a sample of it to check, and (b) if it costs, I'm sheepishly not able to bring money into this obscure theory.

I'm trying to test a theory about scoring in the last ten minutes of games. I'd make a beautiful graph if only I could find the data :)

If you have any information, I'd be so grateful!

Thanks!

[Edit: grammar]