熊猫:如何通过选择列的范围来筛选行?

你可以这样做:

df[df.ix[:,2:7].eq(1).any(axis=1)].ix[:,2:7] 

输出(由于所有0而缺少行1):

   c2  c3  c4  c5  c6
0   1   1   0   0   0
2   0   0   1   0   1

要显示所有列:

df[df.ix[:,2:7].eq(1).any(axis=1)] 

输出:

   name  c1  c2  c3  c4  c5  c6  c7  c8
0  img1   0   1   1   0   0   0   1   0
2  img3   1   0   0   1   0   1   0   0

# test data
from io import StringIO
data = StringIO('''name,c1,c2,c3,c4,c5,c6,c7,c8
img1,0,1,1,0,0,0,1,0
img2,1,0,0,0,0,0,1,1
img3,1,0,0,1,0,1,0,0''')

import pandas as pd
df = pd.read_csv(data)


# list of columns to be used

# select using column name
# cols = ['c{}'.format(i) for i in range(2,7)]

# select using column number
cols = df.columns[2:7]

# select if any col is 1
df = df[(df[cols]==1).any(axis=1)]



print(df)

   name  c1  c2  c3  c4  c5  c6  c7  c8
0  img1   0   1   1   0   0   0   1   0
2  img3   1   0   0   1   0   1   0   0