deleting the old rownames might help. rownames(df1) <- rownames(df2) <- rownames(df3) <- NULL
But a reproducible example would be interestng. In simple cases there is no problem with "duplicated" rownames as they are automatically renamed: > df1 <- data.frame(A=1, B=2, row.names="A") > df2 <- data.frame(A=1, B=2, row.names="A") > rbind(df1,df2) A B A 1 2 A1 1 2 > df1 <- data.frame(A=1:2, B=2:3, row.names=c("A", "A1")) > df2 <- data.frame(A=1, B=2, row.names="A") > rbind(df1,df2) A B A 1 2 A1 2 3 A2 1 2 On Mon, Mar 31, 2014 at 11:53 PM, Rolf Turner <r.tur...@auckland.ac.nz> wrote: > On 01/04/14 05:42, Jefferson Ferreira Ferreira wrote: >> >> There are other issues here addressing the same question, but I don't >> realize how to solve my problem based on it. So, I have 5 data frames that >> I want to merge rows in one unique data frame using rbind, but it returns >> the error: >> >> "Error in row.names<-.data.frame(*tmp*, value = value) : 'row.names' >> duplicated not allowed In addition: Warning message: non-unique values >> when >> setting 'row.names': '1', '10', '100', '1000', '10000', '100000', >> '1000000', '1000001 [....]" >> >> The data frames have the same columns but different number of rows. I >> thought the rbind command took the first column as row.names. So tried to >> put a sequential id in the five data frames but it doesn't work. I've >> tried >> to specify a sequential row names among the data frames via row.names() >> but >> with no success too. The merge command is not an option I think because >> are >> 5 data frames and successive merges will overwrite precedents. I've >> created >> a new data frame only with ids and tried to join but the resulting data >> frame don't append the columns of joined df. >> >> Follows an extract of df 1: >> >> id image power value pol class1 1 tsx_sm_hh 0.1834515 >> -7.364787 hh FR2 2 tsx_sm_hh 0.1834515 -7.364787 hh FR3 3 >> tsx_sm_hh 0.1991938 -7.007242 hh FR4 4 tsx_sm_hh 0.1991938 >> -7.007242 hh FR5 5 tsx_sm_hh 0.2079365 -6.820693 hh FR6 6 >> tsx_sm_hh 0.2079365 -6.820693 hh FR[...]1802124 1802124 tsx_sm_hh >> 0.1991938 -7.007242 hh FR >> >> The four other df's are the same structure, except the 'id' columns that >> don't have duplicated numbers among it. 'pol' and 'image' columns are >> defined as levels. and all.pol <- rbind(df1,df2,df3,df4,df5) return the >> this error of row.names duplicated. >> >> Any idea? > > > Not without a reproducible example. If you can create one, use dput() to > include the necessary data in your posting. > > You *might* try something like: > > e1 <- df1[1:5,1:2] > e2 <- df2[1:5,1:2] > ee <- rbind(e1,e2) > > If that throws the error, include dput(e1) and dput(e2) in your posting. If > it *doesn't* then this might give you some insight into just what is > triggering the error. > > Look at rownames(df1) and rownames(df2) as well as rownames(e1) and > rownames(e2). > > cheers, > > Rolf Turner > > ______________________________________________ > 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. ______________________________________________ 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.