擅长:python、mysql、java
<p>最简单的方法是一分为二,然后浓缩:</p>
<pre><code>dep_cols = ['SOBT', 'PLANNED_DEP_HOUR', 'DEPARTURE_FLIGHT_HAUL']
arr_cols = ['SIBT', 'PLANNED_ARR_HOUR', 'ARRIVAL_FLIGHT_HAUL']
new_cols = ['DATETIME','PLANNER_HOUR','FLIGHT_HAUL']
dep = df[dep_cols].copy()
arr = df[arr_cols].copy()
dep.columns, arr.columns = new_cols, new_cols
dep['TYPE'] = 'DEP'
arr['TYPE'] = 'ARR'
pd.concat([dep, arr])
DATETIME PLANNER_HOUR FLIGHT_HAUL TYPE
0 2016-01-01 14:10:00 14 Long Haul DEP
1 2016-01-01 06:30:00 6 Short Haul DEP
2 2016-01-01 07:05:00 7 Long Haul DEP
3 2016-01-01 10:40:00 10 Long Haul DEP
4 2016-01-01 10:50:00 10 Long Haul DEP
0 2016-01-01 04:05:00 4 Ultra Long Haul ARR
1 2016-01-01 04:25:00 4 Ultra Long Haul ARR
2 2016-01-01 05:05:00 5 Long Haul ARR
3 2016-01-01 05:20:00 5 Short Haul ARR
4 2016-01-01 05:25:00 5 Long Haul ARR
</code></pre>