FailedMathematician FailedMathematician - 2 months ago 34
JSON Question

R json,incomplete final line found

My problem: R json,incomplete final line found

My effort: I followed 'Incomplete final line' warning when trying to read a .csv file into R

I used this site to check my files validity. It is data from my facebook news feed collected using graph api.

My code:

library("rjson")
work<-"C:/ContainingFolder/"
json_data <- fromJSON(paste(readLines(paste0(work,"SunwayFB.txt")), collapse=""))


My error:

Warning message:
In readLines(paste0(work, "SunwayFB.txt")) :
incomplete final line found on 'C:/ContainingFolder/SunwayFB.txt'

Answer

It works without any errors if you read the file with fromJSON instead of readLines.

fp <- file.path(work, "SunwayFB.txt")
json_data <- fromJSON(file = fp)

By the way: For the readLines way, you have to add a new line at the end of the file.