使用python合并行解决冲突优先级

Question

输入

>>> data
     OrderID            TimeStamp  ErrorCode Duration          ResponseType  \
0    3000000  1488948188555841641        NaN      IOC                   NaN   
1    3000000  1488948188556444675          0      NaN     NEW_ORDER_CONFIRM   
2    3000000  1488948188556448153          2      NaN         TRADE_CONFIRM   

预期输出

>>> data
     OrderID            TimeStamp1           TimeStamp2  ErrorCode Duration       ResponseType     

2    3000000  1488948188555841641  1488948188556448153          0      IOC         TRADE_CONFIRM 

基本上我想根据OrderID折叠这两行，但是Errorcode，只需要从NEW\u ORDER\u CONFIRM获取。你知道吗

问题的更大意图是Use particular column value as key to search in pandas dataframe