python - Removing parentheses and comma

Question

I'm importing Data from a database into python data frame. Now, I wish to use the data for further analysis, however, I need to do a little cleaning of the data before using. Currently, the required column is formatted like ('2275.1', '1950.4'). The output that I require should look like:2275.1 and 1950.4 exclusively. can someone please help

Answer 1

This is one way to do it:

import re
x = "'('2275.1', '1950.4')'"
y = re.findall(r'd+.d', x)
for i in y:
  print i

Output:

2275.1
1950.4