def test4(self):
df = self.example_df
out = add_expression_column(self.example_df, ['str2', 'num3', 'str3', 'num4'],
[''' str1 || '_a' ''',
''' case when num1 > 2 then 100 else 0 end''',
''' cast(num1 as char)''',
''' cast(num1 as float)'''], expr_type='sqlite')['out_table']
def test7(self):
out = add_expression_column(self.example_df,
['new_num1', 'new_num2', 'new_num3', 'new_num4',
'new_num5', 'new_num6', 'new_num7',
'new_str1', 'new_str2'],
['log(num1)', 'exp(num1)', 'sin(num1)', 'cos(num1)',
'sqrt(num1)', 'arctan(num1)', 'num1 in [1,3,5]',
'''str1 in ['a', 'c']''', '''str1 in ['a', 'c'] & str1 in ['b', 'c']'''], expr_type='python')
def test6(self):
df = self.example_df
out = add_expression_column(df, ['str10'], ['str1 || 100'])
print(out['out_table'])
def test1(self):
out = add_expression_column(self.example_df, ['num3', 'num4'],
['log(num1)', 'sqrt(num3)'],
expr_type='python')
print(out['out_table'])
def test6(self):
df = self.example_df
out = add_expression_column(df, ['str10'], ['str1 || 100'])
