Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Python visual is not accurate

The matplotlib plot that shows up in Power BI, is different from that one, that the same code generates in a jupyter notebook. Please help.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank you Pragati11  and amitchandak .

    The issue was with the sequence of columns. Power BI sends the columns in the alphabetical order, and not in the order in which the columns get uploaded.

    Thanks again for your prompt support.

Anonymous's avatar
Anonymous
Not applicable
5 years ago
amitchandak wrote:

Anonymous, can share some sample images?

Thank you for the prompt response Amit.
 
This is the code:
import pandas as pd
import pickle
import matplotlib.pyplot as plt

enq_loaded_model = pickle.load(open('C:ENQUIRY.sav', 'rb'))
y = enq_loaded_model.predict(dataset)
plt.plot(y)
plt.show()
 
First one is from Power BI, and the second one from jupyter notebook
Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Anonymous ,

 

I can see the difference clearly in the y-axis scaling.

In Jupyter your y-axis range is till 2200, thereore the graph shows a different pattern.

In Power BI your y-axis range is till 2950, therefore graph is different.

 

In your pythin script when you are generating plot in Power BI, you will have to define range for your y-axis. Try giving this range similar to that in Jupyter notebook. I am sure you will get the same graph.

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pragati11 ,

     

    Thank you.

     

    It didn't work. First one is from Power BI, and the seocnd one from jupyter notebook.

     

    It didn't work.

     

    Code:

     

    import pandas as pd
    import pickle
    import matplotlib.pyplot as plt

    enq_loaded_model = pickle.load(open('C:/ENQUIRY.sav', 'rb'))
    # predict the enquiry
    y = enq_loaded_model.predict(dataset)
    plt.ylim([500,2500])
    plt.plot(y)
    plt.show()
    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      Hi Anonymous ,

       

      Can you make sure that under this visual in Power BI, the fields that you have used - they are set to Don't Summarise?

       

      This could be the reason why you don't see anything in Power BI for the same python script.

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Checked again, Pragati11 . Each one of them is set to "Don't Summarize".