I have the following dataframe:
I'm trying to get rid of the percentage signs. In order to do this I decided to apply a function to the Democrat and Republican column and try to split() by the percentage sign. The following code tries to do that:
gallup_2012[['Democrat/Lean Democratic', 'Republican/Lean
Republican']].apply(lambda x: x.split('%')[0])
However, when I try to do this, I get the following error:
("'Series' object has no attribute 'split'", u'occurred at index Democrat/Lean > Democratic')
I'm not quite sure why this error occurs, as I can apply other functions to this series. It's just that the split() function doesn't work.
Any help would be appreciated!