How to extract data from multiple json file into a single column of a dataframe in R?

Question

I have some 100 json files in one folder.

I want to construct a dataset in R that contains a column which contains complete data from each of the json file.

Dataset must contain a column say jsonfile and each row in this column should contain data from one json file i.e data from 1st json file from the folder should be in first row of this column, 2nd json file data should be in second row of the column and so on. without destroying the structure of json file in this column

Can we achieve this using R? If yes, how can we do this?

I would really appreciate any help.

Patrick · Accepted Answer · 2022-08-19 13:09:41Z

1

In case your files are in a data folder you can iterate over it and add the info in a data frame

df  <- NULL
dir <- "data/"
for (file_ in list.files(dir)){
  fullPath <- paste0(dir,file_)
  content  <- readChar(fullPath, file.info(fullPath)$size)
  df       <- rbind(df, data.frame(fileName = fullPath, content = content))
}

Result:

answered Aug 19, 2022 at 13:09

Patrick

1601 silver badge7 bronze badges

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

Comments

Marcus · Accepted Answer · 2022-08-19 16:06:29Z

0

Without sample data and example output it's hard to know what you're asking, but to generally to bind identical json files into a single data.frame

purrr::map_dfr(
  list.files("data/", full.names = TRUE), jsonlite::fromJSON
)

fromJSON creates a data.frame from the file. map_dfr iterates over the files and binds the data.frames together.

answered Aug 19, 2022 at 16:06

Marcus

3,6561 gold badge9 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to extract data from multiple json file into a single column of a dataframe in R?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related