clustering PCA output

Hello all, I am trying to cluster the PCA analysis output (PC loadings). The rough version of protocol (attached) is working but i need help in:

'how to label the properties in the PC clustering visualization'. The outcome i am currently getting is this (shown in figure below):

And the data I am reading is:


PropertiesPC1

PC2


PC_0.21297-0.096328
Q_PC_0.21297-0.096328
vsa_pol-0.20656-0.029011
lip_acc-0.213720.016597
PEOE_PC_0.21264-0.074102
TPSA-0.208020.034297
PEOE_VSA_PNEG-0.19425-0.15775
Q_VSA_PNEG-0.18566-0.22706
GCUT_SLOGP_10.165980.23982
Q_VSA_POL-0.206970.083965
SlogP_VSA2-0.187470.038381
SMR_VSA0-0.1734-0.24447
vsa_acc-0.16569-0.31525
Q_RPC_0.188050.0052587
RPC_0.188050.0052587
a_ICM-0.141-0.37005
Q_VSA_FHYD0.17390.17617
Q_VSA_FPOL-0.1739-0.17617
a_nO-0.196620.040441
PEOE_VSA_POL-0.199270.10687
a_nN-0.16072-0.021941
PEOE_VSA_6-0.16123-0.055919
vsa_other-0.16851-0.23518
a_IC-0.18120.28785
SlogP0.16429-0.04757
PC.-0.182590.31464
Q_PC.-0.182590.31464
zagreb-0.17070.25108
Weight-0.178530.23416


cluster-pic.jpg


One more question I have is how to delete rows in a particular outcome? For instance I am running a PCA protocol whose output in PCA loadings is Std. Dev (1st row), Variance explained (2nd row) and Total variance explained (3rd row), after which (4th row and further) all the properties start.

When i pipe this output in another component (such as above mentioned 'clusering PCA visualization') it automatically reads the first three rows also (where i only want it to read the properties). How do i avoid reading such rows?

Thank you

nar