community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

NLP Sentiment tool in other languages

Highlighted
Meteor

Hi everyone

 

I was following the Comparing Sentiment Analysis Algorithms article, but when trying to use the StandfordCoreNLP Sentiment tool I was getting the error "The external program "java" returned an error code: 2", just like in this post, being unable to run Java using the RunCommand.

 

The solution, posted here, worked fine, being able to solve the problem by wraping the java command in a cmd shell. 

 

However, I am unable to get the CoreNLP running in other languages,as explained here. Any idea on how to modify the macro to achieve this? I have been toying with the configuration of some Formula tools but I am back to Java errors.

 

Cheers,

Javi Calvo 

 

 

 

Alteryx
Alteryx

Hi @jcalvo92 

 

It looks like quite a bit of work needs to be done to get that tool to run with other languages based on the dependencies listed. One alternative would be to run your text through a translation API as part of your workflow to then be run through an English sentiment analysis process. That way you could run the tool as is.

Meteor

Hi @BrandonB

 

That’s actually a solid alternative, but it moves the problem to how to translate texts in Alteryx. I am only able to find solutions that use the Cognitive Services Text Translation macro. This uses the same Microsoft paid services than the Cognitive Services Text Analytics macro, which already provides sentiment analysis in multiple languages at the same price.

 

So instead of paying for a translation, you can pay directly for a sentiment analysis in your language of choice.

 

The "Comparing Sentiment Analysis Algorithms" article that I mentioned explored different open source solutions, but all of them are in English only, or difficult to adapt to Alteryx.

 

Do you know an open source solution to translate texts in Alteryx? That would solve the problem.

 

Thank you for your feedback

Alteryx
Alteryx

I haven't used it yet myself, but there are quite a few free Python libraries that offer free text translation like the following: 

https://pypi.org/project/googletrans/

 

 

Meteor

Thanks, will have a look at it

Labels