我有一个示例数据框,如下所示
import pandas as pd
import numpy as np
NaN = np.nan
data = {'ID':['A','A','A','A','A','A','A','A','A','C','C','C','C','C','C','C','C'],
'Week': ['Week1','Week1','Week1','Week1','Week2','Week2','Week2','Week2','Week3',
'Week1','Week1','Week1','Week1','Week2','Week2','Week2','Week2'],
'Risk':['High','','','','','','','','','High','','','','','','',''],
'Testing':[NaN,'Pos',NaN,'Neg',NaN,NaN,NaN,NaN,'Pos', NaN,
NaN,NaN,'Negative',NaN,NaN,NaN,'Positive'],
'CloseContact': [NaN, 'True', NaN, NaN, 'False',NaN, NaN, 'False', 'True',
NaN, NaN, 'False', NaN, 'True','True','False', NaN ]}
df1 = pd.DataFrame(data)
df1
现在,必须创建两列CC1和CC2。对于每个ID,对于每个星期(重要),CC1将获得“CloseContact”列的第一个非空值,CC2将获得“CloseContact”列的第二个非空值
最终的数据帧应该如下图所示
非常感谢您的帮助。多谢各位
尝试:
原始DF:
最终输出:
就像你的previous question:
输出:
相关问题 更多 >
编程相关推荐