Pandas Forward Fill Based on Keyword
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2021 06:47 AM
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!
Labels:
- Labels:
-
Dataframe