擅长:python、mysql、java
<p>首先,我将输入列用逗号分隔,以便更容易处理表单:</p>
<pre><code>ID,ACT1,ACT2,ACT3,ACT4
1,154438.0,154104.0,155321.0,155321.0
2,154042.0,154073.0,154104.0,154104.0
</code></pre>
<p>然后可以使用CSV读取器读取每一行,提取以列名为键的键、值对。然后你从字典中弹出ID,得到它的值,比如1,2,等等,然后你可以根据日期的值重新排序。代码如下:</p>
<pre><code>#!/usr/bin/env python3
import csv
from operator import itemgetter
idAndTuple = {}
with open('time.txt') as csvfile:
reader = csv.DictReader(csvfile)
for row in reader:
myID = row.pop('ID',None)
reorderedList = sorted(row.items(), key = itemgetter(1))
idAndTuple[myID] = reorderedList
print( myID, reorderedList )
</code></pre>
<p>运行时的结果是:</p>
<pre><code>1 [('ACT2', '154104.0'), ('ACT1', '154438.0'), ('ACT3', '155321.0'), ('ACT4', '155321.0')]
2 [('ACT1', '154042.0'), ('ACT2', '154073.0'), ('ACT3', '154104.0'), ('ACT4', '154104.0')]
</code></pre>
<p>我想这就是你要找的。你知道吗</p>