nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Siemens Community Catalyst Program

The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.

Nominate Now

Rename many columns

choose_username

Hi there,

i wanted to rename a column with the Operator Rename. The Problem is that i have to rename 31 columns. As far as i see i do need to use 31 Rename-Operators? My Question is: Is there a way to rename all 31 columns with 1 operator?

thanks in advance

user

Find more posts tagged with

AI Studio

Accepted answers

All comments

wessel

Use the Loop Attributes operator?

IngoRM

Hi,

maybe the operators "Rename by Replacing" or "Rename by Generic Names" can also be helpful. If you want to use specific names, looping could indeed be the best option - you could even take the old and new names from another example set...

Cheers,
Ingo

choose_username

Hello,

the approach with the Loop sounds interessting. By trying it i found out that it is neccessary to make use of macros. Is there a tutorial or example how to do this in RM?

(btw its a great product with great support)

Greetings

User

IngoRM

Hi,

did you try our new Community Extension? Just download and install it from our update- and installation server via the Help menu of RapidMiner. You can search for processes containing the word "Loop" or "Macro" and you will see several examples of processes containing operators making use of them.

Cheers,
Ingo

Andrew2

If you want a quick and dirty hack, I successfully used the de-obfuscate operator to rename columns. Provide an obfuscation map file containing a row for each attribute you want to rename in the following form:


oldname<tab>newname

The tab is important; spaces cause an error.

Ugly but effective.

regards,

Andrew

IngoRM

Nice one

Cheers,
Ingo

choose_username

thx for the tip. i will give it a try : )

greetings User

wessel

How to convert all attributes to lower-case?

choose_username

well i simply use the Rename Operator. But maybe there s a solution tryin "Rename by Replacing" in combination with an regular expression like [A-Z] -> [a-z] and a loop or smthing

greetings

User

wessel

hmm :P

Then you need to type 26 replacements..

IngoRM

Hi,

this is easily possible with a short script. You can find an example process with our Community Extension for RapidMiner. Just download the extension, show the corresponding view and search for the process "Transform Attribute Names to lower Case (Script)". You can then simply download the process and run it directly in your client.

Cheers,
Ingo

wessel

awchisholm wrote:
If you want a quick and dirty hack, I successfully used the de-obfuscate operator to rename columns. Provide an obfuscation map file containing a row for each attribute you want to rename in the following form:
oldname<tab>newname
The tab is important; spaces cause an error.

Ugly but effective.

regards,

Andrew

How does this work?

Andrew2

Here's an example process


<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.0">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" expanded="true" name="Process">
    <process expanded="true" height="161" width="480">
      <operator activated="true" class="generate_data" expanded="true" height="60" name="Generate Data" width="90" x="112" y="75"/>
      <operator activated="true" class="de_obfuscate" expanded="true" height="76" name="rename" width="90" x="380" y="75">
        <parameter key="obfuscation_map_file" value="c:\temp\att.txt"/>
      </operator>
      <connect from_op="Generate Data" from_port="output" to_op="rename" to_port="example set input"/>
      <connect from_op="rename" from_port="example set output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

The file referred to is here


att1	apple
att2	banana
att3	pear
att4	grape
att5	orange

Ugly but effective

Andrew

Quick Links

Upcoming Events

Advancing power electronics design with Simcenter PSIM and High-Performance Computing
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Getting Started with Faster Motor Building in Simcenter Simlab
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Practical hybrid solver workflows in Simcenter Feko
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…

View all community events