Another month, another opportunity for the #NationalTransitDatabase to change their spreadsheet layout. I created a quick bugfix to my #ntdr #rstats package on Github.
It'll be a few days until I can get the bugfix on CRAN as well, so please use `remotes::install_github("vgXhc/ntdr")` for now.

June data from the #NationalTransitDatabase was released yesterday. Download the unwieldy Excel file https://www.transit.dot.gov/ntd/data-product/monthly-module-adjusted-data-release
Or use the #rstats {ntdr} package to easily retrieve the data. https://vgxhc.github.io/ntdr/

#transit

And once again, the #NationalTransitDatabase has changed the layout of their ridership spreadsheet. Which breaks my #rstats ntdr package. https://github.com/vgXhc/ntdr/issues/6 I'll try to get this fixed over the weekend.

My first ever #rstats package made it to CRAN! Thanks to the R Packages book, it was all pretty smooth sailing. Here's a quick blog post about `ntdr`, a package to retrieve monthly ridership data from the National Transit Database. https://haraldkliems.netlify.app/posts/2023-05-31-ntdr-an-r-package-for-transit-data/
#transit #NationalTransitDatabase

Minor release for my ntdr #rstats package. Mostly internal changes and some documentation updates to reflect the new terminology being used in the #NationalTransitDatabase https://vgxhc.github.io/ntdr/index.html

I'm pleased to see that the #NationalTransitDatabase released another month of #transit data and my `ntdr` #rstats package still works. (Last month they changed the layout of their spreadsheet, which temporarily broke the package). https://github.com/vgXhc/ntdr

New blog post: Trying to make sense of #NationalTransitDatabase data -- what's the difference between "raw" and "adjusted" data? What are the data adjusted for? I don't have many definitive answers, but the post provides a slightly better sense now of the limitations of the data, at least for #MadisonWI https://haraldkliems.netlify.app/posts/2023-03-26-understanding-adjusted-data-in-the-national-transit-database/ #transit #rstats

It may not be pretty, but it works for now: Solution for the changed layout of the #NationalTransitDatabase spreadsheets (https://fosstodon.org/@haraldkliems/109987988712925603): Defining the column names manually with some helper functions. First 9 columns are always the same, followed by one column for every month after 2002-01-01. The main downside is that the 13 MB spreadsheet needs to be read in twice. #rstats

Why does my #rstats package to get #NationalTransitDatabase data suddenly no longer work? Oh, because NTD decided to change the column names of their spreadsheet... *shakes fist*

December #NationalTransitDatabase data is out. #MadisonMetro ridership for December 2022 is at 75% of December 2019. This is a good development -- back in October, ridership was just 59% of the 2019 reference period.
#transit #MadisonWI

#transit and #FTA #NTD experts: Is there a good explanation somewhere on the difference between the FTA's #NationalTransitDatabase monthly module adjusted data release and the monthly module raw? The explanation on the FTA website are not super helpful. https://www.transit.dot.gov/ntd/data-product/monthly-module-adjusted-data-release