pandas处理时间信息

pandas处理时间信息    

#index 处理
spNameList = multiRawData.index.levels[0].values
spNameListAll= multiRawData.droplevel(1).index.values

timeDelta = pd.Timedelta(days = 360)#超过60天即无效

CreateTimeStr= pd.Timestamp(datetime.now()).strftime('%Y-%m-%dT%H:%M:%S.%f')[0:-3]+'Z'#



#时间处理
startTime = pd.to_datetime('2023-07-22 18',format = '%Y-%m-%d %H')
startTime = pd.to_datetime(['2023-07-21'])#开始日期

endTimeHour = pd.to_datetime(endTimeHour,format='%Y%m%d%H')

# 时间增加
endTimeHour = endTimeHour + pd.DateOffset(hours = 1)

##产生时间间隔
timeInterval  = pd.date_range(startTimeHour,endTimeHour,freq='60T')#60T表示60min

## Timedelta  转成 秒数 
obsDurationSingle = (eTime-sTime).total_seconds()      #Timedelta  转成 秒数  

##时区
#更换时区格式
obsTime = pd.to_datetime(obsTime).replace(tzinfo=None)
#转换时区
obsTime.tz_localize('Asia/Shanghai')
obsTime.tz_convert('Asia/Shanghai')


#IDLE输出彩色
import sys
try: color = sys.stdout.shell
except AttributeError: raise RuntimeError("Use IDLE")

color.write("Yes","STRING")
color.write(" or ","KEYWORD")
color.write("No\n","COMMENT")

printComment = '正在读取{folder}含有{num}个dat文件\n'.format(folder = folderPath,num =len(datFileList))
color.write(printComment,"COMMENT")