How to open TSV file in Python?

Question

DataFrame.from_csv('C:\Users\~~\data.tsv', sep='\t')

Error that I get:

SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

`\U` is an escape sequence in Python `str` objects. Use a raw string literal: `r'C:\Users\~~\data.tsv'` to ignore escape sequences — juanpa.arrivillaga, Mar 07 '20 at 00:14

score 0 · Answer 1 · edited Mar 07 '20 at 03:33

0

Check if this work for you.

import csv

with open('C:\Users\~~\data.tsv') as tsvfile:
    reader = csv.DictReader(tsvfile, dialect='excel-tab')
    for row in reader:
        print(row)

edited Mar 07 '20 at 03:33

Hami

704
2
9
27

answered Mar 07 '20 at 00:29

shashi adhikari

1
2

No, now I get: SyntaxError: invalid syntax – Uncicylebear1 Mar 07 '20 at 00:47

How to open TSV file in Python?

1 Answers1