Exemplos de PandasReader._execute_ast_df em Python

Exemplo n.º 1

 def test_count_no_rows_exact_typed(self):
     reader = PandasReader(df, schema)
     query = QueryParser(schema).queries("SELECT COUNT(*) as c FROM PUMS.PUMS WHERE age > 100")[0]
     trs = reader._execute_ast_df(query)
     assert(trs['c'][0] == 0)

Exemplo n.º 2

 def test_sum_noisy(self):
     reader = PandasReader(df, schema)
     query = QueryParser(schema).queries("SELECT SUM(age) as age_total FROM PUMS.PUMS")[0]
     trs = reader._execute_ast_df(query)
     assert(trs['age_total'][0] > 1000)