pandas write tsv code example

Example 1: python how to write pandas dataframe as tsv file

# Basic syntax:
Dataframe.to_csv('/path/to/filename', sep='\t')

Example 2: saving a pandas dataframe as a csv

df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)

Example 3: pandas convert tsv to dataframe

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

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

Tags: