Sending data from variable to sql query in pandas read_sql(')

Question

I want to send start date and end date value into my sql query from 2 separate variables. Suppose, I have start_date = '2020-05-14' and end_date = '2020-07-08' stored in a variable. Now my query is:

db_connection_str = 'mysql+pymysql://username:password@host/table_name'
db_connection = create_engine(db_connection_str)
def myfunc(start_date, end_date):
    sql_syn = "SELECT col_id, col_a, col_b, date, FROM en_stat where date between :start_date and :end_date"
    sql_df = pd.read_sql(sql_syn, con=db_connection, chunksize=100)

how to pass the start_date and end_date values dynamically for this particular code.

Mayank Porwal · Accepted Answer · 2021-03-15 06:34:10Z

3

Use python3 f-strings:

def myfunc(start_date, end_date):
    sql_syn = f"SELECT col_id, col_a, col_b, date, FROM en_stat where date between {start_date} and {end_date}"
    sql_df = pd.read_sql(sql_syn, con=db_connection, chunksize=100)

answered Mar 15, 2021 at 6:34

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Sending data from variable to sql query in pandas read_sql(')

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related