2 回答

TA贡献1943条经验 获得超7个赞
pandas read_csv中的usecols参数接受一个函数来过滤您感兴趣的列:
import pandas as pd
from io import StringIO
data = """Date/Time Apple Tart Cherry Pie Blueberry Pie Banana Pudding Tomato Soup
1:00 2 4 7 6 5
2:00 3 5 4 5 8
3:00 1 4 7 4 4"""
df = pd.read_csv(StringIO(data),
sep='\s{2,}',
engine='python',
#this is the key part of the code for your usecase
#looks for columns that contain Pie or Date/Time
#and returns only those columns
#quite extensible as well, since it accepts a function
usecols = lambda x: ("Pie" in x) or ("Date/Time" in x) )
df
Date/Time Cherry Pie Blueberry Pie
0 1:00 4 7
1 2:00 5 4
2 3:00 4 7

TA贡献1874条经验 获得超12个赞
您可以在将 read_csv() 用作列表时指定列名,例如:
df=pd.read_csv('fila.csv',names=['columnName#1','columnName3'])
看我没有使用“columnName2”。
添加回答
举报