jlbrosnahan
jlbrosnahan

Reputation: 173

Errors running Pandas Profile Report

I'm trying to run a Profile Report for EDA in conda Jupyter NB, but keep getting errors.
Here is my code thus far:

    import pandas_profiling
    from pandas_profiling import ProfileReport

    profile = ProfileReport(data)

and

    profile = pandas_profiling.ProfileReport(data)

both of which produce:

TypeError: concat() got an unexpected keyword argument 'join_axes'

Research recommended upgrading to Pandas 1.0, which I'm using.

Also tried

    data.profile_report()        

AttributeError: 'DataFrame' object has no attribute 'profile_report'

Any tips on where I am going wrong?

Addendum...So I finally figured it out. Needed to install latest version of pandas-profiling in conda, which was 202003 version. Too easy.

Upvotes: 12

Views: 23650

Answers (7)

Aditya Vikram
Aditya Vikram

Reputation: 51

I think the problem is generally with the previous versions of Pandas-Profiling, try upgrading it to a newer version

If you are using google collab !pip3 install pandas_profiling --upgrade

Otherwise use $ pip3 install pandas_profiling --upgrade

After executing this restart runtime

Upvotes: 1

user13227382
user13227382

Reputation:

#update Profiling to latest Version first

import sys
!{sys.executable} -m pip install -U pandas-profiling[notebook]
!jupyter nbextension enable --py widgetsnbextension

import pandas as pd
from pandas_profiling import ProfileReport

train = pd.read_csv("train.csv")

#Generate the profile report

report = ProfileReport(train)

print(repr(report.report))

report.to_widgets()

Upvotes: 2

Saurabh Asthana
Saurabh Asthana

Reputation: 1

Execute below command and once completed restart the runtime

!pip install pandas-profiling==2.7.1 

Upvotes: -2

Khubaib Raza
Khubaib Raza

Reputation: 583

Also running into the same issue. I upgraded using pip3 install pandas_profiling --upgrade

Upvotes: 2

Tanmey Rawal
Tanmey Rawal

Reputation: 181

First I tried just running the command !pip install pandas-profiling but still was not working but then I found this !pip install pandas-profiling==2.7.1 command, now it is working for me.

Upvotes: 11

jlbrosnahan
jlbrosnahan

Reputation: 173

Installed most recent version (March 2020) of pandas-profiling in conda.

conda install -c conda-forge/label/cf202003 pandas-profiling

Was then able to import pandas_profiling in jupyter notebook

Upvotes: 4

Tushar_Rath
Tushar_Rath

Reputation: 21

This works with the latest release of pandas profiling as well.

Release date - 14th April, 2020.

Find the link to install the same.

https://pypi.org/project/pandas-profiling/

Upvotes: 2

Related Questions