Python/Pandas-使用delimter读取带有tab的csv文件无法正常工作 [英] Python/Pandas - Read csv file with tab as delimter is not working as desired

问题描述

我有一个制表符分隔的csv文件，如下所示:

I have a tab seperated csv file like below:

    1   2   3   4   5   6   7   8   9   10

    a   b   c   d   e   f   g   h   i   j

    k   l   m   n   o   p   q   r   s   t

而且，我正在使用以下代码将其读取到数据框

And, I'm reading it to a dataframe with the below code

    df = pd.read_csv('C:/Users/IBM_ADMIN/Desktop/Delete/input1.csv',encoding='ANSI', delimiter='\t', header=0)

当我执行以上代码时，我将得到如下图所示的输出-> what_I_got

When I execute the above code I'm getting output like this image -> what_I_got

但是，我期望这样-> 期望的输出

But, I'm expecting like this -> desired_output

我尝试了多种方法来拆分该列，但是它不起作用.能否请我提供解决方案?

I tried many ways to split the column but it's not working.Could you help me with a solution please?

推荐答案

您需要删除delimiter='\t'-分隔符为,.

You need remove delimiter='\t' - separator is ,.

它起作用是因为默认分隔符是,，也可以删除header=0，因为如果不是header=0参数，默认情况下是header=0:

It working because default separator is ,, also is possible remove header=0 because if not parmeter names by default header=0:

df = pd.read_csv('C:/Users/IBM_ADMIN/Desktop/Delete/input1.csv',encoding='ANSI')

这篇关于Python/Pandas-使用delimter读取带有tab的csv文件无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！