Error when parsing JSON file into R - how to fix?

Question

Using the package rtweet, I have streamed some tweets and saved them in a JSON file.

When using the following: tweets_df <- parse_stream('file.json'), I get the following error during the process:

Does anyone have any idea how to fix this so that the JSON file can be read into R as a data frame?

Answer 1

Have you tried it this way? I don't personally use rtweet but work with json files.

#load library to read json
library(jsonlite)
json_data <- fromJSON("db.json")

It reads it as a nested list but then you can simply change it to a dataframe using df<-rlist::list.stack(x, fill=TRUE )'

You might have to adapt it and for example use a loop if your json file contains several users.