如果我分別在 x 軸和 y 軸上繪制以下年度人口數(shù)據(jù)，如何從圖中獲取 10 年的每日數(shù)據(jù)，就像我希望能夠從使用創(chuàng)建的曲線中獲取每天的人口這個數(shù)據(jù)那可能嗎？ 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
提交
取消