Sentiment analysis using Vader- AttributeError: 'float' object has no attribute 'encode'

Question

import numpy as np
import pandas as pd
df=pd.read_excel('Finning2.xlsx',encoding='utf-8')
import nltk
nltk.download('vader_lexicon')
from nltk.sentiment.vader import SentimentIntensityAnalyzer
sid = SentimentIntensityAnalyzer()

 review = df['review']
 review = str(review).encode('utf-8')

 df['scores'] = df['review'].apply(lambda review:sid.polarity_scores(review))

score 2 · Answer 1 · answered Mar 22 '20 at 08:12

2

We need to convert review column into string before applying polarity_scores funtion

    df['score'] = df['review'].apply(lambda review:sid.polarity_scores(str(review)))

answered Mar 22 '20 at 08:12

msrr

21
2

Tony Kipkemboi · Answer 2 · 2022-11-03T16:46:08.383

Try this (worked for me):

    import numpy as np
    import pandas as pd
    import nltk
    
    from nltk.sentiment.vader import SentimentIntensityAnalyzer

    df=pd.read_excel('Finning2.xlsx').astype(str)

    nltk.download('vader_lexicon')
    
    sid = SentimentIntensityAnalyzer()

    review = df['review']
    review = str(review).encode('utf-8')

    df['scores'] = df['review'].apply(lambda review:sid.polarity_scores(review))

score 0 · Answer 3 · answered May 17 '19 at 12:47

0

I mocked up an example (shown below) but am not able to replicate the behavior you're seeing. Can you please show us how the dataframe is being formed or a sample of what the 'review' column looks like for your data?

dict = {"population": [200.4, 143.5, 1252, 1357, 52.98]}

import pandas as pd
df = pd.DataFrame(dict)

pop = str(df['population']).encode("utf-8")
print(pop)

And here is the output:

b'0     8.516\n1    17.100\n2     3.286\n3     9.597\n4     1.221\nName: area, dtype: float64'

answered May 17 '19 at 12:47

jkovba

1,229
2
11
20

Thanks but it still does not work. here is the an example – Mohamed Helmy May 17 '19 at 12:59
Hi Mohamed, I don't see your example, would you mind re-posting it? – jkovba May 17 '19 at 13:08
Sorry, here is an example review No not really. Stop phoning me They should make it easier No, not really. I always find them very helpful. – Mohamed Helmy May 17 '19 at 13:19
Sorry, I don't quite follow. Your error message says 'float', so I'm expecting the data to be numeric. Can you please provide more details? – jkovba May 17 '19 at 13:52

Sentiment analysis using Vader- AttributeError: 'float' object has no attribute 'encode'

3 Answers3