using pandas df with map

Question

I want to map my DF values into a string:

SQL = """select * from mytable where col1={0} and col2={1}"""

I tried this ListResult = map(lambda x :SQL.format(*x),DF[['Col1','Col2']])

but the output be like

[u'select * from mytable where col1 = C and col2=o', 
 u'select * from mytable where col1 = C and col2=o']

How can I generate a list of string completed with the values from my DF (the number of columns may vary according to the SQL)?

EDIT: add sample and expected result

> DF =  

 - Col1 Col2
 - 0     1591354166       12387796
 - 1     1596855166        8833942
 - 2     1626196066       12584655

expected result:

[select * from mytable where col1=1591354166 and col2=12387796,
 select * from mytable where col1=1596855166 and col2=8833942, 
 select * from mytable where col1=1626196066 and col2=12584655]

Can you add Minimal, Complete, and Verifiable example or at least sample of dataframe - 3,4 rows and desired output from sample? — jezrael
– jezrael, Commented Apr 20, 2016 at 7:47

jezrael · Accepted Answer · 2016-04-20 07:59:30Z

1

I think you can add values for generating numpy array from DataFrame:

SQL = """select * from mytable where col1='{0}' and col2='{1}'"""

print map(lambda x :SQL.format(*x),df[['Col1','Col2']].values)

["select * from mytable where col1='1591354166' and col2='12387796'",
 "select * from mytable where col1='1596855166' and col2='8833942'", 
 "select * from mytable where col1='1626196066' and col2='12584655'"]

answered Apr 20, 2016 at 7:59

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

Steven Over a year ago

I was just missing the .values. I like when solution are that easy ^^ thx

jezrael Over a year ago

Glad can help you! Good luck!

MaxU - stand with Ukraine · Accepted Answer · 2016-04-20 08:06:21Z

0

is that what you want?

In [50]: ListResult = df.apply(lambda x: SQL.format(x.Col1, x.Col2), axis=1).tolist()

In [51]: ListResult
Out[51]:
['select * from mytable where col1=1591354166 and col2=12387796',
 'select * from mytable where col1=1596855166 and col2=8833942',
 'select * from mytable where col1=1626196066 and col2=12584655']

edited Apr 20, 2016 at 8:06

answered Apr 20, 2016 at 7:54

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

Collectives™ on Stack Overflow

using pandas df with map

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related