无法查看所有用户输入值

2024-05-16 00:32:08 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在自动化我的东西,为此我陷入了困境。 不管怎么解释,我使用的是用户输入,其中一些公式在相应的单元格中用于输出,但是当我查看最终输出时,它只反映了循环的最后一个输入值

我想要所有提交的值的最终输出

df1 = pd.read_excel('abc.xlsx',worksheet='sheet1')

loops = int(input("Total Outage in Month: "))
inputs = []
for x in range(loops):
    user_input1 = [input('Enter the Impacted_Device : ') ]
    user_input2 = [input('Number_of_Impacted_Connection :') ]
    user_input3 = [input('Outage_Minutes  :')]

    inputs.append(user_input1)
    inputs.append(user_input2)
    inputs.append(user_input3)
    break


Impacted_Device = input(str("Enter the Impacted_Device : "))
Number_of_Impacted_Connection = int(input("Number_of_Impacted_Connection : "))
Outage_Minutes = int(input("Outage_Minutes : "))
Connection_Outage = int(Number_of_Impacted_Connection * Outage_Minutes)


df1['Impacted Connections'] = np.where((df1['Router'].str.contains(Impacted_Device)== True),Number_of_Impacted_Connection,'None')
df1['Outage Minutes'] = np.where((df1['Router'].str.contains(Impacted_Device)== True),Outage_Minutes,'None')
df1['Connection Outage'] = np.where((df1['Router'].str.contains(Impacted_Device)== True),Connection_Outage,'None')

df1

Tags: ofnumberinputdevicenpconnectionintdf1