How to left align a dataframe column in python?

Question

Have to left align a description column in the pandas dataframe in python. Similar to left or right align a cell in excel sheet. is there any solution for this? Image attached for reference.

!Dataset

Try giving some more detail about the specifics of your problem and what you've tried. It's not clear exactly what the screenshot is showing and what you're trying to achieve — Sven Harris
– Sven Harris, Commented Nov 24, 2018 at 18:01
Description column in the dataset is right aligned. I just need left align it. Like how we use in excel left align,right align a cell. — rocky.im
– rocky.im, Commented Nov 24, 2018 at 18:06
a pandas DataFrame is an in memory table structure so has no concept of alignment. It looks like you're displaying it in some way but not clear in your question/screenshot how this is being done. So it's likely a display setting you need to change — Sven Harris
– Sven Harris, Commented Nov 24, 2018 at 18:08
Okay understood. Thank you. I have updated the question and image. — rocky.im
– rocky.im, Commented Nov 24, 2018 at 18:26

Zion Oyemade · Accepted Answer · 2019-05-08 13:58:45Z

5

Try this

df.style.set_properties(subset=["col1", "col2"], **{'text-align': 'right'})

answered May 8, 2019 at 13:58

Zion Oyemade

4436 silver badges18 bronze badges

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

Comments

Biswadip Mandal · Accepted Answer · 2018-11-24 18:04:35Z

-1

I think you can just remove the leading spaces.

df.Description = df.Description.apply(lambda row: row.lstrip(' '))

answered Nov 24, 2018 at 18:04

Biswadip Mandal

5441 gold badge4 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to left align a dataframe column in python?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related