from datetime import datetime
datetime.now()
#返回当前的时间点
datetime.now().year
datetime.now().month
datetime.now().day
#返回周几,加一因为是从0开始计数,所以。。
datetime.now().weekday()+1
datetime.now().isocalendar()
#2021年的第16周的第一天
datetime.now().isocalendar()[0]
datetime.now().isocalendar()[1]
datetime.now().isocalendar()[2]
#仅要日期
datetime.now().date()#仅要时刻
datetime.now().time()#格式的选择,Y-year,m-month,d-day,H-hour,M-minite,S-second
datetime.now().strftime('%Y-%m-%d')datetime.now().strftime('%Y-%m-%d %H:%M:%S')
#字符串和时间格式互换
now = datetime.now()
nowtype(now)
type(str(now))
str_time = '2021-4-19'
type(str_time)from dateutil.parser import parse
parse(str_time)type(parse(str_time))
#时间索引
import pandas as pd
import numpy as np
index = pd.DatetimeIndex(['2021-4-19','2021-4-20','2021-4-21','2021-4-22','2021-4-23','2021-4-24','2021-4-25','2021-4-26','2021-4-27','2021-4-28'])
data = pd.DataFrame(np.arange(1,11),columns = ["num"],index = index)
data
data["2021"]
data['2021-4-17':'2021-4-25']
import pandas as pd
df = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data5.xlsx")
df
df[df["注册时间"]==datetime(2018,8,8)]
df[df["注册时间"]>datetime(2018,8,9)]
df[(df["注册时间"]>datetime(2018,8,9))&(df["注册时间"]<datetime(2018,8,11))]
#注意&两边的条件要用()