โ09-25-2019 02:49 AM
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
โ09-27-2019 03:22 AM
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
โ10-02-2019 02:34 AM
Thank you Chaitanya.