Skip to main content
We are happy to announce that we have now released Pycelonis 1.5.
Pycelonis is a python library built and managed by Celonis that allows easy interaction with Celonis pre-processed data as well as include functions to support building process-specific custom machine learning algorithms in python.
This release (Pycelonis 1.5) includes some major changes such as improving stability and robustness as well as bringing new functionalities. Following are the new changes and what it means for you:
New Push Data Functions
Pushing data to datapools is now split into 3 different functions covering 4 different behaviors:

  1. Create new table in the datapool data_pool.create_table(table_name="MY_PUSH_TABLE", df_or_path=df, if_exists="error")

  2. Append data to an existing table in the datapool data_pool.append_table(table_name="MY_PUSH_TABLE", df_or_path=append_df)

  3. Upsert data into an existing table in the datapool data_pool.upsert_table(table_name="MY_PUSH_TABLE", df_or_path=upsert_df, primary_keys=['C'])

  4. Replace data with the data in an existing table in the datapool
    data_pool.create_table(table_name="Test_Data", df_or_path=replace_df, if_exists="drop")

You can then add the newly created table to the datamodel where needed using a different function which is:
data_model.add_table_from_pool(table_name="MY_NEW_TABLE", alias= "MY_NEW_TABLE")
What does this mean for you?
All the other functions in pycelonis that were previously available to push data into datapools or datamodel are now deprecated. This means that they will still work but we recommend switching to the new methods to have a better experience.
Simulation
We have also added a new module in pycelonis that allows you to simulate process changes before implementing them.
If you want to learn more about it, check the following post on Process Simulation.
For more details and change log, please have a look at pycelonis documentation.
Best Regards,
Celonis Product Team

Hello,

 

Are these changes applicable to CMP4 or only IBC ? Because i tried to append the dataframe through push option in CMP4 and it keeps giving me errors.


Hey, This is only applicable to Cloud Versions. For CPM4 the recommended python package is celonis_tools. And if you have to use pycelonis, I recommend using pycelonis=1.4.1.

 

I hope that helps you. Let me know if you still have any issues.


I tried to do append in celonis_tools and still face the same issue . Could you please let know if any installation is required for append operation.


Hi Nikkitha,

 

For CPM4 I suggest to refer to the following documentations;

Python_API : https://help.celonis.de/display/PYT/Python+API.

Or celonis-tools for CPM 4.5.

 

How to get access: Log into any CPM4 instance, click on your user name and go to "Help". There the "Manual (EN)" button will forward you to help.celonis.de and log you in automatically. Then you can also open the links above.