execute part of string as code pandas/python

Question

This is the sample string value in a pandas df column :

'Had {0} {1} in {2}.format(num_of_persons,type_of_person,date)'

I want to extract the code part starting at '.format()' and input the values in the string where it would look something like this:

num_of_persons='20'
type_of_person ='patients'
date='2020-04'

text='Had {0} {1} in {2}'.format(num_of_persons,type_of_person,date)

I want to extract and output like this in the pandas df column :

 'Had 20 patients in 2020-04'

I tried splitting the string at '.' but unsure how to convert the second half into code and not the string that will execute.

Any help is appreciated

Where do you have a pandas df column? All I see is three local variables. Please make examples relevant to your problem. — Amadan
– Amadan, Commented May 27, 2021 at 1:45
do the strings num_of_persons etc refer to local variables? are there more than three? — Jan Wilamowski
– Jan Wilamowski, Commented May 27, 2021 at 2:30

Raumschifffan · Accepted Answer · 2021-05-27 01:56:52Z

3

foo, bar = col.split(".")
exec(f"text  = '{foo}'.{bar}")

exec() is used for running code in a string.

answered May 27, 2021 at 1:56

Raumschifffan

3702 silver badges14 bronze badges

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

2 Comments

Faliha Zikra Over a year ago

Does 'text' in this case then contain 'Had {0} {1} in {2}'.format(num_of_persons,type_of_person,date) or would it contain 'Had 20 patients in 2020-04' ?

Raumschifffan Over a year ago

It contains the formatted String, you cannont change the variables after that, without recalling exec()

BENY · Accepted Answer · 2021-05-27 01:43:58Z

0

Try with apply

df['out'] = df.apply(lambda x : 'Had {0} {1} in {2}'.format(x['c1'],x['c2'],x['c3']),axis=1)

answered May 27, 2021 at 1:43

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

execute part of string as code pandas/python

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