How can I merge or join these table(seg, conv)? [cloesed]

Asked Apr 11 '22 at 12:16

Active Jun 07 '22 at 00:56

Viewed 21 times

I have two table like these.

First table is SEG

Second table is CONV

I have to merge or join these two table like this.(on 'id', 'date')

Result_merge

How do I combine to get the same result as the third(in PYTHON)? Please help me and always thx.

edited Jun 07 '22 at 00:56

asked Apr 11 '22 at 12:16

Eonsworld

pivot the second table and merge (see duplicates). NB. please do not use images of data, provide **text** or **DataFrame constructors** – mozway Apr 11 '22 at 12:18
https://docs.google.com/spreadsheets/d/1kFpKdzYi8GVfGHfDEyO9OnfzZeDr6tN8dNUL76mZ4VI/edit#gid=1661729794 its google spread sheet data. Could u help me? – Eonsworld Apr 11 '22 at 14:54

0 Answers0