how can I do PCA on a table ?

LO
2019 5 30
1 个回答
回答已采纳
更新时间：2019 6 7
10 次查看（30 天）

0 个投票

I have a 3000 x 18 table containing 18 variables (one per column) of both numerical and categorical type (6 categorical).
I would liket to do PCA on the whole dataset
but the command
[coeff,score]=pca(mytable) does not work.
any idea on how to proceed ?

请先登录，再回答此问题。

 采纳的回答

Star Strider
Star Strider 2019-5-30

2 个投票

The pca function only accepts single-precision or double-precision numerical arrays. You most likely need to use the table2array (link) function first, to get the numeric data out of your table and into a form that pca can use.

4 个评论
显示 2更早的评论 隐藏 2更早的评论

LO
LO 2019-6-7
Thanks,
I have tried and I got this error message
Error using pca (line 168)
The value of X must not be an object.
the table is now in string format. this is not suitable for the PCA function.
I tried to convert the matrix to numerical values using str2num but I got the message "Input must be a character vector or string scalar"
Star Strider
Star Strider 2019-6-7
Unless you can extract just the numerical values, you cannot use the pca function.
LO
LO 2019-6-7
Got it, thanks. I thought categorical PCA was also possible with MATLAB.
Perhaps the answer is no. I will try to then exclude the non numerical variables and see if it works !
Star Strider
Star Strider 2019-6-7
It should work in that instance.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Dimensionality Reduction and Feature Extraction 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by