AttributeError: 'float' object has no attribute 'split'

Question

I am calling this line:

lang_modifiers = [keyw.strip() for keyw in row["language_modifiers"].split("|") if not isinstance(row["language_modifiers"], float)]

This seems to work where row["language_modifiers"] is a word (atlas method, central), but not when it comes up as nan.

I thought my if not isinstance(row["language_modifiers"], float) could catch the time when things come up as nan but not the case.

Background: row["language_modifiers"] is a cell in a tsv file, and comes up as nan when that cell was empty in the tsv being parsed.

Why has this been downvoted? Just so I know. You can test on the 3 test cases I include in the question. — Dhruv Ghulati
– Dhruv Ghulati, Commented Feb 14, 2017 at 15:20

Mooncrater · Accepted Answer · 2018-10-31 11:04:04Z

55

You are right, such errors mostly caused by NaN representing empty cells. It is common to filter out such data, before applying your further operations, using this idiom on your dataframe df:

df_new = df[df['ColumnName'].notnull()]

Alternatively, it may be more handy to use fillna() method to impute (to replace) null values with something default. E.g. all null or NaN's can be replaced with the average value for its column

housing['LotArea'] = housing['LotArea'].fillna(housing.mean()['LotArea'])

or can be replaced with a value like empty string "" or another default value

housing['GarageCond']=housing['GarageCond'].fillna("")

edited Oct 31, 2018 at 11:04

Mooncrater

4,9618 gold badges42 silver badges71 bronze badges

answered Mar 13, 2017 at 18:08

Ozgur Ozturk

1,33311 silver badges12 bronze badges

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

Comments

AS Mackay · Accepted Answer · 2019-03-16 17:30:15Z

5

You might also use df = df.dropna(thresh=n) where n is the tolerance. Meaning, it requires n Non-NA values to not drop the row

Mind you, this approach will remove the row

For example: If you have a dataframe with 5 columns, df.dropna(thresh=5) would drop any row that does not have 5 valid, or non-Na values.

In your case you might only want to keep valid rows; if so, you can set the threshold to the number of columns you have.

pandas documentation on dropna

edited Mar 16, 2019 at 17:30

AS Mackay

2,8559 gold badges21 silver badges27 bronze badges

answered Mar 16, 2019 at 17:05

hpl002

6196 silver badges7 bronze badges

Collectives™ on Stack Overflow

AttributeError: 'float' object has no attribute 'split'

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related