def cleanblock(self):
"""clean one block of a table"""
blockaddr = self.block * self.dim * BSIZE
if blockaddr >= self.numrows: # done
if self.hideN:
self.rowl.HideLabelsWithDataAt(2, self.lastlbl)
if self.hideinsig < 1.:
self.rowl.HideLabelsWithDataAt(1, self.lastlbl)
if self.hideL and hidelok:
self.rowl.SetRowLabelWidthAt(1,self.lastlbl, 0)
###self.rowl.SetValueAt(1, self.lastlbl, " ")
return False
for row in range(self.dim):
rowaddr = blockaddr + row * BSIZE
if self.lowertri: # blank cells past dialgonal
for c in range(row + 1, self.dim):
self.datacells.SetValueAt(rowaddr, c, " ")
self.datacells.HideFootnotesAt(rowaddr, c)
if not self.hideN:
self.datacells.SetValueAt(rowaddr+2, c, " ")
if not (self.hideinsig < 1.):
self.datacells.SetValueAt(rowaddr+1, c, " ")
# blank insignificant cells (if requested) and highlight large corrs (if requested)
for c in range(self.dim): # column loop
if self.lowertri and c > row:
continue
skip = False
if self.hideinsig < 1. or self.boldsig < 1.: # blank insig
if c != row:
try:
sig = floatex(self.datacells.GetValueAt(rowaddr+1, c))
except:
sig = 1. # hide if not a number
if sig > self.hideinsig:
self.datacells.SetValueAt(rowaddr, c, " ")
self.datacells.HideFootnotesAt(rowaddr, c) # remove all footnotes
skip = True
elif sig <= self.boldsig:
self.datacells.SetTextStyleAt(rowaddr, c,
SpssClient.SpssTextStyleTypes.SpssTSBold)
corr = None
if self.emphlarge < 1. and (not skip) and c != row: # highlight large corrs unless failed sig test
try:
corr = floatex(self.datacells.GetValueAt(rowaddr, c))
except:
corr = 10.
if abs(corr) >= self.emphlarge:
self.datacells.SetTextStyleAt(rowaddr, c, style)
self.datacells.SetBackgroundColorAt(rowaddr, c, color)
if (not self.decimals is None) and (not skip):
self.datacells.SetHDecDigitsAt(rowaddr, c, self.decimals)
self.block += 1
def cleanblock(self):
"""clean one block of a table"""
blockaddr = self.block * self.dim * BSIZE
if blockaddr >= self.numrows: # done
if self.hideN:
self.rowl.HideLabelsWithDataAt(2, self.lastlbl)
if self.hideinsig < 1.:
self.rowl.HideLabelsWithDataAt(1, self.lastlbl)
if self.hideL and hidelok:
self.rowl.SetRowLabelWidthAt(1,self.lastlbl, 0)
###self.rowl.SetValueAt(1, self.lastlbl, " ")
return False
for row in range(self.dim):
rowaddr = blockaddr + row * BSIZE
if self.lowertri: # blank cells past dialgonal
for c in range(row + 1, self.dim):
self.datacells.SetValueAt(rowaddr, c, " ")
self.datacells.HideFootnotesAt(rowaddr, c)
if not self.hideN:
self.datacells.SetValueAt(rowaddr+2, c, " ")
if not (self.hideinsig < 1.):
self.datacells.SetValueAt(rowaddr+1, c, " ")
# blank insignificant cells (if requested) and highlight large corrs (if requested)
for c in range(self.dim): # column loop
if self.lowertri and c > row:
continue
skip = False
if self.hideinsig < 1. or self.boldsig < 1.: # blank insig
if c != row:
try:
sig = floatex(self.datacells.GetValueAt(rowaddr+1, c))
except:
sig = 1. # hide if not a number
if sig > self.hideinsig:
self.datacells.SetValueAt(rowaddr, c, " ")
self.datacells.HideFootnotesAt(rowaddr, c) # remove all footnotes
skip = True
elif sig <= self.boldsig:
self.datacells.SetTextStyleAt(rowaddr, c,
SpssClient.SpssTextStyleTypes.SpssTSBold)
corr = None
if self.emphlarge < 1. and (not skip) and c != row: # highlight large corrs unless failed sig test
try:
corr = floatex(self.datacells.GetValueAt(rowaddr, c))
except:
corr = 10.
if abs(corr) >= self.emphlarge:
self.datacells.SetTextStyleAt(rowaddr, c, style)
self.datacells.SetBackgroundColorAt(rowaddr, c, color)
if (not self.decimals is None) and (not skip):
self.datacells.SetHDecDigitsAt(rowaddr, c, self.decimals)
self.block += 1
def datacellstyles(self, roworcol, expression):
"""Apply datacell styles looping over rows or columns
roworcol is the row or column number to process.
expression is True if an applyto expression exists."""
coldim = self.dimension == "columns"
if coldim:
limit = self.numdatarows
else:
limit = self.numdatacols
for i in range(limit):
outcome = True
if coldim:
row, col = i, roworcol
else:
row,col = roworcol, i
if expression:
try: # this api is new in V18 or 17.0.2
x = float(self.datacells.GetUnformattedValueAt(row, col))
except AttributeError:
x = floatex(self.datacells.GetValueAt(row, col), self.datacells.GetNumericFormatAt(row, col))
except ValueError:
x = self.datacells.GetValueAt(row, col) # 2/19/2015
try:
if outcome:
outcome = eval(self.applyto, {'x':x, "i":i, "ii": roworcol})
except (NameError, SyntaxError), e:
if not isinstance(self.applyto, unicode):
self.applyto = unicode(self.applyto, self.encoding)
raise ValueError(_("APPLYTO expression is invalid: %s") % self.applyto)
except:
outcome = False
def colorCrosstabResiduals(obj, i, j, numrows, numcols, section, more, custom):
if section == "datacells":
try:
if abs(floatex(obj.GetValueAt(i, j))) >= custom.get("thresh", 2.0):
for k in range(custom.get("number", 1) + 1):
obj.SetBackgroundColorAt(i - k, j, RGB((255, 0, 0)))
obj.SetBackgroundColorAt(i - 1, j, RGB((255, 0, 0)))
except:
pass
def colorCrosstabResiduals(obj, i, j, numrows, numcols, section, more,custom):
if section == "datacells":
try:
if abs(floatex(obj.GetValueAt(i,j))) >= custom.get("thresh", 2.0):
for k in range(custom.get("number", 1) + 1):
obj.SetBackgroundColorAt(i - k, j, RGB((255,0,0)))
obj.SetBackgroundColorAt(i-1, j, RGB((255,0,0)))
except:
pass
def crittest(value): """return whether value meets the criterion test. Tries to handle locale formatted and decorated strings via floatex function""" try: c = cmp(abs(floatex(value)), critvalue) return olist[c+1] except: return False
def makeSigCoefsBold(obj, i, j, numrows, numcols, section, more):
"""Working on the REGRESSION Coefficients table, make each coefficient
that is significant at the 5% level bold.
Coefficients are column 0, and significance is column 4"""
# a little misuse protection
if section != 'datacells':
return
sig = floatex(obj.GetValueAt(i, 4), obj.GetNumericFormatAt(i, 4))
if sig <= 0.05:
obj.SetTextStyleAt(i,0, SpssClient.SpssTextStyleTypes.SpssTSBold)
more.rowlabelarray.SetTextStyleAt(i, 3, SpssClient.SpssTextStyleTypes.SpssTSBold)
def makeSigCoefsBold(obj, i, j, numrows, numcols, section, more):
"""Working on the REGRESSION Coefficients table, make each coefficient
that is significant at the 5% level bold.
Coefficients are column 0, and significance is column 4"""
# a little misuse protection
if section != 'datacells':
return
sig = floatex(obj.GetValueAt(i, 4), obj.GetNumericFormatAt(i, 4))
if sig <= 0.05:
obj.SetTextStyleAt(i, 0, SpssClient.SpssTextStyleTypes.SpssTSBold)
more.rowlabelarray.SetTextStyleAt(
i, 3, SpssClient.SpssTextStyleTypes.SpssTSBold)
def datacellstyles(self, roworcol, expression):
"""Apply datacell styles looping over rows or columns
roworcol is the row or column number to process.
expression is True if an applyto expression exists."""
coldim = self.dimension == "columns"
if coldim:
limit = self.numdatarows
else:
limit = self.numdatacols
for i in range(limit):
outcome = True
if coldim:
row, col = i, roworcol
else:
row,col = roworcol, i
if expression:
try: # this api is new in V18 or 17.0.2
x = float(self.datacells.GetUnformattedValueAt(row, col))
except AttributeError:
x = floatex(self.datacells.GetValueAt(row, col), self.datacells.GetNumericFormatAt(row, col))
except ValueError:
x = self.datacells.GetValueAt(row, col) # 2/19/2015
try:
if outcome:
outcome = eval(self.applyto, {'x':x, "i":i, "ii": roworcol})
except (NameError, SyntaxError) as e:
if not isinstance(self.applyto, str):
self.applyto = str(self.applyto, self.encoding)
raise ValueError(_("APPLYTO expression is invalid: %s") % self.applyto)
except:
outcome = False
if outcome:
# checksigcells will return True if
# - not doing significance formatting or
# - doing significance formatting and it should be applied to this cell
# Thus sig formatting can suppress formatting that would otherwise be applied
if self.checksigcells(row, col):
for f in self.stylecalls:
rc = f(self.datacells, row, col, self.numdatarows, self.numdatacols, "datacells", self)
if rc is False:
return rc