如何将标题行添加到 pandas DataFrame

2022-01-11 00:00:00 python pandas csv header

问题描述

我正在将一个 csv 文件读入 pandas.此 csv 文件由四列和一些行组成，但没有我要添加的标题行.我一直在尝试以下方法:

I am reading a csv file into pandas. This csv file constists of four columns and some rows, but does not have a header row, which I want to add. I have been trying the following: 

Cov = pd.read_csv("path/to/file.txt", sep='	')
Frame=pd.DataFrame([Cov], columns = ["Sequence", "Start", "End", "Coverage"])
Frame.to_csv("path/to/file.txt", sep='	')

但是当我应用代码时，我得到以下错误:

But when I apply the code, I get the following Error:

ValueError: Shape of passed values is (1, 1), indices imply (4, 1)

这个错误到底是什么意思?在 python 中将标题行添加到我的 csv 文件/pandas df 的一种干净的方法是什么?

What exactly does the error mean? And what would be a clean way in python to add a header row to my csv file/pandas df?

解决方案

你可以直接在names稳定/生成/pandas.read_csv.html" rel="noreferrer">read_csv

You can use names directly in the read_csv

names : 类似数组，默认 None 要使用的列名列表.如果文件不包含标题行，那么您应该显式传递 header=None

names : array-like, default None List of column names to use. If file contains no header row, then you should explicitly pass header=None

Cov = pd.read_csv("path/to/file.txt", 
                  sep='	', 
                  names=["Sequence", "Start", "End", "Coverage"])

相关文章