cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Pandas Forward Fill Based on Keyword

WhatIsHappening
New Contributor

Hello! I am trying to forward fill a column in a Pandas dataframe based on a keyword. I have come up with:

pdf_df['EEName_TEST'] = pdf_df['EEName_TEST'].str.contains('Name:').ffill()

This gives me a boolean result but I still can't figure out what I'm missing to actually fill in the names and haven't been able to find a good solution yet. Any thoughts would be greatly appreciated!

0 REPLIES 0
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.