如何在读取 CSV 文件时将字符串值转换为整数值?

2024-01-10

打开 CSV 文件时,整数列将转换为字符串值(“1”、“23”等)。循环将它们转换回整数的最佳方法是什么?

import csv

with open('C:/Python27/testweight.csv', 'rb') as f:
    reader = csv.reader(f)
    rows = [row for row in reader if row[1] > 's']

for row in rows:
    print row

CSV 文件如下:

Account Value
ABC      6
DEF      3
GHI      4
JKL      7

我认为这符合你的要求:

import csv

with open('C:/Python27/testweight.csv', 'r', newline='') as f:
    reader = csv.reader(f, delimiter='\t')
    header = next(reader)
    rows = [header] + [[row[0], int(row[1])] for row in reader if row]

for row in rows:
    print(row)

Output:

['Account', 'Value']
['ABC', 6]
['DEF', 3]
['GHI', 4]
['JKL', 7]
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

如何在读取 CSV 文件时将字符串值转换为整数值? 的相关文章

随机推荐