AttributeError: 'DataFrame' object has no attribute


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


from pandas import Series, DataFrame

import pandas as pd

import json

data = []
with open('file.json') as f:
for line in f:

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?

This question is tagged with python pandas attributeerror

~ Asked on 2013-10-15 22:32:13

The Best Answer is


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:


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:


~ Answered on 2013-10-16 00:29:39


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

~ Answered on 2015-04-29 00:02:24

Most Viewed Questions: