removing spaces from all column names at once in R using gsub

Asked Feb 25 '19 at 08:20

Active Feb 25 '19 at 08:24

Viewed 92 times

I have a datafile with 57 columns and most of my column names contain space. According to the Best Practices in Preparing Data Files for Importing into R blank spaces should be removed. I tried using the gsub as in this post however I do not know how to refer to the column names ?

gsub("\\s+","_",mydata)

this renames my entire datafile. How can I rename the column names only?

edited Feb 25 '19 at 08:24

markus

25,843
5
39
58

asked Feb 25 '19 at 08:20

user1607

2

Try `names(mydata) <- gsub("\\s+","_", names(mydata))` – markus Feb 25 '19 at 08:22
@markus your solution works, thanks - quick & easy – user1607 Feb 25 '19 at 10:03

removing spaces from all column names at once in R using gsub

0 Answers0