pandas to tsv code example

Example 1: python save df to csv

df.to_csv(r'/directory/path/file_name.csv', index = False, header = True)

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 dataframe from tsv

df = pd.read_csv("PATH../xyz.tsv",sep="\t")

Example 4: 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!