w3resource

Pandas: Print DataFrame without index

Pandas Indexing: Exercise-23 with Solution

Write a Pandas program to print a DataFrame without index.

Sample Solution:

Python Code :

import pandas as pd
df = pd.DataFrame({
    'school_code': ['s001','s002','s003','s001','s002','s004'],
    'class': ['V', 'V', 'VI', 'VI', 'V', 'VI'],
    'name': ['Alberto Franco','Gino Mcneill','Ryan Parkes', 'Eesha Hinton', 'Gino Mcneill', 'David Parkes'],
    'date_of_birth': ['15/05/2002','17/05/2002','16/02/1999','25/09/1998','11/05/2002','15/09/1997'],
    'weight': [35, 32, 33, 30, 31, 32]},
     index =  [1, 2, 3, 4, 5, 6])
print("Original DataFrame with single index:")
print(df)
print("\nDataFrame without index:")
print(df.to_string(index=False))

Sample Output:

Original DataFrame with single index:
  school_code class            name date_of_birth  weight
1        s001     V  Alberto Franco    15/05/2002      35
2        s002     V    Gino Mcneill    17/05/2002      32
3        s003    VI     Ryan Parkes    16/02/1999      33
4        s001    VI    Eesha Hinton    25/09/1998      30
5        s002     V    Gino Mcneill    11/05/2002      31
6        s004    VI    David Parkes    15/09/1997      32

DataFrame without index:
school_code class            name date_of_birth  weight
      s001     V  Alberto Franco    15/05/2002      35
      s002     V    Gino Mcneill    17/05/2002      32
      s003    VI     Ryan Parkes    16/02/1999      33
      s001    VI    Eesha Hinton    25/09/1998      30
      s002     V    Gino Mcneill    11/05/2002      31
      s004    VI    David Parkes    15/09/1997      32

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to insert a column at a specific index in a given DataFrame.
Next: Write a Pandas program to find integer index of rows with missing data in a given dataframe.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/python-exercises/pandas/index/pandas-indexing-exercise-23.php