python批量计算浮点型高光谱数据平均反射率并存储到csv

import numpy as np
import csv

# 读取数据
data = np.loadtxt('data.txt', delimiter=',')

# 计算平均反射率
average_reflectance = np.mean(data, axis=1)

# 存储数据到csv文件
with open('average_reflectance.csv', mode='w', newline='') as file:
writer = csv.writer(file)
writer.writerow(['Sample', 'Average Reflectance'])
for i in range(len(average_reflectance)):
writer.writerow([f'Sample_{i+1}', average_reflectance[i]])