在行pandas python上使用部分字符串匹配返回DataFrame项目[重复]

尝试这个：

df[df['RSD_TYPE'].str.contains("AQ5")]['FILTER LIST']

例：

In [3]: dfOut[3]:   RSD_TYPE          FILTER LIST0     AQ500          [N/A, Z mean, SNR mean, Dir mean]1    Triton  [wipe mean, Z mean, Avail mean, Dir mean]2  Windcube [N/A, W mean, Q mean, Dir mean]3    Zephir     [Rain mean, W mean, Packets, dir mean][4 rows x 2 columns]

In [4]: df[df['RSD_TYPE'].str.contains("AQ5")]Out[4]:  RSD_TYPE  FILTER LIST0    AQ500  [N/A, Z mean, SNR mean, Dir mean][1 rows x 2 columns]

In [5]: df[df['RSD_TYPE'].str.contains("AQ5")]['FILTER LIST']Out[5]:0    [N/A, Z mean, SNR mean, Dir mean]Name: FILTER LIST, dtype: object