<p>如果我正确理解您的问题,您需要阅读2个输入文件:</p>
<ul>
<li><p>1包含您要查找的用户ID</p></li>
<li><p>2包含与用户相关的项目数据</p></li>
</ul>
<p>以这种方式,类似这样的东西会在文件2中找到您在1中指定的所有用户,并将它们写出来结果.csv你知道吗</p>
<blockquote>
<p>Sepicify your search IDs in search_for.csv. Keep in mind that this
will revrite your result.csv every time you run it.</p>
</blockquote>
<pre><code>import csv
import sys
import os
inputPatterns = open(os.curdir + '/search_for.csv', 'rt')
# Reader for the IDs (users) you are looking to find (key)
reader = csv.reader(inputPatterns)
ids = []
# reading the IDs you are looking for from search_for.csv
for row in reader:
ids.append(row[0])
inputPatterns.close()
# Let's see if any of the user IDs we are looking for has any project related info
# if so write them to your output CSV
for userID in ids:
# Organization list with names and Company ID and reader
userList = open(os.curdir + '/users.csv', 'rt')
reader = csv.reader(userList)
# This will be the output file
result_f = open(os.curdir + "/" + userID + ".csv", 'w')
w = csv.writer(result_f)
# Writing header information
w.writerow(['Date', 'Prj1_Assigned', 'Prj1_closed', 'Prj2_assigned', 'Prj2_solved'])
# Scanning for projects for user and appending them
for row in reader:
if userID == row[1]:
w.writerow([row[3], row[4], row[5], row[6], row[7]])
result_f.close()
userList.close()
</code></pre>
<p>例如,<strong>搜索_对于.csv</strong>看起来像这样</p>
<p><a href="https://i.stack.imgur.com/IWRWF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IWRWF.png" alt="if your search_for.csv looks like this"/></a></p>