-
Notifications
You must be signed in to change notification settings - Fork 0
/
createTemplate.py
executable file
·118 lines (110 loc) · 5.14 KB
/
createTemplate.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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Thu Dec 19 12:24:14 2019
@author: bacterie
"""
columns = [ [1,2,3,4,5,6,7,8,9,10,11,12],
#['SBW25-1', 'SBW25-1', 'SBW25-1', 'SBW25-4', 'SBW25-4', 'SBW25-4', 'SBW25-16', 'SBW25-16', 'SBW25-64', 'SBW25-64', 'SBW25-256', 'SBW25-1024']
['SBW25-WT-Sc' for i in range(12)]
]
with open('/Users/bacterie/Desktop/template.csv', 'w') as f:
print("#This is an example template file for dropsignal 0.2.46.", file=f)
print("# Required Columns are: `description` (str), `well` (str)", file=f)
print("# Optional Columns are `dilution` (float), `order` (int), `droplet_number` (int), `expected_growth` (bool).", file=f)
print("# Column names are case insensitive, lines starting with \"#\" will be skipped.", file=f)
print("well,description,order,droplet_number,dilution,expected_growth", file=f)
print("A2,"+columns[1][1]+",0,10,1,1", file=f)
print("A3,Empty,1,10,1,1", file=f)
print("A4,"+columns[1][3]+",2,10,1,1", file=f)
print("A5,Empty,3,10,1,1", file=f)
print("A6,"+columns[1][5]+",4,10,1,1", file=f)
print("A7,Empty,5,10,1,1", file=f)
print("A8,"+columns[1][7]+",6,10,1,1", file=f)
print("A9,Empty,7,10,1,1", file=f)
print("A10,"+columns[1][9]+",8,10,1,1", file=f)
print("A11,Empty,9,10,1,1", file=f)
print("A12,"+columns[1][11]+",10,10,1,1", file=f)
print("B1,"+columns[1][0]+",22,10,1,1", file=f)
print("B2,Empty,21,10,1,1", file=f)
print("B3,"+columns[1][2]+",20,10,1,1", file=f)
print("B4,Empty,19,10,1,1", file=f)
print("B5,"+columns[1][4]+",18,10,1,1", file=f)
print("B6,Empty,17,10,1,1", file=f)
print("B7,"+columns[1][6]+",16,10,1,1", file=f)
print("B8,Empty,15,10,1,1", file=f)
print("B9,"+columns[1][8]+",14,10,1,1", file=f)
print("B10,Empty,13,10,1,1", file=f)
print("B11,"+columns[1][10]+",12,10,1,1", file=f)
print("B12,Empty,11,10,1,1", file=f)
print("C1,Empty,23,10,1,1", file=f)
print("C2,"+columns[1][1]+",24,10,1,1", file=f)
print("C3,Empty,25,10,1,1", file=f)
print("C4,"+columns[1][3]+",26,10,1,1", file=f)
print("C5,Empty,27,10,1,1", file=f)
print("C6,"+columns[1][5]+",28,10,1,1", file=f)
print("C7,Empty,29,10,1,1", file=f)
print("C8,"+columns[1][7]+",30,10,1,1", file=f)
print("C9,Empty,31,10,1,1", file=f)
print("C10,"+columns[1][9]+",32,10,1,1", file=f)
print("C11,Empty,33,10,1,1", file=f)
print("C12,"+columns[1][11]+",34,10,1,1", file=f)
print("D1,"+columns[1][0]+",46,10,1,1", file=f)
print("D2,Empty,45,10,1,1", file=f)
print("D3,"+columns[1][2]+",44,10,1,1", file=f)
print("D4,Empty,43,10,1,1", file=f)
print("D5,"+columns[1][4]+",42,10,1,1", file=f)
print("D6,Empty,41,10,1,1", file=f)
print("D7,"+columns[1][6]+",40,10,1,1", file=f)
print("D8,Empty,39,10,1,1", file=f)
print("D9,"+columns[1][8]+",38,10,1,1", file=f)
print("D10,Empty,37,10,1,1", file=f)
print("D11,"+columns[1][10]+",36,10,1,1", file=f)
print("D12,Empty,35,10,1,1", file=f)
print("E1,Empty,47,10,1,1", file=f)
print("E2,"+columns[1][1]+",48,10,1,1", file=f)
print("E3,Empty,49,10,1,1", file=f)
print("E4,"+columns[1][3]+",50,10,1,1", file=f)
print("E5,Empty,51,10,1,1", file=f)
print("E6,"+columns[1][5]+",52,10,1,1", file=f)
print("E7,Empty,53,10,1,1", file=f)
print("E8,"+columns[1][7]+",54,10,1,1", file=f)
print("E9,Empty,55,10,1,1", file=f)
print("E10,"+columns[1][9]+",56,10,1,1", file=f)
print("E11,Empty,57,10,1,1", file=f)
print("E12,"+columns[1][11]+",58,10,1,1", file=f)
print("F1,"+columns[1][0]+",70,10,1,1", file=f)
print("F2,Empty,69,10,1,1", file=f)
print("F3,"+columns[1][2]+",68,10,1,1", file=f)
print("F4,Empty,67,10,1,1", file=f)
print("F5,"+columns[1][4]+",66,10,1,1", file=f)
print("F6,Empty,65,10,1,1", file=f)
print("F7,"+columns[1][6]+",64,10,1,1", file=f)
print("F8,Empty,63,10,1,1", file=f)
print("F9,"+columns[1][8]+",62,10,1,1", file=f)
print("F10,Empty,61,10,1,1", file=f)
print("F11,"+columns[1][10]+",60,10,1,1", file=f)
print("F12,Empty,59,10,1,1", file=f)
print("G1,Empty,71,10,1,1", file=f)
print("G2,"+columns[1][1]+",72,10,1,1", file=f)
print("G3,Empty,73,10,1,1", file=f)
print("G4,"+columns[1][3]+",74,10,1,1", file=f)
print("G5,Empty,75,10,1,1", file=f)
print("G6,"+columns[1][5]+",76,10,1,1", file=f)
print("G7,Empty,77,10,1,1", file=f)
print("G8,"+columns[1][7]+",78,10,1,1", file=f)
print("G9,Empty,79,10,1,1", file=f)
print("G10,"+columns[1][9]+",80,10,1,1", file=f)
print("G11,Empty,81,10,1,1", file=f)
print("G12,"+columns[1][11]+",82,10,1,1", file=f)
print("H2,Empty,93,10,1,1", file=f)
print("H3,"+columns[1][2]+",92,10,1,1", file=f)
print("H4,Empty,91,10,1,1", file=f)
print("H5,"+columns[1][4]+",90,10,1,1", file=f)
print("H6,Empty,89,10,1,1", file=f)
print("H7,"+columns[1][6]+",88,10,1,1", file=f)
print("H8,Empty,87,10,1,1", file=f)
print("H9,"+columns[1][8]+",86,10,1,1", file=f)
print("H10,Empty,85,10,1,1", file=f)
print("H11,"+columns[1][10]+",84,10,1,1", file=f)
print("H12,Empty,83,10,1,1", file=f)