annotate src/breadcrumbs/scripts/scriptEnvToTable.py @ 0:0de566f21448 draft default tip

v2
author sagun98
date Thu, 03 Jun 2021 18:13:32 +0000
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
sagun98
parents:
diff changeset
1 #!/usr/bin/env python
sagun98
parents:
diff changeset
2 """
sagun98
parents:
diff changeset
3 Author: Timothy Tickle
sagun98
parents:
diff changeset
4 Description: Convert Env file to table
sagun98
parents:
diff changeset
5 """
sagun98
parents:
diff changeset
6
sagun98
parents:
diff changeset
7 __author__ = "Timothy Tickle"
sagun98
parents:
diff changeset
8 __copyright__ = "Copyright 2012"
sagun98
parents:
diff changeset
9 __credits__ = ["Timothy Tickle"]
sagun98
parents:
diff changeset
10 __license__ = ""
sagun98
parents:
diff changeset
11 __version__ = ""
sagun98
parents:
diff changeset
12 __maintainer__ = "Timothy Tickle"
sagun98
parents:
diff changeset
13 __email__ = "ttickle@sph.harvard.edu"
sagun98
parents:
diff changeset
14 __status__ = "Development"
sagun98
parents:
diff changeset
15
sagun98
parents:
diff changeset
16 import sys
sagun98
parents:
diff changeset
17 import argparse
sagun98
parents:
diff changeset
18 import csv
sagun98
parents:
diff changeset
19
sagun98
parents:
diff changeset
20
sagun98
parents:
diff changeset
21 #Set up arguments reader
sagun98
parents:
diff changeset
22 argp = argparse.ArgumentParser( prog = "scriptEnvToTable.py",
sagun98
parents:
diff changeset
23 description = """Convert Env file to table""" )
sagun98
parents:
diff changeset
24
sagun98
parents:
diff changeset
25 #Arguments
sagun98
parents:
diff changeset
26 #For table
sagun98
parents:
diff changeset
27 argp.add_argument("strEnvFile", metavar = "EnvFile", help ="EnvFile data file")
sagun98
parents:
diff changeset
28 argp.add_argument("strOutputFile", metavar = "OutputFile", help ="Output File")
sagun98
parents:
diff changeset
29 args = argp.parse_args( )
sagun98
parents:
diff changeset
30
sagun98
parents:
diff changeset
31 hndlReader = csv.reader(open(args.strEnvFile,'rU'), delimiter="\t")
sagun98
parents:
diff changeset
32
sagun98
parents:
diff changeset
33 lsListOfIDs = []
sagun98
parents:
diff changeset
34 lsListOfFeatures = []
sagun98
parents:
diff changeset
35 dictValues = {}
sagun98
parents:
diff changeset
36 for lsLine in hndlReader:
sagun98
parents:
diff changeset
37 print(lsLine)
sagun98
parents:
diff changeset
38 lsListOfIDs.append(lsLine[1])
sagun98
parents:
diff changeset
39 lsListOfFeatures.append(lsLine[0])
sagun98
parents:
diff changeset
40 tpleKey = tuple([lsLine[1],lsLine[0]])
sagun98
parents:
diff changeset
41 if tpleKey in dictValues:
sagun98
parents:
diff changeset
42 print("Error:: Duplicate key entries found")
sagun98
parents:
diff changeset
43 exit(1)
sagun98
parents:
diff changeset
44 dictValues[tpleKey] = lsLine[2]
sagun98
parents:
diff changeset
45
sagun98
parents:
diff changeset
46 lsListOfIDs = list(set(lsListOfIDs))
sagun98
parents:
diff changeset
47 lsListOfFeatures = list(set(lsListOfFeatures))
sagun98
parents:
diff changeset
48 print(lsListOfIDs)
sagun98
parents:
diff changeset
49 print(lsListOfFeatures)
sagun98
parents:
diff changeset
50 hndlWrite = csv.writer(open(args.strOutputFile,'w'), delimiter="\t")
sagun98
parents:
diff changeset
51 hndlWrite.writerow(["ID"]+lsListOfIDs)
sagun98
parents:
diff changeset
52 for sFeature in lsListOfFeatures:
sagun98
parents:
diff changeset
53 lsFeatureLine = [sFeature]
sagun98
parents:
diff changeset
54 for sSample in lsListOfIDs:
sagun98
parents:
diff changeset
55 lsFeatureLine.append(dictValues.get(tuple([sSample,sFeature]),0))
sagun98
parents:
diff changeset
56 hndlWrite.writerow(lsFeatureLine)