reshaping a pandas table

Asked Jul 27 '20 at 15:25

Active Jul 27 '20 at 15:25

Viewed 25 times

This is probably a simple one but I've been trying all day with no luck

I have a table that looks like this:

event   user country    plan

start   fred    uk      free
start   fred    uk      free
start   john    fr      paid
stop    john    fr      paid
stop    fred    uk      free
scan    john    fr      paid
scan    fred    uk      free
scan    fred    uk      free
stop    john    fr      paid
start   john    fr      paid

Id like to convert it into this:

           event
user    start   stop  scan  country    plan
fred    2       1     2      uk         free
John    2       2     1      fr        paid

Can anyone help? I've tried pivot but it keeps on telling me: ValueError: Index contains duplicate entries, cannot reshape

Thanks

asked Jul 27 '20 at 15:25

matt3526

1

Try `pd.crosstab(df['user'], df['event']).join(df.groupby('user')[['country', 'plan']].first())` – Chris Adams Jul 27 '20 at 15:32
1

wow that's amazing, thanks!. Now to read up on cross tab and join. – matt3526 Jul 27 '20 at 16:05

reshaping a pandas table

0 Answers0