<p>通过使用<code>usecols</code>参数<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html" rel="nofollow noreferrer">see the Documentation.</a>调用<code>read_csv()</code>,只能加载选定的列</p>
<pre><code># this would load only column 0, 1, and 2
# you can use column names too: ['col0', 'col1', 'col2']
dummy_example = pandas.read_csv('path_to/your_file.csv', usecols=[0, 1, 2])
</code></pre>
<p>然而,在你的情况下,我会在没有<code>pandas</code>的情况下做这件事</p>
<pre><code>input_file = 'path_to/input_file.txt'
output_file = 'path_to/output_file.csv'
# open both files, output in "append" mode
with open(input_file, 'r') as file, open(output_file, 'a+') as out_file:
for line in file.readlines():
try:
# split at 'Group'
line = line.split('Group')[1]
# split and select after Group name
line = line.split()[1:]
except:
# no 'Group' or no data thereafter
# skip to the next loop
continue
# create name-id pairs
name_id = list(zip(line[2::2], line[1::2]))
for tup in name_id:
# make comma separated string
string = ','.join(tup) + '\n'
# append to the outfile
out_file.write(string)
</code></pre>
<p>输出文件</p>
<pre><code>Pradeep,e34
Venkat,e44
Azhar,r45
Pavan,e14
Vipul,e24
Asad,r15
Kumar,e45
Akshay,e55
Vivek,e44
Pradeep,e34
Venkat,e44
Azhar,r45
Pavan,e14
Vipul,e24
Asad,r15
Kumar,e45
Akshay,e55
Vivek,e44
</code></pre>