我想將每月數(shù)據(jù)拆分為每周,并使用每周所指的相同每月值填充每周行。這些變量是我需要處理的變量?!伴_始日期”非空 datetime64[ns] “結(jié)束日期”非空 datetime64[ns]import pandas as pddf = pd.read_excel("file")import pandas as pdimport math, datetimed1 = datetime.date(yyyy, mm, dd)d2 = datetime.date(yyyy, mm, dd)h = []while d1 <= d2: print(d1) d1 = d1 + datetime.timedelta(days=7) h.append(d1)df = pd.Series(h)print(df)我已經(jīng)嘗試過上面的代碼,但我認(rèn)為它完全沒用:這是我的數(shù)據(jù)集中的內(nèi)容:price starting date ending date model 1000 2013-01-01 2013-01-14 blue 598 2013-01-01 2013-01-14 blue 156 2013-01-15 2013-01-28 red這就是我想得到的:weekly date price model 2013-01-01 1000 blue 2013-01-01 598 blue 2013-01-08 1000 blue 2013-01-08 598 blue 2013-01-15 156 red 2013-01-22 156 red
添加回答
舉報(bào)
0/150
提交
取消