CODEWITHSUNDEEP
jsonr
FailedMathematician
FailedMathematician

Reputation: 467

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'

Upvotes: 6

Views: 9068

Answers (3)

smaug
smaug

Reputation: 936

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.

Upvotes: 1

Junhee Shin
Junhee Shin

Reputation: 31

You can ignore the warning message.

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

add warn field.

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

Upvotes: 3

Sven Hohenstein
Sven Hohenstein

Reputation: 81683

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.

Upvotes: 8

Related Questions