读取csv文件中数据,写入新文件该数据在第几行第几列,并写入读取的数据:
import csv
def 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, content
def 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:
pass
return result
def save_data(csv_file, column_names, row_names, da