move string at the end of column names to beginning

Question

I have a counts data frame. The column names are A01_rep1, A02_rep1, A03_rep1, A01_rep2, A02_rep2 ..... I want to rename the column names to rep1_A01, rep1_A02, rep1_A03, rep2_A01, rep2_A02.....

I have tried using gsub but am confused how to accurately use it. Also used some iteration of this post Move characters from beginning of column name to end of column name (additonal question) but have not found it to work. Any help is appreciated.

data %>% rename_with(~str_replace(., "([^_]+)_(.*)", "\\2_\\1")) — Onyambu
– Onyambu, Commented Sep 20, 2022 at 18:14

Onyambu · Accepted Answer · 2022-09-20 18:15:06Z

2

in base R:

names(data) <- sub("([^_]+)_(.*)", "\\2_\\1", names(data))

In tidyverse:

data %>% 
   rename_with(~str_replace(., "([^_]+)_(.*)", "\\2_\\1"))

answered Sep 20, 2022 at 18:15

Onyambu

80.3k3 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

move string at the end of column names to beginning

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related