输入数据集示例:
DateTime,A,B
2001-2-28T00:00:01,1.3,2.1
2001-2-28T00:00:02,nan,2.7
2001-2-28T00:00:05,1.1,2.9
2001-2-28T00:00:08,nan,2.9
2001-2-28T00:00:10,nan,2.3
2001-2-28T00:00:25,1.2,2,4
...
2020-2-28T00:00:50,1.9,3.6
2020-2-28T00:01:48,1.8,nan
2020-2-28T00:00:52,1.7,nan
2020-2-28T00:00:25,1.9,2.6
你知道吗dtf.fillna公司(method='ffill',limit='1Min',limit\u reference='DateTime')
预期结果:
DateTime,A,B
2001-2-28T00:00:01,1.3,2.1
2001-2-28T00:00:02,1.3,2.7
2001-2-28T00:00:05,1.1,2.9
2001-2-28T00:00:08,1.1,2.9
2001-2-28T00:00:10,1.1,2.3
2001-2-28T00:00:25,1.2,2,4
...
2020-2-28T00:00:50,1.9,3.6
2020-2-28T00:01:48,1.8,3.6
2020-2-28T00:00:52,1.7,nan
2020-2-28T00:00:25,1.9,2.6
不想像在另一个例子中建议的那样重新采样数据,因为数据量太大,无法定期采样,也不想创建“假”样本,只想为其中一个传感器读数缺失的样本填充nan值: Python Pandas fillna with timedelta
目前没有回答
相关问题 更多 >
编程相关推荐