Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How can I change the name of columns

Hello All,

I would like to change the three last column's names into "First Class", "Second Class", and "Third Class" instead of "Passenger First Class"... as well.

Thank you very much.
Loan Nguyen

Image: https://us.v-cdn.net/6030995/uploads/editor/pc/g9h4zh4i7o0z.png

Find more posts tagged with

AI Studio

Accepted answers

Caperez

Hi @Loan_Nguyen56
You have an operator named Rename into Blending-> Attributes->Names & Roles.

regards

All comments

Caperez

Hi @Loan_Nguyen56
You have an operator named Rename into Blending-> Attributes->Names & Roles.

regards

Loan_Nguyen56

ceaperez
Thanks for your letting me know.
Besides that, I follow the instructions below to get the new column names however, I cannot get the right answer.
"Renaming attributes with regular expressions

Search for the operator Rename by Replacing, add it, and connect it to Pivot.
Also connect the operator to the result port on the right.
Copy count$(.*)$_(.*) into the replace what parameter field. Make sure that you get all the parentheses right!
Copy $1 $2 into the replace by parameter. "

And, what does count$(.*)$_(.*) means?

Thanks,

Caperez

Hi @Loan_Nguyen56,

They are replacing the names of the Attributes (Column) using a Regular Expression.

Probably their Attributes names are like count(something)_anotherthing

With this part count$(.*)$_(.*) they are locating the two parametrized blocks after the string "count"

Then with $1 $2 instruction into the replace by parameter, they are replacing the original string by the first coincident block $1 (something) and the second coincidente block $2 (anotherthing)

you don't have a regular pattern in your Attributes names maybe is better to use another operator like Rename by Generic Name and write Passenger Class, for example.

Regards,

Loan_Nguyen56

ceaperez,

Wow, I understand it clearly.
Thank you very much for your kind help.

Regards,