Can I use Python libraries in Domo?

DataLawton

Hey everyone,

I’d like to use scipy.optimize in Domo to perform optimization calculations (similar to Excel Solver).

Since MagicETL has a Python Tile, is this where I should implement it?

Thank you!

ggenovese

You can view a list of installed packages on the packages tab inside the python tile. If you do a search for scipy you should see it in the list.

ArborRose

Make sure scipy.optimize is installed. It should be pre-installed in the Domo Python environment.

import pandas as pd

from scipy.optimize import minimize

The Python tile will use Pandas DataFrames. Something like this.

import pandas as pd

from scipy.optimize import minimize




# Assuming your input data looks something like this:

# df = pd.DataFrame({

#     'variable': ['x1', 'x2'],

#     'coefficient': [5, 8],

#     'constraint': [20, 30]

# })




# Input data from the Python Tile

coefficients = df['coefficient'].values

constraints = df['constraint'].values




# Objective function to minimize

def objective(x):

    return sum(coefficients * x)




# Constraints: Example constraint that the sum of variables <= 100

constraint = {'type': 'ineq', 'fun': lambda x: 100 - sum(x)}




# Bounds: Non-negative variables

bounds = [(0, None)] * len(coefficients)




# Initial guess for the variables

x0 = [0] * len(coefficients)




# Run the optimization

result = minimize(objective, x0, bounds=bounds, constraints=[constraint])




# Output results

df_output = pd.DataFrame({'variable': df['variable'], 'value': result.x})

Note - Domo also has Jupyter Workspace, where you can use Python code.