为什么我在python中读取一个非常好的csv文件时会得到所有的nonnull?

2024-04-26 14:46:23 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试读取一个完美的csv文件在熊猫,当我检查头部,我看到所有非空的。为什么会发生这种情况?你知道吗

我的CSV文件:

Chr1    Cufflinks       exon    3631    3913    .       +       .       gene_id "XLOC_000001"; transcript_id "TCONS_00000001"; exon_number "1"; gene_name "ANAC001"; oId "AT1G01010.1
Chr1    Cufflinks       exon    3996    4276    .       +       .       gene_id "XLOC_000001"; transcript_id "TCONS_00000001"; exon_number "2"; gene_name "ANAC001"; oId "AT1G01010.1
Chr1    Cufflinks       exon    4486    4605    .       +       .       gene_id "XLOC_000001"; transcript_id "TCONS_00000001"; exon_number "3"; gene_name "ANAC001"; oId "AT1G01010.1
Chr1    Cufflinks       exon    4706    5095    .       +       .       gene_id "XLOC_000001"; transcript_id "TCONS_00000001"; exon_number "4"; gene_name "ANAC001"; oId "AT1G01010.1
Chr1    Cufflinks       exon    5174    5326    .       +       .       gene_id "XLOC_000001"; transcript_id "TCONS_00000001"; exon_number "5"; gene_name "ANAC001"; oId "AT1G01010.1
Chr1    Cufflinks       exon    5439    5899    .       +       .       gene_id "XLOC_000001"; transcript_id "TCONS_00000001"; exon_number "6"; gene_name "ANAC001"; oId "AT1G01010.1
Chr1    Cufflinks       exon    23146   24451   .       +       .       gene_id "XLOC_000002"; transcript_id "TCONS_00000002"; exon_number "1"; gene_name "DCL1"; oId "AT1G01040.1";

读取文件的代码:

df = pd.read_csv("my_file.csv", sep = '\t', header = None)
df.head()
<class 'pandas.core.frame.DataFrame'>
Int64Index: 5 entries, 0 to 4
Data columns:
X.1    5  non-null values
X.2    5  non-null values
X.3    5  non-null values
X.4    5  non-null values
X.5    5  non-null values
X.6    5  non-null values
X.7    5  non-null values
X.8    5  non-null values
X.9    5  non-null values
dtypes: int64(2), object(7)

另外,当我运行下面的

df = pd.read_csv(file_in2, sep = '\t', header = None, engine = 'python)
TypeError: read_csv() got an unexpected keyword argument 'engine'

Tags: nameidnumbernullvaluesoidtranscriptnon