pandas 按照列值进行模糊查询 

N09_P1 = dfResults.loc[dfResults['des'].isin(['0027-P1'])] #绝对查询

found = dfResults.loc[dfResults['des'].str.contains('0027-P1')]#模糊查询

 

多条件级联查询

 

N30_0032_P1 = dfResults.loc[dfResults['des'].str.contains('0877-P1') | dfResults['des'].str.contains('0032-P1')]
N30_0032_P2 = dfResults.loc[dfResults['des'].str.contains('0877-P2') | dfResults['des'].str.contains('0032-P2')]
N30_0032_P3 = dfResults.loc[dfResults['des'].str.contains('0877-P3') | dfResults['des'].str.contains('0032-P3')]
N30_0032_P4 = dfResults.loc[dfResults['des'].str.contains('0877-P4') | dfResults['des'].str.contains('0032-P4')]
posted @ 2021-05-31 20:54  bH1pJ  阅读(365)  评论(0)  编辑  收藏  举报