thr3ads.net - R help - [R] Need hep for converting date data in POSIXct [Jul 2013]

If this information is useful, please help other people find it:
Share via:

arun

2013-Jul-08 01:01 UTC

[R] Need hep for converting date data in POSIXct

Hi,
I am not sure how your dataset looks like.? If it is like the one below:
(otherwise, please provide a reproducible example using ?dput())

dat1<- read.table(text="
datetime
10/02/2010
02:30
11/02/2010
04:00
14/02/2010
06:30
",sep="",header=TRUE,stringsAsFactors=FALSE)

lst1<-split(dat1,(seq_along(dat1$datetime)-1)%%2+1)
?dat2<-
data.frame(datetime=as.POSIXct(paste(lst1[[1]][,1],lst1[[2]][,1]),format="%d/%m/%Y
%H:%M"))
?str(dat2)
#'data.frame':??? 3 obs. of? 1 variable:
# $ datetime: POSIXct, format: "2010-02-10 02:30:00" "2010-02-11
04:00:00" ...
?dat2
#???????????? datetime
#1 2010-02-10 02:30:00
#2 2010-02-11 04:00:00
#3 2010-02-14 06:30:00


#or
data.frame(datetime=as.POSIXct(paste(dat1[seq(1,nrow(dat1),by=2),1],?
dat1[seq(2,nrow(dat1),by=2),1]),format="%d/%m/%Y %H:%M"))
#???????????? datetime
#1 2010-02-10 02:30:00
#2 2010-02-11 04:00:00
#3 2010-02-14 06:30:00



A.K.



Hey everybody, 

I am a new user of R software. I don't know how I can merge two rows in 
one. In fact, I have one row with the date(dd/mm/yyyy) and another with the 
time (hh:mm) and I would like to get one row with date time in order to 
convert to POSIXct. How can I do it??

laila

2013-Jul-08 09:52 UTC

head link

[R] Need hep for converting date data in POSIXct

Hi Arun,
I think that my data has another format. When I type the comand dput(time), it
appears the following information:
 structure(list(date = structure(c(696L, 18L, 19L, 43L, 44L, 45L, 
67L, 68L, 94L, 95L, 117L, 118L, 141L, 142L, 167L, 168L, 193L.......), .Label =
c("01/01/2011 12:32", "01/02/2011 00:49", "01/02/2011
12:54",....), class = "factor")), .Names = "date",
row.names = c(NA,
716L), class = "data.frame").  When I tried to convert to POSIXct , it
gives me this thing:structure(c(NA_real_, NA_real_, NA_real_, NA_real_,
NA_real_, NA_real_, NA_real_, NA_real_, NA_real,NA_real_), class =
c("POSIXct", "POSIXt"), tzone = "") Script I have
done is: library(argosfilter)
setwd("C:/Users/Usuario/Dropbox/Laila Aranda/PUFGRA")
Geo = 
read.table("2370001_PUFGRA_2009_Gough_000_retarded10_both.trj",header=FALSE,sep
= ",", col.names= c("type", "date",
"secs", "Trans1",  "Trans2", "lat.sta", 
"lat.comp", "long",  "dist", "rumbo",
"velocidad",  "confianza"))
location=subset(Geo, select= c(lat.comp,long))
time=subset(Geo, select =c(date))
k<-as.POSIXct( ¡time, format= "%d/%m/%y %H:%M") Laila  PS: I've
just realised that I made a mistake, because I want to merge two columns not
rows. In fact, I have one column: dd/mm/yyyy mm:hh and another column(secs):
40567,87.  I send you a picture of my database.

 
Date: Sun, 7 Jul 2013 18:10:09 -0700
From: ml-node+s789695n4671066h81@n4.nabble.com
To: laila_zgz@hotmail.com
Subject: Re: Need hep for converting date data in POSIXct



	Hi,

I am not sure how your dataset looks like.  If it is like the one below:
(otherwise, please provide a reproducible example using ?dput())


dat1<- read.table(text="

datetime

10/02/2010

02:30

11/02/2010

04:00

14/02/2010

06:30

",sep="",header=TRUE,stringsAsFactors=FALSE)


lst1<-split(dat1,(seq_along(dat1$datetime)-1)%%2+1)

 dat2<-
data.frame(datetime=as.POSIXct(paste(lst1[[1]][,1],lst1[[2]][,1]),format="%d/%m/%Y
%H:%M"))

 str(dat2)

#'data.frame':    3 obs. of  1 variable:

# $ datetime: POSIXct, format: "2010-02-10 02:30:00" "2010-02-11
04:00:00" ...

 dat2

#             datetime

#1 2010-02-10 02:30:00

#2 2010-02-11 04:00:00

#3 2010-02-14 06:30:00



#or

data.frame(datetime=as.POSIXct(paste(dat1[seq(1,nrow(dat1),by=2),1], 
dat1[seq(2,nrow(dat1),by=2),1]),format="%d/%m/%Y %H:%M"))

#             datetime

#1 2010-02-10 02:30:00

#2 2010-02-11 04:00:00

#3 2010-02-14 06:30:00




A.K.




Hey everybody, 


I am a new user of R software. I don't know how I can merge two rows in 

one. In fact, I have one row with the date(dd/mm/yyyy) and another with the 

time (hh:mm) and I would like to get one row with date time in order to 

convert to POSIXct. How can I do it??


______________________________________________

[hidden email] mailing list

https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.



	
	
	
	

	

	
	
		If you reply to this email, your message will be added to the discussion
below:
	
http://r.789695.n4.nabble.com/Need-hep-for-converting-date-data-in-POSIXct-tp4671059p4671066.html
	
	
		
		To unsubscribe from Need hep for converting date data in POSIXct, click here.

		NAML
	 		 	   		  

data.docx (213K)
<http://r.789695.n4.nabble.com/attachment/4671084/0/data.docx>




--
View this message in context:
http://r.789695.n4.nabble.com/Need-hep-for-converting-date-data-in-POSIXct-tp4671059p4671084.html
Sent from the R help mailing list archive at Nabble.com.
	[[alternative HTML version deleted]]

arun

2013-Jul-08 20:53 UTC

head link

[R] Need hep for converting date data in POSIXct

Hi Laila,
There is only one column from the dput() output.
time1<- structure(list(date....
str(time1)
#'data.frame':??? 20 obs. of? 1 variable:
# $ date: Factor w/ 582 levels "01/01/2009 01:58",..: 370 389 390 409
410 429 430 450 451 471 ..
?time1[,1]<-as.POSIXct(time1[,1],format="%d/%m/%Y %H:%M")
head(time1)
?# ?????????????? date
#1 2008-11-20 12:23:00
#2 2008-11-21 00:33:00
#3 2008-11-21 12:29:00
#4 2008-11-22 00:29:00
#5 2008-11-22 12:39:00
#6 2008-11-23 00:50:00


A.K.





________________________________
From: laila Aranda Romero <laila_zgz at hotmail.com>
To: arun <smartpink111 at yahoo.com> 
Sent: Monday, July 8, 2013 4:29 PM
Subject: RE: [R] Need hep for converting date data in POSIXct




Arun,

?When I type dput(head(time,20), it appears this:

structure(list(date = structure(c(370L, 389L, 390L, 409L, 410L, 
429L, 430L, 450L, 451L, 471L, 472L, 491L, 492L, 511L, 512L, 531L, 
532L, 549L, 550L, 567L), .Label = c("01/01/2009 01:58",
"01/01/2009 13:57",
"01/02/2009 03:49", "01/02/2009 15:51", "01/03/2009
04:40", "01/03/2009 16:37",
"01/04/2009 04:21", "01/04/2009 16:33", "01/05/2009
04:33", "01/05/2009 16:31",
"01/06/2009 03:11", "01/06/2009 15:10", "01/07/2009
02:49", "01/07/2009 14:46",
"01/08/2009 02:44", "01/08/2009 14:44", "01/09/2009
01:05", "01/09/2009 13:14",
"01/12/2008 00:58", "01/12/2008 12:53", "02/01/2009
02:01", "02/01/2009 13:58",
"02/02/2009 03:59", "02/02/2009 15:58", "02/03/2009
04:37", "02/03/2009 16:25",
"02/04/2009 04:30", "02/04/2009 16:30", "02/05/2009
04:33", "02/05/2009 16:31",
"02/06/2009 02:52", "02/06/2009 14:57", "02/07/2009
02:47", "02/07/2009 14:51",
"02/08/2009 02:42", "02/08/2009 14:42", "02/09/2009
01:14", "02/09/2009 13:19",
"03/01/2009 01:52", "03/01/2009 13:57", "03/02/2009
03:55", "03/02/2009 15:56",
"03/03/2009 04:21", "03/03/2009 16:29", "03/04/2009
04:39", "03/04/2009 16:29",
"03/05/2009 04:27", "03/05/2009 16:24", "03/06/2009
02:53", "03/06/2009 14:48",
"03/07/2009 02:55", "03/07/2009 14:54", "03/08/2009
02:36", "03/08/2009 14:28",
"03/09/2009 01:32", "03/09/2009 13:37", "04/01/2009
01:57", "04/01/2009 13:57",
"04/02/2009 03:55", "04/02/2009 15:50", "04/03/2009
04:35", "04/03/2009 16:35",
"04/04/2009 04:28", "04/04/2009 16:36", "04/05/2009
04:43", "04/05/2009 16:43",
"04/06/2009 02:36", "04/06/2009 14:40", "04/07/2009
02:49", "04/07/2009 14:48",
"04/08/2009 02:40", "04/08/2009 14:38", "04/09/2009
01:45", "04/09/2009 13:54",
"05/01/2009 02:02", "05/01/2009 14:01", "05/02/2009
03:51", "05/02/2009 15:49",
"05/03/2009 04:35", "05/03/2009 16:40", "05/04/2009
04:36", "05/04/2009 16:29",
"05/05/2009 04:18", "05/05/2009 16:13", "05/06/2009
02:41", "05/06/2009 14:22",
"05/07/2009 02:50", "05/07/2009 14:57", "05/08/2009
02:31", "05/08/2009 14:28",
"05/09/2009 02:08", "05/09/2009 14:13", "06/01/2009
01:55", "06/01/2009 13:52",
"06/02/2009 03:54", "06/02/2009 15:55", "06/03/2009
04:39", "06/03/2009 16:40",
"06/04/2009 04:20", "06/04/2009 16:19", "06/05/2009
03:56", "06/05/2009 15:49",
"06/06/2009 02:20", "06/06/2009 14:26", "06/07/2009
03:10", "06/07/2009 15:05",
"06/08/2009 02:35", "06/08/2009 14:35", "06/09/2009
02:10", "06/09/2009 14:01",
"06/12/2008 12:27", "07/01/2009 01:54", "07/01/2009
13:38", "07/02/2009 03:49",
"07/02/2009 15:50", "07/03/2009 04:53", "07/03/2009
16:33", "07/04/2009 04:23",
"07/04/2009 16:22", "07/05/2009 03:33", "07/05/2009
15:34", "07/06/2009 02:40",
"07/06/2009 14:59", "07/07/2009 02:52", "07/07/2009
14:55", "07/08/2009 02:34",
"07/08/2009 14:37", "07/09/2009 01:59", "07/09/2009
13:45", "07/12/2008 00:28",
"07/12/2008 12:33", "08/01/2009 01:23", "08/01/2009
13:09", "08/02/2009 03:52",
"08/02/2009 15:51", "08/03/2009 04:33", "08/03/2009
16:47", "08/04/2009 04:26",
"08/04/2009 16:27", "08/05/2009 03:29", "08/05/2009
15:28", "08/06/2009 03:08",
"08/06/2009 14:58", "08/07/2009 03:02", "08/07/2009
15:01", "08/08/2009 02:38",
"08/08/2009 14:31", "08/09/2009 01:32", "08/09/2009
13:19", "08/12/2008 00:27",
"08/12/2008 12:29", "09/01/2009 00:57", "09/01/2009
12:52", "09/02/2009 03:45",
"09/02/2009 15:46", "09/03/2009 04:33", "09/03/2009
16:38", "09/04/2009 04:34",
"09/04/2009 16:25", "09/05/2009 03:27", "09/05/2009
15:13", "09/06/2009 02:50",
"09/06/2009 14:32", "09/07/2009 03:01", "09/07/2009
15:08", "09/08/2009 02:35",
"09/08/2009 14:31", "09/09/2009 01:08", "09/09/2009
13:05", "09/12/2008 00:34",
"09/12/2008 12:32", "10/01/2009 00:54", "10/01/2009
12:48", "10/02/2009 03:51",
"10/02/2009 15:45", "10/03/2009 04:41", "10/03/2009
16:30", "10/04/2009 04:21",
"10/04/2009 16:33", "10/05/2009 03:28", "10/05/2009
15:39", "10/06/2009 02:31",
"10/06/2009 14:50", "10/07/2009 03:03", "10/07/2009
15:03", "10/08/2009 02:43",
"10/08/2009 14:45", "10/09/2009 00:58", "10/09/2009
12:59", "10/12/2008 00:26",
"10/12/2008 12:30", "11/02/2009 03:54", "11/02/2009
15:59", "11/03/2009 04:32",
"11/03/2009 16:36", "11/04/2009 04:38", "11/04/2009
16:35", "11/05/2009 03:29",
"11/05/2009 15:19", "11/06/2009 02:56", "11/06/2009
14:55", "11/07/2009 02:57",
"11/07/2009 14:57", "11/08/2009 02:35", "11/08/2009
14:36", "11/09/2009 01:03",
"11/09/2009 13:08", "12/02/2009 03:54", "12/02/2009
15:55", "12/03/2009 04:36",
"12/03/2009 16:37", "12/04/2009 04:34", "12/04/2009
16:36", "12/05/2009 03:19",
"12/05/2009 15:17", "12/06/2009 02:36", "12/06/2009
14:36", "12/07/2009 03:07",
"12/07/2009 15:14", "12/08/2009 02:38", "12/08/2009
14:35", "12/09/2009 01:04",
"12/09/2009 13:06", "12/12/2008 12:33", "13/02/2009
04:00", "13/02/2009 15:56",
"13/03/2009 04:48", "13/03/2009 16:49", "13/04/2009
04:34", "13/04/2009 16:08",
"13/05/2009 03:02", "13/05/2009 14:55", "13/06/2009
02:31", "13/06/2009 14:30",
"13/07/2009 03:10", "13/07/2009 15:05", "13/08/2009
02:38", "13/08/2009 14:42",
"13/09/2009 01:05", "13/09/2009 12:59", "13/12/2008
00:28", "13/12/2008 12:28",
"14/02/2009 03:56", "14/02/2009 15:56", "14/03/2009
04:46", "14/03/2009 16:41",
"14/04/2009 04:10", "14/04/2009 16:34", "14/05/2009
02:57", "14/05/2009 15:00",
"14/06/2009 02:32", "14/06/2009 14:21", "14/07/2009
03:04", "14/07/2009 15:08",
"14/08/2009 02:45", "14/08/2009 14:43", "14/09/2009
00:59", "14/09/2009 13:03",
"14/12/2008 00:28", "14/12/2008 12:37", "15/02/2009
03:52", "15/02/2009 16:07",
"15/03/2009 04:37", "15/03/2009 16:37", "15/04/2009
04:36", "15/04/2009 16:28",
"15/05/2009 02:58", "15/05/2009 14:58", "15/06/2009
02:23", "15/06/2009 14:22",
"15/07/2009 03:12", "15/07/2009 15:04", "15/08/2009
02:39", "15/08/2009 14:40",
"15/09/2009 00:58", "15/09/2009 12:57", "15/12/2008
00:18", "15/12/2008 12:19",
"16/02/2009 04:26", "16/02/2009 16:29", "16/03/2009
04:48", "16/03/2009 16:42",
"16/04/2009 04:22", "16/04/2009 16:27", "16/05/2009
02:38", "16/05/2009 14:28",
"16/06/2009 02:17", "16/06/2009 14:31", "16/07/2009
03:06", "16/07/2009 14:59",
"16/08/2009 02:37", "16/08/2009 14:37", "16/09/2009
00:56", "16/09/2009 12:55",
"16/12/2008 00:20", "16/12/2008 12:17", "17/02/2009
04:19", "17/02/2009 16:20",
"17/03/2009 04:35", "17/03/2009 16:41", "17/04/2009
04:30", "17/04/2009 16:24",
"17/05/2009 02:20", "17/05/2009 14:21", "17/06/2009
02:46", "17/06/2009 14:46",
"17/07/2009 02:59", "17/07/2009 15:06", "17/08/2009
02:39", "17/08/2009 14:38",
"17/09/2009 00:55", "17/09/2009 12:49", "17/12/2008
00:20", "17/12/2008 12:22",
"18/02/2009 04:22", "18/02/2009 16:18", "18/03/2009
04:48", "18/03/2009 16:43",
"18/04/2009 04:29", "18/04/2009 16:30", "18/05/2009
02:10", "18/05/2009 14:18",
"18/06/2009 02:37", "18/06/2009 14:47", "18/07/2009
03:09", "18/07/2009 15:11",
"18/08/2009 02:40", "18/08/2009 14:19", "18/09/2009
00:51", "18/09/2009 12:49",
"18/12/2008 00:20", "18/12/2008 12:15", "19/01/2009
13:00", "19/02/2009 04:16",
"19/02/2009 16:15", "19/03/2009 04:46", "19/03/2009
16:41", "19/04/2009 04:25",
"19/04/2009 16:28", "19/05/2009 02:14", "19/05/2009
14:16", "19/06/2009 02:41",
"19/06/2009 14:47", "19/07/2009 03:09", "19/07/2009
15:03", "19/08/2009 02:34",
"19/08/2009 14:24", "19/09/2009 00:45", "19/09/2009
12:42", "19/12/2008 00:16",
"19/12/2008 12:16", "20/01/2009 01:23", "20/01/2009
13:53", "20/02/2009 04:24",
"20/02/2009 16:20", "20/03/2009 04:40", "20/03/2009
16:39", "20/04/2009 04:38",
"20/04/2009 16:38", "20/05/2009 02:15", "20/05/2009
14:18", "20/06/2009 02:50",
"20/06/2009 14:46", "20/07/2009 03:05", "20/07/2009
15:06", "20/08/2009 02:29",
"20/08/2009 14:18", "20/09/2009 00:37", "20/09/2009
12:35", "20/11/2008 12:23",
"21/01/2009 01:57", "21/01/2009 14:02", "21/02/2009
04:08", "21/02/2009 16:07",
"21/03/2009 04:34", "21/03/2009 16:34", "21/04/2009
04:33", "21/04/2009 16:29",
"21/05/2009 02:19", "21/05/2009 14:28", "21/06/2009
02:44", "21/06/2009 14:51",
"21/07/2009 03:05", "21/07/2009 15:03", "21/08/2009
02:19", "21/08/2009 14:21",
"21/09/2009 00:30", "21/09/2009 12:32", "21/11/2008
00:33", "21/11/2008 12:29",
"22/01/2009 02:00", "22/01/2009 14:14", "22/02/2009
04:07", "22/02/2009 15:59",
"22/03/2009 04:34", "22/03/2009 16:37", "22/04/2009
04:49", "22/04/2009 16:44",
"22/05/2009 02:29", "22/05/2009 14:44", "22/06/2009
02:50", "22/06/2009 14:47",
"22/07/2009 02:58", "22/07/2009 14:58", "22/08/2009
02:20", "22/08/2009 14:10",
"22/09/2009 00:29", "22/09/2009 12:31", "22/11/2008
00:29", "22/11/2008 12:39",
"23/01/2009 02:36", "23/01/2009 14:52", "23/02/2009
03:56", "23/02/2009 16:01",
"23/03/2009 04:52", "23/03/2009 16:52", "23/04/2009
04:25", "23/04/2009 16:30",
"23/05/2009 02:57", "23/05/2009 15:12", "23/06/2009
02:52", "23/06/2009 14:46",
"23/07/2009 02:55", "23/07/2009 14:49", "23/08/2009
02:04", "23/08/2009 13:53",
"23/09/2009 00:29", "23/09/2009 12:24", "23/11/2008
00:50", "23/11/2008 12:51",
"23/12/2008 12:45", "24/01/2009 03:04", "24/01/2009
15:11", "24/02/2009 04:10",
"24/02/2009 16:08", "24/03/2009 04:41", "24/03/2009
16:32", "24/04/2009 04:34",
"24/04/2009 16:19", "24/05/2009 03:14", "24/05/2009
15:25", "24/06/2009 02:38",
"24/06/2009 14:48", "24/07/2009 02:47", "24/07/2009
14:46", "24/08/2009 01:51",
"24/08/2009 13:48", "24/09/2009 00:21", "24/09/2009
12:16", "24/11/2008 00:44",
"24/11/2008 12:45", "24/12/2008 01:10", "24/12/2008
13:24", "25/01/2009 03:15",
"25/01/2009 15:24", "25/02/2009 04:08", "25/02/2009
16:17", "25/03/2009 04:28",
"25/03/2009 16:30", "25/04/2009 04:13", "25/04/2009
16:19", "25/05/2009 03:21",
"25/05/2009 15:30", "25/06/2009 02:45", "25/06/2009
14:49", "25/07/2009 02:42",
"25/07/2009 14:39", "25/08/2009 01:50", "25/08/2009
13:47", "25/09/2009 00:10",
"25/11/2008 00:40", "25/11/2008 12:40", "25/12/2008
01:18", "25/12/2008 13:39",
"26/01/2009 03:40", "26/01/2009 15:32", "26/02/2009
04:22", "26/02/2009 16:29",
"26/03/2009 04:30", "26/03/2009 16:26", "26/04/2009
04:19", "26/04/2009 16:14",
"26/05/2009 03:26", "26/05/2009 15:32", "26/06/2009
02:48", "26/06/2009 14:45",
"26/07/2009 02:35", "26/07/2009 14:43", "26/08/2009
01:48", "26/08/2009 13:33",
"26/11/2008 00:47", "26/11/2008 12:50", "26/12/2008
01:59", "26/12/2008 14:12",
"27/01/2009 03:31", "27/01/2009 15:44", "27/02/2009
04:36", "27/02/2009 16:43",
"27/03/2009 04:30", "27/03/2009 16:19", "27/04/2009
04:19", "27/04/2009 16:30",
"27/05/2009 03:32", "27/05/2009 15:32", "27/06/2009
02:44", "27/06/2009 14:49",
"27/07/2009 02:42", "27/07/2009 14:30", "27/08/2009
01:29", "27/08/2009 13:21",
"27/11/2008 00:45", "27/11/2008 12:45", "27/12/2008
02:06", "27/12/2008 14:11",
"28/01/2009 03:53", "28/01/2009 15:48", "28/02/2009
04:41", "28/02/2009 16:37",
"28/03/2009 04:15", "28/03/2009 16:14", "28/04/2009
04:33", "28/04/2009 16:32",
"28/05/2009 03:32", "28/05/2009 15:33", "28/06/2009
02:49", "28/06/2009 14:43",
"28/07/2009 02:30", "28/07/2009 14:30", "28/08/2009
01:19", "28/08/2009 13:18",
"28/11/2008 00:48", "28/11/2008 12:48", "28/12/2008
02:01", "28/12/2008 13:54",
"29/01/2009 03:52", "29/01/2009 16:05", "29/03/2009
04:15", "29/03/2009 16:21",
"29/04/2009 04:28", "29/04/2009 16:28", "29/05/2009
03:32", "29/05/2009 15:41",
"29/06/2009 02:46", "29/06/2009 14:49", "29/07/2009
02:27", "29/07/2009 14:43",
"29/08/2009 01:26", "29/08/2009 13:19", "29/11/2008
00:49", "29/11/2008 12:50",
"29/12/2008 02:01", "29/12/2008 13:50", "30/01/2009
04:15", "30/01/2009 16:03",
"30/03/2009 04:30", "30/03/2009 16:33", "30/04/2009
04:29", "30/04/2009 16:26",
"30/05/2009 03:40", "30/05/2009 15:40", "30/06/2009
02:46", "30/06/2009 14:51",
"30/07/2009 02:51", "30/07/2009 14:43", "30/08/2009
01:25", "30/08/2009 13:23",
"30/11/2008 00:50", "30/11/2008 12:53", "30/12/2008
01:50", "30/12/2008 14:03",
"31/01/2009 04:08", "31/01/2009 16:01", "31/03/2009
04:33", "31/03/2009 16:23",
"31/05/2009 03:31", "31/05/2009 15:27", "31/07/2009
02:42", "31/07/2009 14:39",
"31/08/2009 01:22", "31/08/2009 13:08", "31/12/2008
01:56", "31/12/2008 13:53"
), class = "factor")), .Names = "date", row.names = c(NA,
20L
), class = "data.frame")?

I hope?that you're asking for this!!!!! :)
Laila

> Date: Mon, 8 Jul 2013 12:26:41 -0700
> From: smartpink111 at yahoo.com
> Subject: Re: [R] Need hep for converting date data in POSIXct
> To: laila_zgz at hotmail.com
> 
> Hi laila,
> 
> You need to provide the full dput() output.? As I mentioned in my earlier
email in Nabble ( which I am not sure you got it), use dput() for a smaller
dataset.
> For eg.
> dput(head(dataset,20))
> 
> 
> 
> 
> 
> ----- Original Message -----
> From: laila <laila_zgz at hotmail.com>
> To: r-help at r-project.org
> Cc: 
> Sent: Monday, July 8, 2013 5:52 AM
> Subject: Re: [R] Need hep for converting date data in POSIXct
> 
> Hi Arun,
> I think that my data has another format. When I type the comand dput(time),
it appears the following information:
> structure(list(date = structure(c(696L, 18L, 19L, 43L, 44L, 45L, 
> 67L, 68L, 94L, 95L, 117L, 118L, 141L, 142L, 167L, 168L, 193L.......),
.Label = c("01/01/2011 12:32", "01/02/2011 00:49",
"01/02/2011 12:54",....), class = "factor")), .Names =
"date", row.names = c(NA,
> 716L), class = "data.frame").? When I tried to convert to POSIXct
, it gives me this thing:structure(c(NA_real_, NA_real_, NA_real_, NA_real_,
NA_real_, NA_real_, NA_real_, NA_real_, NA_real,NA_real_), class =
c("POSIXct", "POSIXt"), tzone = "") Script I have
done is: library(argosfilter)
> setwd("C:/Users/Usuario/Dropbox/Laila Aranda/PUFGRA")
> Geo =?
read.table("2370001_PUFGRA_2009_Gough_000_retarded10_both.trj",header=FALSE,sep
= ",", col.names= c("type", "date",
"secs", "Trans1",? "Trans2", "lat.sta",?
"lat.comp", "long",? "dist", "rumbo",
"velocidad",? "confianza"))
> location=subset(Geo, select= c(lat.comp,long))
> time=subset(Geo, select =c(date))
> k<-as.POSIXct( ?time, format= "%d/%m/%y %H:%M") Laila? PS:
I've just realised that I made a mistake, because I want to merge two
columns not rows. In fact, I have one column: dd/mm/yyyy mm:hh and another
column(secs): 40567,87.? I send you a picture of my database.?
> 
> 
> Date: Sun, 7 Jul 2013 18:10:09 -0700
> From: ml-node+s789695n4671066h81 at n4.nabble.com
> To: laila_zgz at hotmail.com
> Subject: Re: Need hep for converting date data in POSIXct
> 
> 
> 
> ??? Hi,
> 
> I am not sure how your dataset looks like.? If it is like the one below:
(otherwise, please provide a reproducible example using ?dput())
> 
> 
> dat1<- read.table(text="
> 
> datetime
> 
> 10/02/2010
> 
> 02:30
> 
> 11/02/2010
> 
> 04:00
> 
> 14/02/2010
> 
> 06:30
> 
> ",sep="",header=TRUE,stringsAsFactors=FALSE)
> 
> 
> lst1<-split(dat1,(seq_along(dat1$datetime)-1)%%2+1)
> 
> dat2<-
data.frame(datetime=as.POSIXct(paste(lst1[[1]][,1],lst1[[2]][,1]),format="%d/%m/%Y
%H:%M"))
> 
> str(dat2)
> 
> #'data.frame':? ? 3 obs. of? 1 variable:
> 
> # $ datetime: POSIXct, format: "2010-02-10 02:30:00"
"2010-02-11 04:00:00" ...
> 
> dat2
> 
> #? ? ? ? ? ???datetime
> 
> #1 2010-02-10 02:30:00
> 
> #2 2010-02-11 04:00:00
> 
> #3 2010-02-14 06:30:00
> 
> 
> 
> #or
> 
> data.frame(datetime=as.POSIXct(paste(dat1[seq(1,nrow(dat1),by=2),1],?
dat1[seq(2,nrow(dat1),by=2),1]),format="%d/%m/%Y %H:%M"))
> 
> #? ? ? ? ? ???datetime
> 
> #1 2010-02-10 02:30:00
> 
> #2 2010-02-11 04:00:00
> 
> #3 2010-02-14 06:30:00
> 
> 
> 
> 
> A.K.
> 
> 
> 
> 
> Hey everybody, 
> 
> 
> I am a new user of R software. I don't know how I can merge two rows in
> 
> one. In fact, I have one row with the date(dd/mm/yyyy) and another with the
> 
> time (hh:mm) and I would like to get one row with date time in order to 
> 
> convert to POSIXct. How can I do it??
> 
> 
> ______________________________________________
> 
> [hidden email] mailing list
> 
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> 
> 
> 
> ??? 
> ??? 
> ??? 
> ??? 
> 
> ??? 
> 
> ??? 
> ??? 
> ??? ??? If you reply to this email, your message will be added to the
discussion below:
> ??? ???
http://r.789695.n4.nabble.com/Need-hep-for-converting-date-data-in-POSIXct-tp4671059p4671066.html
> ??? 
> ??? 
> ??? ??? 
> ??? ??? To unsubscribe from Need hep for converting date data in POSIXct,
click here.
> 
> ??? ??? NAML
> ???????? ???????? ?????? ??? ? 
> 
> data.docx (213K)
<http://r.789695.n4.nabble.com/attachment/4671084/0/data.docx>
> 
> 
> 
> 
> --
> View this message in context:
http://r.789695.n4.nabble.com/Need-hep-for-converting-date-data-in-POSIXct-tp4671059p4671084.html
> Sent from the R help mailing list archive at Nabble.com.
> ??? [[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> ????

arun

2013-Jul-11 02:27 UTC

head link

[R] Need hep for converting date data in POSIXct

Hi,
I guess the error message:> vmask(lat,lon,time,vmax=25)Error en vmask(lat, lon,
time, vmax = 25) : objeto 'lat' no encontrado

says that you have not defined the object 'lat'.

time<-subset(Geo, select =date)
time[,1]<-? as.POSIXct(time[,1],format="%d/%m/%Y %H:%M")
location<- subset(Geo,select=c(lat.comp,long))
?time1<- time[,1]
?lat<- location[,1]
?long<- location[,2]
library(argosfilter)
?vmask(lat,long,time1,25)
#[1] "end_location" "end_location" "not"?????????
"not"????????? "end_location"
#[6] "end_location"

A.K.
________________________________
From: laila Aranda Romero <laila_zgz at hotmail.com>
To: arun <smartpink111 at yahoo.com> 
Sent: Wednesday, July 10, 2013 6:21 PM
Subject: RE: [R] Need hep for converting date data in POSIXct





Hi,

The code: 

library(argosfilter)
setwd("C:/Users/Usuario/Dropbox/Laila Aranda/PUFGRA")
Geo =?
read.table("2370001_PUFGRA_2009_Gough_000_retarded10_both.trj",header=FALSE,sep
= ",", col.names= c("type", "date",
"secs", "Trans1",? "Trans2",
"lat.sta",? "lat.comp", "long",?
"dist", "rumbo", "velocidad",?
"confianza"))
View(Geo)
location=subset(Geo, select= c(lat.comp,long))
time=subset(Geo, select =c(date))
time[,1]<-as.POSIXct(time[,1],format="%d/%m/%Y
%H:%M")???
vmask(lat,lon,time,vmax=25)




The example: library(argosfilter)> setwd("C:/Users/Usuario/Dropbox/LailaAranda/PUFGRA")
> Geo
=?read.table("2370001_PUFGRA_2009_Gough_000_retarded10_both.trj",header=FALSE,sep= ",", col.names= c("type",
"date","secs", "Trans1",?"Trans2",
"lat.sta",?"lat.comp", "long",?"dist",
"rumbo", "velocidad",?
"confianza"))> str(Geo)
'data.frame':? 582
obs. of? 12 variables:?$
type???? : Factor w/ 2 levels
"midnight","noon": 2 1 2 1 2 1 2 1 2 1 ...
?$
date???? : Factor w/ 582 levels
"01/01/2009 01:58",..: 370 389 390 409 410 429 430 450 451 471 ...

?$
secs???? : num? 39773 39773 39774 39774 39775 ...?$
Trans1?? : Factor w/ 186 levels
"04:06","04:08",..: 14 17 17 16 16 28 28 19 19 15 ...
?$
Trans2?? : Factor w/ 159 levels
"00:01","00:03",..: 30 30 28 28 34 34 35 35 36 36 ...
?$
lat.sta? : num? -42.7 -39.1 -37.8 -37.9 -41.2 ...
?$
lat.comp : num? -42.7 -40.6 -38.6 -37.9
-39 ...

?$
long???? : num? 9.31 11.66 10.88 10.72 13.06 ...
?$ dist???? : num?
0 0 127 45 131 ...
?$ rumbo???
: num? 0 0 -16.49 -9.64 -57.22 ...
?$ velocidad: num? 0 0 10.64 3.75 10.75 ...?$ confianza: int? 3 9 9 9 9 6 6 9 9
9
...> head(Geo)type???????????? date???? secs Trans1 Trans2 lat.sta lat.comp? long??
dist
1?noon 20/11/2008 12:23 39772.52?
04:59? 19:47? -42.72??
-42.72? 9.31?? 0.00
2 midnight 21/11/2008 00:33 39773.02? 05:18?
19:47? -39.14?? -40.63 11.66?? 0.00
3?noon 21/11/2008 12:29 39773.52?
05:18? 19:41? -37.82??
-38.60 10.88 127.02
4 midnight 22/11/2008 00:29 39774.02? 05:17?
19:41? -37.86?? -37.86 10.72?
45.04
5 noon 22/11/2008 12:39 39774.53?
05:17 ?20:00? -41.21??
-39.04 13.06 130.78
6 midnight 23/11/2008 00:50 39775.03? 05:41?
20:00? -36.56?? -38.51 16.02 142.06
?? rumbo
velocidad confianza
1??
0.00????? 0.00???????? 3
2??
0.00????? 0.00???????? 9
3 -16.49????
10.64???????? 9
4?
-9.64????? 3.75??? ?????9
5 -57.22????
10.75???????? 9
6?
77.07???? 11.66???????? 6> location=subset(Geo, selectc(lat.comp,long))
> str(location)'data.frame':? 582
obs. of? 2 variables:
?$lat.comp: num? -42.7 -40.6 -38.6 -37.9 -39 ...
?$long??? : num? 9.31 11.66 10.88 10.72 13.06 ...> head(location)
lat.comp? long
1??
-42.72? 9.31
2??
-40.63 11.66
3??
-38.60 10.88
4??
-37.86 10.72
5??
-39.04 13.06
6??
-38.51 16.02
> time=subset(Geo, select =c(date))
> time[,1]<-as.POSIXct(time[,1],format="%d/%m/%Y
%H:%M")> str(time)'data.frame':? 582
obs. of? 1 variable:
?$ date:
POSIXct, format: "2008-11-20 12:23:00" "2008-11-21
00:33:00" ...> head(time)???????????????? date
1 2008-11-20 12:23:00
2 2008-11-21 00:33:00
3 2008-11-21 12:29:00
4 2008-11-22 00:29:00
5 2008-11-22 12:39:00
6 2008-11-23 00:50:00> vmask(lat,lon,time,vmax=25)Error en vmask(lat, lon,
time, vmax = 25) : objeto 'lat' no encontrado

arun

2013-Jul-14 20:15 UTC

head link

[R] Need hep for converting date data in POSIXct

HI,
Try this:
Geo<- read.table(text="
long??? lat.comp confianza
?9.31?????? -42.72???????? 3
11.66????? -40.63???????? 9
10.88????? -38.60???????? 9
10.72???? -37.86???????? 9
13.06???? -39.04???????? 9
16.02???? -38.51???????? 6
",sep="",header=TRUE) 
?col1<- as.numeric(factor(Geo$confianza))
?with(Geo, plot(long,lat.comp,col=col1))
A.K.






________________________________
From: laila Aranda Romero <laila_zgz at hotmail.com>
To: arun <smartpink111 at yahoo.com> 
Sent: Sunday, July 14, 2013 3:28 PM
Subject: RE: [R] Need hep for converting date data in POSIXct




Arun, 

I?contact you again because I have another difficulty with R.? I posted the
following message but it hasn't been accepted by the f?rum filter. So
I'm not sure if you can see it!!!!?

I have the following database: 

head(Geo) 
long ? ?lat.comp confianza 
?9.31 ? ? ? -42.72 ? ? ? ? 3 
11.66 ? ? ?-40.63 ? ? ? ? 9 
10.88 ? ? ?-38.60 ? ? ? ? 9 
10.72 ? ? -37.86 ? ? ? ? 9 
13.06 ? ? -39.04 ? ? ? ? 9 
16.02 ? ? -38.51 ? ? ? ? 6 

I am trying to plot ? Geo$ long versus Geo$lat.comp with diferent colours
regarding the number of Geo$confianza. I don't know how to make the palette
and tell R to plot the points using this palette in the same graph.
Regards,
Laila

> Date: Thu, 11 Jul 2013 03:10:40 -0700
> From: smartpink111 at yahoo.com
> Subject: Re: [R] Need hep for converting date data in POSIXct
> To: laila_zgz at hotmail.com
> 
> Hi Laila,
> No problem.
> Regards,
> Arun
> 
> 
> 
> 
> ----- Original Message -----
> From: laila <laila_zgz at hotmail.com>
> To: r-help at r-project.org
> Cc: 
> Sent: Thursday, July 11, 2013 3:38 AM
> Subject: Re: [R] Need hep for converting date data in POSIXct
> 
> Arun, the last email has been sent it by itself. I have just found the
problem and it works. Thank very much!!!!
> 
> Date: Wed, 10 Jul 2013 19:36:43 -0700
> From: ml-node+s789695n4671274h29 at n4.nabble.com
> To: laila_zgz at hotmail.com
> Subject: Re: Need hep for converting date data in POSIXct
> 
> 
> 
> ??? 
> 
> Hi,
> 
> I guess the error message:
> 
> > vmask(lat,lon,time,vmax=25)
> 
> Error en vmask(lat, lon,
> 
> time, vmax = 25) : objeto 'lat' no encontrado
> 
> 
> says that you have not defined the object 'lat'.
> 
> 
> time<-subset(Geo, select =date)
> 
> time[,1]<-? as.POSIXct(time[,1],format="%d/%m/%Y %H:%M")
> 
> location<- subset(Geo,select=c(lat.comp,long))
> 
> time1<- time[,1]
> 
> lat<- location[,1]
> 
> long<- location[,2]
> 
> library(argosfilter)
> 
> vmask(lat,long,time1,25)
> 
> #[1] "end_location" "end_location" "not"? ? ?
? ? "not"? ? ? ? ? "end_location"
> 
> #[6] "end_location"
> 
> 
> A.K.
> 
> ________________________________
> 
> From: laila Aranda Romero <[hidden email]>
> 
> To: arun <[hidden email]> 
> 
> Sent: Wednesday, July 10, 2013 6:21 PM
> 
> Subject: RE: [R] Need hep for converting date data in POSIXct
> 
> 
> 
> 
> 
> 
> Hi,
> 
> 
> The code: 
> 
> 
> library(argosfilter)
> 
> setwd("C:/Users/Usuario/Dropbox/Laila Aranda/PUFGRA")
> 
> Geo = 
> 
>
read.table("2370001_PUFGRA_2009_Gough_000_retarded10_both.trj",header=FALSE,sep
> 
> = ",", col.names= c("type", "date",
> 
> "secs", "Trans1",? "Trans2",
> 
> "lat.sta",? "lat.comp", "long", 
> 
> "dist", "rumbo", "velocidad", 
> 
> "confianza"))
> 
> View(Geo)
> 
> location=subset(Geo, select= c(lat.comp,long))
> 
> time=subset(Geo, select =c(date))
> 
> time[,1]<-as.POSIXct(time[,1],format="%d/%m/%Y
> 
> %H:%M")? 
> 
> vmask(lat,lon,time,vmax=25)
> 
> 
> 
> 
> 
> The example: library(argosfilter)
> 
> > setwd("C:/Users/Usuario/Dropbox/LailaAranda/PUFGRA")
> 
> > Geo =
read.table("2370001_PUFGRA_2009_Gough_000_retarded10_both.trj",header=FALSE,sep
> 
> = ",", col.names= c("type",
"date","secs", "Trans1", "Trans2",
"lat.sta", "lat.comp", "long", "dist",
"rumbo", "velocidad",? "confianza"))
> 
> > str(Geo)
> 
> 
> 'data.frame':? 582
> 
> obs. of? 12 variables: $
> 
> type? ???: Factor w/ 2 levels
> 
> "midnight","noon": 2 1 2 1 2 1 2 1 2 1 ...
> 
> $
> 
> date? ???: Factor w/ 582 levels
> 
> "01/01/2009 01:58",..: 370 389 390 409 410 429 430 450 451 471
...
> 
> 
> $
> 
> secs? ???: num? 39773 39773 39774 39774 39775 ... $
> 
> Trans1???: Factor w/ 186 levels
> 
> "04:06","04:08",..: 14 17 17 16 16 28 28 19 19 15 ...
> 
> $
> 
> Trans2???: Factor w/ 159 levels
> 
> "00:01","00:03",..: 30 30 28 28 34 34 35 35 36 36 ...
> 
> $
> 
> lat.sta? : num? -42.7 -39.1 -37.8 -37.9 -41.2 ...
> 
> $
> 
> lat.comp : num? -42.7 -40.6 -38.6 -37.9
> 
> -39 ...
> 
> 
> $
> 
> long? ???: num? 9.31 11.66 10.88 10.72 13.06 ...
> 
> $ dist? ???: num 
> 
> 0 0 127 45 131 ...
> 
> $ rumbo? 
> 
> : num? 0 0 -16.49 -9.64 -57.22 ...
> 
> $ velocidad: num? 0 0 10.64 3.75 10.75 ... $ confianza: int? 3 9 9 9 9 6 6
9 9 9
> 
> ...
> 
> > head(Geo)
> 
> type? ? ? ? ? ???date? ???secs Trans1 Trans2 lat.sta lat.comp? long? 
> 
> dist
> 
> 1 noon 20/11/2008 12:23 39772.52 
> 
> 04:59? 19:47? -42.72? 
> 
> -42.72? 9.31???0.00
> 
> 2 midnight 21/11/2008 00:33 39773.02? 05:18 
> 
> 19:47? -39.14???-40.63 11.66???0.00
> 
> 3 noon 21/11/2008 12:29 39773.52 
> 
> 05:18? 19:41? -37.82? 
> 
> -38.60 10.88 127.02
> 
> 4 midnight 22/11/2008 00:29 39774.02? 05:17 
> 
> 19:41? -37.86???-37.86 10.72 
> 
> 45.04
> 
> 5 noon 22/11/2008 12:39 39774.53 
> 
> 05:17? 20:00? -41.21? 
> 
> -39.04 13.06 130.78
> 
> 6 midnight 23/11/2008 00:50 39775.03? 05:41 
> 
> 20:00? -36.56???-38.51 16.02 142.06
> 
> ???rumbo
> 
> velocidad confianza
> 
> 1? 
> 
> 0.00? ? ? 0.00? ? ? ???3
> 
> 2? 
> 
> 0.00? ? ? 0.00? ? ? ???9
> 
> 3 -16.49? ? 
> 
> 10.64? ? ? ???9
> 
> 4 
> 
> -9.64? ? ? 3.75? ? ? ???9
> 
> 5 -57.22? ? 
> 
> 10.75? ? ? ???9
> 
> 6 
> 
> 77.07? ???11.66? ? ? ???6
> 
> > location=subset(Geo, select> 
> c(lat.comp,long))
> 
> 
> > str(location)
> 
> 'data.frame':? 582
> 
> obs. of? 2 variables:
> 
> $lat.comp: num? -42.7 -40.6 -38.6 -37.9 -39 ...
> 
> $long? ? : num? 9.31 11.66 10.88 10.72 13.06 ...
> 
> > head(location)
> 
> 
> lat.comp? long
> 
> 1? 
> 
> -42.72? 9.31
> 
> 2? 
> 
> -40.63 11.66
> 
> 3? 
> 
> -38.60 10.88
> 
> 4? 
> 
> -37.86 10.72
> 
> 5? 
> 
> -39.04 13.06
> 
> 6? 
> 
> -38.51 16.02
> 
> 
> > time=subset(Geo, select =c(date))
> 
> > time[,1]<-as.POSIXct(time[,1],format="%d/%m/%Y
> 
> %H:%M")
> 
> > str(time)
> 
> 'data.frame':? 582
> 
> obs. of? 1 variable:
> 
> $ date:
> 
> POSIXct, format: "2008-11-20 12:23:00" "2008-11-21
> 
> 00:33:00" ...
> 
> > head(time)
> 
> ? ? ? ? ? ? ? ???date
> 
> 1 2008-11-20 12:23:00
> 
> 2 2008-11-21 00:33:00
> 
> 3 2008-11-21 12:29:00
> 
> 4 2008-11-22 00:29:00
> 
> 5 2008-11-22 12:39:00
> 
> 6 2008-11-23 00:50:00
> 
> > vmask(lat,lon,time,vmax=25)
> 
> Error en vmask(lat, lon,
> 
> time, vmax = 25) : objeto 'lat' no encontrado
> 
> 
> ______________________________________________
> 
> [hidden email] mailing list
> 
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> 
> 
> 
> ??? 
> ??? 
> ??? 
> ??? 
> 
> ??? 
> 
> ??? 
> ??? 
> ??? ??? If you reply to this email, your message will be added to the
discussion below:
> ??? ???
http://r.789695.n4.nabble.com/Need-hep-for-converting-date-data-in-POSIXct-tp4671059p4671274.html
> ??? 
> ??? 
> ??? ??? 
> ??? ??? To unsubscribe from Need hep for converting date data in POSIXct,
click here.
> 
> ??? ??? NAML
> ???????? ???????? ?????? ??? ? 
> 
> 
> 
> --
> View this message in context:
http://r.789695.n4.nabble.com/Need-hep-for-converting-date-data-in-POSIXct-tp4671059p4671301.html
> Sent from the R help mailing list archive at Nabble.com.
> ??? [[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> ??

R help - Jul 2013 - Need hep for converting date data in POSIXct

[R] Need hep for converting date data in POSIXct

[R] Need hep for converting date data in POSIXct

[R] Need hep for converting date data in POSIXct

[R] Need hep for converting date data in POSIXct

[R] Need hep for converting date data in POSIXct