python : How to delete the column which contains specific word or string like 'No data' i.e. removing columns which has any specific string

Asked Nov 30 '21 at 06:46

Active Nov 30 '21 at 06:50

Viewed 301 times

  Rat Rat 1 Rat 2
0 jkl No    jkl
1 ghj No    jkhj
2 mmm No    jkl
3 klj No    oo
4 kkk No    jkk

I want to remove the column which has string 'No' and the output should have only rows Rat and Rat 2

edited Nov 30 '21 at 06:50

asked Nov 30 '21 at 06:46

Rocky

1

how did you create these columns? are they read from `csv`? using some external library like `pandas`? – chickity china chinese chicken Nov 30 '21 at 06:53
Does this answer your question? [Drop columns if rows contain a specific value in Pandas](https://stackoverflow.com/questions/56754831/drop-columns-if-rows-contain-a-specific-value-in-pandas) – Bhagyesh Dudhediya Nov 30 '21 at 07:00
Possibly an answer can be derived from [Delete a column from a Pandas DataFrame](https://stackoverflow.com/questions/13411544/delete-a-column-from-a-pandas-dataframe), – chickity china chinese chicken Nov 30 '21 at 07:02

0 Answers0