Truncating all values in a column pandas

Question

I am attempting to truncate column values in pandas after dividing by a number. Here are the two methods I have tried:

df['new'] = int('%.0f'%(df['old']/12))

df['new'] = int(df['old']/12)

Each time I get type errors:

cannot convert the series to <class 'float'>
cannot convert the series to <class 'int'>

How can I solve this problem while avoiding these errors?

Does `df['new'] = df['old'] // 12` do what you're after? – Jon Clements Nov 12 '18 at 17:22 — Jon Clements, Nov 12 '18 at 17:22
@JonClements Perfect! Thank you very much. – a.powell Nov 12 '18 at 17:24 — a.powell, Nov 12 '18 at 17:24

score 1 · Answer 1 · answered Nov 12 '18 at 17:26

1

The code needs to convert the Series generated by the division into int.

df['new'] = (df['old'] / 12).astype(int)

answered Nov 12 '18 at 17:26

jeevs

1 Answers1