Convert Column Data to Row

sgnarkhede2016sgnarkhede2016 Member Posts: 140 Contributor II
Hello ,
I have 
Data:
Value                             Attribute
?
Count
4.0
MONTH
15.0
WEEK_OF_YEAR
2022.0
YEAR
1633.1286847639503
prediction(Count)
?
Count
4.0
MONTH
16.0
WEEK_OF_YEAR
2022.0
YEAR
1674.7535102732875
prediction(Count)
Expected output
Count MONTH WEEK_OF_YEAR YEAR prediction(Count)
?          4.0         15.0                        2022 1633.128   

Can anyone help me on this

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,249 RM Data Scientist
    Hi,
    sounds like the transpose operator is your thing.
    BR,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • sgnarkhede2016sgnarkhede2016 Member Posts: 140 Contributor II
    edited June 13
    mschmitz Attribute values repeating after 5 entries i want all in row-wise only one header

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,249 RM Data Scientist
    Then Transpose and Append?

    BR,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.