python - Updating datafram columns with same row

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65841908/updating-datafram-columns-with-same-row

Answer 1

You can use the DataFrame's fillna method after your concat step - to "forward fill" the values from the first row into all the subsequent rows

df = pd.concat([df,header_df],axis=1,join='outer')
df = df.fillna(method='ffill')