Splitting Record Columns: A Deep Dive into Pandas String Operations and Dataframe Manipulation