Signup/Sign In
Ask Question
Not satisfied by the Answer? Still looking for a better solution?

Dropna not working

Hi guys,

I am extracting tables using Pandas and want to get rid of empty rows in the dataframe. One of the tables looks like this:
 Instrument           Price           Order Date   Type Lots  Gap   Duration Note
0 nnNZD/USDnn nnSelln0.73250 Sep 27, 2016 7:17pm Limit 41 189 weeks
1
2
3 nnGBP/CHFnn nnSelln1.32000 Sep 1, 2016 11:33am Limit 595 193 weeks
4
5

so to delete empty rows I use in code:
1
df.dropna(axis = 0, how = 'all', inplace=True)


Unfortunately does not work!

Any ideas please?
by

1 Answer

vishaljlf39
Your data frame probably filled with empty strings not nan values.

Login / Signup to Answer the Question.