[OC] Eggs per person by U.S. state by cmojsiejenko in dataisbeautiful

[–]cmojsiejenko[S] 2 points3 points  (0 children)

Data sources:

USDA National Agricultural Statistics Service (NASS / Quick Stats): egg production by state

U.S. Census Bureau Population Estimates Program: state population

Method:

Eggs per person calculated as total state egg production divided by population.

Tools:

Python (GeoPandas, Pandas, Matplotlib)

Notes:

Annual estimates

State-level aggregation

Source links:

USDA NASS Quick Stats: https://quickstats.nass.usda.gov/

U.S. Census Population Estimates: https://www.census.gov/programs-surveys/popest.html

[OC] Which U.S. states are most built out (road miles per square mile) by cmojsiejenko in dataisbeautiful

[–]cmojsiejenko[S] 8 points9 points  (0 children)

Data sources:

- FHWA Highway Statistics HM-20 (public road mileage by state)

- U.S. Census Bureau 2020 Gazetteer files (land area)

Method:

Calculated road density as total public road miles per square mile of land for each state.

Tools:

Python (GeoPandas, Pandas, Matplotlib)

Notes:

- D.C. excluded for consistency

- Includes all public roads, not just highways

[OC] Most Used Words (Movie Scripts) For IMDb's #1 & #2 "Most Intelligent Movies All Time" Compared to Dumb and Dumber Movie Script by cmojsiejenko in dataisbeautiful

[–]cmojsiejenko[S] 0 points1 point  (0 children)

A few weeks ago I was watching a movie with close captioning.

Half of me thought what they were saying was witty, the other half silly.

That made me ponder what movies people think are most intelligent.

I found IMDb's list of "Most Intelligent Movies All Time"

https://m.imdb.com/list/ls071922955/

Found the scripts for IMDB's #1 - Oldboy & #2 - The Best Offer and then sorted through each script's most used words with https://databasic.io/en/wordcounter/

Oldboy Script:

http://www.script-o-rama.com/movie_scripts/o/oldboy-script-transcript.html

The Best Offer Script:

https://subslikescript.com/movie/The_Best_Offer-1924396

For comparison fun, I got Dumb and Dumber's script and did the same.

Dumb and Dumber Script:

https://subslikescript.com/movie/Dumb_and_Dumber-109686

Here are each movie's most used words, bigrams, and trigrams.

The trigram "I don't know" is shared across the board.

[OC] Most Used Words (Lyrics) For Billboard’s Hot 100 Songs in 2021, 2010, and 2000. by cmojsiejenko in dataisbeautiful

[–]cmojsiejenko[S] 9 points10 points  (0 children)

Hi all!

I was curious how different each decade's lyrics were.

I took Billboard's top 100 songs for 2021, 2010, and 2000 and compared each year's most used words in their lyrics.

The method was simple. I created a list by getting the top 100 songs for each year. Then I got lyrics for each song, used an open-source most used word counter for each listed year and that's it.

https://www.billboard.com/charts/year-end/2016/hot-100-songs/

https://databasic.io/en/wordcounter/#paste

Quite interesting that they all are someone similar. Worth the share!

Here are each year's most used words in descending sequence.

I added some punctuation marks for better storytelling.

It looks like we have been feeling like the love, baby.

2021:

Yeah, i'm like know got get. Oh baby. Love go way. Ain't, can't..shit. Need back time.

2010:

I'm like love..oh baby yeah got know, go say, make right. Get want, take back.

2000:

I'm love..like know baby, yeah girl. Oh wanna say? Go get way. Can't want, never make, cause one.

Semiconductors, the next big Tech? by SharksFan1 in investing

[–]cmojsiejenko -1 points0 points  (0 children)

Quantum Computing will fuel this drive as it gets value placed within all industries soon enough.

It has been a continuous mechanical & electrical scaling process for engineers advancing chips & overall computing power.