6

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'
Community
  • 1
  • 1

3 Answers3

8

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.

Sven Hohenstein
  • 80,497
  • 17
  • 145
  • 168
3

You can ignore the warning message.

readLines(paste0(work,"SunwayFB.txt"))

add warn field.

readLines(paste0(work,"SunwayFB.txt"), warn=FALSE)

1

In most cases, Incomplete final line warnings can be averted by appending a new line to the file you are trying to open. Just go to the end of file -> press enter -> Save the file -> re-run whatever command you are using to load it in R and it shall show no warning.

smaug
  • 846
  • 10
  • 26