python如何读取数据框中的数据_根据python中的索引数据框获取值

data2 = pd.read_excel(fpath2,header = [0,1,2])

a = data2[1][0] #1 represents month - Jan, 0 represents whether it is weekday

结果是这样的：Timestamp L U

00:00:00 239.90 394.04

01:00:00 228.30 400.57

02:00:00 195.42 395.23

03:00:00 166.02 390.32

04:00:00 143.73 373.59

05:00:00 135.43 355.78

06:00:00 79.48 359.10

........................

我想要做的是根据特定时间得到L（低频段）和U（高频段）值，例如在凌晨5点。如果有人能帮助我，我将非常感激。

加载的文件是这样的：1 # First header

0 | 1 # Second haeder

Timestamp L | U L | U # Third header

0:00 239.9 394.04 252.9 344.22

1:00 228.3 400.57 240.34 323.33

2:00 195.42 395.23 214.07 288.09

3:00 166.02 390.32 183.05 262.1

4:00 143.73 373.59 158.42 244.5

5:00 135.43 355.78 136.85 419.55

6:00 79.48 359.1 126.33 597.67

我试过了a = data2[1][0][5:00]

但它给了我空数据帧的结果Empty DataFrame

Columns: [L, U]

Index: []

我尝试a = data2 [5:00]时甚至很奇怪，它给了我：Empty DataFrame

Columns: [(1, 0, L), (1, 0, U), (1, 1, L), (1, 1, U), (2, 0, L), (2, 0, U), (2, 1, L), (2, 1, U), (3, 0, L), (3, 0, U), (3, 1, L), (3, 1, U), (4, 0, L), (4, 0, U), (4, 1, L), (4, 1, U), (5, 0, L), (5, 0, U), (5, 1, L), (5, 1, U), (6, 0, L), (6, 0, U), (6, 1, L), (6, 1, U), (7, 0, L), (7, 0, U), (7, 1, L), (7, 1, U), (8, 0, L), (8, 0, U), (8, 1, L), (8, 1, U), (9, 0, L), (9, 0, U), (9, 1, L), (9, 1, U), (10, 0, L), (10, 0, U), (10, 1, L), (10, 1, U), (11, 0, L), (11, 0, U), (11, 1, L), (11, 1, U), (12, 0, L), (12, 0, U), (12, 1, L), (12, 1, U)]

Index: []

[0 rows x 48 columns]