回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>使用文本文件中的值创建表时遇到一些问题。我的文本文件如下所示:</p>
<pre><code>e432,6/5/3,6962,c8429,A,4324
e340,2/3/5,566623,c1210,A,3201
e4202,6/5/3,4232,c8419,E,4232
e3230,2/3/5,66632,c1120,A,53204
e4202,6/5/3,61962,c8429,A,4322
</code></pre>
<p>我想生成一个包含数组的表,其中:最后一列(amountpaid)值小于第三列(final total),如果第五列(status)等于“a”。未付总额是减去最终总额和已付金额后得出的。你知道吗</p>
<p>生成表的代码是:</p>
<pre><code>data = open("pJoptionc.txt", "r")
info=data.readlines()
data.close
for li in info:
status=li.split(",")[4]
finaltotal=int(li.split(",")[2])
amountpaid=int(li.split(",")[5])
totalrev=0
headers = ["Estimate Number", "Date", "Final Total", "Customer Number", "Status", "Amount Paid", "Outstanding Amount"]
print(" ".join(headers))
for line in open("pJoptionc.txt", "r"):
line = line.strip().split(",")
line.append(str(int(line[2]) - int(line[5])))
if line[2] == line[5] or line[4] in ("E"):
continue
for i, word in enumerate(line):
print(word.ljust(len(headers[i - (i > 4)])), end=" " * ((i - (i > 4)) != len(headers) - 1))
print()
outstandingrev =(finaltotal) - (amountpaid)
totalrev += int(outstandingrev)
print("The total amount of outstanding revenue is...")
print("£",totalrev)
</code></pre>
<p>我想要的输出是</p>
<pre><code>Estimate Number Date Final Total Customer Number Status Amount Paid Outstanding Amount
e432 6/5/3 6962 c8429 A 4324 2638
e340 2/3/5 566623 c1210 A 3201 563422
e3230 2/3/5 66632 c1120 A 53204 13428
e4202 6/5/3 61962 c8429 A 4322 57640
The total amount of outstanding revenue is...
£ 13428
</code></pre>
<p>但是,当我运行代码时,输出是反复重复的表,并且负值出现在“未付金额”列中。我使用的是python3.4.3。你知道吗</p>