R Read abbreviated month form a date that is not in English

r date as.date
Maria Velasco picture Maria Velasco · Aug 17, 2015 · Viewed 7.2k times · Source

I have a text file that includes dates, and want to convert it to a datatable.

Converting the dates such as 03-FEB-2011 can be done with

data$fecha <- as.Date(data$textDate , "%d-%b-%Y")

The problem is that the column is in Spanish, so I don't get Jan but Ene, or Aug but Ago. How can I change the locale so the %b abbreviation works for Spanish? Is there any other way to achieve this?

Answer

SabDeM picture SabDeM · Aug 18, 2015

As my previous comment, here is a complete and tested answer. As I've said you have to set your locale to the one right for your data (in this case spanish).

The code that allows you to do that is the following:

Sys.setlocale(locale="es_ES.UTF-8")

you can see the complete list of available locales with system("locale -a", intern = TRUE) (not sure if it works well on Windows systems).

Here is an example:

x <- c("03-Ago-2011", "21-Ene-2012")
as.Date(x, format = "%d-%b-%Y")
[1] "2011-08-03" "2012-01-21"

Related questions

Convert character to class Date

I have a data frame with a character column of dates. When I use as.Date, most of my dates are parsed correctly, except for a few instances. The example below will hopefully show you what is going on. # my …

Read More
What are the "standard unambiguous date" formats for string-to-date conversion in R?

Please consider the following $ R --vanilla > as.Date("01 Jan 2000") Error in charToDate(x) : character string is not in a standard unambiguous format But that date clearly is in a standard unambiguous format. Why the error message? Worse, an ambiguous …

Read More
Fastest way to parse a date-time string to class Date

I have a column with dates as character in the format 10/17/2017 12:00:00 AM. I want parse the string and keep only the date part as class Date, i.e. 2017-10-17. I am using - df$ReportDate = as.Date(df$ReportDate, …

Read More