I have a Python dataframe with roughly 50.000 rows and 30 columns.
This dataframe is the result of a computer simulation.
25 of the columns are input parameters of this computer simulation, the rest are output variables. I would like to identify the "best" parameters, but as the output variables are dependent from each other and also variable in their acceptable limits, I cannot define a compound cost function and have to do this task manually.
I would like to analyse this dataframe by visualizing the dependency of various input to output variables and started doing so by setting up different small
matplotlib based code snippets that show the dependency between two variables. I could extend this to three variables to get a three dimensional plot, but still I would not get the big picture. I also sorted my dataframe and extracted individual variable sets, but still this does not help much for the big picture.
I am looking for a Python library or a set of (matplotlib) commands that help me to find dependencies between variables more easily.
Alternatively, I could image to load my dataframe in a sql database to use any packages or visualisation tools there.