擅长:python、mysql、java
<p>data.csv:</p>
<pre><code>Name col1 col2 col3 col6 col7 col8 col9
John 0 23 0 1 4 1 23
victor 1 4 5 2 1 4 15
Alida 1 1 2 6 0 2 2
Natalie 0 1 1 4 2 3 4
Morman 3 3 1 0 5 2 1
</code></pre>
<p>代码:</p>
<pre><code>import pandas as pd
df = pd.read_csv('data.csv', delimiter=' ')
df = df.set_index('Name')
print(df, '\n')
for index, row in df.iterrows():
print(index, row[row >= 4].index[0])
</code></pre>
<p>输出:</p>
<pre><code> col1 col2 col3 col6 col7 col8 col9
Name
John 0 23 0 1 4 1 23
victor 1 4 5 2 1 4 15
Alida 1 1 2 6 0 2 2
Natalie 0 1 1 4 2 3 4
Morman 3 3 1 0 5 2 1
John col2
victor col2
Alida col6
Natalie col6
Morman col7
</code></pre>