Create a pandas series based on conditional values in another series

Asked Apr 11 '20 at 05:35

Active Apr 11 '20 at 05:35

Viewed 201 times

I want to create a pandas series based on the values in the 'overall' series.

if relevant.overall <= 2:
        relevant['Sentiment'] = 'Negative'
    elif relevant.overall == 3:
        relevant['Sentiment'] = 'Neutral'
    else: #Score of 4 or 5
        relevant['Sentiment'] = 'Positive'

This was my code for which I got the error: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all(). Then I checked on some previously asked question and tried the accepted answer on this: Why am I getting ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

Sentiment = []    
for i, row in relevant.iterrows(): 
    if row.overall <= 2:
        Sentiment.append('Negative')
    elif row.overall == 3:
        Sentiment.append('Neutral')
    else: #Score of 4 or 5
        Sentiment.append('Positive')

This is my code now for which I'm getting, 'str' object has no attribute 'append'.

asked Apr 11 '20 at 05:35

manish

check `np.select` – jezrael Apr 11 '20 at 05:36
That worked but with a warning. __main__:6: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead @jezrael – manish Apr 11 '20 at 06:06
How is created `relevant` ? – jezrael Apr 11 '20 at 06:11
amazon_review = pd.read_json('Books_small.json', lines=True) relevant = amazon_review[['reviewText', 'overall']] @jezrael – manish Apr 11 '20 at 06:13
1

then change `relevant = amazon_review[['reviewText', 'overall']]` to `relevant = amazon_review[['reviewText', 'overall']].copy()` – jezrael Apr 11 '20 at 06:31
1

That worked, thanks! @jezrael – manish Apr 11 '20 at 06:35

Create a pandas series based on conditional values in another series

0 Answers0