df['result'] = df['result'].str.replace(r'D', '') df time result 1 09:00 52 2 10:00 62 3 11:00 44 4 12:00 30 5 13:00 110