Thanks, but I need to use all the information in the csv file:
Batch Path,D:\MassHunter\GCMS\1\data\2022\julio\08072022
Analysis File Name,Unk_2.uaf
Analyst Name,LAC01,Analysis Time,7/11/2022 4:25:24 PM
File Name,080722 12.D,Path Name,D:\MassHunter\GCMS\1\data\2022\julio\08072022
Sample Name,LS-137-22,Type,Sample
Acq. Method File,VOC_PAMS_Scott_SCAN,Acq. Method Path,D:\MassHunter\GCMS\1\methods\
Acq. Date-Time,7/8/2022 10:54:14 PM,Acq. Operator,MOC
Instrument Name,LAC01,Dil.,1
Component RT,Compound Name,CAS#,Formula,Component Area,Match Factor,Estimated Conc.
7.3114,"Propanal, 2-methyl-",78-84-2,C4H8O,70086.5,92.8,
,,,,,,
8.1251,Butanal,123-72-8,C4H8O,192912.5,97.5,
,,,,,,
10.1817,"Silanediol, dimethyl-",1066-42-8,C2H8O2Si,601151.0,98.4,
,,,,,,
10.6182,Benzene,71-43-2,C6H6,302109.7,96.1,
,,,,,,
Sample Chromatogram
I'm writing a code who read the dataframe and create a new clean df, like this image:
Thank you for your time.