Converting SQL Code To Python Code Query

[eddywinch82]

I understand buran,

To keep on topic in this Thread, what should I type, to do a conversion of the SQL Code, to Python Code ? Those lines of Code converted, to Python Pandas Code, should help me with the issue I have.

Regards

Eddie Winch

[jim2007]

Thanks for that info Larz60+, I see you can't simply, have SQL code translated into Python Code, using SQLAlchemy ?

Code has to be executed, as part of querying a database etc. Because at the moment, I only want, direct translation of that SQL Code, to Python Code.

Eddie

It does not matter what language you pick, you will not be able to translate the artifact of SQL you posted into it because it’s copying data directly into a temp table on the server!

And executing this type of thing on a client could be problematic in any case if it’s a large data set since all you are doing is dragging data across the wire only to push it back over again.

If you tell us what you are trying to achieve, perhaps we can suggest a better way of achieving it.

[eddywinch82]

Hi jim2007,

On Page 3 of the Thread, the Link I provided in my post earlier, I talk about the issue I am having. That part of SQL Code I posted, is significant, because it deals, with adding of two particular Numerical values together, which I wan't to do in the Python Pandas Code, I have at the moment, which I run in Jupyter Notebook.

So if someone could tell me what the Python Code, equivalent would be, for those lines of SQL Code. I could change my current Code hopefully, to achieve the Output DataFrame I want.

Regards

Eddie Winch

[buran]

I am closing this thread now, there is no sense in continuing here.
Keep the discussion in the original thread.