I’m trying to red and execute a SQL file in Python using sqlalchemy. Should be simple, right? I get this error Why am I getting this error? I’m not sure if this is a file encoding error or a SQLAlchemy error. Ideally, this should be simple. EDIT: This code works fine, assuming the table temp exist…
Tag: python
SQL & Pandas Efficiency [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 2 years ago. Improve this question Quick question. What is the rule of thumb when deciding where to begi…
Parsing a variable into a sql statement in Python
I have the following insert statement that let me parse sql query into a python file and then returning a dataframe of that data that is collected from the query params = ‘DRIVER={ODBC Driver 13 …
pyodbc.ProgrammingError: (‘The SQL contains 1 parameter markers, but 7 parameters were supplied’, ‘HY000’) [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 2 years ago. Improve this question When running the below script it ends in the following error, as I do find other posts o…
Python Pandas non equal join
Have table OUT Need: so i need make non equal join equivalent SQL query : or as SQL query: The problem in PANDAS is that NON EQUAL SELF JOIN cannot be done with MERGE. And I can’t find another way….. Answer We can solve this in pandas in a smarter way by using groupby with agg and joining the stri…
How to convert an SQL Output to a python list [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question So basically I have an SQL database with 5 different columns of data. what I am trying to do…
Return a table location (path) using SQL query (from Python code)
I am trying to return a table location (path) using a SQL query (in my Python code). Is it possible? I’m using Hive and the data is stored in hdfs. I found this snippet of code elsewhere: But unfortunately I don’t understand it, so I don’t even know how to customise it to my problem. I want …
Binding dates to SQL in Python for cx_Oracle
I am using the following query to select logs fro a logs table. I have the following dictionary of parameters: and executing the query as follows : Now the problem is I am not getting any values for this date range. But if I execute the query in Oracle, by specifying the dates, it is working. What is wrong he…
Python – loop through same query with different variables, merge data frames
I have a query in SAS where I use a Macro variable to repeat a query to Teradata with a different variable. We have 5 databases, one for each state, where I run the same query, but use the variable to update the state, then mend all data sets. I’m looking for help in how I can do this in
How to retry after sql connection failed in python?
Whats the right way to retry when connection/write to a DB fails in python? Im trying to use this code and it works until i restart my sql server and python tries to connect to it i get “retry after …