Stripping 0's from the middle of a dataframe

user_9571733 0
Viewed 35

Basically data is coming into my program in this format 0xxxx000xxxx where the x is unique to the data that I have in another system. I'm trying to remove those 0's as they're always in the same place. I tried

df['item'] = df['item'].str.replace('0','')

but sometimes the x can be a 0 and will get rid of it. I'm not sure how to get rid of just the 0's in those specific positions.

EX: Input: 099890000890

Output (Desired): 99890890

pandas dataframe python
1 Answers

Use the str accessor for indexing:

df['item'] = df['item'].str[1:5] + df['item'].str[8:]

Or str.replace:

df['item'] = df['item'].str.replace(r'0(.{4})000(.{4})', r'\1\2', regex=True)

Output (as new column. Item2):

           item     item2
0  099890000890  99890890
user_163434640
Related