Python如何使用pandas编写新的csv文件

Question

import pandas as pdpd.__version__df = pd.read_csv('myfile.csv', usecols=[0,3,4,5,9])print (df)我只想从 csv 文件返回这些特定列并将其写入新的 csv 文件？我怎样才能做到这一点到目前为止我可以读取数据！但不知道怎么写绝对的 Python 初学者警告

Answer 1

根据您的输入，我假设您正在尝试实现类似的目标？

#import library

import pandas as pd

pd.__version__

# read the csv with all columns

df = pd.read_csv('myfile.csv')

print (df)

# create csv with filtered columns

filter_cols = ["0","3","4","5","9"]

df.to_csv('output.csv', columns = filter_cols)