[R] Need to merge multiple data frames with time stamp

Sandeep.Sampara at ril.com Sandeep.Sampara at ril.com
Fri Oct 18 13:37:48 CEST 2013



I'm trying to combine 15 different data frames but all have time field as
common. But the thing is time intervals are different (like min's and

So I have to check the common time from all the 15 data frames and merge it
to a single data frame and then export it to excel or csv. 

I tried with below query but it's not giving exact output. It's almost 5
year of data, but its giving output for 3months only. 

Please help with your query to get my output. 


a <- merge(MA2DHPA,MA2DHPB,by="IP_Trend_Time")

b <- merge(MA2UCPA,MA2UCPB,by="IP_Trend_Time")

c <- merge(MA2DCPA,MA2DCPB,by="IP_Trend_Time")

d <- merge(MA2DHTA,MA2DHTB,by="IP_Trend_Time")

e <- merge(MA2UCTA,MA2UCTB,by="IP_Trend_Time")

f <- merge(MA2DCTA,MA2DCTB,by="IP_Trend_Time")

g <- merge(MA2CP,MA2CPS,by="IP_Trend_Time")

h <- MA2AP


x <- merge(a,b,by="IP_Trend_Time")

y <- merge(c,d,by="IP_Trend_Time")

z <- merge(e,f,by="IP_Trend_Time")

w <- merge(g,h,by="IP_Trend_Time")


x1 <- merge(x,y,by="IP_Trend_Time")

y1 <- merge(z,w,by="IP_Trend_Time")


MA2 <- merge(x1,y1,by="IP_Trend_Time")



Sandeep S|IT&C,
Reliance Industries Limited (E&P) | Onshore Terminal | Gadimoga
*  +91 884 2977066 / 9908130749


Please consider the environment before printing this email.


-------------- next part --------------
"Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s). 
are confidential and may be privileged. If you are not the intended recipient. you are hereby notified that any 
review. re-transmission. conversion to hard copy. copying. circulation or other use of this message and any attachments is 
strictly prohibited. If you are not the intended recipient. please notify the sender immediately by return email. 
and delete this message and any attachments from your system.

Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email. 
The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."

More information about the R-help mailing list