Table of Contents
Different methods to display entire DataFrame in pandas
In this tutorial we will discuss how to display the entire DataFrame in Pandas using the following methods:
- Using
set_option()
method - Display with or without
index
- Display in
Markdown
format - Display in
psql
format - Display in
plain-text
format - Display in
RST
format - Display in
github
format - Display in
pretty
format - Display in
tsv
format - Display in
HTML
format
Create pandas DataFrame with example data
DataFrame is a data structure used to store the data in two dimensional format. It is similar to table that stores the data in rows and columns. Rows represents the records/ tuples and columns refers to the attributes.
We can create the DataFrame by using pandas.DataFrame() method.
Syntax:
pandas.DataFrame(input_data,columns,index)
Parameters:
It will take mainly three parameters
- input_data is represents a list of data
columns
represent the columns names for the dataindex
represent the row numbers/values
We can also create a DataFrame using dictionary by skipping columns and indices.
Example: Python Program to create a dataframe for market data from a dictionary of food items by specifying the column names.
# import the module
import pandas
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# display the dataframe
print(dataframe)
Output:
id name cost quantity
item-1 foo-23 ground-nut oil 567.00 1
item-2 foo-13 almonds 562.56 2
item-3 foo-02 flour 67.00 3
item-4 foo-31 cereals 76.09 2
You can learn more at Pandas dataframe explained with simple examples
1. Print entire DataFrame using set_option() method
Here we are going to display the entire dataframe
with this method, we can display n number of rows and columns.
Syntax:
# display all the rows
pandas.set_option('display.max_rows', None)
# display all the columns
pandas.set_option('display.max_columns', None)
# set width - 100
pandas.set_option('display.width', 100)
# set column header - left
pandas.set_option('display.colheader_justify', 'left')
# set precision - 5
pandas.set_option('display.precision', 5)
Example:
# import the module
import pandas
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# display all the rows
pandas.set_option('display.max_rows', None)
# display all the columns
pandas.set_option('display.max_columns', None)
# set width - 100
pandas.set_option('display.width', 100)
# set column header - left
pandas.set_option('display.colheader_justify', 'left')
# set precision - 5
pandas.set_option('display.precision', 5)
# display the dataframe
print(dataframe)
Output:
id name cost quantity
item-1 foo-23 ground-nut oil 567.00 1
item-2 foo-13 almonds 562.56 2
item-3 foo-02 flour 67.00 3
item-4 foo-31 cereals 76.09 2
2. Print entire DataFrame with or without index
Here we are going to display the entire dataframe.
With this method, we can display n number of rows and columns with and with out index
.
Syntax:
dataframe.to_string(index=False)
dataframe.to_string(index=True)
Example:
# import the module
import pandas
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# display the dataframe with out index
print("Pandas DataFrame without index:\n", dataframe.to_string(index=False))
# display the dataframe with index
print("Pandas DataFrame with index:\n", dataframe.to_string(index=True))
Output:
Pandas DataFrame without index:
id name cost quantity
foo-23 ground-nut oil 567.00 1
foo-13 almonds 562.56 2
foo-02 flour 67.00 3
foo-31 cereals 76.09 2
Pandas DataFrame with index:
id name cost quantity
item-1 foo-23 ground-nut oil 567.00 1
item-2 foo-13 almonds 562.56 2
item-3 foo-02 flour 67.00 3
item-4 foo-31 cereals 76.09 2
3. Print entire DataFrame in Markdown format
Here we are going to display in markdown
format
Syntax:
dataframe.to_markdown()
Example:
# import the module
import pandas
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay in mark down
print(dataframe.to_markdown())
Output:
| | id | name | cost | quantity |
|:-------|:-------|:---------------|-------:|-----------:|
| item-1 | foo-23 | ground-nut oil | 567 | 1 |
| item-2 | foo-13 | almonds | 562.56 | 2 |
| item-3 | foo-02 | flour | 67 | 3 |
| item-4 | foo-31 | cereals | 76.09 | 2 |
4. Print entire DataFrame in psql format
Here we are going to display the entire dataframe in psql
format.
This is a format available in tabulate package. so we need to install this package.
Install tabulate using pip:
pip install tabulate
Syntax for this format:
tabulate(dataframe, headers='keys', tablefmt='psql')
where, dataframe is the input dataframe
Example: Python program to display the entire dataframe in psql format
# import the module
import pandas
from tabulate import tabulate
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay the entire dataframe in psql format
print(tabulate(dataframe, headers='keys', tablefmt='psql'))
Output:
+--------+--------+----------------+--------+------------+
| | id | name | cost | quantity |
|--------+--------+----------------+--------+------------|
| item-1 | foo-23 | ground-nut oil | 567 | 1 |
| item-2 | foo-13 | almonds | 562.56 | 2 |
| item-3 | foo-02 | flour | 67 | 3 |
| item-4 | foo-31 | cereals | 76.09 | 2 |
+--------+--------+----------------+--------+------------+
5. Print entire DataFrame in plain-text format
Here we are going to display the entire dataframe in plain-text
format.
This is a format available in tabulate package. so we need to install this package.
Install tabulate using pip:
pip install tabulate
Syntax for this format:
tabulate(dataframe, headers='keys', tablefmt='plain-text')
where, dataframe is the input dataframe
Example: Python program to display the entire dataframe in plain-text format
# import the module
import pandas
from tabulate import tabulate
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay the entire dataframe in plain-text format
print(tabulate(dataframe, headers='keys', tablefmt='plain-text'))
Output:
id name cost quantity
------ ------ -------------- ------ ----------
item-1 foo-23 ground-nut oil 567 1
item-2 foo-13 almonds 562.56 2
item-3 foo-02 flour 67 3
item-4 foo-31 cereals 76.09 2
6. Print entire DataFrame in RST format
Here we are going to display the entire dataframe in RST
format. RST stands for restructured text .
This is a format available in tabulate package. so we need to install this package.
Install tabulate using pip:
pip install tabulate
Syntax for this format:
tabulate(dataframe, headers='keys', tablefmt='RST')
where, dataframe is the input dataframe
Example: Python program to display the entire dataframe in RST
format
# import the module
import pandas
from tabulate import tabulate
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay the entire dataframe in RST format
print(tabulate(dataframe, headers='keys', tablefmt='RST'))
Output:
id name cost quantity
------ ------ -------------- ------ ----------
item-1 foo-23 ground-nut oil 567 1
item-2 foo-13 almonds 562.56 2
item-3 foo-02 flour 67 3
item-4 foo-31 cereals 76.09 2
7. Print entire DataFrame in github format
Here we are going to display the entire dataframe in github
format.
This is a format available in tabulate package. so we need to install this package.
Install tabulate using pip:
pip install tabulate
Syntax for this format:
tabulate(dataframe, headers='keys', tablefmt='github ')
where, dataframe is the input dataframe
Example: Python program to display the entire dataframe in github format
# import the module
import pandas
from tabulate import tabulate
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay the entire dataframe in github format
print(tabulate(dataframe, headers='keys', tablefmt='github'))
Output:
| | id | name | cost | quantity |
|--------|--------|----------------|--------|------------|
| item-1 | foo-23 | ground-nut oil | 567 | 1 |
| item-2 | foo-13 | almonds | 562.56 | 2 |
| item-3 | foo-02 | flour | 67 | 3 |
| item-4 | foo-31 | cereals | 76.09 | 2 |
8. Print entire DataFrame in pretty format
Here we are going to display the entire dataframe in pretty
format.
This is a format available in tabulate package. so we need to install this package.
Install tabulate using pip:
pip install tabulate
Syntax for this format:
tabulate(dataframe, headers='keys', tablefmt='pretty')
where, dataframe is the input dataframe
Example: Python program to display the entire dataframe in pretty format
# import the module
import pandas
from tabulate import tabulate
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay the entire dataframe in pretty format
print(tabulate(dataframe, headers='keys', tablefmt='pretty'))
Output:
+--------+--------+----------------+--------+----------+
| | id | name | cost | quantity |
+--------+--------+----------------+--------+----------+
| item-1 | foo-23 | ground-nut oil | 567.0 | 1 |
| item-2 | foo-13 | almonds | 562.56 | 2 |
| item-3 | foo-02 | flour | 67.0 | 3 |
| item-4 | foo-31 | cereals | 76.09 | 2 |
+--------+--------+----------------+--------+----------+
9. Print entire DataFrame in tsv format
Here we are going to display the entire dataframe in tab separated value
format.
This is a format available in tabulate package. so we need to install this package.
Install tabulate using pip:
pip install tabulate
Syntax for this format:
tabulate(dataframe, headers='keys', tablefmt='tab')
where, dataframe is the input dataframe
Example: Python program to display the entire dataframe in tab format
# import the module
import pandas
from tabulate import tabulate
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay the entire dataframe in tab format
print(tabulate(dataframe, headers='keys', tablefmt='tab'))
Output:
id name cost quantity
------ ------ -------------- ------ ----------
item-1 foo-23 ground-nut oil 567 1
item-2 foo-13 almonds 562.56 2
item-3 foo-02 flour 67 3
item-4 foo-31 cereals 76.09 2
10. Print entire DataFrame in HTML format
Here we are going to display the entire dataframe in HTML (Hyper text markup language)
format.
This is a format available in tabulate package. so we need to install this package.
Install tabulate using pip:
pip install tabulate
Syntax for this format:
tabulate(dataframe, headers='keys', tablefmt='HTML')
where, dataframe is the input dataframe
Example: Python program to display the entire dataframe in HTML
format
# import the module
import pandas
from tabulate import tabulate
# consider the food data
food_input={'id':['foo-23','foo-13','foo-02','foo-31'],
'name':['ground-nut oil','almonds','flour','cereals'],
'cost':[567.00,562.56,67.00,76.09],
'quantity':[1,2,3,2]}
# pass this food to the dataframe by specifying rows
dataframe=pandas.DataFrame(food_input,index = ['item-1', 'item-2', 'item-3', 'item-4'])
# dispay the entire dataframe in HTML format
print(tabulate(dataframe, headers='keys', tablefmt='HTML'))
Output:
id name cost quantity
------ ------ -------------- ------ ----------
item-1 foo-23 ground-nut oil 567 1
item-2 foo-13 almonds 562.56 2
item-3 foo-02 flour 67 3
item-4 foo-31 cereals 76.09 2
Summary
In this article we discussed how to print entire dataframe in following formats:
- Markdown format
- psql format
- plain-text format
- RST format
- github format
- pretty format
- tsv format
- HTML format
References