Saturday, November 16, 2024
Google search engine
HomeLanguagesHow to load a TSV file into a Pandas DataFrame?

How to load a TSV file into a Pandas DataFrame?

In this article, we will discuss how to load a TSV file into a Pandas Dataframe.

The idea is extremely simple we only have to first import all the required libraries and then load the data set by using various methods in Python

Dataset Used:  data.tsv

Using read_csv() to load a TSV file into a Pandas DataFrame

Here we are using the read_csv() method to load a TSV file in to a Pandas dataframe.

Python3




import pandas as pd
 
# Data.tsv is stored locally in the
# same directory as of this python file
df = pd.read_csv('data.tsv',sep = '\t')
display(df)


Output:

Load a TSV file into a Pandas DataFrame

Load a TSV file into a Pandas DataFrame

Using read_table() to load a TSV file into a Pandas DataFrame

Here we are using the read_table() method to load a TSV file into a Pandas dataframe.

Python3




import pandas as pd
 
# Read TSV file into DataFrame
df = pd.read_table('data.tsv')
display(df)


Load a TSV file into a Pandas DataFrame

Load a TSV file into a Pandas DataFrame

RELATED ARTICLES

Most Popular

Recent Comments