tb4.to_csv('закупки.csv', index=False) # # доходы Д62К90 tb5 = pd.pivot_table( dp4, values=['sum'], index=['cD1', 'cD2', 'cK1', 'god', 'mes'], aggfunc={'sum': sum}, ) tb5.reset_index(inplace=True) tb5 = tb5.fillna(0) tb5.to_csv('выручка.csv', index=False) # Выгрузка сделанных анализов в РД x = GetObject(None, "Excel.Application") wb = x.Workbooks("TestPrAn.xlsx") ws = wb.Worksheets("аморт") StartRow = 6 StartCol = 1 ws.Range( ws.Cells(StartRow, StartCol), ws.Cells(StartRow + len(tb2.index) - 1, StartCol + len(tb2.columns) - 1)).Value = tb2.values ws = wb.Worksheets("закуп") StartRow = 2 StartCol = 1 ws.Range( ws.Cells(StartRow, StartCol), ws.Cells(StartRow + len(tb4.index) - 1,
index=['schD2', 'schK2'], columns=['muk'], aggfunc={'sum': sum, 'data': sum}) tb.reset_index(inplace=True) tb = tb.fillna(0) tb['DK'] = tb.schD2.astype(str).str.cat(tb.schK2.astype(str), sep=';') with open('prVn.pickle', 'rb') as f: prVn = pickle.load(f) with open('pr.pickle', 'rb') as f: pr = pickle.load(f) tb["vn"] = tb["DK"].map(prVn) tb["opis"] = tb["DK"].map(pr) tb = tb.fillna(0) x = GetObject(None, "Excel.Application") wb = x.Workbooks("TestPr.xlsx") ws = wb.Worksheets("ГК") StartRow = 6 StartCol = 1 ws.Range(ws.Cells(StartRow, StartCol), ws.Cells(StartRow + len(tb.index) - 1, StartCol + len(tb.columns) - 1)).Value = tb.values # делаем помесячную ГК tb = pd.pivot_table(dp, values=['sum', 'data'], index=['schD2', 'schK2'], columns=['god', 'mes'], aggfunc={'sum': sum, 'data': sum} , margins=True ) tb.reset_index(inplace=True)