R JSON File
JSON stands for JavaScript Object Notation. The JSON file contains the data as text in a human-readable format. Like other files, we can also read and write into the JSON files. For this purpose, R provides a package named rjson, which we have to install with the help of the familiar command install.packages.
Install rjson package
By running the following command into the R console, we will install the rjson package into our current working directory.
Output
Creating a JSON file
The extension of JSON file is .json. To create the JSON file, we will save the following data as employee_info.json. We can write the information of employees in any text editor with its appropriate rule of writing the JSON file. In JSON files, the information contains in between the curly braces({}).
Example: employee_info.json
Output
Read the JSON file
Reading the JSON file in R is a very easy and effective process. R provide from JSON() function to extract data from a JSON file. This function, by default, extracts the data in the form of a list. This function takes the JSON file and returns the records which are contained in it.
Let’s see an example to understand how fromJSON() function is used to extract data and print the result in the form of a list. We will consider the employee_info.json file which we have created before.
Example
Output
Converting JSON data to a Data Frame
R provide, as.data.frame() function to convert the extracted data into data frame. For further analysis, data analysts use this function. Let’s start an example to see how this function is used, and in our example, we will consider our employee_info.json file.
Example
Output
