在Python 3中使用适当的编码从CSV文件加载不同类型的数据

import csv

# 假设我们有一个名为data.csv的文件，内容如下：
# name,age,salary
# Alice,30,50000
# Bob,25,45000

# 打开CSV文件，指定编码为utf-8
with open('data.csv', mode='r', encoding='utf-8') as csvfile:
    csvreader = csv.DictReader(csvfile)
    
    for row in csvreader:
        # 将字符串转换为相应的数据类型
        name = row['name']
        age = int(row['age'])
        salary = float(row['salary'])
        
        print(f"Name: {name}, Age: {age}, Salary: {salary}")

try:
    with open('data.csv', mode='r', encoding='utf-8') as csvfile:
        # ...
except UnicodeDecodeError:
    with open('data.csv', mode='r', encoding='gbk') as csvfile:
        # ...

def clean_and_convert(value, target_type):
    try:
        return target_type(value)
    except ValueError:
        return None  # 或者返回一个默认值

for row in csvreader:
    age = clean_and_convert(row['age'], int)
    salary = clean_and_convert(row['salary'], float)
    # ...