-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathtabler.py
205 lines (190 loc) · 7.41 KB
/
tabler.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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
"""
tabler.py
Creates tables in HTML for Salstat
Submit a list of [heading: value] pairs in the desired order
p-values are automatically formatted as %1.6f (all other floats as %5.3f?)
The first two routines are generic and for single answer results.
Following are a handful of tabler functions for particular tests
(c) 2013, Alan James Salmoni
"""
def tableANOVAWithin(results):
ln1 = '<table class="table table-striped"><tr>\n'
headhtml = '<tr><th>Variable</th><th>Source</th><th>Sum of squares</th><th>DF</th><th>Mean square</th><th>F</th><th>p</th></tr>\n'
l1vars = ("Name",results["SSbet"],results["DFbet"],results["MSbet"],results["F"],results["p"])
l2vars = (results["SSwit"],results["DFwit"],results["MSwit"])
l3vars = (results["SSres"],results["DFres"],results["MSres"])
l4vars = (results["SSint"])
l5vars = (results["SStot"],results["DFtot"])
line1 = '<tr><td>%s</td><td>Between groups</td><td>%.3f</td><td>%d</td><td>%.3f</td><td>%.3f</td><td>%1.4f</td></tr>\n'%(l1vars)
line2 = '<tr><td></td><td>Within groups</td><td>%.3f</td><td>%d</td><td>%.3f</td><td></td><td></td></tr>\n'%(l2vars)
line3 = '<tr><td></td><td>Residual</td><td>%.3f</td><td>%d</td><td>%.3f</td><td></td><td></td></tr>\n'%(l3vars)
line4 = '<tr><td></td><td>Interaction</td><td>%.3f</td><td></td><td></td><td></td><td></td></tr>\n'%(l4vars)
line5 = '<tr><td></td><td>Total</td><td>%.3f</td><td>%d</td><td></td><td></td><td></td></tr>\n'%(l5vars)
line = ln1+headhtml+line1+line3+line4+line2+line5+'</table>'
return line
def tableANOVABetween(results):
ln1 = '<table class="table table-striped"><tr>\n'
headhtml = '<tr><th>Variable</th><th>Source</th><th>Sum of squares</th><th>DF</th><th>Mean square</th><th>F</th><th>p</th></tr>\n'
l1vars = ("Name",results["SSbet"],results["DFbet"],results["MSbet"],results["F"],results["p"])
l2vars = (results["SSwit"],results["DFerr"],results["MSerr"])
l3vars = (results["SStot"],results["DFtot"])
line1 = '<tr><td>%s</td><td>Between groups</td><td>%.3f</td><td>%d</td><td>%.3f</td><td>%.3f</td><td>%1.4f</td></tr>\n'%(l1vars)
line2 = '<tr><td></td><td>Within groups</td><td>%.3f</td><td>%d</td><td>%.3f</td></tr>\n'%(l2vars)
line3 = '<tr><td></td><td>Total</td><td>%.3f</td><td>%d</td></tr>\n'%(l3vars)
line = ln1+headhtml+line1+line2+line3+'</table>'
return line
def table(ListofLists):
ln1 = '<table class="table table-striped"><tr>'
ln2 = '<tr>'
for List in ListofLists:
key = List[0]
val = List[1]
headhtml = '<th>%s</th>'%key
if key == 'p':
try:
foothtml = '<td>%1.6f</td>'%val
except TypeError:
foothtml = '<td>n/a</td>'
elif type(val) is int:
foothtml = '<td>%d</td>'%val
elif (type(val) is str):
foothtml = '<td>%s</td>'%val
#elif type(val) is float:
else:
fltstr = str(val)
foothtml = '<td>%s</td>'%fltstr
# really need to figure out what parameters make a good display for each number
ln1 = ln1 + headhtml
ln2 = ln2 + foothtml
ln1 = ln1 + '</tr>' + ln2 + '</tr>\n</table>\n'
return ln1
def vtable(List):
key = List[0]
vals = List[1:]
btn_id = ' id="%s"'%key
chartbutton = '<a class="btn btn-mini dropdown-toggle"%s data-toggle="dropdown" \
href="#">Chart</a>\n'%btn_id
linehtml = '<tr><td>%s</td>'%(key)
for val in vals:
if key == 'p':
try:
linehtml = '<td>%1.6f</td>'%val
except TypeError:
linehtml = '<td>n/a</td>'
elif type(val) is int:
linehtml = linehtml + '<td>%d</td>'%val
elif (type(val) is str):
linehtml = linehtml + '<td>%s</td>'%val
elif type(val) is float:
linehtml = linehtml + '<td>%s</td>'%str(val)
elif type(val) is tuple:
print ("TUPLE!", val)
else:
try:
linehtml = linehtml + '<td>%s</td>'%str(val)
except:
pass
linehtml = linehtml + '</tr>\n'
return linehtml
def tableHinges(List):
key = List[0]
vals = List[1:]
linehtml = '<tr><td>%s</td>'%(key)
for val in vals:
linehtml += '<td>%s, %s</td>'%(str(val[0]), str(val[1]))
linehtml += '</tr>\n'
return linehtml
def tableMultiples(vals, varName):
table = '<h3>%s</h3><table class="table table-striped">\n'%varName
table += '\t<tr><th>Value</th>'
try:
if vals['freqs']:
table += '<th>Frequencies</th>'
except ValueError:
table += '<th>Frequencies</th>'
try:
if vals['props']:
table += '<th>Proportions</th>'
except ValueError:
table += '<th>Proportions</th>'
try:
if vals['percs']:
table += '<th>Percentages</th>'
except ValueError:
table += '<th>Percentages</th>'
table += '</tr>\n'
N = len(vals['values'])
for idx in range(N):
table += '\t<tr><td>%s</td>'%vals['values'][idx]
try:
if vals['freqs']:
table += '<td>%s</td>'%vals['freqs'][idx]
except ValueError:
table += '<td>%s</td>'%vals['freqs'][idx]
try:
if vals['props']:
table += '<td>%s</td>'%vals['props'][idx]
except ValueError:
table += '<td>%s</td>'%vals['props'][idx]
try:
if vals['percs']:
table += '<td>%s %%</td>'%vals['percs'][idx]
except ValueError:
table += '<td>%s %%</td>'%vals['percs'][idx]
table += '</tr>\n'
table += '</table>\n'
return table
def tableFrequencies(List):
table = '<table class="table table-striped">\n'
table += '\t<tr><th>Value</th><th>Frequency</th></tr>\n'
for var in List:
values = var[0]
freqs = var[1]
table += '<table class="table table-striped">\n'
table += '\t<tr><th>Value</th><th>Frequency</th></tr>\n'
for idx, row in enumerate(values):
table += '\t<tr><td>%s</td><td>%s</td></tr>\n'%(str(row),str(freqs[idx]))
table += '</table>\n'
return table
def tableProportions(List):
"""
Passes two arrays in a list:
array 1 = value
array 2 = corresponding proportions
"""
table = ''
for turn in List:
vals = turn[0]
props = turn[1]
table += '<table class="table table-striped">\n'
table += '\t<tr><th>Value</th><th>Proportion</th></tr>\n'
for idx, val in enumerate(vals):
table += '\t<tr><td>%s</td><td>%s</td></tr>\n'%(str(val),str(props[idx]))
table += '</table>\n'
return table
def tableMode(List):
"""
Produces a table to display modes.
Passed are two arrays:
1 = frequency
2 = modal values
"""
table = '<h3>Mode</h3>\n<table class="table table-striped">\n'
table += '\t<tr><th>Frequency</th><th>Modal values</th></tr>\n'
for turn in List:
freq = turn[0]
vals = turn[1]
table += '\t<tr><td>%s</td><td>%s<br />'%(str(freq), str(vals[0]))
for idx in range(1, len(vals)):
table += '\t%s<br />\n'%(str(vals[idx]))
table += '</td></tr>\n\t<tr><td></td><td></td></tr>\n'
table += '</table>\n'
return table
if __name__ == '__main__':
a1 = ['Variable 1','Var001']
a2 = ['Variable 2','Var002']
a3 = ['df',99]
a4 = ['t',30.0001]
a5 = ['p',0.003]
a = [a1,a2,a3,a4,a5]
print (table(a))