How to load a tsv file into a Pandas DataFrame

Question

I m new to python and pandas   I m trying to get a tsv file loaded into a pandas DataFrame     This is what I m trying and the error I m getting    gt  gt  gt  df1   DataFrame csv reader open  c    trainSetRel3 txt    delimiter   t     Traceback  most recent call last     File   lt pyshell 28 gt    line 1  in  lt module gt      df1   DataFrame csv reader open  c    trainSetRel3 txt    delimiter   t      File  C  Python27 lib site-packages pandas core frame py   line 318  in   init       raise PandasError  DataFrame constructor not properly called    PandasError  DataFrame constructor not properly called

User · Answer

Try this  df   pd read csv  rating-data tsv  sep   t   df head       You actually need to fix the sep parameter

User · Answer

data   pd read csv  your dataset tsv   delimiter     t   quoting   3   You can use a delimiter to separate data  quoting   3 helps to clear quotes in datasst

User · Answer

As of 17 0 from csv is discouraged   Use pd read csv fpath  sep   t   or pd read table fpath

User · Answer

Try this  import pandas as pd DataFrame   pd read csv  quot dataset tsv quot   sep  quot  t quot

User · Answer

Note  As of 17 0 from csv is discouraged  use pd read csv instead  The documentation lists a  from csv function that appears to do what you want   DataFrame from csv  c    trainSetRel3 txt   sep   t     If you have a header  you can pass header 0   DataFrame from csv  c    trainSetRel3 txt   sep   t   header 0

User · Answer

Use read table filepath   The default separator is tab

User · Answer

df   pd read csv  filename csv   sep   t   header 0    You can load the tsv file directly into pandas data frame by specifying delimitor and header

User · Answer

open file  save as  csv and then apply   df   pd read csv  apps csv   sep   t     for any other format also  just change the sep tag

[python] How to load a tsv file into a Pandas DataFrame?

Examples related to python

Examples related to pandas

Examples related to csv