CX_Oracle-将数据从Oracle导入到Pandas数据框 [英] CX_Oracle - import data from Oracle to Pandas dataframe

问题描述

我是python的新手，我想使用此简单查询将一些数据从Oracle数据库导入python(pandas数据框)

I'm new in python and I want import some data from a Oracle Database to python (pandas dataframe) using this simple query

SELECT* 
                FROM TRANSACTION
                WHERE DIA_DAT >=to_date('15.02.28 00:00:00',  'YY.MM.DD HH24:MI:SS')
                AND (locations <> 'PUERTO RICO'
                OR locations <> 'JAPAN')
                AND CITY='LONDON'

我做了

import cx_Oracle
ip = 'XX.XX.X.XXX'
port = YYYY
SID = 'DW'
dsn_tns = cx_Oracle.makedsn(ip, port, SID)

connection = cx_Oracle.connect('BA', 'PASSWORD', dsn_tns)

df_ora = pd.read_sql('SELECT* FROM TRANSACTION WHERE DIA_DAT>=to_date('15.02.28 00:00:00',  'YY.MM.DD HH24:MI:SS') AND (locations <> 'PUERTO RICO' OR locations <> 'JAPAN') AND CITY='LONDON'', con=connection)  

但是我有这个错误

SyntaxError: invalid syntax

我做错了什么?

谢谢

推荐答案

您需要正确引用SQL查询.如果您查看问题(或IDE)中突出显示的语法，则会注意到单引号没有按预期工作.

You need to properly quote your SQL Query. If you look at the syntax highlighting in your question (or an IDE), you'll notice that the single quotes aren't working as you expect.

将最外面的引号更改为双引号-如果要在一行上全部-将三引号更改为多行:

Change the outer most quotes to double quotes - if you want it all on one line - or triple quotes if you want it across multiple lines:

query = """SELECT* 
           FROM TRANSACTION
           WHERE DIA_DAT >=to_date('15.02.28 00:00:00',  'YY.MM.DD HH24:MI:SS')
           AND (locations <> 'PUERTO RICO'
           OR locations <> 'JAPAN')
           AND CITY='LONDON'"""
df_ora = pd.read_sql(query, con=connection)

这篇关于CX_Oracle-将数据从Oracle导入到Pandas数据框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！