Pandas Profiling doesn't display the output

Question

Good Morning,

I have the following dataframe:

print(df)

                  Company              ...      Sales
0                  Medi ltd.           ...      4.16000
1                  Pia  ltd.           ...      2.59907

[26958 rows x 15 columns]

But whenever I run:

import pandas_profiling as pp
pp.ProfileReport(df)

It just outputs, withouth plots or frames:

Out[92]: <pandas_profiling.ProfileReport at 0x1131e0668>

I tried generating a sample df, but it doesn't work either:

print(sample)

     Col1 Col2
Row1    1    2
Row2    3    4

How can I solve this issue?

What does it show if you do `pp.ProfileReport(df).to_html()`? — hellpanderr, Sep 28 '18 at 10:25
And if you do `from IPython.core.display import display, HTML;display(HTML(pp.ProfileReport(df).to_html()))` — hellpanderr, Sep 28 '18 at 10:38
I am using Spyder from Anaconda, could it be related to that? In Jupyter it works perfectly. — Alessandro Ceccarelli, Sep 28 '18 at 14:14
If Spyder uses IPython then it does not know what to do with that html output. — hellpanderr, Sep 28 '18 at 14:21
Okay, this is the reason then! There is no way to display it there? — Alessandro Ceccarelli, Sep 28 '18 at 16:04
I could only find the solution I posted above, but it does not work, so.. — hellpanderr, Sep 28 '18 at 23:49

score 3 · Accepted Answer · answered Jul 18 '19 at 14:03

3

Answer for future reference:

This is not a pandas-profiling specific issue. Spyder does seem to have issues with displaying HTML, more information can be found in this disscussion: https://github.com/spyder-ide/spyder/issues/4582
A quick workaround would be to save the report to a file. You can do that like this:

report = pp.ProfileReport(df)
report.to_file('profile_report.html')

answered Jul 18 '19 at 14:03

Simon

5,464
6
49
85

I'm running this in a conda environment in vs code and I don't get any output, error or otherwise, with trying any of this. Any thoughts why this may be occuring? I can open a new question if needed – CGermain Feb 18 '20 at 15:53

Pandas Profiling doesn't display the output

1 Answers1