ich versuche eine Spalte in zwei Splaten zu unterteilen:
Code: Alles auswählen
separate(refine, "Product code / number", into = c("product_code","product_number"), sep = "-")
Code: Alles auswählen
# A tibble: 25 x 7
company product_code product_number address city country name
* <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 philips p 5 Groningensingel 147 arnhem the netherlands dhr p. jansen
2 philips p 43 Groningensingel 148 arnhem the netherlands dhr p. hansen
3 philips x 3 Groningensingel 149 arnhem the netherlands dhr j. Gansen
4 philips x 34 Groningensingel 150 arnhem the netherlands dhr p. mansen
5 philips x 12 Groningensingel 151 arnhem the netherlands dhr p. fransen
6 philips p 23 Groningensingel 152 arnhem the netherlands dhr p. franssen
7 akzo v 43 Leeuwardenweg 178 arnhem the netherlands dhr p. bansen
8 akzo v 12 Leeuwardenweg 179 arnhem the netherlands dhr p. vansen
9 akzo x 5 Leeuwardenweg 180 arnhem the netherlands dhr p. bransen
10 akzo p 34 Leeuwardenweg 181 arnhem the netherlands dhr p. janssen
# ... with 15 more rows
Gruß