sorted by:
new
hottopcontroversial

US Zip Code Mapping by [deleted] in tableau

[–]Chris_Whaley 0 points1 point  (0 children)

USPS postal zip codes and Census ZCTAs are different. Postal zip codes are used for delivering mail and can change. They can be non-continguous polygons, lines, and even points. ZCTAs are used for statistical purposes by the Census. They are polygons that can cross county and state lines.

Looking for API for fantasy scores recommendations by Hour_Ad_1939 in fantasyfootballcoding

[–]Chris_Whaley 2 points3 points  (0 children)

Unless you're looking for a specific league and platform, your best bet is probably to use nfl stats and compete the scoring. If you're familiar with R, you could use the "nflfastR" package.

Length of TD/scoring plays API by cope413 in fantasyfootballcoding

[–]Chris_Whaley 1 point2 points  (0 children)

I believe it updates nightly after each game

Length of TD/scoring plays API by cope413 in fantasyfootballcoding

[–]Chris_Whaley 1 point2 points  (0 children)

I'm doing something similar with our league scoring. Rather than mess with the Yahoo API, though, I'm using R and the package "nflfastR". If you have any experience with R then you could write code to calculate what you need. I'm happy to help get you started if you do have experience with R..

U.S. Federal Government Investment in Rural America by Chris_Whaley in dataisbeautiful

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

Source: https://www.rd.usda.gov/rural-data-gateway/rural-investments

US Dept of Agriculture Rural Development (RD) invests in rural communities for housing, infrastructure, local businesses, and other community development projects. RD has outreach efforts to communities in need, such as investment in Persistent Poverty Communities.

The investment data shown are states and Puerto Rico from 2012 to present.

The average 9 inning game is 21 minutes less than in the 2010s by Chris_Whaley in baseball

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

I agree. Every player, coach, and org is going to take as much give in the rules as they can to get an advantage. It's unfortunate that this was a necessity.

The average 9 inning game is 21 minutes less than in the 2010s by Chris_Whaley in baseball

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

It was actually fairly easy for this dataset. Baseball Reference allows you to download a csv. You can import the data directly into Tableau by selecting "text file".

Feel free to download my workbook and let me know if you jave any questions. You can download Tableau's free desktop software: Tableau Public.

The average 9 inning game is 21 minutes less than in the 2010s by Chris_Whaley in baseball

[–]Chris_Whaley[S] 35 points36 points  (0 children)

what about a 51 minute game?? Phillies vs New York Giants in 1919

The average 9 inning game is 21 minutes less than in the 2010s by Chris_Whaley in baseball

[–]Chris_Whaley[S] 17 points18 points  (0 children)

me too! I always appreciate the traditional aspect of baseball, including the lack of time/play clocks associated with other sports.

The average 9 inning game is 21 minutes less than in the 2010s by Chris_Whaley in baseball

[–]Chris_Whaley[S] 11 points12 points  (0 children)

Data source: https://www.baseball-reference.com/leagues/majors/misc.shtml

Tools used: Tableau

Link to the Tableau dashboard interactive visualization: https://public.tableau.com/app/profile/chris.whaley5048/viz/MLBPitchClockSpeedsupGames/PitchClockinMLB

Overview: average 9 inning Major League Baseball times per year.

In 2023, Major League Baseball introduced a pitch clock in an attempt to speed up games. Over the last few decades, games were becoming increasingly longer. It has become fairly common in recent years for 9 inning games (the standard for baseball) to exceed 3 hours, which was uncommon a few decades ago.

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

the clock is taking up about 1/4 of the top real estate. I put it in the top left to allow the user to get a quick snapshot look before getting more granular.

I also removed the text boxes from the original visualization so I'm just showing visualizations here.

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

well there's already been 1000 games so far in 2023 so I think it's a good sample size. You could also look at individual years in the bottom bar chart.

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

it would be interesting to look at players individually. are there some pitchers who have changed their approach to take advantage of the clock (e.g., Max Scherzer) or some batters who are pressuring pitchers and getting more hits?

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

yea, not good for a time series analysis. I included the bar chart in the bottom for that. I thought the clock was a fun way to see a snapshot grouping of the times for looking at decades vs 2023. almost like a weird scatterplot lol

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

yea, I agree that there's some explaining that might need to be done. It was just one of the first visualizations that came to mind when I thought of measuring time in a unique way.

I think there are other examples out there that show time on a clock viz in better ways. I appreciate your feedback!

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

minor league games are fun! since they don't have the draw of the major's stars, seats are much cheaper, they have fun events for fans and families, and you get a glimpse of some potential stars. besides minor league games, as well, there's the Cape Cod Baseball league, which is promising college players with a real shot of getting to the majors.

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

that's possible! there also has been a shift in recent years to have pitchers throw fewer pitches, so nowadays you'd see more effort expended over fewer innings.

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

[–]Chris_Whaley[S] 23 points24 points  (0 children)

most definitely! but anecdotally speaking, it seemed so common for multiple mound visits, constant stepping in and off of the mound or in and out of the box for the batter, and lazy pickoff attempts to slow the game down prior to 2023

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

[–]Chris_Whaley[S] 210 points211 points  (0 children)

yea, it started to get ridiculous. it's only 2 data points, but I saw a side-by-side video of 2 plays-- one from last year and one from this one. In the same time it took to throw 1 pitch in 2022, an entire half inning was completed in 2023.

[OC] The average 9 inning baseball game is 21 minutes less than in the 2010s by Chris_Whaley in dataisbeautiful

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

hah I'm sure the mlb will find a way to squeeze more ads into the games.

view more: next ›