Python Pandas DataFrame remove Empty Cells

I have a pd.DataFrame that was created by parsing some excel spreadsheets. A column of which has empty cells. For example, below is the output for the frequency of that column, 32320 records have missing values for Tenant.

   In [67]: value_counts(Tenant,normalize=False)
   Out[67]:
                              32320
   Thunderhead                8170
   Big Data Others            5700
   Cloud Cruiser              5700
   Partnerpedia               5700
   Comcast                    5700
   SDP                        5700
   Agora                      5700
   dtype: int64

I am trying to drop rows where Tenant is missing, however isnull option does not recognize the missing values.

   In [71]: df['Tenant'].isnull().sum()
   Out[71]: 0

The column has data type “Object”. What is happening in this case ? How can I drop records where Tenant is missing?


Download python.pandas.dataframe.remove.empty.cells.zip
Direct Link


Download


Download python.pandas.dataframe.remove.empty.cells.zip
Mediafire


Download


Download python.pandas.dataframe.remove.empty.cells.zip
Sharebeast


Download


Download python.pandas.dataframe.remove.empty.cells.zip
Uploadsat


Download


Download python.pandas.dataframe.remove.empty.cells.zip
Ryushare


Download