im trying to erase "." from a DataFrame column using the replace function but i have no idea why is not working. The currently column looks like:
Time
5:00 PM
4:00AM
3:30 P.M
2:00 .P.M
What i want is to change that column to a DataTime Hour type , but i think that i need to clean it first. So, in order to do that i want to erase the "." but when i use:
df.Time=df.Time.replace({'.':''})
still does not work. How can i do it?
CodePudding user response:
You can use
print(df.Time.str.replace('.','', regex=True))
CodePudding user response:
You can use:
df.Time=df.Time.apply(lambda x: x.replace('.',''))