search

Chicago / RSocrata

Provides easier interaction with Socrata open data portals http://dev.socrata.com. Users can provide a 'Socrata' data set resource URL, or a 'Socrata' Open Data API (SoDA) web query, or a 'Socrata' "human-friendly" URL, returns an R data frame. Converts dates to 'POSIX' format. Manages throttling by 'Socrata'.
https://CRAN.R-project.org/package=RSocrata
Other
236 stars 83 forks source link

Warning message about partial match of header to headers? #188

Open heathyates opened 4 years ago

heathyates commented 4 years ago

I have the following code which grabs data from a government portal. It is something like this pseudocode:

read.socrata(cms_stars_data_path)

However, I get a strange message as follows:

partial match of 'header' to 'headers'

I searched both the source code here and the Socrates api and could not find any substantive leads. What does this warning mean, what is causing it, and how to remove the warning?

tomschenkjr commented 4 years ago

@heathyates - would you be able to provide the URL path that you're using? It will help replicate the issue and find the source of the issue.

heathyates commented 4 years ago

@tomschenkjr Thank you for the prompt reply. I can share the url because the data is open source. Here is the link:

https://data.medicare.gov/resource/ax9d-vq6k.json

For convenience purposes, you can click the link here.

tomschenkjr commented 4 years ago

Thanks, @heathyates. I attempted to to replicate but could not receive the same error. Here were my replication steps:

update.packages("RSocrata")  # Or install.packages("RSocrata")
cms_stars_data_path <- "https://data.medicare.gov/resource/ax9d-vq6k.json"
d <- read.socrata(cms_stars_data_path)
str(d)
#> 'data.frame':    15446 obs. of  18 variables:
#> $ rn_staffing_rating               : chr  "4" "5" "5" "3" ...
#> $ staffing_rating                  : chr  "4" "5" "5" "3" ...
#> $ location.latitude                : chr  "34.514971" "33.163735" "34.661254" "33.559483" ...
#> $ location.human_address           : chr  "{\"address\": \"701 MONROE STREET NW\", \"city\": \"RUSSELLVILLE\", \"state\": \"AL\", \"zip\": \"35653\"}" "{\"address\": \"260 WEST WALNUT STREET\", \"city\": \"SYLACAUGA\", \"state\": \"AL\", \"zip\": \"35150\"}" "{\"address\": \"380 #>WOODS COVE ROAD\", \"city\": \"SCOTTSBORO\", \"state\": \"AL\", \"zip\": \"35768\"}" "{\"address\": \"7755 FOURTH AVENUE SOUTH\", \"city\": \"BIRMINGHAM\", \"state\": \"AL\", \"zip\": \"35206\"}" ...
#> $ location.needs_recoding          : chr  "FALSE" "FALSE" "FALSE" "FALSE" ...
#> $ location.longitude               : chr  "-87.736372" "-86.254687" "-86.047116" "-86.722451" ...
#> $ processing_date                  : POSIXct, format: "2020-03-01" "2020-03-01" ...
#> $ qm_rating                        : chr  "5" "4" "2" "1" ...
#> $ federal_provider_number          : chr  "015009" "015010" "015012" "015014" ...
#> $ health_inspection_rating         : chr  "5" "3" "2" "3" ...
#> $ overall_rating                   : chr  "5" "4" "3" "2" ...
#> $ provider_name                    : chr  "BURNS NURSING HOME, INC." "COOSA VALLEY HEALTHCARE CENTER" "HIGHLANDS HEALTH AND REHAB" "EASTVIEW REHABILITATION & HEALTHCARE CENTER" ...
#> $ provider_state                   : chr  "AL" "AL" "AL" "AL" ...
#> $ staffing_rating_footnote         : chr  NA NA NA NA ...
#> $ rn_staffing_rating_footnote      : chr  NA NA NA NA ...
#> $ overall_rating_footnote          : chr  NA NA NA NA ...
#> $ health_inspection_rating_footnote: chr  NA NA NA NA ...
#> $ qm_rating_footnote               : chr  NA NA NA NA ...

Can you run a few commands and provide the info? This will help us locate the potential source.

sessionInfo()$R.version$version.string
sessionInfo()$otherPkgs$RSocrata$Version