Return value pairs based on first row and column
anon8723879278
Gnumeric has a nice tool for calculating correlations, but is limited in terms of specifying your output. It looks like this, Figure 8-7 :
Correlations | pressure | distance | height
pressure | 1 | |
distance | 0.9841073| 1 |
height | 0.7633996| 0.7239509| 1
I would like to generate pairs like this:
pressure pressure 1
pressure distance -
pressure height -
distance pressure 0.9841073
distance distance 1
distance height -
height pressure 0.7633996
height distance 0.7239509
height height 1
I'm fine with 1's and blanks, but it would be nice if I could avoid them. It doesn't have to be within a spreadsheet.
BruceWayne
This is a pretty straightforward Index/Match:
=INDEX($B$2:$D$4,MATCH($A6,$A$2:$A$4,0),MATCH($B6,$B$1:$D$1,0))
Assuming your data is like the below:
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Can't find installed Office 2013 Home and business with MsiEnumProducts
- Next: SyntaxError: keyword can't be an expression (views.py)
Related
Related Related
- 1
Pandas - Get first row value of a given column
- 2
Return row of Data Frame based on value in a column - R
- 3
Return same row multiple times for each value in an array-based column
- 4
Split a row based on a column value
- 5
Grouping observations based on first row value
- 6
I need to return multiple column headers from a table based on the value of the cells within a row
- 7
Delete pairs of rows based on value in column
- 8
Return value in dataframe based on row index, column reference
- 9
iterate through df column and return value in dataframe based on row index, column reference
- 10
Delete a row based on the first value of the group
- 11
Excel Formula To Get First Non-Zero Value in Row and Return Column Header
- 12
Excel formula to get first and last non-empty value in a row and return column header
- 13
RETURN VALUE FROM COLUMN WHERE FIRST ROW SHOWS TODAYS DATE
- 14
ExecuteScalar doesn't return the first column of the first row
- 15
Split line into key-value pairs based on first string
- 16
How to return all the cells in a row if first column matches a value on another worksheet
- 17
Generate cell pairs based on first row and column
- 18
I need to return multiple column headers from a table based on the value of the cells within a row
- 19
iterate through df column and return value in dataframe based on row index, column reference
- 20
Return value in dataframe based on row index, column reference
- 21
Return one row in a view based on a left join column value
- 22
Return unique row when using GROUP BY based on a column value
- 23
Select lowest value and return first row only
- 24
Return value in column based on value of two rows?
- 25
Return row of Data Frame based on value in a column. R script
- 26
return the first row of value when a column has the same value 4 times consecutively
- 27
Select first row for each different column value
- 28
Duplicate row based in column value
- 29
Mysql query to only return rows based on column of first row
Comments