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)
