Simple Ways to Read TSV Files in Python
In this article, we will discuss how to read TSV files in Python.
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.
Example: Program Using Pandas
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.
with open("filename.tsv") as file: tsv_file = csv.reader(file, delimiter="\t")
Example: Program Using csv
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.
with open("filename.tsv") as file: for line in file: l=line.split('\t')
Example: Program Using split()