Simple data frame rowname trim question

[cook675]

I have an object with a dataframe in it that has rownames as follows:

"_ABC"
"_DEF"
"_GHI"

How do I get rid of the _ at the beggining of each rowname?

Thanks!

[mattwarkentin]

Hi @cook675,

Is it a variable or truly a rowname? It is a variable, depending on the name of the variable, try this:

library(tidyverse)

data <- tibble(x = c("_ABC", "_DEF", "_GHI"))

data %>%
  mutate(x = str_replace(x, "_", ""))

I can be more helpful if you show the actual structure of the data.

[cook675]

@mattwarkentin

data <- tibble(x = c("_ABC", "_DEF", "GHI")) data %>% mutate(x = str_replace(x, "", ""))

Thanks for the reply, they are actual rownames and not variables, however, I was trying to generalize in the problem. These are not the actual rownames; and there are 17,000 of them and they all begin with "_" ! So how to remove the underscore from them all across the set?

[andresrcs]

The solution would be almost the same

df <- data.frame(x = 1:3, 
                 row.names = c("_ABC", "_DEF", "_GHI")
                 )
df
#>      x
#> _ABC 1
#> _DEF 2
#> _GHI 3

rownames(df) <- gsub(pattern = "_", replacement = "", x = rownames(df))
df
#>     x
#> ABC 1
#> DEF 2
#> GHI 3

^{Created on 2019-11-13 by the reprex package (v0.3.0.9000)}
Note: Please make your questions providing a proper REPRoducible EXample (reprex) like the one above.

[cook675]

Thanks both of you I really appreciate it!