将世界时转化为北京时
Python:
time_BJ = datetime.datetime.strptime(time_UTC,'%Y-%m-%d %H:%M') + datetime.timedelta(hours=8) #时间格式为2016-01-01 00:00 ------>2016-01-01 08:00 (单个数据转化)
for i in range(data_list1.shape[0]):
data_list1.iloc[i,7] = datetime.datetime.strptime(data_list1.iloc[i,6],'%Y-%m-%d %H:%M') + datetime.timedelta(hours=8) #dataframe中一列数据转化,这个方式转化特别慢!!!!!!
Excel:
=TEXT(C2,"0")&TEXT(D2,"0#")&TEXT(E2,"0#")&TEXT(F2,"00") # 2016 01 01 00 四列数据合并成 2016010100的格式
=TEXT(DATE(LEFT(G2,4),MID(G2,5,2),MID(G2,7,2))+RIGHT(G2,2)/24+1/3,"yyyy-mm-dd hh:mm")
# 将2016010100世界时的数据转化为北京时并写成 2016-01-01 08:00
#excel 处理一列速度很快!!!!!!