首页 > 解决方案 > python循环在行中插入值

问题描述

我有一个包含地址信息的数据框,这样

df
streetNumber   streetName   province   postalCode
120            ABC AVE          A          121345
20             ACD Street       A          231345
21             QWE AVE          B          234912
6              WDS Road         C          212344

我想将这四列合并为一个名为address一次保存所有地址信息的列。我使用以下循环来连接列,但是如何将值插入到address列中?

for index, row in df.iterrows():
    # try statements let us attempt something.
    try:
        address = ' '.join([row['streetNumber'], row['streetName'], 
                            row['province'], row['postalCode']])

预期产出

streetNumber   streetName   province   postalCode    address
120            ABC AVE          A          121345    120 ABC AVE A 121345
20             ACD Street       A          231345    20 ACD Street A 231345    
21             QWE AVE          B          234912    21 QWE AVE B 234912
6              WDS Road         C          212344    6 WDS Road C 212344

标签: pythonpandasloops

解决方案


推荐阅读