how to copy and paste sql query in pandas read_Sql

Question

I'm new to python and am trying to run sql code in python and have the results in a pandas dataframe. I'm using the following code and the code runs when i have a simple sql query. But when I try to run a super long and complex query with proper formatting in sql, it fails. Can I use any module/option so python recognizes the indention and spacing within sql queries as python specific?

cnxn=...#here it's the connection to my sql server database sql_2=

r'( Select distinct NPI, 
        practice_code=RIGHT('000'+CAST(newcode AS VARCHAR(3)),3),
        SRcode,
        StandardZip,
        Zipclass,
        CountySSA,
        PrimaryCountySSA,
        PrimaryCounty,
        PrimaryCountyClass,
        Lat_Clean,
        Long_Clean
    FROM Docusinporactice a
    LEFT JOIN locationInfo b 
    on a.zip=b.zip
    )

sql_data_test=pd.read_sql_query(sql_2, cnxn)

Can try to wrap long text with triple quotes, like """SOME LONG STRING""" — reptilicus
– reptilicus, Commented May 23, 2016 at 16:52

n1tk · Accepted Answer · 2016-05-23 17:11:59Z

2

r = """ Select distinct NPI, practice_code=RIGHT('000'+CAST(newcode AS VARCHAR(3)),3), SRcode, StandardZip, Zipclass, CountySSA, PrimaryCountySSA, PrimaryCounty, PrimaryCountyClass, Lat_Clean, Long_Clean FROM Docusinporactice a LEFT JOIN locationInfo b on a.zip=b.zip """

this way should work the sql statement

answered May 23, 2016 at 17:11

n1tk

2,5502 gold badges25 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

n1tk Over a year ago

you are welcome. I would appreciate if you'll accept as the answer.

Collectives™ on Stack Overflow

how to copy and paste sql query in pandas read_Sql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related