How to count frequency of values across the entire dataframe

Question

hello I have the following dataset: I want to count the frequency of each value occuring across the entire dataset. I am aware of the value_count() which is works only on columns but not for the entire dataset. I used the following code:

df.value_counts()

But it results in an error:

AttributeError: 'DataFrame' object has no attribute 'value_counts'

Please could you help me count the frequency of values across the whole dataset?

**Please provide a [mcve], as well as the entire error message.** Also, please do not share information as images unless absolutely necessary. See: https://meta.stackoverflow.com/questions/303812/discourage-screenshots-of-code-and-or-errors, https://idownvotedbecau.se/imageofcode, https://idownvotedbecau.se/imageofanexception/. — AMC, May 03 '20 at 01:28

score 7 · Accepted Answer · answered May 02 '20 at 20:16

7

You can use the stack function to stack all values in one column, and then use value_counts:

df.stack().value_counts()

answered May 02 '20 at 20:16

Daniel Geffen

1,777
1
11
16

1

nice one, I'dd add in `pd.melt(df)['value'].value_counts()` as well – Umar.H May 02 '20 at 20:19
could you tell me what is the difference between melt and stack? – tulock May 02 '20 at 20:20
[This](https://www.youtube.com/watch?v=kJsiiPK5sxs) video explains it pretty well @tulock – Umar.H May 02 '20 at 20:29

How to count frequency of values across the entire dataframe

1 Answers1