# 提取一年数据
df['2020'].head()
Out[42]:
detectorID Vol_L1 Ocp_L1 ... Vol_L8 Ocp_L8 Sp_L8
GlobalTime ...2020-01-0300:00:1240327630.0200... NaN NaN NaN
2020-01-0300:00:4240327610.0067... NaN NaN NaN
2020-01-0300:01:1240327630.0206... NaN NaN NaN
2020-01-0300:01:4240327620.0106... NaN NaN NaN
2020-01-0300:02:1240327620.0106... NaN NaN NaN
[5 rows x 25 columns]# 提取1月份数据
df['2020-1']# 提取1月3日数据
df['2020-1-4']# 提取1月4日21点数据
df['2020-1-4 21']# 提取1月4日21点45分数据
df['2020-1-4 21:45']
Out[52]:
detectorID Vol_L1 Ocp_L1 ... Vol_L8 Ocp_L8 Sp_L8
GlobalTime ...2020-01-0421:45:1240327640.0239... NaN NaN NaN
2020-01-0421:45:4240327640.0239... NaN NaN NaN
[2 rows x 25 columns]