擅长:python、mysql、java
<pre><code>import re
from collections import defaultdict
def sum_months(data_path):
with open (data_path, 'r') as f:
rows = f.readlines()
sumdict = defaultdict(int)
for row in rows:
month = re.findall("/\d{2}/\d{4}", row)[0]
sum = re.findall("\d+$", row)[0]
sumdict[month] += eval(sum)
return sumdict
def pad_strings_and_create_rows(sumdict):
rows = []
for k, v in sumdict.iteritems():
rows.append('01' + k + ' - ' + '30' + k + ' ' + str(v))
return list(sorted(rows))
def write_result_to_file(results_lst):
with open('reslt.txt', 'a') as f:
for row in results_lst:
f.write(row + '\n')
write_result_to_file(pad_strings_and_create_rows(sum_months('data.txt')))
</code></pre>