擅长:python、mysql、java
<p>如果您想要一个简单的代码,此代码适用于您:</p>
<pre><code>a_lines = open('FileA', 'r').readlines()[1:]
b_lines = open('FileB', 'r').readlines()[1:]
file_result = open('result', 'w')
# Read content of FileA to a table (list of lists)
a_table = []
for l in a_lines:
a_table.append([w.strip() for w in l.split(',')])
# Read content of FileB in a dictionary.
# The 'id' field as dictionary key for simple look-up.
b_dict = {}
for l in b_lines:
words = l.split(',')
b_dict[words[1].strip()] = words[0].strip()
# Do the actual work and save result.
for row in a_table:
if row[0] in b_dict:
file_result.write(b_dict[row[0]] + ',' + row[0] + ',')
file_result.write(row[2] + '\n')
</code></pre>
<p>我用你的样品测试了一下。你知道吗</p>