-
Notifications
You must be signed in to change notification settings - Fork 1
/
create_head.py
67 lines (52 loc) · 3.14 KB
/
create_head.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
import os
import pandas as pd
project_path = os.path.realpath('')
dict_ = {'ae1_frp':'AE1 FUEL RACK POSIT:1742:mm:Average:900',
'ae2_frp':'AE2 FUEL RACK POSIT:2742:mm:Average:900',
'ae3_frp':'AE3 FUEL RACK POSIT:3742:mm:Average:900',
'ae4_frp':'AE4 FUEL RACK POSIT:4742:mm:Average:900',
'ae1_cac_P':'AE1 CA OTL CAC PRESS:1649:Bar:Average:900',
'ae2_cac_P':'AE2 CA OTL CAC PRESS:2649:Bar:Average:900',
'ae3_cac_P':'AE3 CA OTL CAC PRESS:3649:Bar:Average:900',
'ae4_cac_P':'AE4 CA OTL CAC PRESS:4649:Bar:Average:900',
'ae1_cac_ca':'AE1 EXH CA OUTET 1:1543: C:Average:900',
'ae2_cac_ca':'AE2 EXH CA OUTET 1:2543: C:Average:900',
'ae3_cac_ca':'AE3 EXH CA OUTET 1:3543: C:Average:900',
'ae4_cac_ca':'AE4 EXH CA OUTET 1:4543: C:Average:900',
'ae1_exh':'AE1 EXH MEAN VALUE:1591: C:Average:900',
'ae2_exh':'AE2 EXH MEAN VALUE:2591: C:Average:900',
'ae3_exh':'AE3 EXH MEAN VALUE:3591: C:Average:900',
'ae4_exh':'AE4 EXH MEAN VALUE:4591: C:Average:900',
'ae1_fo_P':'AE1 FO INLET PRESS:1603:Bar:Average:900',
'ae2_fo_P':'AE2 FO INLET PRESS:2603:Bar:Average:900',
'ae3_fo_P':'AE3 FO INLET PRESS:3603:Bar:Average:900',
'ae4_fo_P':'AE4 FO INLET PRESS:4603:Bar:Average:900',
'ae1_rpm':'AE1 ENG SPEED:1745:RPM:Average:900',
'ae2_rpm':'AE2 ENG SPEED:2745:RPM:Average:900',
'ae3_rpm':'AE3 ENG SPEED:3745:RPM:Average:900',
'ae4_rpm':'AE4 ENG SPEED:4745:RPM:Average:900',
'me1_frp':'ME1 FUEL RACK POSIT:10005:%:Average:900',
'me2_frp':'ME2 FUEL RACK POSIT:20005:%:Average:900',
'me3_frp':'ME3 FUEL RACK POSIT:30005:%:Average:900',
'me4_frp':'ME4 FUEL RACK POSIT:40005:%:Average:900',
'me1_ca_T':'ME1 CA TEMP COOL OUT:1343:C:Average:900',
'me2_ca_T':'ME2 CA TEMP COOL OUT:2343:C:Average:900',
'me3_ca_T':'ME3 CA TEMP COOL OUT:3343:C:Average:900',
'me4_ca_T':'ME4 CA TEMP COOL OUT:4343:C:Average:900',
'me1_cac_T':'ME1 CHARGE AIR TEMP:1347:C:Average:900',
'me2_cac_T':'ME2 CHARGE AIR TEMP:2347:C:Average:900',
'me3_cac_T':'ME3 CHARGE AIR TEMP:3347:C:Average:900',
'me4_cac_T':'ME4 CHARGE AIR TEMP:4347:C:Average:900',
'me1_exh_T':'ME1 EXH GAS MEAN:1125:C:Average:900',
'me2_exh_T':'ME2 EXH GAS MEAN:2125:C:Average:900',
'me3_exh_T':'ME3 EXH GAS MEAN:3125:C:Average:900',
'me4_exh_T':'ME4 EXH GAS MEAN:4125:C:Average:900',
'me1_rpm':'ME1 ENGINE SPEED:1364:rpm:Average:900',
'me2_rpm':'ME2 ENGINE SPEED:2364:rpm:Average:900',
'me3_rpm':'ME3 ENGINE SPEED:3364:rpm:Average:900',
'me4_rpm':'ME4 ENGINE SPEED:4364:rpm:Average:900',
'fo_booster_13':'FO BOOST 1 CONSUMPT:6165:m3/h:Average:900',
'fo_booster_24':'FO BOOST 2 CONSUMPT:6166:m3/h:Average:900'}
#%%
df = pd.DataFrame.from_dict(dict_,orient='index')
df.to_excel('headers_dict.xlsx')