如何将多个pandas dataframe列(地址详细信息)连接成一个列，空格分隔并忽略空字符串？

import pandas as pd

# 创建示例DataFrame
df1 = pd.DataFrame({'Address1': ['123 Main St', '456 Elm St', '789 Oak St'],
                    'Address2': ['Apt 1', '', 'Suite 2']})

df2 = pd.DataFrame({'Address1': ['111 Pine St', '222 Maple St', '333 Cedar St'],
                    'Address2': ['Unit 3', 'Apt 2', '']})

# 将多个DataFrame列连接成一个列
def concat_columns(row):
    # 将每个DataFrame的列连接成一个字符串，使用空格分隔
    address_parts = [str(row['Address1']), str(row['Address2'])]
    address = ' '.join(part for part in address_parts if part.strip())  # 忽略空字符串
    return address

# 应用concat_columns函数到每一行
df1['Full Address'] = df1.apply(concat_columns, axis=1)
df2['Full Address'] = df2.apply(concat_columns, axis=1)

# 合并两个DataFrame
result = pd.concat([df1['Full Address'], df2['Full Address']])

print(result)