(Sql + Python) df array to string with single quotes?

Question

Goal: how to convert (111, 222, 333) to ('111', '222', '333') for an sql query in Python?

What I have done so far:

I am calling a csv file to a df: dataset = pd.read_csv('simple.csv') print(dataset)

LIST 0 111 1 222 2 333

List11 = dataset.LIST.apply(str) print(List1)

0 111 1 222 2 333

Name: OPERATION, dtype: object

myString = ",".join(List1) print(myString)

111,222,333

sql = "SELECT * FROM database WHERE list IN (%s)" %myString

This does not work. Could you please help?

klin · Accepted Answer · 2018-03-28 19:02:48Z

2

Use format():

list1 = ('111', '222', '333')
myString = ",".join("'{0}'".format(elem) for elem in list1)
print(myString)

gives

'111','222','333'

answered Mar 28, 2018 at 19:02

klin

123k15 gold badges240 silver badges262 bronze badges

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

1 Comment

greencar Over a year ago

After I obtained a list -- it worked like a charm! :) dataset['LIST'].values.tolist() Thanks alot !

Piyush Upadhyay · Accepted Answer · 2018-03-28 19:01:10Z

0

Please try this and verify if it helps-

sql = "SELECT * FROM database WHERE list IN (%s)" % ",".join(map(myString,List1))

answered Mar 28, 2018 at 19:01

Piyush Upadhyay

4455 silver badges12 bronze badges

Comments

MarcinEl · Accepted Answer · 2018-03-28 19:04:14Z

0

There is possibility that it will works.

myString = "','".join(List1)
sql = "SELECT * FROM database WHERE list IN ('%s')" %myString

answered Mar 28, 2018 at 19:04

MarcinEl

2192 silver badges6 bronze badges

Collectives™ on Stack Overflow

(Sql + Python) df array to string with single quotes?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related