how can I separate a text from a number in Panda Python, if it’s not already separated by a space (" ")?
In my data frame df I have a column with 0.3314QSF.
I want to split this into two columns containing respectively 0.3314 and QSF in two different columns within my data frame.
The data frame consists of thousands of rows, this rule should be working for all the rows.
You can do it use
>>> df['a'].str.extract(r'([\d.]+)(\w+)') 0 1 0 0.3314 QSF
str.split (you’ll have an extra empty entry but you can remove):
>>> df['a'].str.split(r'(=?[\d.]+)', expand=True) 0 1 2 0 0.3314 QSF >>> df['a'].str.split(r'(=?[\d.]+)', expand=True).drop(0, axis=1) 1 2 0 0.3314 QSF