Shell Programming and Scripting

Experiment Name,XYZ_07/28/15,
Specimen Name,Specimen_001,
Tube Name, Control,
Record Date,7/28/2015 14:50,
$OP,XYZYZ,
GUID,abc,
Population,#Events,%Parent
All Events,10500,
P1,10071,95.9
Early Apoptosis,1113,11.1
Late Apoptosis,1091,10.8
Live,7856,78
Necrosis,11,0.1

Experiment Name,ABC_07/28/15
Specimen Name,Specimen_001
Tube Name,OA_10uM
Record Date,"Jul 28, 2015 2:52:36 PM"
$OP,XYZYZ 
GUID,abc
Population,#Events,%Parent
All Events,12156,
P1,11821,97.2
Early Apoptosis,806,6.8
Late Apoptosis,901,7.6
Live,10087,85.3
Necrosis,27,0.2

Tube Name	Early Apoptosis	Late Apoptosis	Live	Necrosis
Control	11.1	10.8	78	0.1
OA_10uM	6.8	7.6	85.3	0.2

Experiment Name,ABC_07/28/15
Specimen Name,Specimen_001
Tube Name,Unstained Control
Record Date,"Jul 28, 2015 2:42:33 PM"
$OP,XYZ 
GUID,abc
Population,#Events,%Parent
All Events,15282,
P1,14744,96.5
Early Apoptosis,71,0.5
Late Apoptosis,1,0.0
Live,14672,99.5
Necrosis,0,0.0

Experiment Name,ABC_07/28/15
Specimen Name,Specimen_001
Tube Name,OA_10uM
Record Date,"Jul 28, 2015 2:52:36 PM"
$OP,KLM 
GUID,efg 
Population,#Events,%Parent
All Events,12156,
P1,11821,97.2
Early Apoptosis,806,6.8
Late Apoptosis,901,7.6
Live,10087,85.3
Necrosis,27,0.2

awk -F, -v HD="Tube Name,Early Apoptosis,Late Apoptosis,Live,Necrosis" '
BEGIN           {for (N=i=split (HD, T); i>0; i--) SRCH[T[i]]
                 for (i=1; i<=N; i++) printf "%s\t", T[i]
                 print ""
                }
FNR==1 && L     {for (i=1; i<=N; i++) printf "%s\t", PR[T[i]]
                 print ""
                 delete PR
                }

$1 in SRCH      {PR[$1]=$NF
                 L=1
                }
END             {for (i=1; i<=N; i++) printf "%s\t", PR[T[i]]
                 print ""
                }
'  file[12]
Tube Name       Early Apoptosis Late Apoptosis  Live    Necrosis
Unstained Control       0.5     0.0     99.5    0.0
OA_10uM 6.8     7.6     85.3    0.2

import os
from collections import deque

def parse_file(f,first=0):
	header=""
	line_3=""
	cnt=0
	q=deque([],maxlen=4)
	with open(f) as file:
		for line in file:
			line=line.replace("\n","")
			cnt+=1
			if cnt==3:
				line_3 = line
			else:
				# print(line)
				q.extend([line])
				
	items = line_3.split(",")
	if first:
		header = header+" "+items[0]
	content=items[1]
	for i in q:
		items = i.split(",")
		if first:
			header = header+" "+items[0]
		content = content+" "+items[2]
	if first:
		print(header)
	print(content)
	
file_cnt=0				
for file in os.listdir("leo"):
	file="leo/"+file
	if file_cnt==0:
		file_cnt+=1
		parse_file(file,first=1)
	else:
		parse_file(file)