Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Want to remove common pattern from column names.

Himanshu_PantHimanshu_Pant Member Posts: 46 Learner II
I have a datset which contain a common pattern across all the column name. E.g.

average(column1)    average(column2)  average(column3)  average(column4).

I want column name like: 
column1                    column2          column3              column4

so how to remove, average() from each column name.

P.S. Please suggest a way without using a loop. If not, than loop will also work.

Best Answer

  • kaymankayman Member Posts: 662 Unicorn
    Solution Accepted
    use rename by replace, and replace average\((.*)\) with $1
Sign In or Register to comment.