News for hackers. Stuff that matters.
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?
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.

[1] https://dbplyr.tidyverse.org/

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 faizshah on Monday November 04, 2019 @04:45PM (#21446852)
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 medecau on Monday November 04, 2019 @04:25PM (#21446666)
Re:What SQL Analysts Need to Know About Python (2016) by shrikant on Monday November 04, 2019 @05:48PM (#21447496)