It seems fairly straightforward using python's CSV reader.
data.csv
a,54.2
s,78.5
k,89.62
a,77.2
a,65.56
script.py
import csv
result = {}
with open('data.csv', 'rb') as csvfile:
csvreader = csv.reader(csvfile, delimiter=',', quotechar='"')
for row in csvreader:
if row[0] in result:
result[row[0]].append(row[1])
else:
result[row[0]] = [row[1]]
print result
output
{
'a': ['54.2', '77.2', '65.56'],
's': ['78.5'],
'k': ['89.62']
}
As @Pete poined out, you can beautify it using defaultdict:
script.py
import csv
from collections import defaultdict
result = defaultdict(list) # each entry of the dict is, by default, an empty list
with open('data.csv', 'rb') as csvfile:
csvreader = csv.reader(csvfile, delimiter=',', quotechar='"')
for row in csvreader:
result[row[0]].append(row[1])
print result
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…