<p>工作样品</p>
<pre><code>N11,12,123,123,0
N21,12,133,123,0
N12,12,143,123,0
N32,12,125,123,0
N11,12,121,123,0
N12,12,121,123,0
N11,12,122,123,0
N21,12,127,123,0
N32,12,183,123,0
N14,12,193,123,0
</code></pre>
<p>假设</p>
<ul>
<li>如果第一列只有一个值,它将被设置为max和min</li>
</ul>
<p>代码,注释和解释</p>
<pre><code>import csv
# Collect the pairs in a dict of lists where the first value is the minimum
# and the second the max
min_max = dict()
with open('example.csv') as csvfile:
readCSV = csv.reader(csvfile, delimiter=',')
for row in readCSV:
# Check if the value already exists in the dict
row_val = min_max.get(row[0])
if row_val is not None:
row_min = min_max[row[0]][0] # Get the min
row_max = min_max[row[0]][1] # Get the max
# Check against current value
min_max[row[0]][0] = min(row[2], row_min)
min_max[row[0]][1] = max(row[2], row_max)
else:
# If it doesn't exist update the dict
min_max[row[0]] = [row[2], row[2]]
print(min_max)
</code></pre>
<p>输出</p>
<pre><code>{'N11': ['121', '123'], 'N21': ['127', '133'], 'N12': ['121', '143'], 'N32': ['125', '183'], 'N14': ['193', '193']}
</code></pre>