When reading CSV in R, how do you keep the time and date format the same?

Question

My CSV looks as follows

But when I read it in R, it changes the format for Date and Time(most important issue).

Here is my simple code that I used to read the csv

library(readr)
dat1<- read_csv("2010.csv")

How can I make it so that the format for date and time doesn't change and looks like the first picture?

Can you put `str(dat1)` or even better `dput(dat1)` in your question? — jogo, Oct 20 '16 at 13:10

xtluo · Accepted Answer · 2016-10-20T03:36:09.270

0

Try:

dat1 <- read.table("2010.csv", sep = ",", header = T)

If this answer goes wrong, then:

First check exactly what's in your .csv by opening it with text or some code editors instead of Excel or something like that. The problem I think maybe is that some APP like MS Excel, it will do some auto format converting in preview mode, so what you saw may be not what's really in your file.

For example: 2015-1-1 in .csv when open with Excel, it becomes 2015/1/1

edited Oct 20 '16 at 03:36

answered Oct 20 '16 at 03:21

xtluo

1,961
18
26

Thank you so much! That fixed the problem. – Dean Oct 20 '16 at 03:40

When reading CSV in R, how do you keep the time and date format the same?

1 Answers1