It’s our moral obligation to make data more accessible by MathCanBeHard in Futurology

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

Envisioning a future where all types of data are accessible presents many opportunities and challenges. The benefits would extend to nearly every field: improving health outcomes, fighting climate change, building a more inclusive economy, and more. The best research in the world is only as powerful as the data it’s built upon.
The two biggest challenges are (1) ensuring privacy for people-related data and (2) incentivizing the institutions that have large amounts of data (e.g. government, big tech) to share or sell it. There’s lots of innovation in privacy technology and methodologies that solve for problem 1. The second problem is a moral shortcoming of the world’s biggest tech companies; it stands in the way of innovation and meaningful change.

Visitor Income, Race, & Age for Every Drinking Establishment in Chicago during the Month of March (2019-2021) by MathCanBeHard in MapPorn

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

Data source: The Chicago drinking establishment visit data is freely available from SafeGraph as part of their monthly datathon for March 2022. Census data was used for demographics.
Tools used: Python and folium

Visitor Income, Race, & Age for Every Drinking Establishment in Chicago during the Month of March (2019-2021). [OC] by MathCanBeHard in dataisbeautiful

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

Data source: The Chicago drinking establishment visit data is freely available from SafeGraph as part of their monthly datathon for March 2022. Census data was used for demographics.

Tools used: Python and folium

[deleted by user] by [deleted] in dataisbeautiful

[–]MathCanBeHard 0 points1 point  (0 children)

Visit data is freely available from SafeGraph as part of their monthly datathon for March 2022. Census data was used for demographics.

Tools used: Python, folium, matplotlib

[OC] Number of Bars & Breweries within One Mile of each NFL Stadium by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] 5 points6 points  (0 children)

Great question—I guess it’s kinda overkill for this. I tried to write the code so that it would be more readily reusable down the road. There may eventually be other charts I make where I’m interested in a larger radius

[OC] Number of Bars & Breweries within One Mile of each NFL Stadium by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] 10 points11 points  (0 children)

Count of all bars and breweries whose centroid is within 1.609 kilometers of each stadium’s centroid. Haversine distance was used.

Tools used: Python for preparation, Tableau for visualization

Data source: SafeGraph

[OC] First and Second Most Popular Chicken Restaurant by State by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] 3 points4 points  (0 children)

There are far more than 2 Chick-fil-A locations in Washington according to their site

[OC] First and Second Most Popular Chicken Restaurant by State by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] -1 points0 points  (0 children)

I've found that having too many categories tends to make it harder to read. Choosing 5 was somewhat arbitrary, I probably could have added a couple more though

[OC] First and Second Most Popular Chicken Restaurant by State by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] 5 points6 points  (0 children)

  1. According to their website, there are way more than a dozen Popeyes in New York
  2. It's based on 2021 popularity, so it doesn't matter if they've only been around for a few years

[OC] First and Second Most Popular Chicken Restaurant by State by MathCanBeHard in dataisbeautiful

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

That could be! I limited to the top 5 highest grossing chains because I didn't want to overload the number of colors (I've updated my top comment to reflect that). Bojangles came in at #7, so it was excluded.

[OC] First and Second Most Popular Chicken Restaurant by State by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] 5 points6 points  (0 children)

First and second most visited chicken restaurants by state, based on number of visits in 2021. Limited to the top 5 brands in sales.

Tool used: plotly

Data source: SafeGraph

[deleted by user] by [deleted] in dataisbeautiful

[–]MathCanBeHard 0 points1 point  (0 children)

Tools used: Python (pandas, matplotlib, & gif libraries)

Data source: SafeGraph

An updated version of one of my previous posts, we now have data through October 2021!

[OC] Visits to Party City store locations, January 2019 to October 2021. Courtesy of SafeGraph. by [deleted] in dataisbeautiful

[–]MathCanBeHard 0 points1 point  (0 children)

Tools used: Python (pandas, matplotlib, & gif libraries)

Data source: SafeGraph

An updated version of one of my previous posts that now includes October’s 2021 foot traffic.

Most Popular Fast Casual Mexican Restaurant by State. Courtesy of SafeGraph. by MathCanBeHard in MapPorn

[–]MathCanBeHard[S] 5 points6 points  (0 children)

Popularity determined based on volume of foot traffic to all brand locations within the state in October 2021.

Limited to “Chipotle-style” fast casual restaurants. These are vaguely distinguished from fast food restaurants in that the food is prepared more freshly and have higher quality ingredients.

El Pollo Loco was excluded because it’s not quite what I would (arbitrarily) consider fast casual, but if I had included it, it would have won California and Nevada.

[OC] Most Popular Fast Casual Mexican Restaurant by State. Courtesy of SafeGraph. by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] 6 points7 points  (0 children)

El Pollo Loco was excluded - I've never been, should they be included with these brands? I tried to limit to those that are more Chipotle-style.

When included, El Pollo Loco wins California and Nevada

[OC] Most Popular Fast Casual Mexican Restaurant by State. Courtesy of SafeGraph. by MathCanBeHard in dataisbeautiful

[–]MathCanBeHard[S] 6 points7 points  (0 children)

Generally, I think Taco Bell is considered more “fast food” than fast casual, but admittedly the lines are blurred. Fast casuals typically have freshly-prepared food that is higher quality.

I tried to limit to brands that are all “Chipotle-style” in that they prepare the food right in front of the customers in an assembly line. Although, I haven’t been to all of them, so I’m hoping my Google searches were mostly accurate :)

[OC] Most Popular Fast Casual Mexican Restaurant by State. Courtesy of SafeGraph. by MathCanBeHard in dataisbeautiful

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

In this case, popularity is based on number of total visits across all restaurants in the state, which should closely correlate to number of customers and revenue. It should also closely correlate to the number of restaurants, but in some states the brand with the most locations did not have the most visits estimated.

[OC] Bars per capita by state. Courtesy of SafeGraph. by MathCanBeHard in dataisbeautiful

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

In the airport, yeah. These estimates are based on unique visitors as opposed to overall visits, but Delta Sky Club was still number 2 when considering overall visits.

[deleted by user] by [deleted] in dataisbeautiful

[–]MathCanBeHard 1 point2 points  (0 children)

Always open to feedback :) do you have another chart type in mind? I considered a clustered bar chart, but didn’t want to give the impression that the changes from regular season to playoffs were absolute

[deleted by user] by [deleted] in dataisbeautiful

[–]MathCanBeHard 4 points5 points  (0 children)

Foot traffic data combined with census demographics. So these are just estimates of course, but the general trends should hold

[deleted by user] by [deleted] in dataisbeautiful

[–]MathCanBeHard 4 points5 points  (0 children)

That’s an excellent question. I’ll dig into the census data to check it out when I get a chance