You could use the read.csv.sql function in the sqldf package and filter using SQL select. From the help page of read.csv.sql: library(sqldf) write.csv(iris, “iris.csv”, quote = FALSE, row.names = FALSE) iris2 <- read.csv.sql(“iris.csv”, sql = “select * from file where `Sepal.Length` > 5”, eol = “\n”)
Encoding sets the encoding of a character string. It doesn’t set the encoding of the file represented by the character string, which is what you want. This worked for me, after trying “UTF-8″: x <- read.csv(url, header=FALSE, stringsAsFactors=FALSE, fileEncoding=”latin1”) And you may want to skip the first 16 lines, and read in the headers separately. … Read more
The message indicates that the last line of the file doesn’t end with an End Of Line (EOL) character (linefeed (\n) or carriage return+linefeed (\r\n)). The original intention of this message was to warn you that the file may be incomplete; most datafiles have an EOL character as the very last character in the file. … Read more
You can write your own function that accepts a string and converts it to a Date using the format you want, then use the setAs to set it as an as method. Then you can use your function as part of the colClasses. Try: setAs(“character”,”myDate”, function(from) as.Date(from, format=”%d/%m/%Y”) ) tmp <- c(“1, 15/08/2008”, “2, 23/05/2010”) … Read more