def _search(table,
user_dict=pd.DataFrame(),
input_cols=[],
search_words=[],
synonym_dict=[],
main_operator='and'):
if len(search_words) == 0:
raise BrighticsFunctionException('0033', 'Search Words')
for search_word in search_words:
if search_word is None:
raise BrighticsFunctionException('0033', 'Search Words')
_table = table.copy()
filter_list = []
if len(input_cols) == 0:
validate(require_param('input_cols'))
for _list in product(input_cols, search_words):
c, od = _list
filter_list.append([c, od.strip('\'')])
_out_table = _table
filtered_set = set(_out_table.index)
cond = np.full(len(_table), True).tolist()
for _filter in filter_list:
cond = (cond) & (_table[_filter[0]].str.contains(_filter[1]))
_out_table = _table.loc[list(
filtered_set.intersection(set(_table[cond].index)))]
if len(user_dict.index) != 0:
filter_list = []
search_words = [
user_dict['value'][i] for i, key in enumerate(user_dict['key'])
if key in search_words
]
print(search_words)
for _list in product(input_cols, search_words):
c, od = _list
filter_list.append([c, od.strip('\'')])
filtered_set = set()
syno_cond = np.full(len(_table), False).tolist()
for _filter in filter_list:
syno_cond = (syno_cond) | (_table[_filter[0]].str.contains(
_filter[1]))
syno_cond = syno_cond | cond
_out_table = _table.loc[list(
filtered_set.union(set(_table[syno_cond].index)))]
return {'out_table': _out_table}
def _tukeys_range_test(table, response_cols, factor_col, alpha=0.05):
if alpha < 0.001 or alpha >= 0.9:
raise BrighticsFunctionException("0006", ['alpha', 0.001, 0.9])
rb = BrtcReprBuilder()
rb.addMD("""## Tukey's range test Result""")
for response_col in response_cols:
data = table[response_col]
posthoc = pairwise_tukeyhsd(data, table[factor_col], alpha=alpha)
posthoc_html = posthoc._results_table.as_html()
posthoc.plot_simultaneous()
rb.addMD("""### {response_col}""".format(response_col=response_col))
rb.addHTML(posthoc_html)
rb.addPlt(plt)
plt.clf()
return {'result': {'_repr_brtc_': rb.get()}}
def raise_runtime_error(error_message, true_condition=False):
if not true_condition:
raise BrighticsFunctionException('0100', [error_message])
def raise_error(error_code, error_message_params, true_condition=False):
if not true_condition:
raise BrighticsFunctionException(error_code, error_message_params)