使用python读取csv文件时出错

Question

我试图从csv文件中读取一个特定的逗号值，但我得到的是整行值我如何才能得到特定的逗号值

我的csv看起来像这样

Index,Time,Energy
1,1.0,45.034

我需要得到每列的能量值。你知道吗

Answer 1

import csv

with open('somefile.csv') as f:
  reader = csv.DictReader(f, delimiter=',')
  rows = list(reader)

for row in rows:
   print(row['Energy'])

Answer 2

f = open('file.txt')
f.readline() # To skip header
for line in f:
    print(line.split(',')[2])
f.close()

Answer 3

如果您希望即使柱能量的位置发生变化也能工作，可以执行以下操作：

with open('your_file.csv') as f:
    # Get header
    header = f.readline()
    energy_index = header.index('Energy')
    # Get Energy value
    for line in f.readlines():
        energy = line.split(',')[energy_index]
        # do whatever you want to do with Energy