vendredi 23 juin 2023

How to split pandas column in 2 with varying pattern

I have fetched dataframe from site with selenium and one of a columns in a table has a name and serial number in one cell. In frontend it looks fine cause serial number is put in but when i fetch it into pandas dataframe it fetching it in 1 cell, pattern of serial number is vary. The pattern can look like b05/124125 or either f07/d05/f95/10581

I've been searching for some implementation in internet and looks like "column.str.split()" doesnt feet the situation i have.

I getting table from html file with pd.read_excel

Aucun commentaire:

Enregistrer un commentaire