在python pandas中将包含空字符串的列合并为一列

import pandas as pd

data = {'col1': ['a', '', 'c'], 'col2': ['', 'b', '']}
df = pd.DataFrame(data)

df = df.replace('', pd.NA)

df = df.fillna(method='ffill')

df['merged_col'] = df.apply(lambda row: ''.join(row), axis=1)

import pandas as pd

data = {'col1': ['a', '', 'c'], 'col2': ['', 'b', '']}
df = pd.DataFrame(data)

df = df.replace('', pd.NA)
df = df.fillna(method='ffill')
df['merged_col'] = df.apply(lambda row: ''.join(row), axis=1)

print(df['merged_col'])