python - 如何从 CSV 文件创建不带引号的元组？

Question

我正在读取 CSV 文件并需要创建元组，但我需要删除引号。 CSV 行示例:

57, 47, 1.04
1288, 317, 1.106
149, 84, 1.05

我试过了

import csv
from pprint import pprint

with open('./Documents/1.csv', encoding='utf-8-sig') as file:
   reader = csv.reader(file, skipinitialspace=True)
   x = list(map(tuple, reader))

结果是:

[('57', '47', '1.04'),
 ('1288', '317', '1.106'),
 ('149', '84', '1.05')]

我需要它

[(57, 47, 1.04183),
 (1288, 317, 1.106),
 (149, 84, 1.05)]

发现类似问题here但目前还无法找出答案。

Answer 1

您可以使用ast.literal_eval()将元组内的数字转换为各自的类型:

import csv
from ast import literal_eval
from pprint import pprint

with open('1.csv', encoding='utf-8-sig') as file:
   reader = csv.reader(file, skipinitialspace=True)
   x = [tuple(map(literal_eval, x)) for x in map(tuple, reader)]
   print(x)
   # [(57, 47, 1.04), (1288, 317, 1.106), (149, 84, 1.05)]