回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我正在尝试用Python完成一个看似简单的任务。这是我这几天来第三次这么做,我感到很尴尬。你知道吗</p>
<p>我希望打开一个csv文件。如果值不是0或1(它是“?”),我想遍历每一行和每一行中的每一列,用最后一列的值重写该值。最后一列永远不能是0或1。永远不会是“?”。与其说我关心打印语句,不如说我在替换“?”(或非0/1)最后一列中的值。你知道吗</p>
<p>我在这里附上了一个示例csv文件:
<a href="http://www.sharecsv.com/s/7bef636c33054cae624928297146bae1/house.csv" rel="nofollow noreferrer">http://www.sharecsv.com/s/7bef636c33054cae624928297146bae1/house.csv</a></p>
<p>如果您无法查看上面的链接,我已将数据集的示例粘贴到下面:</p>
<pre><code>0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,?,1.00,1.00,1.00,0.00,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,?,1.00
?,1.00,1.00,?,1.00,1.00,0.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,0.00,0.00,0.00
0.00,1.00,1.00,0.00,?,1.00,0.00,0.00,0.00,0.00,1.00,0.00,1.00,0.00,0.00,1.00,0.00
1.00,1.00,1.00,0.00,1.00,1.00,0.00,0.00,0.00,0.00,1.00,?,1.00,1.00,1.00,1.00,0.00
0.00,1.00,1.00,0.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,?,1.00,1.00,1.00,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,?,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,?,?,0.00
0.00,1.00,0.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,?,?,1.00,1.00,0.00,0.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,1.00,?,1.00,1.00,?,?,1.00
0.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,?,?,0.00
1.00,1.00,1.00,0.00,0.00,1.00,1.00,1.00,?,1.00,1.00,?,0.00,0.00,1.00,?,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,?,?,0.00,?,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,?,0.00,?,1.00
1.00,0.00,1.00,0.00,0.00,1.00,0.00,1.00,?,1.00,1.00,1.00,?,0.00,0.00,1.00,0.00
1.00,?,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,?,1.00,1.00,0.00,0.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,?,1.00,1.00,0.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,?,?,1.00,1.00,0.00
1.00,?,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,?,0.00,0.00,1.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,?,0.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,0.00,0.00,1.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,1.00,?,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,0.00,0.00,1.00,0.00,1.00,1.00,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00
1.00,?,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,?,1.00,0.00,1.00,1.00
1.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,1.00,0.00,1.00,0.00,1.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,?,0.00,0.00,0.00,0.00,?,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,?,0.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,0.00,?,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,?,0.00,1.00,0.00,0.00,0.00,1.00,?,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,?,0.00,0.00,0.00,0.00,0.00,0.00,?,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,1.00,0.00
0.00,?,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,?,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,?,?,0.00
1.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00
1.00,1.00,1.00,0.00,0.00,1.00,?,1.00,0.00,0.00,1.00,1.00,0.00,1.00,0.00,?,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,1.00,0.00,0.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,1.00,0.00,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,1.00,0.00,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,1.00,0.00,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,1.00,0.00,?,1.00
1.00,1.00,1.00,0.00,0.00,?,1.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,1.00,?,0.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,?,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,0.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,?,0.00,0.00,0.00,1.00,0.00
1.00,1.00,0.00,1.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,0.00,1.00,1.00
0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,1.00
1.00,?,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,1.00,0.00
1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00
1.00,0.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,0.00,1.00,?,0.00
1.00,1.00,1.00,1.00,0.00,0.00,1.00,1.00,1.00,1.00,1.00,0.00,0.00,1.00,0.00,1.00,1.00
</code></pre>
<p>这是我目前的代码:</p>
<pre><code>import csv
reader = csv.reader(open('house1.csv'), delimiter = ',')
counter = 0
for row in reader:
# print("Opened Reader")
currVal = row[:-1]
counter = counter + 1
# print("set values")
for column in row:
questioncount = 0
# print("Looping columns")
if (column != 0 or column != 1):
questioncount = questioncount + 1
# This is where I should overwrite the value
print("Row " + str(counter) + " has " + str(questioncount) + " question marks ")
</code></pre>
<p>我不明白为什么我有这么多困难。目前,Pycharm的输出是,它说每一行和每一列都有一个问号,这是不正确的。你知道吗</p>
<pre><code>Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 1 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 2 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 3 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 4 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 5 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 6 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 7 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 8 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
Row 9 has 1 question marks
...
Row 435 has 1 question marks
</code></pre>
<p>我希望给出一个像<br/>
<code>0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,?,1.00,1.00,1.00,0.00,1.00,1.00</code><br/>这个python脚本将把这一行变成<br/>
<code>0.00,1.00,0.00,1.00,1.00,1.00,0.00,0.00,0.00,1.00,1.00,1.00,1.00,1.00,0.00,1.00,1.00</code></p>
<p>如有任何建议,将不胜感激。你知道吗</p>