从csv文件中导入数据并转换为浮点型

Question

代码如下，欲从csv文件中导入相关数据：

file=open("C:/Users/jyz_1/Desktop/rainfall.csv")
lsy=[]
for line in file:
    #append csv to list
    line=line.replace("\n","")
    lsy.append(line.split(","))

但最后得到的lsy是这样的：

["['27.5', '18.8', '45', '61.7', '145.8', '265', '447.2', '167', '65.2', '49.9', '101.8', '5.6']", "['16.6', '31.6', '58.8', '73.8', '170.8', '144.4', '161.5', '28.3', '110', '65', '24.9', '13.1']", "['11.4', '28.8', '1.5', '194.1', '188.3', '337.1', '198.5', '282.9', '116.9', '99.5', '4.8', '34.2']", "['10.5', '12.6', '51.1', '144.6', '183.6', '263.3', '185.5', '76.2', '115.7', '115.7', '79.9', '28.2']", "['28', '17.6', '50.1', '170.3', '209.5', '215.3', '122.7', '217.6', '25.6', '79.1', '22.1', '25.2']"]

请教一下这是什么原理？还有要输出纯数字列表该怎么办？

Answer 1

[ [字符串]，[字符串]，[字符字符串] ]
你获得的是字符串列表，不是浮点数
使用强制转换就行，
写一个函数，判断是列表，就遍历，是字符串就转换成数字，递归