Python
7
Вклад в тег
psycopg2.connect(ваши_аргументы_функции, async=1)
import openpyxl
import os
import dbf
book = openpyxl.open("C:\\pypypy\\январь_2401231.xlsx", read_only=True)
sheet = book.active
table = dbf.Table('kvpl.dbf', 'FIO C(60); ADR C(13); TEPLO F(19,5); VODA F(19,5); ELECTRO F(19, 5)', codepage='cp866')
table.open(mode=dbf.READ_WRITE)
for row in range(2, sheet.max_row + 1):
FIO = sheet[row][0].value
ADR = sheet[row][1].value
TEPLO = sheet[row][3].value
VODA = sheet[row][4].value
ELECTRO = sheet[row][5].value
goods = (FIO, ADR, TEPLO, VODA, ELECTRO)
table.append(goods)
table.close()table.append(tuple(goods))
$ jt -r
delete_sequence = [48, 56, 32, 10, 8, 1][:-1]
# Проходим по элементам и удаляем необходимый
for element in delete_sequence:
tree_for_deletion = tree_for_deletion[element]
del tree_for_deletion['value']
# Снова проходим по элементам и проверяем остались ли пустые значения по ключу, если да, то удаляем и завершаем цикл
tree_for_deletion = tree
for element in delete_sequence:
if not tree_for_deletion[element]:
del tree_for_deletion[element]
break
tree_for_deletion = tree_for_deletion[element]
print(tree){48: {56: {32: {10: {1: {'value': -12}}}, 10: {32: {8: {1: {'value': -18}}}, 1: {32: {'пропуск': {'value': 6}}, 8: {'value': -12}}}}}}
Средний