我有這個資料框缺少一些時間（我希望它是每一分鐘）。請參閱下面的示例：
time = np.array([pd.to_datetime("2022-01-01 00:00:00"),pd.to_datetime("2022-01-01 00:00:01"),pd.to_datetime("2022-01-01 00:00:03"), pd.to_datetime("2022-01-01 00:00:04"),pd.to_datetime("2022-01-01 00:00:07"),pd.to_datetime("2022-01-01 00:00:09"), pd.to_datetime("2022-01-01 00:00:10")])
lat = [58.1, 58.4, 58.5, 58.9, 59,59.2, 59.5]
lng = [1.34, 1.44, 1.46, 1.48, 1.55, 1.57, 1.59]
df = pd.DataFrame({"time": time, "lat": lat, "lng" :lng})
time lat lng
2022-01-01 00:00:00 58.1 1.34
2022-01-01 00:00:01 58.4 1.44
2022-01-01 00:00:03 58.5 1.46
2022-01-01 00:00:04 58.9 1.48
2022-01-01 00:00:07 59.0 1.55
2022-01-01 00:00:09 59.2 1.57
2022-01-01 00:00:10 59.5 1.59
我想及時填補空白，以便每分鐘都有資料，并且用中間值的平均值填充緯度/經度。我的計劃是為每分鐘創建一個時間陣列，并嘗試使用 ffil 或類似的東西來填補缺失的點。但我無法弄清楚如何。預期的輸出將是這個
time lat lng
2022-01-01 00:00:00 58.1 1.34
2022-01-01 00:00:01 58.4 1.44
2022-01-01 00:00:01 58.45 1.45
2022-01-01 00:00:03 58.5 1.46
2022-01-01 00:00:04 58.9 1.48
2022-01-01 00:00:05 58.933 1.5033
2022-01-01 00:00:06 58.966 1.5233
2022-01-01 00:00:07 59.0 1.55
2022-01-01 00:00:08 59.1 1.56
2022-01-01 00:00:09 59.2 1.57
2022-01-01 00:00:10 59.5 1.59
請給我一些關于如何做到這一點的建議
uj5u.com熱心網友回復：
創建DatetimeIndex然后按 div 添加丟失的時間。DataFrame.asfreq并插值DataFrame.interpolate：
df = df.set_index('time').asfreq(freq='S').interpolate()
print (df)
lat lng
time
2022-01-01 00:00:00 58.100000 1.340000
2022-01-01 00:00:01 58.400000 1.440000
2022-01-01 00:00:02 58.450000 1.450000
2022-01-01 00:00:03 58.500000 1.460000
2022-01-01 00:00:04 58.900000 1.480000
2022-01-01 00:00:05 58.933333 1.503333
2022-01-01 00:00:06 58.966667 1.526667
2022-01-01 00:00:07 59.000000 1.550000
2022-01-01 00:00:08 59.100000 1.560000
2022-01-01 00:00:09 59.200000 1.570000
2022-01-01 00:00:10 59.500000 1.590000
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/452702.html