Reading list of json files using for loop

Question

I am trying to read list of json files in my local folder. But the below code does not work. Can anyone help me in solving this

json_files <- list.files(pattern = "*.json")
for(i in length(json_files))
{
json_data3[[i]] <- fromJSON(paste(readLines[[i]],collapse = ""))
}

I think instead of readLines[[i]] you want readLines(json_files[[i]]). — Georgery
– Georgery, Commented Jan 17, 2020 at 11:07
What do you need the readLines for? fromJSON(json_files[i]) is how I usually read them in. — Annet
– Annet, Commented Jan 17, 2020 at 11:11

SebSta · Accepted Answer · 2020-01-17 12:09:05Z

1

Im not sure, which json library you are using, but it looks like jsonlite:

library(jsonlite)

json_data <- lapply(list.files(pattern = "*.json"), read_json)
json_data2 <- lapply(list.files(pattern = "*.json"), fromJSON)

To preserve the names of your files as list entries you can do:

names(json_data) <- list.files(pattern= "*.json")
# OR
json_data3 <- sapply(list.files(pattern="*.json"),FUN = read_json,
                     simplify = FALSE,USE.NAMES = TRUE)

edited Jan 17, 2020 at 12:09

answered Jan 17, 2020 at 11:12

SebSta

5062 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

imran p Over a year ago

Hi. thanks. It worked for me. Is it possible to have the file name in list ? right now i do not get from which file I have extracted the data

SebSta Over a year ago

The lazy mans solution is names(json_data) <- list.files(pattern="*.json"), but i also edited the main post

Collectives™ on Stack Overflow

Reading list of json files using for loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related