How to Print Pandas DataFrame with No Index


You can use the following methods to print a pandas DataFrame without the index:

Method 1: Use to_string() Function

print(df.to_string(index=False))

Method 2: Create Blank Index Before Printing

df.index=[''] * len(df)

print(df)

Both methods will print the DataFrame without the index.

The following examples show how to use each method with the following pandas DataFrame:

import pandas as pd

#create DataFrame
df = pd.DataFrame({'team': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],
                   'points': [18, 22, 19, 14, 14, 11, 20, 28],
                   'assists': [5, 7, 7, 9, 12, 9, 9, 4],
                   'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]})

#view DataFrame
print(df)

  team  points  assists  rebounds
0    A      18        5        11
1    B      22        7         8
2    C      19        7        10
3    D      14        9         6
4    E      14       12         6
5    F      11        9         5
6    G      20        9         9
7    H      28        4        12

Notice that the DataFrame contains an index with values ranging from 0 to 7.

Example 1: Use to_string() Function

The following code shows how to use the to_string() function to print the DataFrame without the index:

#print DataFrame without index
print(df.to_string(index=False))

team  points  assists  rebounds
   A      18        5        11
   B      22        7         8
   C      19        7        10
   D      14        9         6
   E      14       12         6
   F      11        9         5
   G      20        9         9
   H      28        4        12

Notice that all four columns are printed without the index column.

Example 2: Create Blank Index Before Printing

The following code shows how to first create an index column with all blank values and then print the DataFrame:

#define index to have all blank values
df.index=[''] * len(df)

#print DataFrame
print(df)

 team  points  assists  rebounds
    A      18        5        11
    B      22        7         8
    C      19        7        10
    D      14        9         6
    E      14       12         6
    F      11        9         5
    G      20        9         9
    H      28        4        12

Notice that all four columns are printed without the index column.

Also notice that this example matches the DataFrame that we printed in the previous example.

Additional Resources

The following tutorials explain how to perform other common tasks in pandas:

How to Show All Rows of a Pandas DataFrame
How to Flatten MultiIndex in Pandas DataFrame
How to Transpose a Pandas DataFrame without Index

Leave a Reply

Your email address will not be published.