Mar-14-2020, 09:19 AM
There is
split data into columns. In your case it could be applied as follows:
Series.str.extract
method in Pandas which cansplit data into columns. In your case it could be applied as follows:
dftemp.iloc[:,0].str.extract(r'([a-zA-Z\s]+)(\d+)(\d+)')