Create a Data Matrix using Python
Budget: $30 – $250 USD
See attached spreadsheet with calculations and an example matrix.
I need Python code to create a matrix (using any any packages you see fit such as Numpy/Plotly/Pandas) to compare z-scores for unspecified number of variables. For example, if there are 3 columns, the I need a z-score along the diaginal for variable 1, variable 2, and variable 3, but then also z-score differences between 1/2, 1/3, and 2/3. The inverse should also be populated (relationship of 2/1 is the relationship of 1/2 * -1). Again, see the attached spreadsheet for an example.
I would like the matrix output formated with red/blue for most negative/most positive, and I would also need detailed comments incase I need to make a change in the future (for example I want to reverse the colors or change a title). The data source will be an excel sheet. Thank you
I need Python code to create a matrix (using any any packages you see fit such as Numpy/Plotly/Pandas) to compare z-scores for unspecified number of variables. For example, if there are 3 columns, the I need a z-score along the diaginal for variable 1, variable 2, and variable 3, but then also z-score differences between 1/2, 1/3, and 2/3. The inverse should also be populated (relationship of 2/1 is the relationship of 1/2 * -1). Again, see the attached spreadsheet for an example.
I would like the matrix output formated with red/blue for most negative/most positive, and I would also need detailed comments incase I need to make a change in the future (for example I want to reverse the colors or change a title). The data source will be an excel sheet. Thank you