Spread function Error: Duplicate identifiers for rows

Asked Dec 28 '17 at 13:48

Active Dec 28 '17 at 14:11

Viewed 85 times

I am converting long to large dataset based on zip code. Some values (intermediate and actual names) can be similar. Spread function from tidyr returns me an error.

zip <- c(02183, 02183, 02184, 02184)
name <- c("Chevregni", "Chevrigny", "Chevresis", "Chevresis")
type <- c("actual_name", "intermediate_name", "actual_name", "intermediate_name")

dummy <- data.frame(zip, name, type)
library(tidyr)
test <- dummy %>% spread(zip, type, name)

Expected result :

zip     actual_name      intermediate_name  
02183   Chevregny        Chevresix
02184   Chevresis       Chevresis

Error : Duplicate identifiers for rows

edited Dec 28 '17 at 14:11

asked Dec 28 '17 at 13:48

Wilcar

2,349
2
21
48

`Chevresix` is not in the original data ... – Jaap Dec 28 '17 at 13:55
Thanks, I edited my post. – Wilcar Dec 28 '17 at 13:55
1

`df %>% spread(type, name)` works for me – Jaap Dec 28 '17 at 13:57
1

Didn't I just duped this question? Did you repost the same one? – Sotos Dec 28 '17 at 13:58
Not really, duplicate values in zip and names create an error – Wilcar Dec 28 '17 at 13:59
So create a new distinct var, i.e. `df %>% mutate(new = row_number()) %>% spread(type, name)` – Sotos Dec 28 '17 at 14:00
2

You are active on SO for quite some time now. Please learn how to post a [reproducible example](http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example/5963610). The problem can't be reproduced with the code you posted. – Jaap Dec 28 '17 at 14:00
I edited my answer. Sorry for the quality of my post – Wilcar Dec 28 '17 at 14:05
`df %>% spread(type, name)` still returns the expected result without an error – Jaap Dec 28 '17 at 14:08
I re-post and have Duplicate identifiers for rows – Wilcar Dec 28 '17 at 14:13
1

Just follow the link I duped it with. Did you try it? That is the solution to your problem (which by the way I found by hitting the FIRST link that came up after I googled *Error : Duplicate identifiers for rows*) – Sotos Dec 28 '17 at 14:16
Your link resolve my problem. – Wilcar Dec 28 '17 at 17:40

Spread function Error: Duplicate identifiers for rows

0 Answers0

Linked