Skip to content

Instantly share code, notes, and snippets.

@jaradc
Created November 2, 2017 19:23
Show Gist options
  • Save jaradc/8482ffbbdf754dcbdaf165ca344f9649 to your computer and use it in GitHub Desktop.
Save jaradc/8482ffbbdf754dcbdaf165ca344f9649 to your computer and use it in GitHub Desktop.
Shows how to turn a correlation matrix into a table
>>> corr
Impressions Clicks CTR Avg. CPC Cost Avg. position \
Impressions 1.000000 0.599646 NaN 0.301556 0.568137 0.197353
Clicks 0.599646 1.000000 NaN 0.566357 0.987073 0.627268
CTR NaN NaN NaN NaN NaN NaN
Avg. CPC 0.301556 0.566357 NaN 1.000000 0.663789 0.809944
Cost 0.568137 0.987073 NaN 0.663789 1.000000 0.707918
Avg. position 0.197353 0.627268 NaN 0.809944 0.707918 1.000000
Conversions 0.558450 0.927165 NaN 0.717237 0.962034 0.746493
Conversions
Impressions 0.558450
Clicks 0.927165
CTR NaN
Avg. CPC 0.717237
Cost 0.962034
Avg. position 0.746493
Conversions 1.000000
corr.where(np.triu(np.ones(corr.shape)).astype('bool')).stack().reset_index().rename(columns={'level_0': 'Row', 'level_1': 'Column', 0: 'Value'})
Row Column Value
0 Impressions Impressions 1.000000
1 Impressions Clicks 0.599646
2 Impressions Avg. CPC 0.301556
3 Impressions Cost 0.568137
4 Impressions Avg. position 0.197353
5 Impressions Conversions 0.558450
6 Clicks Clicks 1.000000
7 Clicks Avg. CPC 0.566357
8 Clicks Cost 0.987073
9 Clicks Avg. position 0.627268
10 Clicks Conversions 0.927165
11 Avg. CPC Avg. CPC 1.000000
12 Avg. CPC Cost 0.663789
13 Avg. CPC Avg. position 0.809944
14 Avg. CPC Conversions 0.717237
15 Cost Cost 1.000000
16 Cost Avg. position 0.707918
17 Cost Conversions 0.962034
18 Avg. position Avg. position 1.000000
19 Avg. position Conversions 0.746493
20 Conversions Conversions 1.000000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment