How do I use query IN an array in python?

Question

I'm still rather new to querying using Python.

So, I have a connection to a table in SMSS via Visual Studio Code. I took a column from the table, turned it into a dataframe, dropped the duplicates, and stored the result in an array with numPy. Now, my goal is to query and SELECT id FROM [my table] WHERE acc_num IN [my array].

I'm using pandas to query using the connection as well.

I'm a little lost on what the structure of the code should be when trying to access this array that it separate from the database itself. Any help is appreciated.

Abishek VK · Accepted Answer · 2022-02-01 16:28:34Z

1

Try this, Assuming the array name is 'array'

tup_ar = tuple(array.flat)
tup_ar
query = "SELECT name FROM table_name WHERE field IN {}".format(tup_ar)
##Execute the query

Execute the query string created using any of the functions available in python.

answered Feb 1, 2022 at 16:28

Abishek VK

5243 silver badges12 bronze badges

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

2 Comments

codercoder Over a year ago

That seems to have worked. I was missing out on using the flat() method.

Abishek VK Over a year ago

Cool. Then please accept the solution.

Collectives™ on Stack Overflow

How do I use query IN an array 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