pandas全表查询定位某个值所在行列的方法
时间：2020-10-01 15:47:02|栏目：Python代码|点击： 次
如下所示：
# create a dataframe with an integer feature and a categorical string feature
demo_df = pd.DataFrame({'Integer Feature': [0, 1, 2, 1], 'Categorical Feature': ['socks', 'fox', 'socks', 'box']})
demo_df
接下来用for遍历：
for indexs in demo_df.index:
for i in range(len(demo_df.loc[indexs].values)):
if(demo_df.loc[indexs].values[i] =='fox'):
print(indexs,i)
print(demo_df.loc[indexs].values[i])
或者用列表推导式：
Categorical FeatureInteger Feature0socks01fox12socks23box1 [ (indexs,i) for indexs in demo_df.index for i in range(len(demo_df.loc[indexs].values)) if(demo_df.loc[indexs].values[i] =='fox')]
