dataframe 查找的isin()用法

import pandas as pd

df = pd.read_excel('分类标准-新.xlsx')

#list0=[7662,7667,7672,7677,7682,7688,7693,7698,7704,7662,7709,7714,7719,7725,7730,7735,7741,7709,7746,7751,7756,7762,7767,7772,7778,7746,7783,7783]
list0=[7664,7669,7674,7679,7684,7690,7695,7700,7706,7664,7711,7716,7721,7727,7732,7737,7743,7711,7748,7753,7758,7764,7769,7774,7780,7748,5047,5047]
a = df[(df['元素编码'].isin(list0))].index.tolist()

result=[]
for x in list0:

    a = df[(df['元素编码']==x)].index.tolist()
    print (a[0])
    result.append(a[0])


df.ix[result]['章节/元素名称'].tolist()
df.ix[result]['元素名'].tolist()


----
#is_in

a = df[(df['元素编码'].isin(list0))].index.tolist()