Simple Ways to Read TSV Files in Python

In this article, we will discuss how to read TSV files in Python.

Input Data:

We will be using the same input file in all various implementation methods to see the output. Below is the input file from which we will read data.

Method 1: Using  Pandas

 We will read data from TSV file using pandas read_csv(). Along with the TSV file, we also pass separator as ‘\t’ for the tab character because, for tsv files, the tab character will separate each field. 

Syntax :

data=pandas.read_csv('filename.tsv',sep='\t')

Example: Program Using Pandas

Output:

Method 2: Using CSV

 We use csv.reader() to convert the TSV file object to csv.reader object. And then pass the delimiter as ‘\t’ to the csv.reader. The delimiter is used to indicate the character which will be separating each field.

Syntax:

with open("filename.tsv") as file:
    tsv_file = csv.reader(file, delimiter="\t")

Example: Program Using csv

Output:

Method 3: Using split

The very simple way to read data from TSV File in Python is using split(). We can read a given TSV file and store its data into a list.

Syntax: 

with open("filename.tsv") as file:
  for line in file:
    l=line.split('\t')

Example: Program Using split() 

Output: