hcrx
hcrx OP t1_iwftyj7 wrote
Link to dataset and analysis (free to copy):
https://rows.com/Henrique/startups/analysis-on-us-social-media-companies-5RSHslXuZHRnbBgGU6GsZ5/live
​
Source: https://en.wikipedia.org/wiki/List_of_social_platforms_with_at_least_100_million_active_users
​
Visualization tool: rows.com
hcrx OP t1_iw6c1i0 wrote
Reply to comment by breathnac in [OC] Correlation between GDP Growth and Self reported happiness '09-'19 (dataset in comments) by hcrx
That’s the point. They are essentially not correlated
hcrx OP t1_iw2ae03 wrote
Reply to comment by ztbwl in [OC] Visualization of energy production source per country in emojis by hcrx
It’s true, it should be faster. The backend of this is a spreadsheet (so is the FE) so it’s a bunch of Vlookups together to create grid.
hcrx OP t1_iw2a9y9 wrote
Reply to comment by epithete52 in [OC] Correlation between GDP Growth and Self reported happiness '09-'19 (dataset in comments) by hcrx
Good point. I didn’t split that but the dataset seems pretty “randomly” distributed. Did you check the dataset?
hcrx OP t1_iw1z1h0 wrote
Reply to comment by epithete52 in [OC] Correlation between GDP Growth and Self reported happiness '09-'19 (dataset in comments) by hcrx
Yes that’s what surprised me the most. If you see the full analysis you can the countries above and below the line, along with other correlations
hcrx OP t1_iw1x2po wrote
Reply to [OC] Correlation between GDP Growth and Self reported happiness '09-'19 (dataset in comments) by hcrx
Based on a comparative analysis of World Happiness Score, GDP per capita and Human Development Index score.Link to analysis and dataset
Source: Our World in Data
https://ourworldindata.org/grapher/gdp-per-capita-worldbank
​
Visualization tool: rows.com
hcrx OP t1_ivzn7mp wrote
Reply to comment by Braddigan in [OC] Visualization of energy production source per country in emojis by hcrx
I just confirmed and you’re right. I was pulling data from Our world in data be must be doing something wrong in some countries.
According to them, Hong Kong in 2019 is 65% coal and 35% gas.
Thanks for spotting this, I’ll update the underlaying dataset
hcrx OP t1_ivy81e3 wrote
Reply to comment by Wertoyou in [OC] Visualization of energy production source per country in emojis by hcrx
You're right, it is electricity. The title is incorrect.
Energy would also count heating (not generated by electricity) and transportation, right.
hcrx OP t1_ivy1mp4 wrote
Reply to comment by tinwetari in [OC] Visualization of energy production source per country in emojis by hcrx
Thank you 🙏
hcrx OP t1_ivxwqiw wrote
Reply to comment by z38ra_ in [OC] Visualization of energy production source per country in emojis by hcrx
It was a bug, thanks for spotting! Just fixed it
hcrx OP t1_ivxl2wd wrote
Reply to comment by Limenoodle_ in [OC] Visualization of energy production source per country in emojis by hcrx
Good question! This is done on a spreadsheet with a table with the energy breakdown by source per country. Then it builds the emoji table when the country changes.
Having one build emoji table per country would be way too heavy, that’s why.
hcrx OP t1_ivxgitq wrote
Link with tool to check for any country
https://rows.com/Henrique/world-data/country-electricity-production-4xqtJEDPR7ppP2bKOjzjFh/live
Source data is from Our World in Data
Visualization tool: rows.com
hcrx OP t1_iwfuqrf wrote
Reply to comment by Future_Green_7222 in [OC] Monthly Active Users per social media platform by hcrx
This data is prior to Musk's acquisition of Twitter. Twitter has always struggled with user engagement.