Data Preprocessing - Need urgently help
Hello Everbody..
i will transform a given data, but i dont know how can i do it in Rapidminer.
Given data:
Client Date Product
Client 1 14.02.1980 Product1
Client 1 14.02.1980 Product 2
Client 1 14.02.1980 Product 3
Client 1 14.02.1980 Product 4
Client 1 14.02.1980 Product 5
Client 1 13.02.1934 Product 1
Client 1 13.02.1934 Product 2
Client 1 13.02.1934 Product 3
Client 1 13.02.1934 Product 4
Client 3 14.02.1934 Product 1
Client 3 14.02.1934 Product 2
Client 3 14.02.1934 Product 3
Client 4 15.02.1934 Product 1
Client 4 15.02.1934 Product 2
Client 5 16.02.1934 Product 1
this is what i want..
Client Date Product1 Product 2 Product 3 Product 4 Product 5
Client 1 14.02.1980 1 1 1 1 1
Client 1 13.02.1934 1 1 1 1 0
Client 3 14.02.1934 1 1 1 0 0
Client 4 15.02.1934 1 1 0 0 0
Client 5 16.02.1934 1 0 0 0 0
I would be very happy if someone can help me. It is very urgent and important
Greetings!
i will transform a given data, but i dont know how can i do it in Rapidminer.
Given data:
Client Date Product
Client 1 14.02.1980 Product1
Client 1 14.02.1980 Product 2
Client 1 14.02.1980 Product 3
Client 1 14.02.1980 Product 4
Client 1 14.02.1980 Product 5
Client 1 13.02.1934 Product 1
Client 1 13.02.1934 Product 2
Client 1 13.02.1934 Product 3
Client 1 13.02.1934 Product 4
Client 3 14.02.1934 Product 1
Client 3 14.02.1934 Product 2
Client 3 14.02.1934 Product 3
Client 4 15.02.1934 Product 1
Client 4 15.02.1934 Product 2
Client 5 16.02.1934 Product 1
this is what i want..
Client Date Product1 Product 2 Product 3 Product 4 Product 5
Client 1 14.02.1980 1 1 1 1 1
Client 1 13.02.1934 1 1 1 1 0
Client 3 14.02.1934 1 1 1 0 0
Client 4 15.02.1934 1 1 0 0 0
Client 5 16.02.1934 1 0 0 0 0
I would be very happy if someone can help me. It is very urgent and important
Greetings!