<div dir="ltr">Boa tarde,<div><br></div><div>Eu tenho uma matriz de correlação e eu preciso derrete-la para fazer um mapa de calor usando a função ggplot.</div><div>Eu tentei o código abaixo mas não obtive sucesso. Alguém, por favor, saberia me dizer como eu poderia concerta-lo?</div><div>Muito Obrigada,</div><div><br></div><div>Michelle</div><div><br></div><div><div>> MatrizCorrelação<-read.table("/Users/bau/MatrizCorrelaçãoMontagem/MatrizCorrelaçãoGLOBALHoraFixa1.txt", header=TRUE)</div><div>> rownames(MatrizCorrelação)<-c("AA","AIG","AXP","BA","CAT","C","DD","DIS","GE","GM","HD","HON","HPQ","IBM","INTC","JNJ","JPM","KO","MCD","MMM","MO","MRK","MSFT","PFE","PG","SBC","UTX","VZ","WMT","XOM")</div><div>> colnames(MatrizCorrelação)<-c("AA","AIG","AXP","BA","CAT","C","DD","DIS","GE","GM","HD","HON","HPQ","IBM","INTC","JNJ","JPM","KO","MCD","MMM","MO","MRK","MSFT","PFE","PG","SBC","UTX","VZ","WMT","XOM")</div><div>> show(MatrizCorrelação)</div><div>              AA         AIG         AXP           BA          CAT            C</div><div>AA    1.00000000  0.64408120 -0.08888420  0.041492345 -0.214144744 -0.101349733</div><div>AIG   0.64408120  1.00000000 -0.10988391  0.617295058  0.088028379 -0.075095179</div><div>AXP  -0.08888420 -0.10988391  1.00000000  0.984315107 -0.116418296  0.990267878</div><div>BA    0.04149235  0.61729506  0.98431511  1.000000000  0.209267495  0.983175770</div><div>CAT  -0.21414474  0.08802838 -0.11641830  0.209267495  1.000000000 -0.024951121</div><div>C    -0.10134973 -0.07509518  0.99026788  0.983175770 -0.024951121  1.000000000</div><div>DD    0.27753220 -0.06536848 -0.15801568 -0.122672004  0.176294459 -0.149479128</div><div>DIS  -0.05058204  0.07235002 -0.08595773 -0.061708245  0.096877395  0.118710406</div><div>GE   -0.06195607  0.16175071 -0.12809978 -0.079195094  0.076001045 -0.113810967</div><div>GM   -0.17302090  0.15943410 -0.13486542 -0.125961248  0.139394559 -0.079676333</div><div>HD    0.77105494  0.27298539 -0.03724273  0.437911231  0.187631652 -0.006079136</div><div>HON  -0.10570566 -0.16445830  0.98729684  0.979601320  0.152368239  0.990517707</div><div>HPQ   0.61508079 -0.04910831  0.89736340  0.001407106 -0.024794271  0.879260018</div><div>IBM  -0.14325256  0.22296189 -0.09312546 -0.052157000  0.282121137 -0.098088741</div><div>INTC -0.04183314  0.17127360  0.88475464  0.977763826  0.153557706  0.905222038</div><div>JNJ   0.39952357 -0.06097491 -0.06834544  0.016560533 -0.029220211 -0.085020474</div><div>JPM   0.01327878 -0.06526108  0.98205656  0.973315186  0.108371050  0.975930796</div><div>KO    0.26902580  0.13846002 -0.10938672 -0.016723587 -0.035708476 -0.071168592</div><div>MCD  -0.11488201 -0.03488877  0.97909811  0.962730357  0.133474400  0.973565190</div><div>MMM   0.85773623  0.48376538 -0.19690222  0.757310198  0.055221755 -0.203401567</div><div>MO   -0.07279634 -0.10441677  0.96450379  0.958209633  0.100724040  0.983380621</div><div>MRK  -0.01910645  0.17189420  0.88570136  0.847176890  0.326006258  0.936235229</div><div>MSFT  0.35282208  0.26522725  0.20144247  0.217889673  0.209585726  0.191500107</div><div>PFE   0.71883544  0.38611556 -0.09965413  0.117492327  0.112854712 -0.078326817</div><div>PG    0.10236671  0.47079288  0.87924130  0.982927812  0.008548316  0.887794977</div><div>SBC   0.44428023  0.22142371 -0.05977186 -0.054472383  0.120476639 -0.039427691</div><div>UTX   0.54274188  0.68774761  0.16461583  0.735488521  0.441567683  0.086510831</div><div>VZ    0.30501108  0.24618829 -0.12762753  0.160866226  0.396779942 -0.129212617</div><div>WMT   0.77504411  0.36572997 -0.11559086  0.614663934  0.193168981 -0.109499052</div><div>XOM   0.81993320  0.29718190  0.91731073  0.742123060  0.309676262  0.887007970</div><div>                DD         DIS           GE          GM           HD         HON</div><div>AA    0.2775322031 -0.05058204 -0.061956065 -0.17302090  0.771054943 -0.10570566</div><div>AIG  -0.0653684788  0.07235002  0.161750706  0.15943410  0.272985391 -0.16445830</div><div>AXP  -0.1580156785 -0.08595773 -0.128099781 -0.13486542 -0.037242735  0.98729684</div><div>BA   -0.1226720044 -0.06170825 -0.079195094 -0.12596125  0.437911231  0.97960132</div><div>CAT   0.1762944592  0.09687739  0.076001045  0.13939456  0.187631652  0.15236824</div><div>C    -0.1494791277  0.11871041 -0.113810967 -0.07967633 -0.006079136  0.99051771</div><div>DD    1.0000000000  0.08783621  0.219436466  0.05454161  0.222548990 -0.09710260</div><div>DIS   0.0878362119  1.00000000 -0.097986050  0.09671508  0.019253735  0.02492730</div><div>GE    0.2194364655 -0.09798605  1.000000000 -0.07464910  0.062579177 -0.12484867</div><div>GM    0.0545416056  0.09671508 -0.074649103  1.00000000 -0.165530144  0.07422148</div><div>HD    0.2225489902  0.01925374  0.062579177 -0.16553014  1.000000000 -0.16409932</div><div>HON  -0.0971025994  0.02492730 -0.124848669  0.07422148 -0.164099317  1.00000000</div><div>HPQ  -0.1167076236  0.03523964  0.259152551 -0.08918722  0.335373767 -0.06660235</div><div>IBM  -0.0983199840  0.06958259  0.092813651  0.10000633 -0.080677701 -0.06706757</div><div>INTC -0.0808370611  0.04800232 -0.052272579 -0.16632106  0.064111405  0.96641571</div><div>JNJ   0.3049063611  0.06805802  0.009974141 -0.01028822  0.368360457 -0.05172531</div><div>JPM  -0.1374144575 -0.07747589 -0.069195345 -0.11317405  0.302011943  0.96576594</div><div>KO   -0.0957552068 -0.08278180 -0.019693951  0.08340010  0.633619019 -0.11972446</div><div>MCD  -0.1400976129 -0.15791131 -0.076893201  0.01860467 -0.079703107  0.97490691</div><div>MMM  -0.0229856560 -0.10135307  0.164736998 -0.13349162  0.805178951 -0.20208163</div><div>MO   -0.1497471686  0.01051476 -0.127495071  0.09013588  0.098128503  0.95074800</div><div>MRK  -0.0679381407  0.51070153 -0.113882492  0.10834896  0.406467216  0.90301349</div><div>MSFT  0.0754694369  0.16517350  0.106216006  0.05085640  0.361052148  0.24126114</div><div>PFE   0.0809256468  0.13541261  0.140722998  0.01548618  0.237424055 -0.10050867</div><div>PG   -0.1388098856 -0.05085018 -0.098617228 -0.02184240  0.760744742  0.96286144</div><div>SBC  -0.2021367506 -0.02090362 -0.014672962  0.11867336  0.539474608 -0.04806091</div><div>UTX   0.2894449830  0.02297845 -0.083819849  0.02513422  0.625110674  0.08030012</div><div>VZ    0.0008030282 -0.02372907 -0.031313893 -0.11937086  0.338167833 -0.19417485</div><div>WMT   0.2899811736 -0.05719813  0.121443858 -0.10411422  0.762089961 -0.06754262</div><div>XOM  -0.1091177189 -0.01506886 -0.180892010 -0.18349266  0.623279211 -0.17881846</div><div>              HPQ         IBM         INTC          JNJ         JPM           KO</div><div>AA    0.615080794 -0.14325256 -0.041833138  0.399523572  0.01327878  0.269025800</div><div>AIG  -0.049108313  0.22296189  0.171273601 -0.060974907 -0.06526108  0.138460020</div><div>AXP   0.897363395 -0.09312546  0.884754635 -0.068345443  0.98205656 -0.109386725</div><div>BA    0.001407106 -0.05215700  0.977763826  0.016560533  0.97331519 -0.016723587</div><div>CAT  -0.024794271  0.28212114  0.153557706 -0.029220211  0.10837105 -0.035708476</div><div>C     0.879260018 -0.09808874  0.905222038 -0.085020474  0.97593080 -0.071168592</div><div>DD   -0.116707624 -0.09831998 -0.080837061  0.304906361 -0.13741446 -0.095755207</div><div>DIS   0.035239643  0.06958259  0.048002324  0.068058023 -0.07747589 -0.082781796</div><div>GE    0.259152551  0.09281365 -0.052272579  0.009974141 -0.06919534 -0.019693951</div><div>GM   -0.089187222  0.10000633 -0.166321056 -0.010288220 -0.11317405  0.083400099</div><div>HD    0.335373767 -0.08067770  0.064111405  0.368360457  0.30201194  0.633619019</div><div>HON  -0.066602346 -0.06706757  0.966415706 -0.051725309  0.96576594 -0.119724456</div><div>HPQ   1.000000000 -0.15701234  0.151721547  0.107106093  0.87748415  0.009943835</div><div>IBM  -0.157012338  1.00000000 -0.039948654  0.020173673 -0.09548061 -0.058925664</div><div>INTC  0.151721547 -0.03994865  1.000000000  0.003201919  0.88754083 -0.065405458</div><div>JNJ   0.107106093  0.02017367  0.003201919  1.000000000  0.17881168  0.190810501</div><div>JPM   0.877484151 -0.09548061  0.887540829  0.178811675  1.00000000 -0.087498384</div><div>KO    0.009943835 -0.05892566 -0.065405458  0.190810501 -0.08749838  1.000000000</div><div>MCD  -0.079793246 -0.08487497  0.951691306  0.012224842  0.96546727 -0.089030871</div><div>MMM   0.003599907 -0.00184816 -0.026441216  0.323647219  0.02841221  0.697119121</div><div>MO    0.265279473 -0.08384818  0.955166076  0.345472431  0.97526394 -0.084530558</div><div>MRK  -0.065863614  0.02588809  0.810354526  0.246594467  0.85285390 -0.079041477</div><div>MSFT  0.201191442  0.17888449  0.246199067  0.189760581  0.22872513  0.170259396</div><div>PFE   0.082804173  0.01478451  0.071951248  0.528572295  0.11845951 -0.061489407</div><div>PG    0.180362173 -0.06510797  0.948012402  0.415851593  0.88791235 -0.010360697</div><div>SBC   0.314991719  0.14796807 -0.040912484  0.659737204  0.01986489  0.096273094</div><div>UTX  -0.044531751  0.24482269  0.474124511 -0.141775588  0.01967263  0.320491202</div><div>VZ    0.293833023  0.28141939  0.136536306  0.746279724  0.44116583 -0.146987598</div><div>WMT  -0.164553642 -0.10344137  0.305813548 -0.185844027 -0.01222057  0.429589230</div><div>XOM   0.873558490 -0.01355011  0.135825195  0.095164950  0.90935280  0.023801710</div><div>              MCD          MMM          MO         MRK       MSFT         PFE</div><div>AA   -0.114882005  0.857736231 -0.07279634 -0.01910645 0.35282208  0.71883544</div><div>AIG  -0.034888767  0.483765381 -0.10441677  0.17189420 0.26522725  0.38611556</div><div>AXP   0.979098108 -0.196902215  0.96450379  0.88570136 0.20144247 -0.09965413</div><div>BA    0.962730357  0.757310198  0.95820963  0.84717689 0.21788967  0.11749233</div><div>CAT   0.133474400  0.055221755  0.10072404  0.32600626 0.20958573  0.11285471</div><div>C     0.973565190 -0.203401567  0.98338062  0.93623523 0.19150011 -0.07832682</div><div>DD   -0.140097613 -0.022985656 -0.14974717 -0.06793814 0.07546944  0.08092565</div><div>DIS  -0.157911312 -0.101353066  0.01051476  0.51070153 0.16517350  0.13541261</div><div>GE   -0.076893201  0.164736998 -0.12749507 -0.11388249 0.10621601  0.14072300</div><div>GM    0.018604672 -0.133491624  0.09013588  0.10834896 0.05085640  0.01548618</div><div>HD   -0.079703107  0.805178951  0.09812850  0.40646722 0.36105215  0.23742405</div><div>HON   0.974906915 -0.202081627  0.95074800  0.90301349 0.24126114 -0.10050867</div><div>HPQ  -0.079793246  0.003599907  0.26527947 -0.06586361 0.20119144  0.08280417</div><div>IBM  -0.084874971 -0.001848160 -0.08384818  0.02588809 0.17888449  0.01478451</div><div>INTC  0.951691306 -0.026441216  0.95516608  0.81035453 0.24619907  0.07195125</div><div>JNJ   0.012224842  0.323647219  0.34547243  0.24659447 0.18976058  0.52857229</div><div>JPM   0.965467274  0.028412214  0.97526394  0.85285390 0.22872513  0.11845951</div><div>KO   -0.089030871  0.697119121 -0.08453056 -0.07904148 0.17025940 -0.06148941</div><div>MCD   1.000000000 -0.002245452  0.94996006  0.79129517 0.13975360 -0.06190441</div><div>MMM  -0.002245452  1.000000000  0.12314993  0.39646696 0.46448561  0.76680157</div><div>MO    0.949960063  0.123149928  1.00000000  0.80766662 0.16859328  0.34554920</div><div>MRK   0.791295169  0.396466958  0.80766662  1.00000000 0.33130833  0.48887353</div><div>MSFT  0.139753596  0.464485612  0.16859328  0.33130833 1.00000000  0.25001730</div><div>PFE  -0.061904406  0.766801566  0.34554920  0.48887353 0.25001730  1.00000000</div><div>PG    0.967108956  0.877382077  0.95432399  0.88725460 0.29352175  0.51502779</div><div>SBC  -0.051205675  0.565865102  0.02652422  0.04986324 0.23363406  0.37208816</div><div>UTX  -0.166869876  0.728133059 -0.31543056  0.17848601 0.54720408  0.23349921</div><div>VZ   -0.114262073  0.401455663  0.34122580  0.48851378 0.32428938  0.48834627</div><div>WMT   0.323884209  0.749895547 -0.08402821 -0.04128828 0.55588607  0.12075279</div><div>XOM  -0.048449716  0.264692382  0.20692791  0.23032417 0.31490297  0.11798174</div><div>               PG         SBC         UTX            VZ         WMT         XOM</div><div>AA    0.102366713  0.44428023  0.54274188  0.3050110822  0.77504411  0.81993320</div><div>AIG   0.470792883  0.22142371  0.68774761  0.2461882948  0.36572997  0.29718190</div><div>AXP   0.879241301 -0.05977186  0.16461583 -0.1276275273 -0.11559086  0.91731073</div><div>BA    0.982927812 -0.05447238  0.73548852  0.1608662257  0.61466393  0.74212306</div><div>CAT   0.008548316  0.12047664  0.44156768  0.3967799421  0.19316898  0.30967626</div><div>C     0.887794977 -0.03942769  0.08651083 -0.1292126166 -0.10949905  0.88700797</div><div>DD   -0.138809886 -0.20213675  0.28944498  0.0008030282  0.28998117 -0.10911772</div><div>DIS  -0.050850179 -0.02090362  0.02297845 -0.0237290706 -0.05719813 -0.01506886</div><div>GE   -0.098617228 -0.01467296 -0.08381985 -0.0313138935  0.12144386 -0.18089201</div><div>GM   -0.021842401  0.11867336  0.02513422 -0.1193708629 -0.10411422 -0.18349266</div><div>HD    0.760744742  0.53947461  0.62511067  0.3381678330  0.76208996  0.62327921</div><div>HON   0.962861445 -0.04806091  0.08030012 -0.1941748467 -0.06754262 -0.17881846</div><div>HPQ   0.180362173  0.31499172 -0.04453175  0.2938330232 -0.16455364  0.87355849</div><div>IBM  -0.065107969  0.14796807  0.24482269  0.2814193875 -0.10344137 -0.01355011</div><div>INTC  0.948012402 -0.04091248  0.47412451  0.1365363063  0.30581355  0.13582519</div><div>JNJ   0.415851593  0.65973720 -0.14177559  0.7462797239 -0.18584403  0.09516495</div><div>JPM   0.887912350  0.01986489  0.01967263  0.4411658296 -0.01222057  0.90935280</div><div>KO   -0.010360697  0.09627309  0.32049120 -0.1469875979  0.42958923  0.02380171</div><div>MCD   0.967108956 -0.05120567 -0.16686988 -0.1142620730  0.32388421 -0.04844972</div><div>MMM   0.877382077  0.56586510  0.72813306  0.4014556626  0.74989555  0.26469238</div><div>MO    0.954323988  0.02652422 -0.31543056  0.3412257993 -0.08402821  0.20692791</div><div>MRK   0.887254598  0.04986324  0.17848601  0.4885137831 -0.04128828  0.23032417</div><div>MSFT  0.293521747  0.23363406  0.54720408  0.3242893772  0.55588607  0.31490297</div><div>PFE   0.515027787  0.37208816  0.23349921  0.4883462710  0.12075279  0.11798174</div><div>PG    1.000000000  0.07123866  0.55045995  0.3788365053  0.71045317  0.31342135</div><div>SBC   0.071238658  1.00000000 -0.05513004  0.5813479300  0.04242171  0.41568437</div><div>UTX   0.550459948 -0.05513004  1.00000000  0.0958598232  0.75842292  0.77676007</div><div>VZ    0.378836505  0.58134793  0.09585982  1.0000000000  0.02010254  0.51042235</div><div>WMT   0.710453169  0.04242171  0.75842292  0.0201025354  1.00000000  0.21252902</div><div>XOM   0.313421347  0.41568437  0.77676007  0.5104223538  0.21252902  1.00000000</div><div>> </div><div>> </div><div>> as.data.frame(as.dist(MatrizCorrelação))</div><div>Erro em as.data.frame.default(as.dist(MatrizCorrelação)) : </div><div>  cannot coerce class ""dist"" to a data.frame</div><div>> #MatrizCorrelação<-read.table(paste0("/Users/bau/MatrizCorrelaçãoMontagem/MatrizCorrelaçãoGLOBALHoraFixa",i,".txt")))</div><div>> melted_MatrizCor<-melt(MatrizCorrelação)</div><div>Using  as id variables</div><div>> </div><div>> </div><div>> ggplot(data=melted_MatrizCor,aes(x=Var1,y=Var2,fill=value)) + geom_tile()</div><div>Erro em eval(expr, envir, enclos) : objeto 'Var1' não encontrado</div></div></div>