英文:
Python - breaking down the percentage of values and adding new rows to the list
问题
I'm a beginner in python and can't figure out the percentage breakdown of the amount. I would like the rows to contain lines with the calculated amounts.
DATA FROM TXT:
['Date', 'Period', 'NumberBill', 'Amount', 'KEY', 'WHAT\n']['31.01.2022', '2', 'BILL3', '-1800.00', 'TEAM', 'BILL\n']['03.02.2022', '2', 'BILL2', '644.00', 'PERSON','BILL\n']['03.02.2022', '2', 'BILL1', '150.00', 'TEAM', 'BILL']
OUT_my:
['31.01.2022', '2', 'BILL3', '-1800.00', 'TEAM', 'BILL\n', -540.0, -360.0, -900.0]['03.02.2022', '2', 'BILL1', '150.00','TEAM', 'BILL', 45.0, 30.0, 75.0]
I wrote:
filepath = "test.txt"file = open(filepath, "r")for i in file:iSplit = i.split(";")percentage1 = 0.30percentage2 = 0.20percentage3 = 0.50result1 = 0result2 = 0result3 = 0if iSplit[4] == 'TEAM':result1 = float(iSplit[3]) * percentage1result2 = float(iSplit[3]) * percentage2result3 = float(iSplit[3]) * percentage3iSplit.append(round(result1, 2))iSplit.append(round(result2, 2))iSplit.append(round(result3, 2))print(iSplit)
What I want to get:
['03.02.2022', '2', 'BILL2', '644.00', 'PERSON','BILL']['31.01.2022', '2', 'BILL3', '-540.00', 'TEAM', 'BILL']['31.01.2022', '2', 'BILL3', '-360.00', 'TEAM', 'BILL']['31.01.2022', '2', 'BILL3', '-900.00', 'TEAM', 'BILL']['03.02.2022', '2', 'BILL1', '45.00', 'TEAM', 'BILL']['03.02.2022', '2', 'BILL1', '30.00', 'TEAM', 'BILL']['03.02.2022', '2', 'BILL1', '75.00', 'TEAM', 'BILL']
英文:
I'm a beginner in python and can't figure out the percentage breakdown of the amount. I would like the rows to contain lines with the calculated amounts.
DATA FROM TXT:
['Date', 'Period', 'NumberBill', 'Amount', 'KEY', 'WHAT\n']['31.01.2022', '2', 'BILL3', '-1800.00', 'TEAM', 'BILL\n']['03.02.2022', '2', 'BILL2', '644.00', 'PERSON','BILL\n']['03.02.2022', '2', 'BILL1', '150.00', 'TEAM', 'BILL']
OUT_my:
['31.01.2022', '2', 'BILL3', '-1800.00', 'TEAM', 'BILL\n', -540.0, -360.0, -900.0]['03.02.2022', '2', 'BILL1', '150.00','TEAM', 'BILL', 45.0, 30.0, 75.0]
I wrote:
filepath = "test.txt"file = open(filepath, "r")for i in file:iSplit = i.split(";")percentage1 = 0.30percentage2 = 0.20percentage3 = 0.50result1 = 0result2 = 0result3 = 0if iSplit[4] == 'TEAM':result1 = float(iSplit[3]) * percentage1result2 = float(iSplit[3]) * percentage2result3 = float(iSplit[3]) * percentage3iSplit.append(round(result1, 2))iSplit.append(round(result2, 2))iSplit.append(round(result3, 2))print(iSplit)`
What I want to get:
['03.02.2022', '2', 'BILL2', '644.00', 'PERSON','BILL]['31.01.2022', '2', 'BILL3', '-540.00', 'TEAM', 'BILL]['31.01.2022', '2', 'BILL3', '-360.00', 'TEAM', 'BILL]['31.01.2022', '2', 'BILL3', '-900.00', 'TEAM', 'BILL]['03.02.2022', '2', 'BILL1', '45.00', 'TEAM', 'BILL']['03.02.2022', '2', 'BILL1', '30.00', 'TEAM', 'BILL']['03.02.2022', '2', 'BILL1', '75.00', 'TEAM', 'BILL']
答案1
得分: 0
要获得您想要的结果，您应该为每个百分比打印一个新行，将金额替换为金额乘以百分比，而不是将它们全部附加到原始行。
要获取非团队行，请使用一个 else: 块来打印原始行。
filepath = "test.txt"team_percentages = [0.30, 0.20, 0.50]with open(filepath, "r") as file:for i in file:iSplit = i.split(";")if iSplit[4] == 'TEAM':for percent in team_percentages:new_row = iSplit.copy()new_row[3] = str(float(iSplit[3]) * percent)print(new_row)else:print(iSplit)
英文:
To get the result you want, you should print a new row for each percentage, with the amount replaced by the amount multiplied by the percentage, not append them all to the original row.
And to get the non-team rows, use an else: block to print the original row.
filepath = "test.txt"team_percentages = [0.30, 0.20, 0.50]with open(filepath, "r") as file:for i in file:iSplit = i.split(";")if iSplit[4] == 'TEAM':for percent in team_percentages:new_row = isplit.copy()new_row[3] = str(float(iSplit[3]) * percent)print(new_row)else:print(iSplit)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论