regex是将一个字符串系列拆分为多个包含部分字符串的系列的最佳方法吗?

splitprice_pt1 = pricedata.str.split(r'\bon\b', expand=True)[0]
#split the numbers on the 'on' text and selecting the first part
split_KE_Date = pricedata.str.split(r'\bon\b', expand=True)[1]
#split the numbers on the 'on' text and selecting the second part
split_KE_Price = splitprice_pt1.str.split(r'^([^,]*,[^,]{3})', expand=True)[0]
#split the numbers on the 3 digits after comma and selecting the first part
range_KE_Price = splitprice_pt1.str.split(r'^([^,]*,[^,]{3})', expand=True)[1]
#split the numbers on the 3 digits after comma and selecting the second part

str1 = "99,0006,000                 on 13-7-2018"
num1 = str1[0:6]
num2 = str2[6:11]
num1 = 99,000
num2 = 6,000

date_pt = re.compile("[0-9]{2}-[0-9]{2}-[0-9]{4}")
date = re.search(str1)