Hello, I have the following two-dimensional dense axis array results extracted from a constraint. [shadow prices] Rows represent time stamps [T] and columns represent nodes [N]. Is there a way of converting the DenseAxisArray into a dataframe with the same dimensions? Thanks

There’s no special support. You’d have to construct the dataframe manually. Potentially something like this: t_list = [t for t in T for _ in N] n_list = [n for _ in T for n in N] x_list = [nodal_pr[t, n] for (t, n) in zip(t_list, n_list)] DataFrame(t = t_list, n = n_list, shadow_price = x_list)

Converting Dense Axis array results into dataframe

Specific Domains Optimization (Mathematical)

jd-foster July 6, 2022, 2:50am 5

This hopefully still works:

You can then do an DataFrames.unstack to pivot the table.

2 Likes