Vuu helpful to all

[vuu]

8 minutes ago, Bhai said:

Koo

Vuu

[sri_india]

3 hours ago, vuu said:

For everyone tired to move data back and forth between system just in oder to calculate a simple aggregate, or writing a hard to maintain script in Python for that purpose, we added complex SQL--like queries  (select, project, joins, aggregates, windowing,  nested queries, etc -- pretty much the entire SQL) as a builtin expression in Python. Please give it a try here www.pythonql.org and send us comments ! Thanks for the feedback.

Github stared bro 

[sri_india]

3 hours ago, k2s said:

Vuu post examples too

from collections import namedtuple
ord = namedtuple('Order', ['cust_id','prod_id','price'])
cust = namedtuple('Cust', ['cust_id','cust_name'])

ords = [ ord(1,1,"16.54"),
         ord(1,2,"18.95"),
         ord(1,5,"8.96"),
         ord(2,1,"????"),
         ord(2,2,"20.00") ]

custs = [ cust(1,"John"), cust(2,"Dave"), cust(3,"Boris") ]

# Basic SQL query, but with some data cleaning
res = [select (name, sum(price) as sum)
        for o in ords
        let price = try float(o.price)  except 0
        for c in custs
        where c.cust_id == o.cust_id
        group by c.cust_id as id, c.cust_name as name]

print (res)

[vuu]

5 minutes ago, sri_india said:

from collections import namedtuple
ord = namedtuple('Order', ['cust_id','prod_id','price'])
cust = namedtuple('Cust', ['cust_id','cust_name'])

ords = [ ord(1,1,"16.54"),
         ord(1,2,"18.95"),
         ord(1,5,"8.96"),
         ord(2,1,"????"),
         ord(2,2,"20.00") ]

custs = [ cust(1,"John"), cust(2,"Dave"), cust(3,"Boris") ]

# Basic SQL query, but with some data cleaning
res = [select (name, sum(price) as sum)
        for o in ords
        let price = try float(o.price)  except 0
        for c in custs
        where c.cust_id == o.cust_id
        group by c.cust_id as id, c.cust_name as name]

print (res)

Vuu

[vuu]

6 minutes ago, sri_india said:

Github stared bro 

Vuu

[sri_india]

3 hours ago, vuu said:

Vuu yes 

 

26 minutes ago, vuu said:

Vuu

 

26 minutes ago, vuu said:

Vuu

is Pavel   your friend or colleague bro???? 

[Bhai]

7 minutes ago, sri_india said:

 

 

is Pavel   your friend or colleague bro???? 

Vuu

[sri_india]

2 minutes ago, Bhai said:

Vuu

vuu aa bonda bro .. that project is owned by a Russian data scientist 

[vuu]

4 hours ago, sri_india said:

 

 

is Pavel   your friend or colleague bro???? 

 Uu

[vuu]

4 hours ago, sri_india said:

 

 

is Pavel   your friend or colleague bro???? 

Vuu

[vuu]

4 hours ago, sri_india said:

vuu aa bonda bro .. that project is owned by a Russian data scientist 

Vuu