title: How to remove constant prefix and suffix character
body: <p>I have a data frame where numeric data is stored in String with some Prefix character which I need to remove. On top of this it has double quotes inside the quotes i.e. ' &quot;&quot; '.</p>
  <pre><code>dict_1 = {&quot;Col1&quot; : [1001, 1002, 1003, 1004, 1005], 
            &quot;Col2&quot; : ['&quot;Rs. 5131&quot;', '&quot;Rs. 0&quot;', '&quot;Rs 351157&quot;', '&quot;Rs 535391&quot;', '&quot;Rs. 6513&quot;']}
  a = pd.DataFrame(dict_1)
  a.head(6)
  
  |    | Col1     |  Col2       |       
  |----|----------|-------------|
  | 0  |1001      |&quot;Rs. 5131&quot;   |
  | 1  |1002      |&quot;Rs. 0&quot;      | 
  | 2  |1003      |&quot;Rs 351157&quot;  |    
  | 3  |1004      |&quot;Rs 535391&quot;  |    
  | 4  |1005      |&quot;Rs. 6513&quot;   |
  
  </code></pre>
  <p>As you can see I want to remove Quotes defined inside Col2 and along with this I have to remove Rs.</p>
  <p>I tried following code to subset</p>
  <pre><code>b = a['Col2'][0]
  b = b[5:]
  b = b[:-1]
  b
  </code></pre>
  <p>But the issue in some observation it is defined as Rs. and in some Rs without period.</p>
  <p>The result should be a column of integers.</p>