Filter columns of the dataframe with specific string

Asked Jul 12 '20 at 06:35

Active Jul 12 '20 at 06:50

Viewed 61 times

I need to filter data of the columns according to string values, for example, I only need the columns that contain: ['CEMENTO MELON', 'G_CTRL_TE_DIEGO_DE_ALMAGRO','G_CTRL_EO_CANELA_2']

todos = []
for f in glob.glob('*.xlsx'):
    #Here must go the code
    todos.append(df)

I would greatly appreciate your help.

edited Jul 12 '20 at 06:50

asked Jul 12 '20 at 06:35

Luis Fernando Silva

try this, ```df[['CEMENTO MELON', 'G_CTRL_TE_DIEGO_DE_ALMAGRO','G_CTRL_EO_CANELA_2']]``` – sushanth Jul 12 '20 at 06:37
Here is another dupe, https://stackoverflow.com/a/11287278/4985099 – sushanth Jul 12 '20 at 06:39

Filter columns of the dataframe with specific string

0 Answers0