How to replace partial strings within a df column

I have the following table. Some entries within the StockCode column have letters at the end, how do I replace these with a number?

I could make a dictionary to map each letter to a number but I feel there a quicker way to do so.

InvoiceNo  |StockCode |
0   536     85123   
1   536     71053Z  
2   536     84406B  
3   536     22623S  


Read more here: https://stackoverflow.com/questions/65051987/how-to-replace-partial-strings-within-a-df-column

Content Attribution

This content was originally published by Zizi96 at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: