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

User · Answer

value counts work only for series  It won t work for entire DataFrame  Try selecting only one column and using this attribute  For example   df  accepted   value counts     It also won t work if you have duplicate columns  This is because when you select a particular column  it will also represent the duplicate column and will return dataframe instead of series  At that time remove duplicate column by using   df   df loc    df columns duplicated    df  accepted   value counts

User · Answer

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

User · Answer

value counts   is now a DataFrame method since pandas 1 1 0 https   pandas pydata org pandas-docs stable reference api pandas DataFrame value counts html

User · Answer

To get all the counts for all the columns in a dataframe  it s just df count

[python] AttributeError: 'DataFrame' object has no attribute

Examples related to python

Examples related to pandas

Examples related to attributeerror