Import Json file into R with unicode error

Asked Jan 20 '20 at 06:34

Active Jan 20 '20 at 07:08

Viewed 155 times

I am having issues importing a JSON file into R

Below is the code

library(RJSON)
json_file <- "file_path"
json_data <-fromJSON(file=json_file)

Which returns - Error in fromJSON(file = json_file) : unexpected character '<ef>'

which i suspect is due to the unicode / hashtag as the JSON file contains hex codes e.g #000000.
If i remove the # and replace it with %23 the file will load correctly.

how do i properly load the JSON file, i do not want to manually replace the "#" as i have thousands of these files.

An idea would be to use REGEX to replace # with %23, however i am not too sure how to do that.

Does anyone have any suggestions?

edited Jan 20 '20 at 07:08

asked Jan 20 '20 at 06:34

Vine

2

Try again with ‘jsonlite’ Package https://cran.r-project.org/web/packages/jsonlite/jsonlite.pdf – dialektike Jan 20 '20 at 08:16
1

Yep, that worked. Cheers – Vine Jan 21 '20 at 01:38

Import Json file into R with unicode error

0 Answers0