how to replace itrerows function in pandas dataframe

Question

for index, row in new_frame.iterrows():
    new_frame.at[index, 'image'] = ('{0}{1}_1.jpg'.format(image_folder, 
                                                           str(row.Code)))

Does this answer your question? [How to apply a list comprehension in Panda Dataframe?](https://stackoverflow.com/questions/62118556/how-to-apply-a-list-comprehension-in-panda-dataframe) — RichieV, Sep 13 '20 at 13:41
No i didn't because i faild i try with itertuples : for row in new_frame.itertuples(): new_frame.at[row.index, 'image'] = ('{0}{1}_1.jpg'.format(image_folder, str(row.Code))) but i got an other probleme — hamza chenni, Sep 13 '20 at 13:42

score 2 · Accepted Answer · answered Sep 13 '20 at 14:03

2

You don't show any sample data, but it seems you could use

new_frame['image'] = image_folder + new_frame['Code'].astype(str) + '_1.jpg'

Assuming image_folder is a string

answered Sep 13 '20 at 14:03

RichieV

5,103
2
11
24

yes image_folder is a string (path to image folder) – hamza chenni Sep 14 '20 at 08:20
your syntax work fine Thank you Is there anny why to add image to dataframe when export it to excel? – hamza chenni Sep 14 '20 at 08:34
You want to insert an image object into an excel sheet? I haven't done that with python, but google xlwings I guess – RichieV Sep 14 '20 at 12:11

how to replace itrerows function in pandas dataframe

1 Answers1