How to print pandas Dataframe without index?

0 votes

I have imported a CSV file in Python using pandas. Now when I try to print it, it displays the contents along with the index. I don’t want to print the index. How can I exclude the index and print only the contents?

This is the code I am using

import pandas as pd
filedata = pd.read_csv(“/home/user/data1”)
print (filedata)

Output:

1 Kia

2 Benz

3 Chevvy

4 Bugatti

5 Ford

6 Fiat
Mar 28, 2019 in Python by John
1,656 views

1 answer to this question.

0 votes

You can print the dataframe without index by converting the dataframe to strong with index as false. Try this:

import pandas as pd
filedata = pd.read_csv(“/home/user/data1”)
print (filedata.tostring(index=False))
answered Mar 28, 2019 by Shri

Related Questions In Python

0 votes
1 answer

How to print the index of a Pandas Dataframe?

You can do this using the code ...READ MORE

answered May 12, 2019 in Python by Usha
123 views
0 votes
1 answer

How to append dataframe without index?

You have to use the ignore_index option. ...READ MORE

answered Apr 1, 2019 in Python by Robert
125 views
0 votes
1 answer

How to get value in Pandas dataframe using index?

You can use the iloc method to do ...READ MORE

answered Apr 8, 2019 in Python by Rohit
287 views
0 votes
1 answer

How to print rows at different locations of pandas dataframe?

Like you are using row slicing, you ...READ MORE

answered May 12, 2019 in Python by Gani
40 views
0 votes
1 answer
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 6, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 549 views
0 votes
0 answers
+4 votes
6 answers
+1 vote
1 answer

How to print one pandas column without index?

There is a slight mistake in what ...READ MORE

answered Mar 28, 2019 in Python by Shri
3,183 views
0 votes
1 answer

How to print all the index of Pandas Dataframe?

Try this: print(df.index.values) READ MORE

answered Apr 8, 2019 in Python by Yogi
62 views