topic Re: Talend Data to Python Pandas in Talend Studio

Talend Data to Python Pandas

Anonymous — Sat, 16 Nov 2024 04:45:27 GMT

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?

Re: Talend Data to Python Pandas

Anonymous — Fri, 06 Sep 2019 12:48:00 GMT

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

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

Re: Talend Data to Python Pandas

Anonymous — Fri, 06 Sep 2019 17:50:49 GMT

Can I get more details?

What is the job design flow here?

Re: Talend Data to Python Pandas

Anonymous — Fri, 06 Sep 2019 17:52:36 GMT

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

Re: Talend Data to Python Pandas

Anonymous — Tue, 10 Sep 2019 06:06:14 GMT

Can I get more help ?

Re: Talend Data to Python Pandas

Anonymous — Tue, 10 Sep 2019 06:07:19 GMT

how to pass incoming link data to tFlexJava?

Re: Talend Data to Python Pandas

Anonymous — Tue, 10 Sep 2019 10:14:57 GMT

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.