合并/连接逐行 PANDAS 数据帧

Question

我有以下数据帧：

Date/Time           P1      P2      P83     ON      OFF
2014-01-13 11:41                    path 83     
2014-01-13 11:41                                    offline
2014-03-26 14:37    path 1              
2014-03-26 14:37                                    offline
2014-03-26 14:37                    path 83     
2014-03-26 15:33    path 1              
2014-03-26 15:33                            online  
2014-04-25 5:44             path 2          
2014-04-25 5:44                                     offline

我想合并具有相同索引的行并填充列。永远不会有一列具有同一索引的值的情况，即列值不会崩溃。所需的输出是如下所示的数据帧：

Date/Time           P1      P2      P3      ON      OFF
2014-01-13 11:41                    path 83         offline
2014-03-26 14:37    path 1          path 83         offline
2014-03-26 15:33    path 1                  online
2014-04-25 5:44             path 2                  offline

非常感谢:)

Answer 1

按键分组并应用.first()

agg = df.groupby('Date/Time').first()

为"状态"创建新列：

agg['STATUS'] = agg['ON'].fillna(agg['OFF'])

如果需要，删除列：

agg.drop(['ON', 'OFF'], axis=1, inplace=True)

将您agg为：

P1      P2      P83   STATUS
Date/Time                                         
2014-01-13 11:41     NaN     NaN  path 83  offline
2014-03-26 14:37  path 1     NaN  path 83  offline
2014-03-26 15:33  path 1     NaN      NaN   online
2014-04-25 5:44      NaN  path 2      NaN  offline