Printing a data frame without index - Python

Question

I have this Employee data.frame:

    Names    Designation
0    Raj         CTO
1   Rohit       Developer
2    Sam         CFO
3    Ane         CEO

I would want to print this data.frame without the index values, how can i do it?

Comments

df.style.hide_index()

should do the trick

---

Hey thanks for sharing this trick. It really worked.

---

great ! I was looking for the solution for hours :)

---

could you pls give the exact syntax to use style.hide_index().

Answer 1

You can convert the data-frame to a string and say index=False.

Below is the command:

print(Employee.to_string(index=False))

Names Designation
  Raj         CTO
Rohit   Developer
  Sam         CFO
  Ane         CEO

Hope it works!!

If you are a beginner and need to know more about Python, It's recommended to go for Python Certification course today.

Thanks!

Comments

Hi,

Anyone can help me with this...

I tried both option to print without index, also I tried myself when export to excel too,  but it still index displays.

-->Tried with 3 options...

df.style.hide_index()

print(df3.to_string(index=False))

df3.to_excel(xlwriter, sheet_name='Hindi Student', index=False)

-->My data I have like below where I am trying to export to excel

df2=df['Name'].where(df['Language'] == 'Hindi').dropna()

df3 = pd.DataFrame({'stud_sec':[section],'ListofPeople':[df2]})

print(df3)

Would appreciate your earliest response on this......

---

When you load your dataset, that time you can drop your index values and column name.

---

This doesn't seem to work for me

Answer 2

Data Frame has a property named "index" which is set to true by default. If you want to print values without index then you have to set this property to false. 

print (df.to_string(index = False))

Interested in a career in data analysis? Our Data Analyst Course will equip you with the tools and techniques you need to succeed.

Answer 3

import pandas

d = ['a','b','c','d','e']
df = pandas.DataFrame(data=d)
print (df.to_string(index = False))

Output:

0
a
b
c
d
e

Answer 4

.tolist() function will remove index

Answer 5

Hi,

At the time of printing the data frame, you can drop the index with the index key as shown below.

print df.to_string(index=False)