Read tsv file python pandas

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:

>>> df1 = DataFrame(csv.reader(open('c:/~/trainSetRel3.txt'), delimiter='\t'))

Traceback (most recent call last):
  File "", line 1, in 
    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!

ankitom

1042 silver badges13 bronze badges

asked Mar 11, 2012 at 6:00

screechOwlscreechOwl

26.3k58 gold badges154 silver badges259 bronze badges

2

The .read_csv function does what you want:

pd.read_csv('c:/~/trainSetRel3.txt', sep='\t')

If you have a header, you can pass header=0.

pd.read_csv('c:/~/trainSetRel3.txt', sep='\t', header=0)

Note: Prior 17.0, pd.DataFrame.from_csv was used (it is now deprecated and the .from_csv documentation link redirects to the page for pd.read_csv).

answered Mar 11, 2012 at 6:06

10

As of 17.0 from_csv is discouraged.

Use pd.read_csv(fpath, sep='\t') or pd.read_table(fpath).

answered Dec 31, 2015 at 16:13

Kamil SindiKamil Sindi

19.9k18 gold badges91 silver badges117 bronze badges

2

Try this

df = pd.read_csv("rating-data.tsv",sep='\t')
df.head()

You actually need to fix the sep parameter.

answered Aug 1, 2019 at 5:14

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

answered Feb 10, 2018 at 17:28

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

answered Feb 16, 2021 at 13:23

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.

answered Apr 15, 2020 at 17:24

KofiKofi

1,0121 gold badge8 silver badges19 bronze badges

use this

import pandas as pd
df = pd.read_fwf('xxxx.tsv')

answered Jun 21 at 8:22

2

Try this:

import pandas as pd
DataFrame = pd.read_csv("dataset.tsv", sep="\t")

answered Feb 21, 2021 at 1:17

How do I read a TSV file in pandas?

How do I read a TSV file in python?

How do I convert TSV to CSV?

How do I read multiple TSV files in python?