Simple code to pull JSON data and convert into .xlsx format.
Code created using R Studio version R-3.6.1
# Import packages install.packages("rjson") install.packages("jsonlite") library("rjson") library("jsonlite") install.packages("openxlsx") library(openxlsx) # Place from where we need to download JSON file (sample URL) json_file <-"https://opendata.ecdc.europa.eu/covid19/casedistribution/json/" # read url and convert to data.frame document <- fromJSON(txt=json_file) summary(document) # Location where the .xls file will be saved write.xlsx(document, "/COVID19.xlsx") The data that will be pulled in can be used to create visulization.
Below is sample tableau visualization.
https://public.tableau.com/profile/swapanroy#!/vizhome/Covid19spread/COVID19-Curve
Top comments (0)