Pandas - how to remove spaces in each column in a dataframe?
data[c] does not return a value, it returns a series (a whole column of data).  
You can apply the strip operation to an entire column df.apply.  You can apply the strip function this way.
I'm trying to remove spaces, apostrophes, and double quote in each column data using this for loop
for c in data.columns:
    data[c] = data[c].str.strip().replace(',', '').replace('\'', '').replace('\"', '').strip()
but I keep getting this error:
AttributeError: 'Series' object has no attribute 'strip'
data is the data frame and was obtained from an excel file
xl = pd.ExcelFile('test.xlsx');
data = xl.parse(sheetname='Sheet1')
Am I missing something?  I added the str but that didn't help.  Is there a better way to do this.
I don't want to use the column labels, like so data['column label'], because the text can be different.  I would like to iterate each column and remove the characters mentioned above.
incoming data:
id        city      country
1       Ontario       Canada
2     Calgary '        Canada'
3   'Vancouver        Canada
desired output:
id  city      country
1   Ontario     Canada
2   Calgary     Canada
3   Vancouver   Canada