Re:What SQL Analysts Need to Know About Python (2016)
by starpilot on Monday November 04, 2019 @02:31PM
(#21445453)
Is anyone working on a translator for pandas dataframe syntax to SQL?
[ Parent
| on HN ]
Re:What SQL Analysts Need to Know About Python (2016)
by alexhutcheson on Monday November 04, 2019 @02:48PM
(#21445671)
In the R world, dbplyr[1] does this amazingly well.
Re:What SQL Analysts Need to Know About Python (2016)
by airstrike on Monday November 04, 2019 @08:26PM
(#21448726)
tidyverse is just an mind-boggingly amazing ecosystem of packages
Forget Da Vinci, the first man to be cloned should be Hadley Wickham
Re:What SQL Analysts Need to Know About Python (2016)
by starpilot on Monday November 04, 2019 @08:56PM
(#21448898)
Dang, Ibis doesn't support Redshift or SQL Server. I'm also having trouble understanding what it really is - it's an entire framework for big data it seems and not just a translator. What I'd really like is just that, something that turns pandas dataframe operation into ANSI SQL. So input pandas2sql('tablename["col"]') -> "select col from tablename". Something really simple to use.
Re:What SQL Analysts Need to Know About Python (2016)
by goatinaboat on Tuesday November 05, 2019 @01:48AM
(#21450257)
Pandas has from_sql and to_sql methods that are compatible with SQLAlchemy if you insist on using an ORM, that gets you most of the way there...
Re:What SQL Analysts Need to Know About Python (2016)
by philipov on Wednesday November 06, 2019 @03:25AM
(#21460651)
SQLAlchemy is more than just an ORM. It also has sql expression language, for writing queries using python without using any ORM features.
Re:What SQL Analysts Need to Know About Python (2016)
by shrikant on Monday November 04, 2019 @05:48PM
(#21447496)
There's also this: https://pypi.org/project/pandasql/