python - Python pandas过滤多列

Question

如果我有一堆标题，我知道我们可以使用 df.filter(regex = 'header') 来获取特定列。如果我有多个“标题”要过滤，例如，我的列如下所示，我想选择任何包含“2018-08-19”和“频率”的列，正则表达式似乎不适用于过滤两个字。

Index(['Frequency(Hz)', '2018-08-19 00:00:00Exhaust5BA-1A361nan',
       '2018-08-19 00:00:00Exhaust5BA-1A363nan',
       '2018-08-19 00:00:00Exhaust5BA-1A365nan',
       '2018-08-19 00:00:00Exhaust5BA-1A367nan',
       '2018-08-19 00:00:00Exhaust5BA-1A462nan',
       '2018-08-19 00:00:00Exhaust5BA-1A464nan',
       '2018-08-19 00:00:00Exhaust5BA-1A466nan', 'nannannannannan',
       'DateMachineSideGangheadSpindle Number',
       '12-01-2020MOD3Intake5BA-1A#351', '12-01-2020MOD3Intake5BA-1A#353 ',
       '12-01-2020MOD3Intake5BA-1A#355 ', '12-01-2020MOD3Intake5BA-1A#357 ',
       '12-01-2020MOD3Intake5BA-1A#452', '12-01-2020MOD3Intake5BA-1A#454',
       '12-01-2020MOD3Intake5BA-1A#456', '12-01-2020MOD3Intake5BA-1A#458',
       '12-01-2020MOD3Intake5BA-1B#351'],
      dtype='object')

标签： pythonpandas