Unstack dataframe with combine by the same date

[Tatiana_P]

What is the simplest way to unstack the following dataframe

df = DataFrame(date=[Date(2018,1,1), Date(2018,1,1), Date(2018,1,1), Date(2018,1,2), Date(2018,1,2), Date(2018,1,2)], B=[“T1”, “T2”, “T3”, “T1”, “T2”, “T3”], value=1:6)

and get such dataframe

Thank you for answering.

[Rudi79]

@Tatiana_P

df = DataFrame(date=[Date(2018,1,1), Date(2018,1,1), Date(2018,1,1), Date(2018,1,2), Date(2018,1,2), Date(2018,1,2)], B=[“T1”, “T2”, “T3”, “T1”, “T2”, “T3”], value=1:6)

unstack(df, :date, :B, :value)

should do the trick.