Extract output from main function in psych package as data frame

Question

When I use the main function, as in the following code, I get a beautiful table that gives all the standardized loads, as well as a table with its own values, as well as the proportion and cumulative proportion.

rotatedpca <- principal(PCFdataset, nfactors = 8, rotate = "varimax", scores = T) 

I would like to export this output to an excel file (using WriteXLS), but I can only do this for dataframes, and rotatedpca is not a data framework and cannot be forced into one. I can extract standardized loads using the following code:

 loadings<-as.data.frame(unclass(rotatedpca$loadings)) 

But I cannot understand how to access other information that is usually displayed when I simply call the main function, in particular, the eigenvalues, proportion and cumulative dispersion are explained. I tried rotatedcpa $ values, but this returns what looks like eigenvalues ​​for all 12 source variables as factors without rotation, which I don't understand. And I could not find a way to even try to extract the explained variance values. How can I just create a data frame that looks like the output of R that I get below from the main function, for example?

  RC2 RC3 RC8 RC1 RC4 RC5 RC6 RC7 SS loadings 1.52 1.50 1.45 1.44 1.01 1.00 0.99 0.98 Proportion Var 0.13 0.12 0.12 0.12 0.08 0.08 0.08 0.08 Cumulative Var 0.13 0.25 0.37 0.49 0.58 0.66 0.74 0.82 Proportion Explained 0.15 0.15 0.15 0.15 0.10 0.10 0.10 0.10 Cumulative Proportion 0.15 0.31 0.45 0.60 0.70 0.80 0.90 1.00 

Thanks for reading my post!

Answer 1

I just added this function to the latest (today) release of psych 1.3.10.11. If you either

  f3 <- fa(Thurstone,3) #or p3 <- principal(Thurstone,3) #then p <- print(f3) p # will give you p $Vaccounted MR1 MR2 MR3 SS loadings 2.6411150 1.8621522 1.4951831 Proportion Var 0.2934572 0.2069058 0.1661315 Cumulative Var 0.2934572 0.5003630 0.6664945 Proportion Explained 0.4402995 0.3104389 0.2492616 Proportion 0.4402995 0.7507384 1.0000000 

In general, if you have suggestions or questions about a psychopath package, you will get a faster answer if you contact me directly.

Bill

Answer 2

Why not this:

  capture.output( print(rotatedpca), file="pc.txt") 

You can read the necessary fragments in Excel using the Text to Columns... function in the / Data menu. Or you can simply paste it into an open, empty Excel document and select the lines you want to convert. Use the "fixed" option, which is likely to be suggested automatically.