Separate words in column name

[vsunilbabu]

Hello,

Can you please help separating my column names using ‘_’ whenever there are capital letters in the column name.

For example:
Input

Output

In my research, I understood that findall() function can help iterating through all column names, using the logic: output.append(“_”.join(re.findall(‘[A-Z][^A-Z]*’, i)))

Can someone help me with a script for this? Or if there is any other better way.

Thanks,
Sunil

[kchaitanya]

Hi Sunil,

Please use the attached pipeline to read a csv and update the column names with the conversion you asked for.

Column_Name_2019_09_27.slp (9.3 KB)

Thanks,
Chaitanya

[vsunilbabu]

Thank you Chaitanya.