How to convert the values in a column in another columns

AlmuVTAlmuVT Member Posts: 8 Contributor II

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

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

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

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


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