Skip to main content
 首页 » 编程设计

python之通过 DictReader 读取 .csv

2024年10月24日11lonelyxmas

我只是尝试使用第一行作为字典的键来读取 .csv,但没有成功。我的文件有两行(测试),项目由制表符分隔。

subjectID   logID   logTimestamp    gameKey userID  writer  gameTime    gameCode    gameDesc 
9991    1711774 6/13/14 E9E91B56    L11-13  general 358 1002    GAMESCRIBE_CREATED 

代码:

def process_data(file_path): 
    users = {} 
 
    # Open the .csv file and creates a dict of actions 
    with open(file_path, 'rb') as csvfile: 
        spamreader = csv.DictReader(csvfile, delimiter='\t') 
        print spam reader 
        print spamreader.fieldnames  
        for row in spamreader: 
            print row 

我一直收到这个错误:

    ['subjectID', 'logID', 'logTimestamp', 'gameKey', 'userID', 'writer', 'gameTime', 'gameCode', 'gameDesc'] 
Traceback (most recent call last): 
  File "logEvents.py", line 41, in <module> 
    process_data(logs_path) 
  File "logEvents.py", line 11, in process_data 
    for row in spamreader: 
  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/csv.py", line 108, in next 
    row = self.reader.next() 
ValueError: I/O operation on closed file 

我不知道我做错了什么。

请您参考如下方法:

您在实际代码中的 with block 之外有 for row in spamreader:

with open(file_path, 'rb') as csvfile: 
    spamreader = csv.DictReader(csvfile, delimiter='\t') 
    print spamreader 
for row in spamreader: # your code 
     print row 

一旦您离开 with block ,文件将关闭,因此尝试从文件对象读取失败。