Convert JSON file into a data frame
The JSON text can also be converted to a data frame. This R object can be used to visualize data in a much more organized tabular structure. After the conversion of the JSON file into list format it is then converted to data frame by using as.data.frame() method which coerces it into a data frame object. The keys of the JSON text are displayed as column headers of the data frame and the values are the cell values.
Syntax: as.data.frame(list)
R
# Import rjson package library ( "rjson" ) # Declaring the json text json_text <- '{ "ID" :[ "1" , "2" , "3" , "4" , "5" ], "User_name" :[ "A" , "B" , "C" , "D" , "E" ], "Marks" :[34,64,24,68,76], "Branch" :[ "Commerce" , "Science" , "Humanities" , "Non-medical" , "Humanities" ] }' # Reading the json text data <- fromJSON (json_text) # Converting data into data frame data_frame <- as.data.frame (data) print ( "JSON dataframe" ) print (data_frame) |
Output:
[1] "JSON dataframe" > print(data_frame) ID User_name Marks Branch 1 1 A 34 Commerce 2 2 B 64 Science 3 3 C 24 Humanities 4 4 D 68 Non-medical 5 5 E 76 Humanities
Download and Parse JSON Using R
In this article, we are going to learn how to download and parse JSON using the R programming language.
JavaScript Object Notation is referred to as JSON. These files have the data in text form, which is readable by humans. The JSON files are open for reading and writing just like any other file. The “rjson” package must be installed in order to work with JSON files in R.
Run the below command in R to install rjson package:
install.packages("rjson")