PYTHON

pandas remove char from column

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

remove character(s)from each column in dataframe

for col in fromdatatable:
    fromdatatable[col] = fromdatatable[col].str.strip('þ') #remove þ from each column
    #fromdatatable[col] = fromdatatable[col].apply(lambda x: x.strip('þ')) #remove þ from each column
    #fromdatatable[col] = fromdatatable[col].apply(lambda x: x[1:-1]) #remove first and last characters from each column