Python如何使用熊猫编写新的csv文件[复制]

Question

import pandas as pd
pd.__version__
df = pd.read_csv('myfile.csv', usecols=[0,3,4,5,9])
print (df)

我只想从csv文件中返回这些特定列，并将其写入新的csv文件？

我该怎么做

到目前为止，我可以读取数据！！但不知道怎么写

绝对PYTHON BEGGINER警报

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)