This query returns the following table:
SELECT * FROM pca_health_ev_scaled;
PCA Example Output Table pca_health_ev_scaled (Columns 1-5)
component_rank |
age |
bmi |
bloodpressure |
glucose |
1 |
-0.0820945759812973
|
0.38700460531683 |
-0.0934544029874236 |
0.0421659209573654 |
2 |
0.60287329949617 |
-0.178614306617327 |
0.319031250574667 |
0.570020193646336 |
3 |
-0.0237436026670202 |
-0.391861948508353 |
0.305911231189858 |
-0.237823829752043 |
4 |
0.0999880092973573 |
-0.214350502528417 |
-0.84442875131615 |
0.0918928751867792 |
5 |
0.140853818736655 |
-0.671616834838167 |
-0.015501119425109 |
-0.335107745512634 |
6 |
0.527398559607415 |
0.108345471463309 |
-0.196134163484707 |
-0.414916634531223 |
7 |
0.424614643879208 |
0.390026086413646 |
0.135571152866786 |
-0.479947126632426 |
8 |
0.375441433452479 |
0.062403350907142 |
-0.160484597462421 |
0.30576507380862 |
PCA Example Output Table pca_health_ev_scaled (Columns 6-9)
strokes |
cigarettes |
insulin |
hdl |
-0.553171280035692 |
0.555650122648362 |
0.436853023913463 |
0.165499659734682 |
0.11893912303648 |
0.00519622025475551 |
0.394361991280982 |
0.0907846812939654 |
-0.217384991305528 |
0.196742944639624 |
0.19229428636829 |
-0.756833856270543 |
-0.0113051638263718 |
-0.211135286383886 |
0.35790331144032 |
-0.223050100375743 |
-0.346967521387127 |
0.0386504810638121 |
-0.0430389572065949 |
0.541129255060056 |
0.432403465056164 |
0.542959220893432 |
-0.127812929085142 |
-0.0370672018602792 |
-0.257455827830989 |
-0.557165985271577 |
0.20322506790708 |
-0.0289034187287952 |
-0.50875166634292 |
0.0347495998643894 |
-0.655039890019023 |
-0.216307455362209 |
PCA Example Output Table pca_health_ev_scaled (Columns 10-13)
sd |
var_proportion |
cumulative_var |
mean |
1.47210975433238 |
0.282175407395904 |
0.28217540739590 |
[-2.753353101070388E-16, 8.881784197001253E-17, 1.0658141036401502E-16, -7.993605777301127E-17, 8.881784197001253E-18, -1.3322676295501878E-17, 7.771561172376097E-18, -1.7763568394002505E-17] |
1.42419340817409 |
0.26410506040189 |
0.546280467797795 |
|
1.04909931627422 |
0.143308512422791 |
0.689588980220586 |
|
0.92250259655368 |
0.110808729251078 |
0.800397709471664 |
|
0.833961785351462 |
0.0905588879461716 |
0.890956597417836 |
|
0.638621453866185 |
0.0531038230909063 |
0.944060420508742 |
|
0.535061102539381 |
0.037277393678471 |
0.981337814187213 |
|
0.378583659238226 |
0.0186621858127871 |
1 |
|