Get startedGet started for free

toJSON()

Apart from converting JSON to R with fromJSON(), you can also use toJSON() to convert R data to a JSON format. In its most basic use, you simply pass this function an R object to convert to a JSON. The result is an R object of the class json, which is basically a character string representing that JSON.

For this exercise, you will be working with a .csv file containing information on the amount of desalinated water that is produced around the world. As you'll see, it contains a lot of missing values. This data can be found on the URL that is specified in the sample code.

This exercise is part of the course

Intermediate Importing Data in R

View Course

Exercise instructions

  • Use a function of the utils package to import the .csv file directly from the URL specified in url_csv. Save the resulting data frame as water.
  • Convert the data frame water to a JSON. Call the resulting object water_json.
  • Print out water_json.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# jsonlite is already loaded

# URL pointing to the .csv file
url_csv <- "https://assets.datacamp.com/production/course_1478/datasets/water.csv"

# Import the .csv file located at url_csv


# Convert the data file according to the requirements


# Print out water_json
Edit and Run Code