Specify custom Date format for colClasses argument in read.table/read.csv

by

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")
con <- textConnection(tmp)

tmp2 <- read.csv(con, colClasses=c('numeric','myDate'), header=FALSE)
str(tmp2)

Then modify if needed to work for your data.

Edit —

You might want to run setClass('myDate') first to avoid the warning (you can ignore the warning, but it can get annoying if you do this a lot and this is a simple call that gets rid of it).

More Related Contents:

  1. How can I read the header but also skip lines – read.table()?
  2. How to prevent ifelse() from turning Date objects into numeric objects
  3. Convert date-time string to class Date
  4. Converting year and month (“yyyy-mm” format) to a date?
  5. Changing date format in R
  6. Number of months between two dates
  7. Invalid multibyte string in read.csv
  8. Subset a dataframe between 2 dates
  9. Find which season a particular date belongs to
  10. as.Date with dates in format m/d/y in R
  11. Convert integer to class Date
  12. as.Date returning NA while converting from ‘ddmmmyyyy’
  13. R: How to handle times without dates?
  14. Extract Month and Year From Date in R
  15. How to read only lines that fulfil a condition from a csv into R?
  16. Extracting time from POSIXct
  17. Format for ordinal dates (day of month with suffixes -st, -nd, -rd, -th)
  18. How to sort a data frame by date
  19. Converting date in Year.decimal form in R
  20. How to subtract years?
  21. Subsetting a dataframe for a specified month and year
  22. How to detect the right encoding for read.csv?
  23. Issue when importing dataset: `Error in scan(…): line 1 did not have 145 elements`
  24. Imported a csv-dataset to R but the values becomes factors
  25. Convert integer as “20160119” to different columns of “day” “year” “month”
  26. Get date difference in years (floating point)
  27. Formatting a date in R without leading zeros
  28. R: xtable and dates
  29. Convert decimal day to HH:MM
  30. Weird error in R when importing (64-bit) integer with many digits

Leave a Comment