Read csv dataset into R

General
1

Hi everyone,
I'm trying to download a csv dataset directly into RStudio from the web. The following code is an example I found online and I can confirm that it runs perfectly and automatically generates a dataframe.

read.csv("https://sebastiansauer.github.io/data/TeachingRatings.csv")

Now the dataset(s) I'm interested in are the officially published Austrian Covid-19 data and I must admit the problem I seem to be having could be determining/identifying the right url. For example I want the dataset CovidFaelle_Altersgruppe.csv.
This can be directly downloaded from h-t-tps://covid19-dashboard.ages.at/data/CovidFaelle_Altersgruppe.csv (when I enter that into my browser, a download window automatically pops up), however read.csv("https://covid19-dashboard.ages.at/data/CovidFaelle_Altersgruppe.csv") doesn't work.
A download link to the data and therewith associated metadata can be found both on

  • h-t-tps://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe/resource/9b11f7a9-9cec-49bb-89ad-6452f4f72172
    and
  • h-t-tps://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe
    which are for some reason circularly linked to each other.
    Also using these urls and manually extending them to include /CovidFaelle_Altersgruppe.csv doesn't work for me though. Also tried right clicking on the download link and copying the link location/saving the link itself, I just can't seem to find the right one.

I'm aware that there might be indirect versions (first downloading the data then loading it from the computer), but I'm eager to understand why this specific one fails me. I apologise for distorting the https using dashes, but new users are apparently only allowed two links per post, however my main issues lies within finding the correct url, so I needed to do that. Thanks in advance for any ideas!

2

Too much javascript and the content is dynamically generated. The usage of "open data" is more along the lines of "visible data." Even the link purportedly to the csv file is this way.

There may be an API for unmediated access, but my German is not good enough for me to find it. I'd suggest contacting the site for suggestions.

the_url <- "https://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe/resource/9b11f7a9-9cec-49bb-89ad-6452f4f72172"

head(readr::read_csv(the_url))
#> 
#> ── Column specification ────────────────────────────────────────────────────────
#> cols(
#>   `<!DOCTYPE html>` = col_character()
#> )
#> Warning: 147 parsing failures.
#> row col  expected    actual                                                                                                                                file
#>  11  -- 1 columns 2 columns 'https://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe/resource/9b11f7a9-9cec-49bb-89ad-6452f4f72172'
#>  29  -- 1 columns 3 columns 'https://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe/resource/9b11f7a9-9cec-49bb-89ad-6452f4f72172'
#>  30  -- 1 columns 2 columns 'https://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe/resource/9b11f7a9-9cec-49bb-89ad-6452f4f72172'
#>  31  -- 1 columns 2 columns 'https://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe/resource/9b11f7a9-9cec-49bb-89ad-6452f4f72172'
#>  32  -- 1 columns 2 columns 'https://www.data.gv.at/katalog/dataset/covid-19-daten-covid19-faelle-je-altergruppe/resource/9b11f7a9-9cec-49bb-89ad-6452f4f72172'
#> ... ... ......... ......... ...................................................................................................................................
#> See problems(...) for more details.
#> # A tibble: 6 x 1
#>   `<!DOCTYPE html>`                                                             
#>   <chr>                                                                         
#> 1 "<!--[if IE 7]> <html lang=\"de\" class=\"ie ie7\"> <![endif]-->"             
#> 2 "<!--[if IE 8]> <html lang=\"de\" class=\"ie ie8\"> <![endif]-->"             
#> 3 "<!--[if IE 9]> <html lang=\"de\" class=\"ie9\"> <![endif]-->"                
#> 4 "<!--[if gt IE 8]><!--> <html lang=\"de\"> <!--<![endif]-->"                  
#> 5 "<head>"                                                                      
#> 6 "<!--[if lte ie 8]><script type=\"text/javascript\" src=\"/katalog/fanstatic/…
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.