{"repo":"bodo-ai/PyDough","free":true,"listed":false,"github":"https://github.com/bodo-ai/PyDough","clone":"git clone https://github.com/bodo-ai/PyDough.git","description":"Analytics DSL for Python","language":"Python","stars":35,"topics":["analytics","artificial-intelligence","big-data","data-science","defog","defog-ai","machine-learning","pandas","python","sql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"PyDough PyDough is an alternative DSL that can be used to solve analytical problems by phrasing questions in terms of a logical document model instead of translating to relational SQL logic. What Is PyDough PyDough allows expressing analytical questions with a purpose built DSL that uses a knowledge graph semantic layer, which incorporates hierarchies and relationships inherent in the data, and makes it more governable. PyDough code is Python, and can be written and analysed as such, and uses a lazy evaluation scheme that does not qualify or execute any logic until requested! We execute by translating its logic into SQL which can be executed in any SQL dialect. Consider the following information represented by the tables in a database: - There are people; each person has a name, ssn, birth date, records of jobs they have had, and records of schools they have attended. - There are employment records; each job record has the ssn of the person being employed, the name of the company, and the total income they made from the job. - There are education records; each education record has the ssn of the person attending the school, the name of the school, and the total tuition they paid to that school. Suppose I want to know for every person their name & the total income they've made from all jobs minus the total tuition paid to all schools. However, I want to include people who have never had a job or never attended any schools, and I need to account for people who could have had mu","default_branch":null,"files":null,"tree":[],"storefront":"/r/bodo-ai","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/bodo-ai/PyDough/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}