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!