How to set column name from column value in Pandas Python?

I have a data frame that looks like the following.

Here, the column values represent the distance and time, in meters and seconds (57: 9 means 57 meters and 9 seconds). I want to rename my column such that the meter value becomes column name and the seconds value remains as a column value. Moreover, the columns where values are None, they should be replaced by Zero (0).

Desired output:

I am new to python so I don’t know how I can achieve that.

>Solution :

First split each column by : with select last splitted values and replace to missing values, for columns forward filling missing values with select last row and after split select first values:

df1 = df.apply(lambda x: x.str.split(': ').str[-1]).fillna(0)
df1.columns = df.ffill().iloc[-1].str.split(': ').str[0].tolist()
print (df1)
    0  57 11469 436 11469 203
0   2   9     0  77  1018  44
1   0  15     0  47     0  89
2  45   0  1116   7     0   0
3   1  23     0   0    18   0
4  23   5     0  63     0   4