Python:是否在数据框中填充缺少的datetime值并向前填充? [英] Python:Fill in missing datetime values in dataframe and fill forward?

问题描述

假设我有一个数据框为:

Let's say I have a dataframe as:

|       timestamp     | value |
| ------------------- | ----- |
| 01/01/2013 00:00:00 |  2.1  |
| 01/01/2013 00:00:03 |  3.7  |
| 01/01/2013 00:00:05 |  2.4  |

我想将数据框设置为:

|       timestamp     | value |
| ------------------- | ----- |
| 01/01/2013 00:00:00 |  2.1  |
| 01/01/2013 00:00:01 |  2.1  |
| 01/01/2013 00:00:02 |  2.1  |
| 01/01/2013 00:00:03 |  3.7  |
| 01/01/2013 00:00:04 |  3.7  |
| 01/01/2013 00:00:05 |  2.4  |

我该怎么办?

推荐答案

您可以使用 resample 与 ffill :

You can use resample with ffill:

print (df.dtypes)
timestamp     object
value        float64
dtype: object

df['timestamp'] = pd.to_datetime(df['timestamp'])

print (df.dtypes)
timestamp    datetime64[ns]
value               float64
dtype: object

df = df.set_index('timestamp').resample('S').ffill()
print (df)
                     value
timestamp                 
2013-01-01 00:00:00    2.1
2013-01-01 00:00:01    2.1
2013-01-01 00:00:02    2.1
2013-01-01 00:00:03    3.7
2013-01-01 00:00:04    3.7
2013-01-01 00:00:05    2.4

---

df = df.set_index('timestamp').resample('S').ffill().reset_index()
print (df)
            timestamp  value
0 2013-01-01 00:00:00    2.1
1 2013-01-01 00:00:01    2.1
2 2013-01-01 00:00:02    2.1
3 2013-01-01 00:00:03    3.7
4 2013-01-01 00:00:04    3.7
5 2013-01-01 00:00:05    2.4

这篇关于Python:是否在数据框中填充缺少的datetime值并向前填充?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！