Change the last value of all column names of a dataframe

Asked Nov 13 '16 at 21:11

Active Mar 23 '23 at 15:41

Viewed 71 times

I have a dataframe, which looks like follows:

# Example data
data <- data.frame(x1.1 = rnorm(10),
                   x2.1 = rnorm(10),
                   x3.1 = rnorm(10))

I want to change the last value ".1" of all column names to ".2". It is important to find a general solution, since I will have to perform this for several big dataframes.

# Desired output:
colnames(data)
# "x1.2" "x2.2" "x3.2"

I can do that with a complicated loop, but I am sure there must be an easier way, which I am not able to find. Thank you very much for your help!

edited Mar 23 '23 at 15:41

aynber

22,380
8
50
63

asked Nov 13 '16 at 21:11

Joachim Schork

2,025
3
25
48

3

Try `colnames(data) <- sub(".1$",".2",colnames(data))` – aichao Nov 13 '16 at 21:17
Thank you very much for the fast answer! That's exactly what I was looking for. – Joachim Schork Nov 13 '16 at 21:18
2

You don't need the `.`, using `1$` and `2` will suffice – Rich Scriven Nov 13 '16 at 21:21
Ah yes you are right, thanks for the improvement! – Joachim Schork Nov 13 '16 at 21:25

Change the last value of all column names of a dataframe

0 Answers0