How to align Output in pandas

Question

I am sure this is a duplicate question. However I wasn't able to find that directed me correctly. I am new so would appreciate any help available.

import pandas as pd

df = pd.DataFrame(index=['A','B','C'], columns=['x','y'])

print(df)

print("df.iloc[0]['x']:", df.iloc[0]['x'])

print(f'''df.iloc[0]: {df.iloc[0]}''')

prints

x    y
A  NaN  NaN
B  NaN  NaN
C  NaN  NaN
df.iloc[0]['x']: nan
df.iloc[0]: x    NaN
y    NaN
Name: A, dtype: object

[Program finished]

A similar question but with numpy has already been answered. Now the question is how should I get the prefix aligned in the third output? The numpy equivalent for similar is

print("Array:", np.array2string(array1, prefix ='Array:'))

Edit 1: Expected Output :

df.iloc[0]: x    NaN
            y    NaN
Name: A, dtype: object

I didn't get it what do you mean by aligned?

Pygirl
– Pygirl

2021-03-13 16:01:11 +00:00
Commented Mar 13, 2021 at 16:01 — Pygirl
– Pygirl, Commented Mar 13, 2021 at 16:01
posted expected output

Subham
– Subham

2021-03-13 16:11:34 +00:00
Commented Mar 13, 2021 at 16:11 — Subham
– Subham, Commented Mar 13, 2021 at 16:11

Pygirl · Accepted Answer · 2021-03-13 16:24:43Z

2

try replacing \n with spaces:

p = df.iloc[0].to_string().replace('\n','\n'+' '*12)
print('{:<11} {}'.format('df.iloc[0]:',p))

df.iloc[0]: x    NaN
            y    NaN

Source

formating info

answered Mar 13, 2021 at 16:24

Pygirl

13.4k6 gold badges36 silver badges48 bronze badges

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

3 Comments

Subham Over a year ago

I might sound noob but is that a syntax or you actually Counted till 12

Pygirl Over a year ago

@Subham: If there is a longer string then it will fail. yeah you are right I manually set it to 12 by counting.

Pygirl Over a year ago

@Subham: There is no other solution than this.

Collectives™ on Stack Overflow

How to align Output in pandas

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related