I already have this df
with only three types of frame_code: P20
, P60
and EV9
bus frame_code
0 U0032 EV9
1 U6762 P20
2 U1438 P20
3 U4623 P20
4 U1791 P20
.. ... ...
88 U3804 P20
89 U4065 P20
90 U1035 P20
91 U0032 P20
92 U0032 P60
I need to group in the next df
:
bus P20 P60 EV9
U0032 2 1 1
U0762 1 0 0
. . . .
I already tried using group_by df = df[["bus", "frame_code"]].groupby(["frame_code"])
, however I couldn't achieve the proper result