各位大神,帮忙指导一下如何计算相关矩阵,大概的数据格式如下
代码,日期,回报,名称
000300,20101001,0.23,A
000300,20101002,0.15,A
000300,20101003,0.03,A
000300,20101004,0.40,A
000301,20101001,0.05,B
000301,20101002,0.19,B
000301,20101003,0.11,B
000301,20101004,0.26,B
000302,20101001,0.31,C
000302,20101002,0.03,C
000302,20101003,0.01,C
000302,20101004,0.27,C
希望的结果是
A B C
A 1 ab ac
B ba 1 bc
C ca cb 1
因为要算的变量在一个column里面,不是多个,所以没啥头绪