def read_length_log():
if __name__ == '__main__':
datas = stat_util.get_list_from_csv(INPUT_PATH)
fix_row_data(datas)
sheet_datas = convert_rowdata_to_dict(datas)
#sheet_datas = stat_util.sort_dict_by_key(sheet_datas)
wb = create_xlsx_from_dict(sheet_datas)
wb.save('Data.xlsx')
new_data[j] += int(d[j])
week_datas[key] = new_data
#print week_datas
for key in sorted(week_datas.keys()):
week_num = 'Week ' + str(key)
data = week_datas.get(key)
values = []
values.append(week_num)
for i in SHEET_INDEX:
if i == SHEET_INDEX[0]:
values.append(int(data[i]))
elif i == SHEET_INDEX[2] or i == SHEET_INDEX[3] or i == SHEET_INDEX[4] or i == SHEET_INDEX[6]:
values.append(int(data[i]))
elif i > SHEET_INDEX[0]:
values.append('%.4f' % ( int(data[i]) * 1.0 / int(data[SHEET_INDEX[0]]) ))
else:
#values.append(data[i] / 7)
values.append(data[i])
#print values
for col_idx , value in enumerate(values):
cell = ws.cell(row = row_idx, column = col_idx)
cell.value = value
row_idx += 1
if __name__ == '__main__':
datas = stat_util.get_list_from_csv(INPUT_PATH)
fix_row_data(datas)
sheet_datas = convert_rowdata_to_dict(datas)
#sheet_datas = stat_util.sort_dict_by_key(sheet_datas)
wb = create_xlsx_from_dict(sheet_datas)
wb.save('Data.xlsx')
