擅长:python、mysql、java
<p>假设你的数据和你的样本是一致的:有序的,5行,第6行是空的。。。在</p>
<pre><code>#!/usr/bin/env python
# -*- coding: utf-8 -*-
def partition(l, n):
def _part():
for i in xrange(0, len(l), n):
yield l[i:i+n]
return [i for i in _part()]
def loadData():
with open('data.dat') as f:
return [row.split(': ') for row in f.read().splitlines() if row ]
data = partition(loadData(), 5)
headers = [[h[0] for h in data[0]]]
columns = [[col[1] for col in row] for row in data]
_data = headers + columns
print "\n".join(",".join(row) for row in _data)
</code></pre>
<p>结果:</p>
^{pr2}$