Printing a pandas dataframe without row number/index [duplicate]

Question

Using the following code:

predictions  = pd.DataFrame([x6,x5,x4,x3,x2,x1])
print(predictions)

Prints the following in the console:

            0
0  782.367392
1  783.314159
2  726.904744
3  772.089101
4  728.797342
5  753.678877

How do I print predictions without row (0-5) or column (0) indexes?

In R the code would look like:

print(predictions, row.names = FALSE)

You can simply use as print(predictions.to_string(index=False)) — niraj
– niraj, Commented Sep 19, 2018 at 0:59
Great it worked! I did not add answer since it was already answered. Happy Coding. :) — niraj
– niraj, Commented Sep 19, 2018 at 1:06

yoonghm · Accepted Answer · 2018-09-19 01:01:41Z

17

print(df.to_string(index=False, header=False))

answered Sep 19, 2018 at 1:01

yoonghm

4,7051 gold badge40 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alexander Over a year ago

That looks nice. You could also do some rounding before printing, e.g. df.round(2).to_string(...)

Alexander · Accepted Answer · 2018-09-19 00:59:04Z

4

print(predictions.values.tolist())

Or

df = pd.DataFrame(np.random.randn(5, 3), columns=list('ABC'))

>>> for row in df.values: print(row)
[-1.09989127 -0.17242821 -0.87785842]
[ 0.04221375  0.58281521 -1.10061918]
[ 1.14472371  0.90159072  0.50249434]
[ 0.90085595 -0.68372786 -0.12289023]
[-0.93576943 -0.26788808  0.53035547]

edited Sep 19, 2018 at 0:59

answered Sep 19, 2018 at 0:56

Alexander

111k32 gold badges212 silver badges208 bronze badges

2 Comments

ZJAY Over a year ago

That returns: [[782.3673915172626], [783.314158724909], [726.9047442598429], [772.0891010290351], [728.7973416236138], [753.67887656913]] - I'm not looking to return brackets or commas, just numbers

Alexander Over a year ago

I just answered this related question about 10 mins ago. stackoverflow.com/questions/52396315/…

U13-Forward · Accepted Answer · 2018-09-19 01:35:33Z

2

Or use:

predictions[0].tolist()

Or can do something like:

'\n'.join(map(str,predictions[0].tolist()))

Or can do:

for i in str(df).splitlines()[1:]:
    print(i.split(None,1)[1])

Or want to assign to string:

s=''
for i in str(df).splitlines()[1:]:
    s+=i.split(None,1)[1]+'\n'
print(s.rstrip())

edited Sep 19, 2018 at 1:35

answered Sep 19, 2018 at 0:59

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

2 Comments

ZJAY Over a year ago

This still has commas, anyway to just simply print the numbers in the dataframe?

U13-Forward Over a year ago

@ZJAY Then do, '\n'.join(map(str,predictions[0].tolist()))

Collectives™ on Stack Overflow

Printing a pandas dataframe without row number/index [duplicate]

3 Answers 3

1 Comment

2 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

2 Comments

Linked

Related