<commit_before># 환불 필드 E4부터 E10까지 +2

from openpyxl import load_workbook

wb = load_workbook('../datas/daily_gabia_20171127.xlsx')
ws = wb.active

ws['E4:E10'.value] =+ 2

wb.save('../datas/jya-edit.xlsx')<commit_msg>homework_1210<commit_after># 환불 필드 E4부터 E10까지 +2

from openpyxl import load_workbook

wb = load_workbook('../datas/daily_gabia_20171127.xlsx')
ws = wb.active

def edit(a):
    return  a + 2


c1 = ws['E4']
d = c1.value
k = edit(d)
ws['E4'] = k

c2 = ws['E5']
d = c2.value
k = edit(d)
ws['E5'] = k

c3 = ws['E6']
d = c3.value
k = edit(d)
ws['E6'] = k

c4 = ws['E7']
d = c4.value
k = edit(d)
ws['E7'] = k

c5 = ws['E8']
d = c5.value
k = edit(d)
ws['E8'] = k

c6 = ws['E9']
d = c6.value
k = edit(d)
ws['E9'] = k

c7 = ws['E10']
d = c7.value
k = edit(d)
ws['E10'] = k

##A = ws['E4':'E10']
#for t in A:
#    for c in t:
#        d = c.value
#        t = edit(d)
#        for i in range (0, 7):
#            A[i] = t

wb.save('../datas/daily_gabia_20171127_edit.xlsx')
{'fraction_non_alphanumeric': 0.20612244897959184, 'fraction_numerical': 0.07755102040816327, 'mean_word_length': 2.9556451612903225, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4873187', 'n_tokens_mistral': 548, 'n_tokens_neox': 526, 'n_words': 114}