Pandas read_sql_query with WHERE condition

Question

I am trying read data from SQL Server into a dataframe using pandas.read_sql_query. I have to set a condition where calendar year = 2020. I am using this syntax:

pd.read_sql_query('SELECT * FROM [abc] WHERE [calendarYear] = 2020', connectionObject)

I am getting an error:

Conversion failed when converting the nvarchar value 'UNKNOWN' to data type int.

Can anyone please help me with the syntax?

Thanks.

Why is calendarYear not an int type? I strongly suggest you make it so — Charlieface
– Charlieface, Commented Mar 8, 2022 at 15:26

ArchAngelPwn · Accepted Answer · 2022-03-08 14:28:58Z

1

This is probably because your calendarYear is a nvarchar so when you search only 2020 it throws an error. Try and put some '' around 2020 so your code would look like

pd.read_sql_query("SELECT * FROM [abc] WHERE [calendarYear] = '2020'", connectionObject)

answered Mar 8, 2022 at 14:28

ArchAngelPwn

3,0461 gold badge6 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Pandas read_sql_query with WHERE condition

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