<p>使用</p>
<pre><code>if column.isdigit():
column = float(column)
values.append({'number_value': column})
</code></pre>
<p><code>isDigit()</code>将标识字符串是否为数字。你知道吗</p>
<p>如果列是数字,则可以执行转换操作</p>
<pre><code>import csv
with open('test.csv', "rt") as csv_file:
content = csv.reader(csv_file,delimiter=';')
for row in content:
values = []
for column in row[0].split(";"):
if column.isdigit():
column = float(column)
values.append({'number_value': column})
payload = {
'row': {'values': values}
}
print (values)
</code></pre>
<p>输出:</p>
<pre><code>[{'number_value': '$30,000 - $39,999'}, {'number_value': 'RENTER'}, {'number_value': 'German'}, {'number_value': 'N'}, {'number_value': 1.0}, {'number_value': '25-29'}, {'number_value': 'German'}, {'number_value': '1 3RD PL UNIT 703'}, {'number_value': 'CA'}, {'number_value': 'LONG BEACH'}, {'number_value': 'LOS ANGELES'}, {'number_value': 90802.0}, {'number_value': '$7.00 - $7.99'}, {'number_value': '7Day'}, {'number_value': 'FM'}, {'number_value': 0.0}, {'number_value': 'CircAdm'}]
</code></pre>