Formatting dataframe to rows based on keys in a column

Question

I have a data-frame like one below:

tag_id      value      time_stamp
tag_1      1          2017-05-01 00:00:00
tag_2      2          2017-05-01 00:00:00
tag_3      3          2017-05-01 00:00:00
tag_1      4          2017-05-01 00:10:00
tag_2      5          2017-05-01 00:10:00
tag_3      6          2017-05-01 00:10:00

I want to format it as under, can someone please help?

time_stamp           tag_1     tag_2   tag_3          
2017-05-01 00:00:00  1         2       3
2017-05-01 00:10:00  4         5       6

score 0 · Accepted Answer · answered Oct 04 '18 at 10:10

0

This is a classic case of pivot.

Assuming df is your dataframe.

df.pivot(index='time_stamp', values='value', columns='tag_id')

answered Oct 04 '18 at 10:10

Rahul Chawla

1,048
10
15

Formatting dataframe to rows based on keys in a column

1 Answers1