Issues in reshaping" long to wide columns with object as values"

Asked Mar 18 '19 at 02:14

Active Mar 18 '19 at 02:18

Viewed 18 times

I have tried to reshape the following data frame from long to wide.

And I want it to become:

where the values under my columns A, B and C are the count of the frequency of my column violation.

How can I do this swiftly? I could not find any relevant pivot documentation.

Thanks!

edited Mar 18 '19 at 02:18

Muhammad usman

asked Mar 18 '19 at 02:14

Filippo Sebastio

1

Please post samples of input and expected output in text form in code tags and let us know then. – RavinderSingh13 Mar 18 '19 at 02:17
Hi there, I provided the picture of my input and out, doesn't it appear? – Filippo Sebastio Mar 18 '19 at 02:18
@FilippoSebastio, please post example data *in text form*, not images. It's impossible to copy-paste image content into our local editors to test solutions. – Peter Leimbigler Mar 18 '19 at 02:24
In the meantime, `pd.crosstab(df['Country'], df['Violations'])` might achieve the expected output. – Peter Leimbigler Mar 18 '19 at 02:26
Thanks Peter, this was so simple! I will post the data in text from so on – Filippo Sebastio Mar 18 '19 at 02:35

0 Answers0