Notebook
In [60]:
import pandas as pd
In [61]:
hp = pd.DataFrame(data=[['1-1-2020', 1, 'one'], 
                        ['2-1-2020', 2, 'two'],
                        ['3-1-2020', 3, 'three']
                       ],
                   columns=['date', 'hour', 'player'])
hp
Out[61]:
date hour player
0 1-1-2020 1 one
1 2-1-2020 2 two
2 3-1-2020 3 three
In [62]:
hp['game_date_str'] = hp['date'] + ':' + hp['hour'].astype(str)
hp
Out[62]:
date hour player game_date_str
0 1-1-2020 1 one 1-1-2020:1
1 2-1-2020 2 two 2-1-2020:2
2 3-1-2020 3 three 3-1-2020:3
In [63]:
hp['game_date'] = pd.to_datetime(hp['game_date_str'], format="%d-%m-%Y:%H")
hp
Out[63]:
date hour player game_date_str game_date
0 1-1-2020 1 one 1-1-2020:1 2020-01-01 01:00:00
1 2-1-2020 2 two 2-1-2020:2 2020-01-02 02:00:00
2 3-1-2020 3 three 3-1-2020:3 2020-01-03 03:00:00
In [64]:
hp = hp.set_index(['game_date', 'player'])
hp
Out[64]:
date hour game_date_str
game_date player
2020-01-01 01:00:00 one 1-1-2020 1 1-1-2020:1
2020-01-02 02:00:00 two 2-1-2020 2 2-1-2020:2
2020-01-03 03:00:00 three 3-1-2020 3 3-1-2020:3
In [ ]: