我想用一列中已经存在的值填充一列。我的意思是所有值都应该是'Texas'或另一个值(该列中存在哪个值)。我尝试了ffill和bfill,它可以正常工作,但是有很多数据框具有这样的nan值,但是每个位置的位置不同数据框。如您所见,顶部和底部的值均为“ nan”,因此填充和填充无效。如何用“德州”填充nan值?
Date Country
2019-11-10 00:00:00 nan
2019-11-10 01:00:00 Texas
2019-11-10 02:00:00 Texas
2019-11-10 03:00:00 nan
2019-11-10 04:00:00 nan
2019-11-10 05:00:00 Texas
2019-11-10 06:00:00 nan
2019-11-10 07:00:00 Texas
2019-11-10 08:00:00 nan
2019-11-10 09:00:00 Texas
2019-11-10 10:00:00 nan
2019-11-10 11:00:00 nan
2019-11-10 12:00:00 Texas
2019-11-10 13:00:00 Texas
2019-11-10 14:00:00 nan
2019-11-10 15:00:00 nan
2019-11-10 16:00:00 nan
2019-11-10 17:00:00 Texas
2019-11-10 18:00:00 nan
2019-11-10 19:00:00 nan
2019-11-10 20:00:00 nan
2019-11-10 21:00:00 Texas
2019-11-10 22:00:00 Texas
2019-11-10 23:00:00 nan
.
.
.
2019-11-20 23:00:00 nan