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

Question

I created a data frame using the following line:

df = pd.read_csv('/Users/cs213/Desktop/class1.csv', sep = ',', error_bad_lines=False)

and if print the columns as such

print (df.columns)

I get

Index(['Text', 'label'], dtype='object')

But if I wanted to use the columns as in here

df = df[df.Text.apply(lambda x: x.isnumeric())]
df = df[df.Text.apply(lambda x: x !="")]
df = df[df.label.apply(lambda x: x !="")]

I get the following error:

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

I have already tried the solution in here: Data-frame Object has no Attribute and it did not work.

Sample of the CSV file

Here is the output of df.head()

Looks like if a column is named 'labels', df.labels returns the error: AttributeError: 'DataFrame' object has no attribute 'labels' but df['labels'] works perfectly fine. — Anant Gupta
– Anant Gupta, Commented Sep 19, 2019 at 13:09

pissall · Accepted Answer · 2018-04-30 12:17:41Z

2

EDIT 1:

Reproducible sample of your CSV :

df = pd.DataFrame({'Text': [u'Well I am', u"Not my scene", u"Brutal"], 'label': ['y', 'n', 'n']})

The function you are trying to run:

>>> df = pd.DataFrame({'Text': [u'Well I am', u"Not my scene", u"Brutal"], 'label': ['y', 'n', 'n']})
>>> df
           Text label
0     Well I am     y
1  Not my scene     n
2        Brutal     n
>>> df = df[df['Text'].apply(lambda x: x.isnumeric())]
>>> df
Empty DataFrame
Columns: [Text, label]
Index: []

Of course there will be no attribute 'label'

So what's happening is that, all x.isnumeric() calls return False, and hence none of the data is saved to df. What you are trying to do with df = df[df['Text'].apply(lambda x: x.isnumeric())] is that "In df, what are the rows in which 'Text' is numeric." (Now this returns False). None of the rows are numeric, so you get an empty dataframe.

edited Apr 30, 2018 at 12:17

answered Apr 30, 2018 at 11:52

pissall

7,4442 gold badges29 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Wanderer Over a year ago

I am still getting an error, KeyError: 'Text', KeyError: 'Text', KeyError: 'label'

pissall Over a year ago

Show the output of your df.head()

Wanderer Over a year ago

I added it to the post

Wanderer Over a year ago

Sorry but I don't get it, what's wrong? thanks in advance

pissall Over a year ago

Updated @user7631183

Collectives™ on Stack Overflow

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

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related