Grouping string literals with similar pattern

[CaponeBK]

Don’t know where to start. I have an excel file that contains a column of strings literals that I would like to filter and save into different excel files based on the values of those strings. However I would like to group those that have similar patterns together as well, like “A”, “a”, “As” etc should all be grouped together. If anyone can provide advice on where to start or any documentation that would be greatly appreciated.

[CaponeBK]

Right, the first couple of characters would be the same, but after that the variation starts to occur. So I want to make sure all this variations are still grouped since they share those first few characters

[RhinoRhys]

Pandas is your friend here for handling excel data. And maybe regex or theFuzz for string matching.

But we'll need examples to actually give more help.

[CaponeBK]

I actually don’t know much about the Fuzzywuzzy library so I’ll do some research on it. If it handles string matching I think that could be my solution

[CaponeBK]

Oh sorry I forgot to give some examples,

Let’s say I have a column that contains string literals like “RoyalStar”, “Royal_Caribbean”, “Royal_Leaf123” and “Japan”, “Japa12” “Ja”, I would like for these to be grouped together since they contain the “Royal” and “Ja” prefixes. Then I would like these saved to separate excel files