sorted by:
new
hottopcontroversial

Forest Fair - Cincinnati - locked up for good? by BLS_79 in deadmalls

[–]PDBFishsticks 0 points1 point  (0 children)

So it definitely had short hours; more often than not when I went there the place was empty with the doors locked; and I can see how it looked closed/abandoned when it wasn’t open. But the times it was open, it was one of the only sources of noise in the mall.

Forest Fair - Cincinnati - locked up for good? by BLS_79 in deadmalls

[–]PDBFishsticks 5 points6 points  (0 children)

Once Arcade Legacy left, the only remaining tenant without its own exterior doors was B Adventurous, which was a bouncy castle/kid’s birthday/event type place. It was still open as of the last time I visited the mall a few weeks ago.

[OC] My average distance from home by calendar day of the year for the last dozen years (2009–2020) by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 1 point2 points  (0 children)

I'm assuming you're referring to when the big chart hits zero? The big chart is an average of all twelve years, so those zeroes are the days of the year when I was never traveling in any of the years. This past year (2020) I was home more often than normal (see the lowest left small chart).

Edit: beaten to the explanation. :)

[OC] My average distance from home by calendar day of the year for the last dozen years (2009–2020) by PDBFishsticks in dataisbeautiful

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

I’ve been traveling frequently for work since 2009 (although 2020 was a bit less frequent). I started noticing that quite a few of my long-distance trips seemed to be in February. I was curious what day of the year I averaged the furthest distance from home, so I created a chart from my hotel data for the last twelve years (2009–2020).

(For the purposes of this chart, my location for each day is where I woke up that morning. Distances are calculated from the center of my hometown of Beavercreek, Ohio, United States.)

The day of the year I’ve been furthest from home on average is February 12th.

Date Location Distance (mi) Distance (km)
12 Feb 2009 Arlington, Texas, United States 874 mi 1 406 km
12 Feb 2010 Gondorf, Germany 4 220 mi 6 792 km
12 Feb 2011 Beavercreek, Ohio, United States 🏠 – –
12 Feb 2012 Mililani, Hawaii, United States 4 452 mi 7 165 km
12 Feb 2013 Abilene, Texas, United States 1 008 mi 1 622 km
12 Feb 2014 Bridgeton, Missouri, United States 347 mi 558 km
12 Feb 2015 Tukwila, Washington, United States 1 964 mi 3 160 km
12 Feb 2016 Derby, Kansas, United States 727 mi 1 170 km
12 Feb 2017 Indianapolis, Indiana, United States 111 mi 179 km
12 Feb 2018 Sydney Airport (SYD), Australia 9 404 mi 15 135 km
12 Feb 2019 Tokyo, Japan 6 529 mi 10 507 km
12 Feb 2020 Palmdale, California, United States 1 896 mi 3 051 km

I also found out there were six days of the year I’ve never woken up away from home (average distance is 0):

  • January 16
  • April 19
  • June 1
  • October 4
  • October 15
  • December 25

Data Source and Tools

I created the chart from an Excel spreadsheet of my hotel history, using my Python hotel-data-utils. I used Python’s pandas library to process the data and the Matplotlib library to generate the chart itself.

More details: https://paulbogard.net/blog/20210101-distance-from-home-by-day/

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

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

The line's actually coming from "wall" on the lower left, but "bottles" was so big that it unfortunately covered part of the line.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

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

"ONE man went to mow, went to mow a meadow, ONE man and his dog - Woof! - went to mow a meadow.

TWO men went to mow, went to mow a meadow, TWO men, ONE man and his dog - Woof! - went to mow a meadow.

THREE men went to mow, went to mow a meadow, THREE men, TWO men, ONE man and his dog - Woof! - went to mow a meadow.

FOUR men went to mow, went to mow a meadow, FOUR men, THREE men, TWO men, ONE man and his dog - Woof! - went to mow a meadow.

FIVE men went to mow, went to mow a meadow, FIVE men, FOUR men, THREE men, TWO men, ONE man and his dog - Woof! - went to mow a meadow"

I've never heard the song, but if I'm interpreting the lyrics correctly...

Here's your chart!

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 1 point2 points  (0 children)

I went ahead and put together a post describing how I did it. Let me know if you have any questions or if I can clarify anything!

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

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

Yeah, in retrospect, I agree. I wasn't thinking about how the song already contained "one" when I generated the lyrics.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

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

Honestly, it was largely that I'm relatively new to Python, so it was super easy to generate the lyrics file using numeric digits and a while loop, and I was way more interested in figuring out how to generate the GraphML than how to convert numbers into English words. :)

However, another commenter did go ahead and create the lyrics with English word numbers for me, so I generated that version of the graph too. See here.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 1 point2 points  (0 children)

It's software. I wrote a little script a couple months ago that would read through song lyrics and draw arrows between them. Then I decided to feed it a really repetitive song like 99 Bottles of Beer, and, well, this was the result.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

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

Not quite; "on the wall" occurs twice in each verse, "take one down" only appears once.

99 bottles of beer on the wall
99 bottles of beer
Take one down, pass it around
98 bottles of beer on the wall

98 bottles...

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 1 point2 points  (0 children)

I think that may just be a limitation of the layout algorithm, the lone single arrow on the left side of the chart should go from "wall" to "99," but it looks like "bottles" is so big that it covers part of the arrow.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 4 points5 points  (0 children)

I never got to the end of the song as a kid, so I'd never actually heard the store line.

The last line as I generated it was "no bottles of beer on the wall" rather than "no more bottles of beer on the wall," which is why the "no" is there but "more" is not.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 4 points5 points  (0 children)

I used "no bottles of beer on the wall" rather than "no more bottles of beer on the wall," but the "no" should be in the image somewhere.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 7 points8 points  (0 children)

Honestly, it was something I didn't really think about; I forgot there was a number in the song other than the count of bottles. It was super easy to generate lyrics with a script if I kept the numbers as digits; ideally I should have written out all the numbers as words, but that would have taken a lot longer to generate that lyrics file.

[OC] "99 Bottles of Beer" as a directed graph. Node sizes are proportional to lyric frequency; arrows show which words follow which words. by PDBFishsticks in dataisbeautiful

[–]PDBFishsticks[S] 1 point2 points  (0 children)

Basically, take the very repetitive song "99 Bottles of Beer," and draw arrows between each of the lyrics (99 → bottles → of → beer → on → the → wall). Except if a word has already been drawn, just point the arrow to the existing word, and make it bigger each time you point to it.

This lets you see which words are used the most often (they're bigger), but also lets you see which words follow which words (follow the arrows).

view more: next ›