title: Removing various characters from (.csv or .txt) file Python
body: <p>I have a .csv file which looks like:</p>
  
  <pre><code>['NAME' " 'RA_I1'" " 'DEC_I1'" " 'Mean_I1'" " 'Median_I1'" " 'Mode_I1'" ...]"
  </code></pre>
  
  <p>where this string carries on for (I think) 95 entries, the entire file is over a thousand rows deep. I want to remove all the characters: <code>[ ' "</code> and just have everything separated by a single white space entry (<code>' '</code>).<br>
  So far I've tried:</p>
  
  <pre><code>import pandas as pd
  
  df1 = pd.read_table('slap.txt')
      for char in df1:
          if char in " '[":
              df1.replace(char, '')
  
  print df1
  </code></pre>
  
  <p>Where I'm just 'testing' the code to see if it will do what I want it to, it's not. I'd like to implement it on the entire file, but I'm not sure how.</p>
  
  <p><em>I've checked <a href="https://stackoverflow.com/questions/15750628/remove-special-characters-from-csv-file-using-python">this old post</a> out but not quite getting it to work for my purposes. I've also played with the linked <a href="https://stackoverflow.com/questions/15750628/remove-special-characters-from-csv-file-using-python">post</a>, the only problem with it seems to be that all the entries are spaced twice rather than just once....</em></p>