Talend Data to Python Pandas

[Anonymous]

All,

Is it possible to pass data from talend to Python Pandas ?

My PythonCode: 

import pandas as pd
import tableauserverclient as TSC
from pandleau import *

df = pd.read_csv(r'C:\Users\user\Documents\Sample - Superstore.csv')
df = pandleau(df)
print (df)
df.to_tableau('C:\ProgramData\Anaconda3\Lib\site-packages\Extract_SS.hyper', add_index=False)

Instead of CSV file, I have to make it as parameter and need to pass data from talend, it can be output of tJoin or Filter link (just for example)

is it possible?

[Anonymous]

This will require a bit of Java. This site might give you some clues

https://pythonhosted.org/javabridge/java2python.html

[Anonymous]

Can I get more details?

What is the job design flow here?

[Anonymous]

I haven't done this, but I would use a tJavaFlex for the Java receiving column data to be sent to python

[Anonymous]

Can I get more help ?

[Anonymous]

how to pass incoming link  data to tFlexJava?

[Anonymous]

You can pass data to the tJavaFlex in the same way as any other component. The documentation for this is here: https://help.talend.com/reader/9q55KsfASqX0qY4GVhEDNQ/gy4G6M2uUTOfL5k5NootZA

As I said, I have not done this before (calling Python from a Talend Job). Therefore the only way I can help more is to try it out myself. Unfortunately I do not have the time at the moment to do this.