Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Kindly help me with below python error :
DataSource.Error: ADO.NET: A problem occurred while processing your Python script.
Here are the technical details: [Expression.Error] We cannot convert the value null to type Text.
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=A problem occurred while processing your Python script.
Here are the technical details: [Expression.Error] We cannot convert the value null to type Text.
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonUnexpectedException
Solved! Go to Solution.
Hi @ganeshnr073 ,
It seems like your code is working with the SentimentIntensityAnalyzer from the nltk library to analyze the sentiment of messages in a dataset. If the code was working fine until a few days ago, it's possible that there might be some new data in the dataset causing the issue.
To handle potential null values or empty strings in the 'Message' column, you can modify the lambda function in the apply() method like this:
dataset['polairty scores'] = dataset['Message'].apply(lambda x: sia.polarity_scores(x)['compound'] if x is not None and x.strip() != '' else None)
This will check if the value is not null and not an empty string before applying the sentiment analysis. If the value is null or an empty string, it will assign None to the 'polairty scores' column for that row.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ganeshnr073 , share some code. the issue is with some text type variable or column
Hi @amitchandak
It working fine until few days back. I had filtered out the balnks columns as well.
Here is the code :
#load in our dependencies
import pandas as pd
from nltk.sentiment.vader import SentimentIntensityAnalyzer
#load in the sentiment analyzer
sia=SentimentIntensityAnalyzer()
#apply the analyzer over each comment
dataset['polairty scores'] =dataset['Message'].apply(lambda x: sia.polarity_scores(x)['compound'])
Hi @ganeshnr073 ,
It seems like your code is working with the SentimentIntensityAnalyzer from the nltk library to analyze the sentiment of messages in a dataset. If the code was working fine until a few days ago, it's possible that there might be some new data in the dataset causing the issue.
To handle potential null values or empty strings in the 'Message' column, you can modify the lambda function in the apply() method like this:
dataset['polairty scores'] = dataset['Message'].apply(lambda x: sia.polarity_scores(x)['compound'] if x is not None and x.strip() != '' else None)
This will check if the value is not null and not an empty string before applying the sentiment analysis. If the value is null or an empty string, it will assign None to the 'polairty scores' column for that row.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the help !!
User | Count |
---|---|
128 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
193 | |
96 | |
66 | |
62 | |
52 |