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?