https://community.databricks.com/t5/data-engineering/pandas-forward-fill-based-on-keyword/m-p/17192#M11226 <P></P> <P>Hello! I am trying to forward fill a column in a Pandas dataframe based on a keyword. I have come up with: </P> <P>pdf_df['EEName_TEST'] = pdf_df['EEName_TEST'].str.contains('Name:').ffill()</P> <P>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!</P> <P></P> Wed, 28 Jul 2021 13:47:43 GMT WhatIsHappening 2021-07-28T13:47:43Z https://community.databricks.com/t5/data-engineering/pandas-forward-fill-based-on-keyword/m-p/17192#M11226 <P></P> <P>Hello! I am trying to forward fill a column in a Pandas dataframe based on a keyword. I have come up with: </P> <P>pdf_df['EEName_TEST'] = pdf_df['EEName_TEST'].str.contains('Name:').ffill()</P> <P>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!</P> <P></P> Wed, 28 Jul 2021 13:47:43 GMT https://community.databricks.com/t5/data-engineering/pandas-forward-fill-based-on-keyword/m-p/17192#M11226 WhatIsHappening 2021-07-28T13:47:43Z