Pandas command unintentionally shifting data between rows

Question

I have a pandas dataframe with a integer column called TDLINX. I'm trying to convert that to a string with leading zeros such that all values are 7 characters, with leading zeros. So 7 would become "0000007"

This is the code that I used:

df_merged_total['TDLINX2'] = df.TDLINX.apply(lambda x: str(x).zfill(7))

At first glance this appeared to work, but as I went further down the file, I realized that the value in TDLINX2 was starting to get shifted. What could be causing this and what can I do to prevent it?

Please show a self-contained example demonstrating your problem. — BrenBarn
– BrenBarn, Commented Apr 15, 2016 at 20:25
if your indices are not aligned between df_merged_total and df then you will observe an offset what does df_merged_total.index.difference(df.index) show? — EdChum
– EdChum, Commented Apr 15, 2016 at 20:43

o-90 · Accepted Answer · 2016-04-15 20:40:43Z

2

You could do something like this:

>>> df = pd.DataFrame({"col":[1, 33, 555, 7777]})
>>> df["new_col"] = ["%07d" % x for x in df.col]

>>> df

    col  new_col
0     1  0000001
1    33  0000033
2   555  0000555
3  7777  0007777

answered Apr 15, 2016 at 20:40

o-90

17.7k10 gold badges44 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Pandas command unintentionally shifting data between rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related