Why wont this code drop a row based on the column value
dete_date = dete_data[dete_data.dete_start_date != 'Not Stated']
the rows with 'Not stated' in the dete_start_date column still exist after running code
Asked
Active
Viewed 83 times
0
RavinderSingh13
- 117,272
- 11
- 49
- 86
Muhuri.JSON
- 117
- 11
-
1Does this answer your question? [Deleting DataFrame row in Pandas based on column value](https://stackoverflow.com/questions/18172851/deleting-dataframe-row-in-pandas-based-on-column-value) – tbhaxor Dec 19 '19 at 06:21
-
1```dete_date = dete_data.loc[dete_data.dete_start_date != 'Not Stated']``` but are you sure 'Not stated' is exactly the way it's phrased (without extra spaces, case sensitive etc) – Grzegorz Skibinski Dec 19 '19 at 06:22
-
'Not stated' or 'Not Stated' ? – J. Doe Dec 19 '19 at 06:22
-
using .loc worked – Muhuri.JSON Dec 19 '19 at 06:30
-
https://stackoverflow.com/questions/19071199/drop-columns-whose-name-contains-a-specific-string-from-pandas-dataframe – Oksana Ok Dec 19 '19 at 07:46