Community Conundrum 25: Feature Visualization is now live! Read More

combine rows with same value

Level 2
combine rows with same value
 

I am trying to rearrange a data in dataiku platform. i am performing several operations, pivoting transposed the data but created more null data. as below

THE data i have

 
TIMEtag1tag2 tag3tag4tag5
00:15:001    
00:15:00 2   
00:15:00  3  
00:15:00   4 
00:15:00    5
00:30:00 7   
00:30:006    
00:30:00  8  
00:30:00    10
00:30:00   9 

 

The Data i need it to be

 
TIMEtag1tag2 tag3tag4tag5
00:15:0012345
00:30:00678910

 

0 Kudos
1 Reply
Dataiker
Dataiker

Hi,

you could do a Group recipe using the TIME column as key and max (or min) aggregates for the other columns. You can also rename the columns in the output stage of the group recipe if you want to drop the suffix