All Questions
7 questions
-1
votes
1
answer
56
views
Clone data with new table in oracle using pandas
I am trying to clone SCOTT.EMP table with TEST table. However datatypes are not matching.
Please advise how to create a clone of EMP with new Table "TEST" with Same datatype in python pandas....
- 77
0
votes
0
answers
38
views
Pandas - decimal.InvalidOperation: [<class 'decimal.ConversionSyntax'>] during read_sql
I am running an extraction of a table in Python using Pandas. I am getting this error:
decimal.InvalidOperation: [<class 'decimal.ConversionSyntax'>]
The code:
dataframes[table] = pd.read_sql(...
- 9
2
votes
1
answer
1k
views
Python using oracledb to connect to Oracle database with Pandas DataFrame Error: "pandas only supports SQLAlchemy connectable (engine/connection)"
I am pretty new to Python and even newer to Pandas and am hoping for some guidance
My company has an on-prem DEV Oracle database that I am trying to connect to using Python & Pandas. After some ...
- 301
0
votes
2
answers
198
views
Pandas read_sql with SQLAlchemy from Oracle Database with many parameters
I have a working setup to read sql data into a pandas dataframe:
connect_string = f"DSN={config.DB};UID={credentials['UID']};PWD={credentials['pwd']};DBQ={config.DB_server};DBA=W;APA=T;EXC=F;FEN=...
- 593
0
votes
0
answers
79
views
data migration (georeferenced data) from oracle to postgres
First, the Python code should connect to an Oracle database and store the retrieved data using the pandas library. Then, a connection to the relevant PostgreSQL database will be established. A table ...
user8044707
0
votes
1
answer
143
views
How can I pass a variable from CSV file to Oracle SQL query fetch in Python?
I have the following piece of code where I read a csv file and connect to the database. then I want to pass two columns from CSV file as variable to my query and eventually convert the result to a pd ...
- 31
0
votes
1
answer
273
views
Python : How to handle case-sensitive and double-quoted postgres column name?
I have python script for incremental data processing. The data source come from Oracle 32-bit and target table is Postgres like below :
import pandas as pd
import cx_Oracle
import psycopg2
import os
...
- 156