首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何在熊猫数据帧中转发填充NaN值?

如何在熊猫数据帧中转发填充NaN值?
EN

Stack Overflow用户
提问于 2019-05-14 07:36:33
回答 1查看 245关注 0票数 0

我有以下熊猫资料:

代码语言:javascript
复制
        S.No.           Name                  DOB Gender  Profile/work Order-History  
    0     1.0      Sam Smith  1989-01-05 00:00:00   Male         abc     A
    1     NaN            NaN                  NaN    NaN         NaN     B
    2     NaN            NaN                  NaN    NaN         NaN     C   
    3     NaN            NaN                  NaN    NaN         NaN     D   
    4     NaN            NaN                  NaN    NaN         NaN     E   
    5     NaN            NaN                  NaN    NaN         NaN     F  
    6     NaN            NaN                  NaN    NaN         NaN     G   
    7     NaN            NaN                  NaN    NaN         NaN     H   
    8     NaN            NaN                  NaN    NaN         NaN     I   

如何转发填充NaN值以实现以下所需的输出?

代码语言:javascript
复制
    S.No.           Name                  DOB Gender  Profile/work  Order-History
0     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         A   
1     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         B
2     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         C
3     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         D
4     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         E
5     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         F
6     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         G
7     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         H
8     1.0      Sam Smith  1983-12-29 00:00:00   Male  abc         I
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-05-14 07:40:56

对于我来说,如果所有数据都在第二行(第一行是标题),则向前填充缺失的值:

代码语言:javascript
复制
df = pd.read_excel('file.xlsx').ffill()
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/56125187

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档