Replace characters from a column of a data frame R

Question

I have a data frame   a  lt - runif  10  b  lt - letters  1 10  c  lt - c rep   A-B   4   rep  A C   6   data1  lt - data frame  a  b  c  data1   And I wan to replace   in A C of column c for - to have a data frame like data2   z  lt - c rep   A-B   4   rep  A-C   6   data2  lt - data frame  a  b  z  data2   Do you know how I can do that

User · Answer

chartr is also convenient for these types of substitutions   chartr       -   data1 c      1   A-B   A-B   A-B   A-B   A-C   A-C   A-C   A-C   A-C   A-C    Thus  you can just do       data1 c  lt - chartr       -   data1 c

User · Answer

You can use the stringr library     library  stringr    a  lt - runif 10  b  lt - letters 1 10  c  lt - c rep  A-B   4   rep  A B   6   data  lt - data frame a  b  c   data                a b   c   1  0 19426707 a A-B   2  0 12902673 b A-B   3  0 78324955 c A-B   4  0 06469028 d A-B   5  0 34752264 e A C   6  0 55313288 f A C   7  0 31264280 g A C   8  0 33759921 h A C   9  0 72322599 i A C   10 0 25223075 j A C  data c  lt - str replace all data c        -    data                a b   c   1  0 19426707 a A-B   2  0 12902673 b A-B   3  0 78324955 c A-B   4  0 06469028 d A-B   5  0 34752264 e A-C   6  0 55313288 f A-C   7  0 31264280 g A-C   8  0 33759921 h A-C   9  0 72322599 i A-C   10 0 25223075 j A-C   Note that this does change factored variables into character

User · Answer

If your variable data1 c is a factor  it s more efficient to change the labels of the factor levels than to create a new vector of characters   levels data1 c   lt - sub       -   levels data1 c                 a b   c 1  0 73945260 a A-B 2  0 75998815 b A-B 3  0 19576725 c A-B 4  0 85932140 d A-B 5  0 80717115 e A-C 6  0 09101492 f A-C 7  0 10183586 g A-C 8  0 97742424 h A-C 9  0 21364521 i A-C 10 0 02389782 j A-C

User · Answer

Use gsub   data1 c  lt - gsub       -   data1 c  data1              a b   c 1  0 34597094 a A-B 2  0 92791908 b A-B 3  0 30168772 c A-B 4  0 46692738 d A-B 5  0 86853784 e A-C 6  0 11447618 f A-C 7  0 36508645 g A-C 8  0 09658292 h A-C 9  0 71661842 i A-C 10 0 20064575 j A-C

[r] Replace characters from a column of a data frame R

Examples related to r

Examples related to replace

Examples related to dataframe