syntax documentation about dfsql HOT 3 CLOSED

OPERATIONS = (
    And, Or, Not,

    Equals, NotEquals, Greater, GreaterEqual, Less, LessEqual, Is, IsNot,

    Plus, Minus, Multiply, Divide, Modulo, Power,

    StringConcat, StringLower, StringUpper, Like,

    In,
)

AGGREGATE_FUNCTIONS = (
    Sum, Mean, Count, CountDistinct,
)

def custom(x):
    return x + '_custom_addition'

data_source.register_function('custom', custom)
sql = "SELECT custom(\"a\")"
query_result = data_source.query(sql)
assert query_result == 'a_custom_addition'

from dfsql import sql_query

sql_query('SELECT magic_function(column1) FROM df', df=df, custom_functions={'magic_function': lambda x: x*x})