Talend Data to Python Pandas

Four Stars

Talend Data to Python Pandas

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?

 

Community Manager

Re: Talend Data to Python Pandas

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

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

Four Stars

Re: Talend Data to Python Pandas

Can I get more details?

 

What is the job design flow here?

Community Manager

Re: Talend Data to Python Pandas

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

Four Stars

Re: Talend Data to Python Pandas

Can I get more help ?

Four Stars

Re: Talend Data to Python Pandas

how to pass incoming link  data to tFlexJava?

Community Manager

Re: Talend Data to Python Pandas

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now