Python Pandas string replace time values not working

Question

I have a series of times in string format. I want to replace values in but it is not working. I feel like I am missing something simple. What is it?

Code

import pandas as pd
s = pd.Series(["08:05:00", "08:15:00", "08:25:00", "08:55:00", "09:05:00", "09:15:00", "09:25:00"])
print(s.dtype)
s.replace({"07:": "7:", "08:": "8:", "09:": "9:"}, inplace=True)

The output I get is.

object
0    08:05:00
1    08:15:00
2    08:25:00
3    08:55:00
4    09:05:00
5    09:15:00
6    09:25:00
dtype: object

what I want is:

0    8:05:00
1    8:15:00
2    8:25:00
3    8:55:00
4    9:05:00
5    9:15:00
6    9:25:00
dtype: object

Mohamed Thasin ah · Accepted Answer · 2022-08-04 16:00:13Z

1

Try this,

s.str.lstrip('0')

O/P;;

0    8:05:00
1    8:15:00
2    8:25:00
3    8:55:00
4    9:05:00
5    9:15:00
6    9:25:00
dtype: object

lstrip docs: https://pandas.pydata.org/docs/reference/api/pandas.Series.str.lstrip.html

answered Aug 4, 2022 at 16:00

Mohamed Thasin ah

11.2k11 gold badges65 silver badges120 bronze badges

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

Comments

Shane S · Accepted Answer · 2022-08-04 15:58:40Z

0

I found the solution which is in the s.replace line of code. Since the desire is to find beginning character of 0 then use of regex is better. The replacement line of code is below.

import pandas as pd
s = pd.Series(["08:05:00", "08:15:00", "08:25:00", "08:55:00", "09:05:00", "09:15:00", "09:25:00"])
print(s.dtype)
s.replace({"^0": ""}, regex=True, inplace=True)

answered Aug 4, 2022 at 15:58

Shane S

2,3633 gold badges25 silver badges50 bronze badges

Collectives™ on Stack Overflow

Python Pandas string replace time values not working

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related