Forum Discussion

Cortana's avatar
Cortana
Icon for Helper IV rankHelper IV
4 years ago

Same R scripts but different result on Power BI

I was trying to draw a correlation plot in powerBI using R scripts. But it is showing different results.  Here is my R scripts code-    library(corrplot) A = cor(na.omit(dataset)) corrplot(A, met...
General Comment
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

would you mind providing the sample data?

  • Cortana's avatar
    Cortana
    Icon for Helper IV rankHelper IV
    4 years ago

    lbendlin 

    As the data size is too big I was trying to share some sample data. But later I found that a small amount of data matched perfectly but the real data does not. Here you will get the real data. The size is about 70MB.. 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Your implementation of na.omit may lead to unintended side effects. As you specify it this will remove all rows where any of the columns is "NA" 

       

      Here is my result based on the data you provided. It has 3285939 rows but only 3117 rows will be left after the na.omit().

       

       

       

      • Cortana's avatar
        Cortana
        Icon for Helper IV rankHelper IV
        4 years ago

        Yeah. It removes maximum rows, but my question is if I run the script in R and PBI separately, it gives me a different result. Shouldn't it be same?