Can I use Python libraries in Domo?

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.