如果我分別在 x 軸和 y 軸上繪制以下年度人口數據，如何從圖中獲取 10 年的每日數據，就像我希望能夠從使用創建的曲線中獲取每天的人口這個數據那可能嗎？ 2020 713,000
2019 703,000
2018 694,000
2017 684,000
2016 674,000
2015 664,000
2014 655,000
2013 645,000
2012 636,000
2011 627,000
1 回答
慕斯王
TA貢獻1864條經驗 獲得超2個贊
import numpy as np
from datetime import datetime,timedelta
import pandas as pd
# make your data a frame
df = pd.DataFrame([[2020, 713000],
[ 2019, 703000],
[ 2018, 694000],
[ 2017, 684000],
[ 2016, 674000],
[ 2015, 664000],
[ 2014, 655000],
[ 2013, 645000],
[ 2012, 636000],
[ 2011, 627000]], columns=['DateTime','pop'])
# make DateTime column an datetime object
df['DateTime'] = df['DateTime'].apply(lambda x: datetime(x,1,1))
# create a time range for each day in your period
time_range = np.arange(datetime(2011, 1,1), datetime(2021,1,1), timedelta(days=1))
# make time_range a frame
af = pd.DataFrame(time_range, columns=['DateTime'])
# merge both together (left join on column DateTime) and interpolate the gaps
df = af.merge(df, on='DateTime', how='left').interpolate()
print(df)
添加回答
舉報
0/150
提交
取消