How to justify columns in pandas?

Question

The original data frame:

       B    C  D 
0     OE   EG  A
1     CA   EG  A
2     HA1  EG  A
3     HA2  EG  A
4  CB      EG  A
5     HB1  EG  A

The desired data frame:

       B    C  D 
0     OE   EG  A
1     CA   EG  A
2     HA1  EG  A
3     HA2  EG  A
4     CB   EG  A
5     HB1  EG  A

and I want to control spaces among columns!

It seems related to this question https://stackoverflow.com/questions/43332057/pandas-strip-white-space — Andrea Di Iura, Mar 14 '22 at 20:50

score 0 · Answer 1 · answered Mar 14 '22 at 20:55

0

Try this:

str_cols = df.select_dtype('object')
df[str_cols.columns] = str_cols.apply(lambda col: col.str.strip())

answered Mar 14 '22 at 20:55

richardec

'DataFrame' object has no attribute 'select_dtype' – Elsaid Sami Elsaid Mohamed Mar 16 '22 at 10:51

score 0 · Accepted Answer · answered Mar 26 '22 at 20:08

0

I found an answer it is related somehow to old style format:

dx['A'] = dx['A'].map('{:6s}'.format)

answered Mar 26 '22 at 20:08

2 Answers2