Discussion :

[Puppet_Master]

Bonjour.

J'ai besoin de découper le chemin d'une colonne d'un data frame et le repartir dans plusieurs colonnes. Voici un exemple de data frame de départ:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
d <- data.frame(
    user   = c("user3","user2","user3","user1","user1","user3"),
    pdc    = c("123", "46", "123", "17", "17", "123"),
    action = c("open","followlike","open","followlike","open","followlike"),
    cible  = c(
        NA,
        "\\\\A\\B\\C\\D\\file_42.png",
        NA,
        "\\\\A\\B\\C\\D\\file_19.png",
        NA,
        "\\\\A\\B\\C\\D\\file_21.png"
    )
)

et voici l'objectif a atteindre:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
d1 <- data.frame(
    user   = c("user3","user2","user3","user1","user1","user3"),
    pdc    = c("123", "46", "123", "17", "17", "123"),
    action = c("open","followlike","open","followlike","open","followlike"),
    cible  = c(
        NA,
        "\\\\A\\B\\C\\D\\file_42.png",
        NA,
        "\\\\A\\B\\C\\D\\file_19.png",
        NA,
        "\\\\A\\B\\C\\D\\file_21.png"
    ),
    dir1 = c(NA,"A",NA,"A",NA,"A"),
    dir2 = c(NA,"B",NA,"B",NA,"B"),
    dir3 = c(NA,"C",NA,"C",NA,"C"),
    dir4 = c(NA,"D",NA,"D",NA,"D"),
    file = c(NA,"file_42.png",NA,"file_19.png",NA,"file_21.png")
)

une idée sur la façon de faire ?

[olivier.decourt]

Bonjour.
Avec la fonction tidyr::separate ?