{"id":127160,"date":"2022-08-10T20:06:18","date_gmt":"2022-08-10T20:06:18","guid":{"rendered":"https:\/\/blog.finxter.com\/?p=563635"},"modified":"2022-08-10T20:06:18","modified_gmt":"2022-08-10T20:06:18","slug":"how-to-convert-tab-delimited-file-to-csv-in-python","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2022\/08\/10\/how-to-convert-tab-delimited-file-to-csv-in-python\/","title":{"rendered":"How to Convert Tab-Delimited File to CSV in Python?"},"content":{"rendered":"\n
\n
\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n
5\/5 – (1 vote) <\/div>\n<\/div>\n

The easiest way to convert a tab-delimited values (TSV) file to a comma-separated values (CSV) file is to use the following three lines of code:<\/strong><\/p>\n

    \n
  1. import pandas as pd<\/code><\/strong><\/li>\n
  2. df = pd.read_csv('my_file.txt', sep='\\t', header=None)<\/code><\/strong><\/li>\n
  3. df.to_csv('my_file.csv', header=None)<\/code><\/strong><\/li>\n<\/ol>\n

    We’ll explain this and other approaches in more detail next—scroll down to Method 3<\/strong> for this exact method.<\/p>\n

    Problem Formulation<\/h2>\n

    Given a tab-delimited file with one tab character '\\t'<\/code> between two values in a given column.<\/p>\n

    Input:<\/strong> 'my_file.tsv'<\/code><\/p>\n

    \n
    \"\"
    Figure<\/strong>: File 'my_file.tsv'<\/code> with tab '\\t'<\/code> separated values.<\/figcaption><\/figure>\n<\/div>\n
    Alice\tDataScience\t$100000\nBob\tProgrammer\t$90000\nCarl\tManager\t$122000\nDave\tFreelancer\t$144000<\/pre>\n
    How to convert the tab-delimited values (TSV) to a comma-separated values (CSV) file?<\/p>\n
    Output:<\/strong> 'my_file.csv'<\/code><\/p>\n
    0,Alice,DataScience,$100000\n1,Bob,Programmer,$90000\n2,Carl,Manager,$122000\n3,Dave,Freelancer,$144000<\/code><\/pre>\n
    We’ll also look at slight variations of this problem. Let’s go!<\/p>\n
    Method 1: String Replace Single Tab<\/h2>\n
    The most straightforward way to convert a tab-delimited (TSV) to a comma-separated (CSV) file in Python is to replace each tabular character '\\t'<\/code> with a comma ','<\/code> character using the string.replace()<\/a><\/code> method. This works if two values are separated by exactly one tabular character.<\/p>\n
    Here’s an example input file 'my_file.tsv'<\/code>:<\/p>\n
    \n
    \"\"<\/figure>\n<\/div>\n
    Here’s an example of some code to convert the tab-delimited file to the CSV file:<\/p>\n
    with open('my_file.tsv') as f: # Read space-delimited file and replace all empty spaces by commas data = f.read().replace('\\t', ',') # Write the CSV data in the output file print(data, file=open('my_file.csv', 'w'))<\/pre>\n
    Output file 'my_file.csv'<\/code>:<\/p>\n
    \n
    \"\"<\/figure>\n<\/div>\n
    If you have any doubts, feel free to dive into our related tutorials:<\/p>\n