Converting column values to rows

Question

I have a dataset where all values in column B are the same. It looks like this:

        A               B
0  Marble Hill     Pizza Place
1  Chinatown       Pizza Place
2  Washington      Pizza Place
3  Washington      Pizza Place
4  Inwood          Pizza Place
5  Inwood          Pizza Place

I wish to convert column A values to rows. Then column B should count the number occurrences of each value from A.
I want it to look like this:

                B
Marble Hill     1   
Chinatown       1
Washington      2
Inwood          2

Can you show what code you've already written/tried? – Anshika Singh Jul 13 '20 at 18:47 — Anshika Singh, Jul 13 '20 at 18:47

score 2 · Answer 1 · answered Jul 13 '20 at 18:51

2

pandas's value_counts() does exactly that. It returns a series with the number of occurrences of each value.

new_df = df["A"].value_counts()

answered Jul 13 '20 at 18:51

Roim

2,986
2
10
25

score 2 · Answer 2 · edited Jul 13 '20 at 20:04

2

Based on the way you are describing your data, it looks like you have a Pandas dataframe.
If that is the case then you can use the value_counts method on column A to get the result you want.
Assuming your dataframe is stored in the variable name df, then...

df['A'].value_counts()

edited Jul 13 '20 at 20:04

SherylHohman

16,580
17
88
94

answered Jul 13 '20 at 18:52

Worley

41
3

Converting column values to rows

2 Answers2