我試圖滿足這個要求,我想在我的資料框中有一個帶有周數的列,基于資料中存在的天數、月數。這是下面的代碼 -
import pandas as pd
import numpy as np
s={'yr':[2014,2014,2014,2014,2015,2015,2015,2015],'Month':['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug'],'Days':[12,24,11,22,10,15,22,3]}
p=pd.DataFrame(data=s)

import datetime
p['week']=datetime.date(p['yr'], p['Month'], p['Days']).isocalendar().week
I am getting the below error-
TypeError: cannot convert the series to <class 'int'>
我不確定如何解決此錯誤,我想我也需要將月份轉換為數字格式,如何才能做到這一點并獲得日期中的周數?
uj5u.com熱心網友回復:
這條線不太好,但它有效:
p['week'] = [datetime.datetime.strptime(str(p['yr'][i]) p['Month'][i] str(p['Days'][i]), '%Y%b%d').isocalendar()[1] for i in range(len(p))]
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/456363.html
