Skip to main content
 首页 » 编程设计

python之如何读取csv文件并提取特定列

2024年11月24日10虾米哥

这是我的 csv 文件:

CommitId                                RefactoringType      RefactoringDetail 
d38f7b334856ed4007fb3ec0f8a5f7499ee2f2b8    Pull Up Attribute   "Pull Up Attribute  protected steps : int from class blokusgame.mi.android.hazi.blokus.GameLogic.PlayerAlgorithm to class blokusgame.mi.android.hazi.blokus.GameLogic.Player" 
d38f7b334856ed4007fb3ec0f8a5f7499ee2f2b8    Pull Up Attribute   "Pull Up Attribute  protected steps : int from class blokusgame.mi.android.hazi.blokus.GameLogic.PlayerAlgorithm to class blokusgame.mi.android.hazi.blokus.GameLogic.Player" 
d38f7b334856ed4007fb3ec0f8a5f7499ee2f2b8    Pull Up Attribute   "Pull Up Attribute  protected steps : int from class blokusgame.mi.android.hazi.blokus.GameLogic.PlayerAlgorithm to class blokusgame.mi.android.hazi.blokus.GameLogic.Pla 

我需要提取这个:

RefactoringDetail 
"Pull Up Attribute  protected steps : int from class blokusgame.mi.android.hazi.blokus.GameLogic.PlayerAlgorithm to class blokusgame.mi.android.hazi.blokus.GameLogic.Player" 
"Pull Up Attribute  protected steps : int from class blokusgame.mi.android.hazi.blokus.GameLogic.PlayerAlgorithm to class blokusgame.mi.android.hazi.blokus.GameLogic.Player" 
"Pull Up Attribute  protected steps : int from class blokusgame.mi.android.hazi.blokus.GameLogic.PlayerAlgorithm to class blokusgame.mi.android.hazi.blokus.GameLogic.Player" 

我试过这段代码:

import pandas as pd 
df = pd.read_csv('result_refactorings.csv', sep='delimiter', header=None) 
df.iloc[:,-1] 

返回所有数据

请帮忙!

请您参考如下方法:

如果您只想使用内置的 csv 模块:

import csv 
import re 
third_column = [] 
with open("result_refactorings.csv") as csvfile: 
    fixed_spaces = [re.sub(" {2,}","\t",x) for x in csvfile] 
    reader = csv.DictReader(fixed_spaces, delimiter="\t") 
    for row in reader: 
        print(row["RefactoringDetail"]) 
        third_column.append(row["RefactoringDetail"]) 

此代码既打印出第三列,又将第三列中的每个项目添加到列表 third_column.. 根据你想做什么,取出一个或另一个。

编辑:仔细检查后,您的 csv 输入似乎用不均匀数量的空格分隔。实际上不是制表符,这就是它的样子。添加了一个小正则表达式来用实际的替换 2 个或更多并发空格选项卡.. 因为在当前状态下它不是有效的 csv。