It is unclear what the problem is. Does following code solve your append
problem?
fmt = "%m/%d/%Y %H:%M"
fname <- "new.txt"
#records = 2904
newfile <- read.csv(fname, header = TRUE, sep = ",", skip=0,
colClasses = c(rep("character",2), rep("numeric", 16))
)
newfile.comb <- cbind(newfile[2], newfile[3])
fname <- "old.txt"
#records = 73768
oldfile <- read.table(fname, header = FALSE, sep = "\t", dec = ".",
colClasses = c("character","numeric","NULL"), skip = 0)
names(oldfile)[1] <- names(newfile)[2]
names(oldfile)[2] <- names(newfile)[3]
combo.file = rbind(oldfile,newfile.comb)
#records = 76672
edit(combo.file)
AA
On Wed, Apr 4, 2012 at 9:27 AM, knavero <knav...@gmail.com> wrote:
> Here is the data I'm working with:
>
> http://r.789695.n4.nabble.com/file/n4530888/new.txt new.txt
>
> http://r.789695.n4.nabble.com/file/n4530888/old.txt old.txt
>
> My code is here:
>
> http://pastebin.com/9jjs6Ahr
>
> I'm looking for away to simply attach the new.txt to the bottom of old.txt
> through R, else I'll just throw it in Excel to do some preprocessing. I've
> looked into using merge, cbind, concatenate, and rbind. However, I'm
> running
> into problems where the 2012 data keeps ending up on top before the 2010
> and
> 2011 data or the function just adds more extra columns to the right side.
> Is
> there a simple method of doing this? Thanks.
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/Trying-to-merge-new-data-set-to-bottom-of-old-data-set-Both-are-zoo-objects-tp4530888p4530888.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
