Is it possible to read the data of a table that we have extracted from a source system using celonis as a CSV file in the Machine Learning workbench using python.
Page 1 / 1
Hi,
It is, you can get data from DM/DP transform it into python data frame and than export as CSV file.
Code Snippet:
from pycelonis import get_celonis
celonis = get_celonis(permissions=False)
data_pool = celonis.data_integration.get_data_pools().find("X")
data_model = data_pool.get_data_models().find("X")
table = tables.find("X")
table.to_csv(index=False)
Rembember about permissions for workbench application being able to reach Data pool and data model, I'll late check if it fully works on Pycelonis 2.0.1 +
Best Regards,
Mateusz Dudek
Hi Mateusz,
Is this code snippet applicable for pycelonis version 1.7.2?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.