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.
