I connect to a csv file and extract a list of first names They are not cleaned and have examples like Title in the Firstname Mr or Miss or Full stops in them, or they have two names like Steve White, where we want to split them up and put Steve as the first name and White as the last name. If the firstname is Mr.Steve then we would want to put Mr in the title field and the update the firstname to Steve. I know I can find things with RegEx but need a little bit of help to create the logic to split things up rather than just do one step

String Manipulation and cleaning data

mlauber71 November 13, 2024, 8:15pm 6

@arvindev here is an example of how to employ a local LLM to sich a split with somewhat unstructured data. Maybe you can adapt the prompt.

2 Likes