The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

How to convert the values in a column in another columns

AlmuVTAlmuVT Member Posts: 8 Contributor II
in Help
Hello!

I have a dataset with a column named "months" wich values are "January 2003", "February 2003".... "January 2005"... and again.
And a second column with the number of events in each month-year.

I want to make differents columns corresponding to each year and they will have the value from each moth in that year. So I want a first column with months with values like January, February... and then one column for each year: 2003, 2004...

How can I do it? :/

Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist
    Solution Accepted
    Hi,

    have you tried a Split operator and splitted on a whitespace?

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Answers

  • AlmuVTAlmuVT Member Posts: 8 Contributor II
    Ah ok, Split operator is what I needed, Thank you!!
Sign In or Register to comment.