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)

pdeffebach July 5, 2022, 4:06pm 2

Can you provide an MWE? See some advice on asking a question here

2 Likes

Topic		Replies	Views
Convert Array to DataFrame General Usage dataframes	11	1486	November 13, 2022
Question about my data General Usage question	23	563	August 4, 2020
DataFrames: ByRow fails in transform with PooledArrays after CSV.read Data question	6	472	August 6, 2021
DataFrame transformation question Data question	2	564	March 11, 2019
How to convert namedarray to dataframe while preserving index/column names General Usage	1	989	February 8, 2020

Converting Dense Axis array results into dataframe

Related topics