remove rows that are empty from column type object pandas

Asked Nov 04 '21 at 07:06

Active Nov 04 '21 at 07:06

Viewed 25 times

I want to remove some blank rows from my dataframe. Since it is an object column, i convert it to string column

reviewsCleanDF['clean_review'] = reviewsCleanDF['clean_review'].astype(str)

which doesn't convert at all.

My idea was to convert it to string column and use

reviewsCleanDF.replace("", np.nan, inplace=True)
reviewsCleanDF.dropna(subset = ["clean_review"], inplace=True)
reviewsCleanDF.reset_index(drop=True)

As you can see, at index 607323, it is blank.

Is there any way to remove it?

asked Nov 04 '21 at 07:06

kittyKat

Can you try `reviewsCleanDF.replace(r'^\s*$, np.nan, inplace=True)` ? – jezrael Nov 04 '21 at 07:09
1

check [this](https://stackoverflow.com/a/21942746/2901002) for solution. – jezrael Nov 04 '21 at 07:10
@jezrael hi i tried your method and i got "EOL while scanning string literal" error – kittyKat Nov 04 '21 at 09:50
sorry, need `r'^\s*$'` – jezrael Nov 04 '21 at 09:51
1

I check your link and put "df.replace(r'^\s+$', np.nan, regex=True)" It finally solve. Thank you! – kittyKat Nov 04 '21 at 09:53

0 Answers0