AttributeError: 'DataFrame' object has no attribute

Question

I keep getting different attribute errors when trying to run this file in ipython...beginner with pandas so maybe I'm missing something

Code:

from pandas import Series, DataFrame  import pandas as pd  import json  nan=float('NaN') data = [] with open('file.json') as f: for line in f:     data.append(json.loads(line))  df = DataFrame(data, columns=['accepted', 'user', 'object', 'response']) clean = df.replace('NULL', nan) clean = clean.dropna()  print clean.value_counts()   AttributeError: 'DataFrame' object has no attribute 'value_counts' 

Any ideas?

Answer 1

value_counts is a Series method rather than a DataFrame method (and you are trying to use it on a DataFrame, clean). You need to perform this on a specific column:

clean[column_name].value_counts() 

It doesn't usually make sense to perform value_counts on a DataFrame, though I suppose you could apply it to every entry by flattening the underlying values array:

pd.value_counts(df.values.flatten()) 

Answer 2

To get all the counts for all the columns in a dataframe, it's just df.count()