求日期的年和该年的第几周，用于合并周数据

#  数据，来自数据库,指定日期第一段
sqlcmd1 = "select * from a_hisdata.hisdata_week order by ts_code,trade_date ASC"
df1 = pd.read_sql(sqlcmd1, dbconn)
df1 = df1.sort_values(by=['ts_code','trade_date'],ascending=True)
df1['trade_date'] =pd.to_datetime(df1['trade_date'])
print(df1.dtypes)
df1['week']=df1['trade_date'].dt.week
df1['year']=df1['trade_date'].dt.year
print(df1.head(3))