python - 通过将条件设置为变量来循环 df.query

Question

所以我有多个条件，我想每次都使用循环来查询它们，这样我就可以过滤数据。所以基本上我想：

metric = ["case1", "case2"] #etc 
df = df.query('Metric == metric[i]')

#instead of-->

df = df.query('Metric == "case1"')
df = df.query('Metric == "case2"')

metric = ["case1", "case2"] etc 
df = df.query('Metric == metric[i]')
#I will loop back around instead of doing them individually

df = df.query('Metric == "case1"')

df = df.query('Metric == "case2"')

标签： pythonpandas

Answer 1

你可以做

df.query('Symbol==@metric[0]')