def createRandomTable(cls, name, nrow, ncol, ncolstr=0,
low_int=0, hi_int=100):
"""
Creates a table with random integers as values
Input: name - name of the table
nrow - number of rows
ncol - number of columns
ncolstr - number of columns with strings
low_int - smallest integer
hi_int - largest integer
"""
ncol = int(ncol)
nrow = int(nrow)
table = cls(name)
ncolstr = min(ncol, ncolstr)
ncolint = ncol - ncolstr
c_list = range(ncol)
random.shuffle(c_list)
for n in range(ncol):
column = Column("Col_" + str(n))
if c_list[n] <= ncolint - 1:
values = np.random.randint(low_int, hi_int, nrow)
values_ext = values.tolist()
else:
values_ext = ut.randomWords(nrow)
#values_ext.append(None)
column.addCells(np.array(values_ext))
table.addColumn(column)
versioned_file = VersionedFile(
settings.SCISHEETS_DEFAULT_TABLEFILE,
st.SCISHEETS_USER_TBLDIR_BACKUP,
st.SCISHEETS_MAX_TABLE_VERSIONS)
table.setVersionedFile(versioned_file)
return table
