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]]

