读取csv文件中数据，写入新文件该数据在第几行第几列，并写入读取的数据：
import csvdef read_data(csv_file):result = []row_names = []with open(csv_file, 'r', encoding="utf-8") as file:reader = csv.reader(file)for row in reader:row_names.append(row[0])result.append(row[1:])column_names = result[0]row_names = row_names[1:]content = result[1:]return column_names, row_names, contentdef parse_data(content):r = len(content)c = len(content[0])result = []for ri in range(r):for ci in range(c):cell = content[ri][ci]cell = cell.strip()if cell:try:value = float(cell)result.append((ri, ci, value))except:passreturn resultdef save_data(csv_file, column_names, row_names, data):with open(csv_file, 'w', newline='', encoding="gbk") as file:writer = csv.writer(file)# 首行# writer.writerow(["起始站点", "终点", "费用（元）"])for item in data:ri, ci, value = itemwriter.writerow([row_names[ri], column_names[ci], value])#直接读取行列值（文字）#writer.writerow([ri+1, ci+1, value])#读取实际表格中第几行第几列# csv_file = 'simple.csv'csv_file = 'linkod.csv'column_names, row_names, content = read_data(csv_file)data = parse_data(content)output = "output2.csv"save_data(output, column_names, row_names, data)
例：由图1得到图2：
图1：
图2：
解释：第一列表示为第1行第2列数据为1。
