擅长:python、mysql、java
<p>为了按节格式化数据,可能最简单的方法是对数据段进行如下处理</p>
<pre><code>keys =['(Lag)=(\d+\.?\d*)',
'(Autocorrelation Index): (\d+\.?\d*)',
'(Semivariance): (\d+\.?\d*)']
import re
string1 = ''.join(open("dummy.txt").readlines())
sections = string1.split('Spatial Statistics')
output = []
heads = []
for isec, sec in enumerate(sections):
found = []
output.append([])
for key in keys:
found.extend(re.findall(key, sec))
for result in found:
print '%s = %s' % (result[0],result[1])
output[-1].append(result[1])
if len(found) > 0 & len(heads) == 0:
heads = [result[0] for result in found]
fout = open('output.csv', 'w')
wrt = csv.writer(fout)
wrt.writerow(heads)
wrt.writerows(outputs)
fout.close()
</code></pre>