The second line, for example, according to the amount of 15 behind three section 1, section 2, subsection 3 of looking for matching item, just match the segment 2 "10 to 30", and then put the value of the brackets in the 0.34 discount that one column, and segmentation is irregular, the total no more than three segment, scope and amount of parentheses is a space between, between 10 to 30 and [0.34], another take less than 10 to 30 front to back, front is greater than or equal to 10, behind is less than 30
The following is a DataFrame code
Df=pd DataFrame ([[15,0.19, '-' and '-', '-'], [15, ' ', '0 to 10 [0.28]' and '10-20 [0.34]', '], [20, ' ', '0 to 10 [0.29]', '10-20 [0.30]', '20-30 [0.42]]], the columns=[' $ten thousand', 'discount', 'section 1', 'segment 2', 'section 3'])
For a great god!!!!!