Fail to convert JSON data into a standard .csv file

Hello, I downloaded the JSON data from Kaggle, Rate My Professor Reviews 5C Colleges | Kaggle, and I want to convert it into a standard data frame in .csv format. However, it only returns one row, 28090 columns. Can anyone help me with it? Really appreciate any help and suggestions.

Here is the link for the dataset: all_reviews.json - Google Drive

Here is my code

library(rjson)
rmp <- fromJSON(file="all_reviews.json")
print(rmp)

rmp_df <- as.data.frame(rmp)
head(rmp_df)

This seems to work.

library(jsonlite)
library(dplyr)
AllDat <- fromJSON("all_reviews.json")
AllDat2 <- bind_rows(AllDat)
1 Like

Thanks for your help.

This topic was automatically closed 7 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.