Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I'm using Power BI Desktop and trying to make a sentimental analysis with the following python code:
import pandas as pd
from nltk.sentiment.vader import SentimentIntensityAnalyzer
import re
from googletrans import Translator
translatedList = []
for index, row in dataset.iterrows():
translator = Translator()
newrow = copy.deepcopy(row)
try:
translated = translator.translate(row['zin'], dest='en')
newrow['translated'] = translated.text
except Exception as e:
print(e)
continue
translatedList.append(newrow)
dataset_new = pd.DataFrame(translatedList)
SentimentAnalysis = SentimentIntensityAnalyzer()
dataset['sentiment score'] = dataset['translated'].apply(lambda x: SentimentAnalysis.polarity_scores(x)['compound']
When I run this in PowerQuery->Python Script, I get this error:
DataSource.Error: ADO.NET: Python script error. |
Can someone help me figuring out what the problem is?
Solved! Go to Solution.
HI @Anonymous ,
When I test your python script by python 3.9.Then :
There seems to be a problem with the script itself.
SyntaxError: unexpected EOF while parsing
Wish it is helpful for you!
Best Regards
Lucien
Maybe I can help you, I'm familiar with python programming in Power BI.
You can contact me at: xiaoqing.gao@cn.abb.com
HI @Anonymous ,
When I test your python script by python 3.9.Then :
There seems to be a problem with the script itself.
SyntaxError: unexpected EOF while parsing
Wish it is helpful for you!
Best Regards
Lucien
No answer?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |