[R] Fwd: rbind error - duplicated row.names not allowed

[Rolf Turner]

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