はじめに
こんにちは．九大M2ITストラテジストの岩附陽太です．この記事は補足的な記事になります．前回の記事で，BADAデータセットを用いたフライトエンベロープ，SR比，燃料流量などの可視化をおこないました．一方で，その際，BadaOpfIntegrationList.csvというファイルを，もとのBADAデータセットからどのように作るかについて言及していませんでした．BADAデータセットがそもそも何かとか，どのように手に入れるか，どんなことができるかは前回の記事をご覧ください．
BADAからcsvを作るためには，まず，'BadaSourceData'というフォルダをこのプログラムと同一階層につくり，その中にOPFファイルをすべて入れてください．その後，下のプログラムを使ってごり押し的にcsvに落とし込みます．なので実行をするだけで大丈夫です．
応用上の注意点としては，BADAにはAPなどのフェーズで値が入っていない場合があります．自分はこれを使用するプログラムのif文で回避してしまっているので，このプログラム値の補完をおこなっていないことを注意してください．また，BADAとCARATSでは機種名が微妙に対応していませんが，それも補完していないので注意してください
プログラム
import numpy as np
import pandas as pd
import csv
import time as TimeCounter
#計算時間の計測
start=TimeCounter.time()
#読み取るデータを指定する場合
#filename = 'MasterData//ReadDataList.csv'
#with open(filename, encoding='utf-8-sig', newline='') as File:
# CsvReader = csv.reader(File)
# AllDataList = [row for row in CsvReader]
#File.close()
#全てのデータを読み取る場合
import os
Path='BadaSourceData'
AllDataList=os.listdir(Path)
print(AllDataList)
LenAllData=len(AllDataList)
TougouList=list()
ColumnsList=list()
ColumnsList.append('BADAKisyu')
ColumnsList.append('EngineNumber')
ColumnsList.append('EngineType')
ColumnsList.append('WakeType')
ColumnsList.append('KisyuEngine')
ColumnsList.append('Reference')
ColumnsList.append('Minimum')
ColumnsList.append('Maximum')
ColumnsList.append('MaxPayload')
ColumnsList.append('MassGrad')
ColumnsList.append('VmoKcas')
ColumnsList.append('Mmo')
ColumnsList.append('MaxAlt')
ColumnsList.append('Hmax')
ColumnsList.append('TempGrad')
ColumnsList.append('ndrst')
ColumnsList.append('Surf')
ColumnsList.append('Clbo')
ColumnsList.append('k')
ColumnsList.append('Cm16')
ColumnsList.append('Phase1')
ColumnsList.append('Name1')
ColumnsList.append('Vstall1')
ColumnsList.append('Cd01')
ColumnsList.append('Cd21')
ColumnsList.append('unused1')
ColumnsList.append('Phase2')
ColumnsList.append('Name1')
ColumnsList.append('Vstall2')
ColumnsList.append('Cd02')
ColumnsList.append('Cd22')
ColumnsList.append('unused2')
ColumnsList.append('Phase3')
ColumnsList.append('Name3')
ColumnsList.append('Vstall3')
ColumnsList.append('Cd03')
ColumnsList.append('Cd23')
ColumnsList.append('unused3')
ColumnsList.append('Phase4')
ColumnsList.append('Name4')
ColumnsList.append('Vstall4')
ColumnsList.append('Cd04')
ColumnsList.append('Cd24')
ColumnsList.append('unused4')
ColumnsList.append('Phase5')
ColumnsList.append('Name5')
ColumnsList.append('Vstall5')
ColumnsList.append('Cd05')
ColumnsList.append('Cd25')
ColumnsList.append('unused5')
ColumnsList.append('Name6')
ColumnsList.append('Cd06')
ColumnsList.append('Cd26')
ColumnsList.append('unused6')
ColumnsList.append('Name7')
ColumnsList.append('Cd07')
ColumnsList.append('Cd27')
ColumnsList.append('unused7')
ColumnsList.append('Name8')
ColumnsList.append('Cd08')
ColumnsList.append('Cd28')
ColumnsList.append('unused8')
ColumnsList.append('Name9')
ColumnsList.append('Cd09')
ColumnsList.append('Cd29')
ColumnsList.append('unused9')
ColumnsList.append('Name10')
ColumnsList.append('Cd010')
ColumnsList.append('Cd210')
ColumnsList.append('unused10')
ColumnsList.append('Name11')
ColumnsList.append('Cd011')
ColumnsList.append('Cd211')
ColumnsList.append('unused11')
ColumnsList.append('Ctc1')
ColumnsList.append('Ctc2')
ColumnsList.append('Ctc3')
ColumnsList.append('Ctc4')
ColumnsList.append('Ctc5')
ColumnsList.append('DescLow')
ColumnsList.append('DescHigh')
ColumnsList.append('DescLevel')
ColumnsList.append('DescApp')
ColumnsList.append('DescLd')
ColumnsList.append('DescCas')
ColumnsList.append('DescMach')
ColumnsList.append('DescUnused1')
ColumnsList.append('DescUnused2')
ColumnsList.append('DescUnused3')
ColumnsList.append('Cfc1')
ColumnsList.append('Cfc2')
ColumnsList.append('DescFuel')
ColumnsList.append('FlowCoefficient')
ColumnsList.append('CruiseCorr')
ColumnsList.append('FuelUnused1')
ColumnsList.append('FuelUnused2')
ColumnsList.append('FuelUnused3')
ColumnsList.append('FuelUnused4')
ColumnsList.append('Tol')
ColumnsList.append('Ldl')
ColumnsList.append('Span')
ColumnsList.append('Length')
ColumnsList.append('GroundUnused1')
for i in range(0,LenAllData):
#for i in range(0,1):
##########################################
TempList=list()
FileName2='BadaSourceData//'+AllDataList[i]
File2 = open(FileName2, 'r')
data = File2.read()
File2.close()
print('AllData',FileName2)
print(data)
KisyuTemp1=AllDataList[i][0:6]
print('KisyuTemp1')
print(KisyuTemp1)
KisyuTemp2=KisyuTemp1.strip('_')
print('KisyuTemp2')
print(KisyuTemp2)
TempList.append(KisyuTemp2)
##########################################
#
temp=0
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=1
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=2
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=3
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=4
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=5
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=6
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=7
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=8
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=9
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=10
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=11
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=12
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
##########################################
temp=13
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
EngineNumber=data[temp*72+20:temp*72+21]
EngineNumber=EngineNumber.strip(' ')
print('EngineNumber',EngineNumber)
TempList.append(EngineNumber)
EngineType=data[temp*72+32:temp*72+38]
EngineType=EngineType.strip(' ')
print('EngineType',EngineType)
TempList.append(EngineType)
WakeType=data[temp*72+55:temp*72+60]
WakeType=WakeType.strip(' ')
print('WakeType',WakeType)
TempList.append(WakeType)
temp=14
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Kisyu2=data[temp*72+3:temp*72+50]
KisyuEngine=Kisyu2.strip(' ')
print('KisyuEngine',KisyuEngine)
TempList.append(KisyuEngine)
##########################################
#
temp=15
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=16
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=17
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
##########################################
temp=18
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Reference=data[temp*72+6:temp*72+17]
Reference=Reference.strip(' ')
print('Reference',Reference)
TempList.append(Reference)
Minimum=data[temp*72+20:temp*72+30]
Minimum=Minimum.strip(' ')
print('Minimum',Minimum)
TempList.append(Minimum)
Maximum=data[temp*72+30:temp*72+43]
Maximum=Maximum.strip(' ')
print('Maximum',Maximum)
TempList.append(Maximum)
MaxPayload=data[temp*72+44:temp*72+56]
MaxPayload=MaxPayload.strip(' ')
print('MaxPayload',MaxPayload)
TempList.append(MaxPayload)
MassGrad=data[temp*72+56:temp*72+69]
MassGrad=MassGrad.strip(' ')
print('MassGrad',MassGrad)
TempList.append(MassGrad)
##########################################
#
temp=19
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=20
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
##########################################
temp=21
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
VmoKcas=data[temp*72+6:temp*72+17]
VmoKcas=VmoKcas.strip(' ')
print('VmoKcas',VmoKcas)
TempList.append(VmoKcas)
Mmo=data[temp*72+20:temp*72+30]
Mmo=Mmo.strip(' ')
print('Mmo',Mmo)
TempList.append(Mmo)
MaxAlt=data[temp*72+33:temp*72+43]
MaxAlt=MaxAlt.strip('')
print('MaxAlt',MaxAlt)
TempList.append(MaxAlt)
Hmax=data[temp*72+46:temp*72+57]
Hmax=Hmax.strip('')
print('Hmax',Hmax)
TempList.append(Hmax)
TempGrad=data[temp*72+59:temp*72+70]
TempGrad=TempGrad.strip(' ')
print('TempGrad',TempGrad)
TempList.append(TempGrad)
##########################################
#
temp=22
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=23
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=24
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
##########################################
temp=25
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
ndrst=data[temp*72+3:temp*72+6]
ndrst=ndrst.strip(' ')
print('ndrst',ndrst)
TempList.append(ndrst)
Surf=data[temp*72+6:temp*72+17]
Surf=Surf.strip(' ')
print('Surf',Surf)
TempList.append(Surf)
Clbo=data[temp*72+20:temp*72+30]
Clbo=Clbo.strip(' ')
print('Clbo',Clbo)
TempList.append(Clbo)
k=data[temp*72+33:temp*72+43]
k=k.strip('')
print('k',k)
TempList.append(k)
Cm16=data[temp*72+46:temp*72+57]
Cm16=Cm16.strip('')
print('Cm16',Cm16)
TempList.append(Cm16)
##########################################
#
temp=26
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=27
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
##########################################
temp=28
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Phase1=data[temp*72+5:temp*72+7]
Phase1=Phase1.strip(' ')
print('Phase1',Phase1)
TempList.append(Phase1)
Name1=data[temp*72+8:temp*72+17]
Name1=Name1.strip(' ')
print('Name1',Name1)
TempList.append(Name1)
Vstall1=data[temp*72+20:temp*72+30]
Vstall1=Vstall1.strip('')
print('Vstall1',Vstall1)
TempList.append(Vstall1)
Cd01=data[temp*72+33:temp*72+43]
Cd01=Cd01.strip('')
print('Cd01',Cd01)
TempList.append(Cd01)
Cd21=data[temp*72+46:temp*72+57]
Cd21=Cd21.strip(' ')
print('Cd21',Cd21)
TempList.append(Cd21)
unused1=data[temp*72+59:temp*72+70]
unused1=unused1.strip(' ')
print('unused1',unused1)
TempList.append(unused1)
##########################################
#
##########################################
temp=29
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Phase2=data[temp*72+5:temp*72+7]
Phase2=Phase2.strip(' ')
print('Phase2',Phase2)
TempList.append(Phase2)
Name2=data[temp*72+8:temp*72+17]
Name2=Name2.strip(' ')
print('Name2',Name2)
TempList.append(Name2)
Vstall2=data[temp*72+20:temp*72+30]
Vstall2=Vstall2.strip('')
print('Vstall2',Vstall2)
TempList.append(Vstall2)
Cd02=data[temp*72+33:temp*72+43]
Cd02=Cd02.strip('')
print('Cd02',Cd02)
TempList.append(Cd02)
Cd22=data[temp*72+46:temp*72+57]
Cd22=Cd22.strip(' ')
print('Cd22',Cd22)
TempList.append(Cd22)
unused2=data[temp*72+59:temp*72+70]
unused2=unused2.strip(' ')
print('unused2',unused2)
TempList.append(unused2)
##########################################
#
##########################################
temp=30
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Phase3=data[temp*72+5:temp*72+7]
Phase3=Phase3.strip(' ')
print('Phase3',Phase3)
TempList.append(Phase3)
Name3=data[temp*72+8:temp*72+17]
Name3=Name3.strip(' ')
print('Name3',Name3)
TempList.append(Name3)
Vstall3=data[temp*72+20:temp*72+30]
Vstall3=Vstall3.strip('')
print('Vstall3',Vstall3)
TempList.append(Vstall3)
Cd03=data[temp*72+33:temp*72+43]
Cd03=Cd03.strip('')
print('Cd03',Cd03)
TempList.append(Cd03)
Cd23=data[temp*72+46:temp*72+57]
Cd23=Cd23.strip(' ')
print('Cd23',Cd23)
TempList.append(Cd23)
unused3=data[temp*72+59:temp*72+70]
unused3=unused3.strip(' ')
print('unused3',unused3)
TempList.append(unused3)
##########################################
#
##########################################
temp=31
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Phase4=data[temp*72+5:temp*72+7]
Phase4=Phase4.strip(' ')
print('Phase4',Phase4)
TempList.append(Phase4)
Name4=data[temp*72+8:temp*72+17]
Name4=Name4.strip(' ')
print('Name4',Name4)
TempList.append(Name4)
Vstall4=data[temp*72+20:temp*72+30]
Vstall4=Vstall4.strip('')
print('Vstall4',Vstall4)
TempList.append(Vstall4)
Cd04=data[temp*72+33:temp*72+43]
Cd04=Cd04.strip('')
print('Cd04',Cd04)
TempList.append(Cd04)
Cd24=data[temp*72+46:temp*72+57]
Cd24=Cd24.strip(' ')
print('Cd24',Cd24)
TempList.append(Cd24)
unused4=data[temp*72+59:temp*72+70]
unused4=unused4.strip(' ')
print('unused4',unused4)
TempList.append(unused4)
##########################################
#
##########################################
temp=32
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Phase5=data[temp*72+5:temp*72+7]
Phase5=Phase5.strip(' ')
print('Phase5',Phase5)
TempList.append(Phase5)
Name5=data[temp*72+8:temp*72+17]
Name5=Name5.strip(' ')
print('Name5',Name5)
TempList.append(Name5)
Vstall5=data[temp*72+20:temp*72+30]
Vstall5=Vstall5.strip('')
print('Vstall5',Vstall5)
TempList.append(Vstall5)
Cd05=data[temp*72+33:temp*72+43]
Cd05=Cd05.strip('')
print('Cd05',Cd05)
TempList.append(Cd05)
Cd25=data[temp*72+46:temp*72+57]
Cd25=Cd25.strip(' ')
print('Cd25',Cd25)
TempList.append(Cd25)
unused5=data[temp*72+59:temp*72+70]
unused5=unused5.strip(' ')
print('unused5',unused5)
TempList.append(unused5)
##########################################
#
temp=33
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
####################################
temp=34
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Name6=data[temp*72+8:temp*72+17]
Name6=Name6.strip(' ')
print('Name6',Name6)
TempList.append(Name6)
Cd06=data[temp*72+33:temp*72+43]
Cd06=Cd06.strip('')
print('Cd06',Cd06)
TempList.append(Cd06)
Cd26=data[temp*72+46:temp*72+57]
Cd26=Cd26.strip(' ')
print('Cd26',Cd26)
TempList.append(Cd26)
unused6=data[temp*72+59:temp*72+70]
unused6=unused6.strip(' ')
print('unused6',unused6)
TempList.append(unused6)
####################################
#
################################
temp=35
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Name7=data[temp*72+8:temp*72+17]
Name7=Name7.strip(' ')
print('Name7',Name7)
TempList.append(Name7)
Cd07=data[temp*72+33:temp*72+43]
Cd07=Cd07.strip('')
print('Cd07',Cd07)
TempList.append(Cd07)
Cd27=data[temp*72+46:temp*72+57]
Cd27=Cd27.strip(' ')
print('Cd27',Cd27)
TempList.append(Cd27)
unused7=data[temp*72+59:temp*72+70]
unused7=unused7.strip(' ')
print('unused7',unused7)
TempList.append(unused7)
################################
#
temp=36
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
################################
temp=37
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Name8=data[temp*72+8:temp*72+17]
Name8=Name8.strip(' ')
print('Name8',Name8)
TempList.append(Name8)
Cd08=data[temp*72+33:temp*72+43]
Cd08=Cd08.strip('')
print('Cd08',Cd08)
TempList.append(Cd08)
Cd28=data[temp*72+46:temp*72+57]
Cd28=Cd28.strip(' ')
print('Cd28',Cd28)
TempList.append(Cd28)
unused8=data[temp*72+59:temp*72+70]
unused8=unused8.strip(' ')
print('unused8',unused8)
TempList.append(unused8)
################################
#
################################
temp=38
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Name9=data[temp*72+8:temp*72+17]
Name9=Name9.strip(' ')
print('Name9',Name9)
TempList.append(Name9)
Cd09=data[temp*72+33:temp*72+43]
Cd09=Cd09.strip('')
print('Cd09',Cd09)
TempList.append(Cd09)
Cd29=data[temp*72+46:temp*72+57]
Cd29=Cd29.strip(' ')
print('Cd29',Cd29)
TempList.append(Cd29)
unused9=data[temp*72+59:temp*72+70]
unused9=unused9.strip(' ')
print('unused9',unused9)
TempList.append(unused9)
################################
#
temp=39
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
################################
temp=40
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Name10=data[temp*72+8:temp*72+17]
Name10=Name10.strip(' ')
print('Name10',Name10)
TempList.append(Name10)
Cd010=data[temp*72+33:temp*72+43]
Cd010=Cd010.strip('')
print('Cd010',Cd010)
TempList.append(Cd010)
Cd210=data[temp*72+46:temp*72+57]
Cd210=Cd210.strip(' ')
print('Cd210',Cd210)
TempList.append(Cd210)
unused10=data[temp*72+59:temp*72+70]
unused10=unused10.strip(' ')
print('unused10',unused10)
TempList.append(unused10)
################################
#
################################
temp=41
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Name11=data[temp*72+8:temp*72+17]
Name11=Name11.strip(' ')
print('Name11',Name11)
TempList.append(Name11)
Cd011=data[temp*72+33:temp*72+43]
Cd011=Cd011.strip('')
print('Cd011',Cd011)
TempList.append(Cd011)
Cd211=data[temp*72+46:temp*72+57]
Cd211=Cd211.strip(' ')
print('Cd211',Cd211)
TempList.append(Cd211)
unused11=data[temp*72+59:temp*72+70]
unused11=unused11.strip(' ')
print('unused11',unused11)
TempList.append(unused11)
################################
#
temp=42
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=43
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
###################################
temp=44
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Ctc1=data[temp*72+6:temp*72+17]
Ctc1=Ctc1.strip(' ')
print('Ctc1',Ctc1)
TempList.append(Ctc1)
Ctc2=data[temp*72+20:temp*72+33]
Ctc2=Ctc2.strip('')
print('Ctc2',Ctc2)
TempList.append(Ctc2)
Ctc3=data[temp*72+33:temp*72+43]
Ctc3=Ctc3.strip('')
print('Ctc3',Ctc3)
TempList.append(Ctc3)
Ctc4=data[temp*72+46:temp*72+57]
Ctc4=Ctc4.strip(' ')
print('Ctc4',Ctc4)
TempList.append(Ctc4)
Ctc5=data[temp*72+59:temp*72+70]
Ctc5=Ctc5.strip(' ')
print('Ctc5',Ctc5)
TempList.append(Ctc5)
##################################
#
temp=45
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
##################################
temp=46
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
DescLow=data[temp*72+6:temp*72+17]
DescLow=DescLow.strip(' ')
print('DescLow',DescLow)
TempList.append(DescLow)
DescHigh=data[temp*72+20:temp*72+30]
DescHigh=DescHigh.strip('')
print('DescHigh',DescHigh)
TempList.append(DescHigh)
DescLevel=data[temp*72+33:temp*72+43]
DescLevel=DescLevel.strip('')
print('DescLevel',DescLevel)
TempList.append(DescLevel)
DescApp=data[temp*72+46:temp*72+57]
DescApp=DescApp.strip(' ')
print('DescApp',DescApp)
TempList.append(DescApp)
DescLd=data[temp*72+59:temp*72+70]
DescLd=DescLd.strip(' ')
print('DescLd',DescLd)
TempList.append(DescLd)
#######################################
#
temp=47
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
######################################
temp=48
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
DescCAS=data[temp*72+6:temp*72+17]
DescCAS=DescCAS.strip(' ')
print('DescCAS',DescCAS)
TempList.append(DescCAS)
DescMach=data[temp*72+20:temp*72+30]
DescMach=DescMach.strip('')
print('DescMach',DescMach)
TempList.append(DescMach)
DescUnused1=data[temp*72+33:temp*72+43]
DescUnused1=DescUnused1.strip('')
print('DescUnused1',DescUnused1)
TempList.append(DescUnused1)
DescUnused2=data[temp*72+46:temp*72+57]
DescUnused2=DescUnused2.strip(' ')
print('DescUnused2',DescUnused2)
TempList.append(DescUnused2)
DescUnused3=data[temp*72+59:temp*72+70]
DescUnused3=DescUnused3.strip(' ')
print('DescUnused3',DescUnused3)
TempList.append(DescUnused3)
#####################################
#
temp=49
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=50
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
###################################
temp=51
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Cf1=data[temp*72+6:temp*72+17]
Cf1=Cf1.strip(' ')
print('Cf1',Cf1)
TempList.append(Cf1)
Cf2=data[temp*72+20:temp*72+30]
Cf2=Cf2.strip('')
print('Cf2',Cf2)
TempList.append(Cf2)
#################################
#
temp=52
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
################################
temp=53
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
DescFuel=data[temp*72+6:temp*72+17]
DescFuel=DescFuel.strip(' ')
print('DescFuel',DescFuel)
TempList.append(DescFuel)
FlowCoefficeient=data[temp*72+20:temp*72+30]
FlowCoefficeient=FlowCoefficeient.strip('')
print('FlowCoefficeient',FlowCoefficeient)
TempList.append(FlowCoefficeient)
###############################
#
temp=54
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
#
#######################################
temp=55
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
CruiseCorr=data[temp*72+6:temp*72+17]
CruiseCorr=CruiseCorr.strip(' ')
print('CruiseCorr',CruiseCorr)
TempList.append(CruiseCorr)
FuelUnused1=data[temp*72+20:temp*72+30]
FuelUnused1=FuelUnused1.strip('')
print('FuelUnused1',FuelUnused1)
TempList.append(FuelUnused1)
FuelUnused2=data[temp*72+33:temp*72+43]
FuelUnused2=FuelUnused2.strip('')
print('FuelUnused2',FuelUnused2)
TempList.append(FuelUnused2)
FuelUnused3=data[temp*72+46:temp*72+57]
FuelUnused3=FuelUnused3.strip(' ')
print('FuelUnused3',FuelUnused3)
TempList.append(FuelUnused3)
FuelUnused4=data[temp*72+59:temp*72+70]
FuelUnused4=FuelUnused4.strip(' ')
print('FuelUnused4',FuelUnused4)
TempList.append(FuelUnused4)
######################################
#
temp=56
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=57
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
##########################################
temp=58
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
Tol=data[temp*72+6:temp*72+17]
Tol=Tol.strip(' ')
print('Tol',Tol)
TempList.append(Tol)
Ldl=data[temp*72+20:temp*72+30]
Ldl=Ldl.strip('')
print('Ldl',Ldl)
TempList.append(Ldl)
Span=data[temp*72+33:temp*72+43]
Span=Span.strip('')
print('Span',Span)
TempList.append(Span)
Length=data[temp*72+46:temp*72+57]
Length=Length.strip(' ')
print('Length',Length)
TempList.append(Length)
GroundUnused=data[temp*72+59:temp*72+70]
GroundUnused=GroundUnused.strip(' ')
print('GroundUnused',GroundUnused)
TempList.append(GroundUnused)
###################################
temp=59
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
temp=60
print('temp',temp)
print(temp,data[temp*72:temp*72+71])
TougouList.append(TempList)
DFTougouList=pd.DataFrame(TougouList,columns=ColumnsList)
print(DFTougouList.head())
DFTougouList.to_csv('BadaOpfIntegrationList.csv')
#計算時間の出力
print('computing time is ',TimeCounter.time()-start)
print('finish')