python - 用于基于多个条件的迭代的 Python 程序

Question

我是 Python 新手，需要专家支持才能根据附加的输入获取输出 1 和输出 2 有人可以帮我完成下面的 python 代码吗，需要单独的表中的输出 1 和输出 2

https://i.stack.imgur.com/tZH9A.png][输入]

https://i.stack.imgur.com/zfZOG.png[输出1]

https://i.stack.imgur.com/cbAGx.png[输出2]

提前致谢

我当前的代码：

import openpyxl
from openpyxl import Workbook
Path = "C:\Input.xlsx"
wb = openpyxl.load_workbook(Path)
sheet1 = wb["Sample"]
if os.path.exists("C:\Output.xlsx"):
    os.remove("C:\Output.xlsx")
else:
    print("The file does not exist")
newbook = Workbook()
newbook["Sheet"].title = "Output1"
newbook.create_sheet("Output2")
newbook.save("C:\Output.xlsx")
ShtOut1 = newbook["Output1"]
ShtOut2 = newbook["Output2"]
mr1 = sheet1.max_row
mc1 = sheet1.max_column
for k in range(1, mr1 + 1):
    for l in range(2, 4):
        d = sheet1.cell(row=k, column=l)
        ShtOut1.cell(row=k, column=l-1).value = d.value
newbook.save("C:\Output.xlsx")

标签： pythonexcelopenpyxldata-processingexceldatareader