擅长:python、mysql、java
<p>这对我有用:</p>
<pre><code>import numpy as np
import collections
data = np.genfromtxt("values.csv",delimiter=' ',skip_header=1,dtype=None)
dataDict = {}
for i,dat in enumerate(data):
dataDict[dat[10]]=[dat[2],dat[9]]
orderedDict = collections.OrderedDict(sorted(dataDict.items()))
fp = open("outResult.csv",'wb')
fp.write(" \tA05\tA01\tB01\n")
fp.write("Time(S)\tAbs\tAbs\tAbs\n")
print " \tA05\tA01\tB01"
print "Time(S)\tAbs\tAbs\tAbs"
for key in orderedDict.keys():
str1 = ''
str2 = ''
str3 = ''
if orderedDict[key][0] == 'A01':
str1 = orderedDict[key][1]
str2 = ' '
str3 = ' '
elif orderedDict[key][0] == 'A05':
str1 = ' '
str2 = orderedDict[key][1]
str3 = ' '
else:
str1 = ' '
str2 = ' '
str3 = orderedDict[key][1]
fp.write("%.02f\t%s\t%s\t%s\n"%(key,str1,str2,str3))
print "%.02f\t%s\t%s\t%s"%(key,str1,str2,str3)
fp.close()
</code></pre>