pandas 将数据框列写入csv [英] Pandas Writing Dataframe Columns to csv

问题描述

我正在编写一个脚本，以将带有标头的大.xlsx文件缩小为一个csv，然后根据标头名称仅写有所需列的新csv文件.

I'm writing a script to reduce a large .xlsx file with headers into a csv, and then write a new csv file with only the required columns based on header name.

import pandas
import csv

df = pandas.read_csv('C:\\Python27\\Work\\spoofing.csv')

time = df["InviteTime (Oracle)"]
orignum = df["Orig Number"]
origip = df["Orig IP Address"]
destnum = df["Dest Number"]

df.to_csv('output.csv', header=[time,orignum,origip,destnum])

我得到的错误是最后一部分代码，它说

The error I'm getting is with that last bit of code, and it says

ValueError: Writing 102 cols but got 4 aliases

我确定我忽略了一些愚蠢的事情，但是我已经阅读了熊猫网站上的to_csv文档，但我仍然感到茫然.我知道我使用了不正确的to_csv参数，但是我似乎无法理解我猜的文档.

I'm sure i'm overlooking something stupid, but I've read over the to_csv documentation on the pandas website and I'm still at a loss. I know I'm using the to_csv parameters incorrectly but I can't seem to get my head around the documentation I guess.

感谢您的帮助，谢谢！

推荐答案

选择特定列的方法是-

header = ["InviteTime (Oracle)", "Orig Number", "Orig IP Address", "Dest Number"]
df.to_csv('output.csv', columns = header)

这篇关于 pandas 将数据框列写入csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！