Passing Parameters to SQLDF in Python

Question

I'm trying to pass parameters through sqldf in python:

id = '001F5'
q = """select * from df where id= %id; """
test = sqldf(q, globals())

I've tried many things e.g. +id, "+id;"" and %id etc and nothing works, is it possible to do this at all?

Many Thanks

Scratch'N'Purr · Accepted Answer · 2016-06-20 14:20:13Z

3

Try:

id = "'001F5'"
q = "select * from df where id=" + id + ";"
test = sqldf(q, globals())

Or you can try:

id = "'001F5'"
q = "select * from df where id={0};".format(id)
test = sqldf(q, globals())

answered Jun 20, 2016 at 14:20

Scratch'N'Purr

10.5k2 gold badges39 silver badges54 bronze badges

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

2 Comments

anurag pandey Over a year ago

let say i have to get the specific column, can i pass those column names as argument also.

Scratch'N'Purr Over a year ago

@anuragpandey you'd have to build the q format string to incorporate the column names, e.g. q = "select {my_col} from df".format(my_col='Column1'). If it's multiple columns, then add the column names into a list and then set my_col = ','.join(my_list).

Collectives™ on Stack Overflow

Passing Parameters to SQLDF in Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related