concat() got an unexpected keyword argument 'join_axes'

[learninlearn]

US_Accidents_May19.csv from kaggle

[learninlearn]

TypeError Traceback (most recent call last)
in
1 import pandas_profiling as pp
----> 2 pp.ProfileReport(df.iloc[[0,10]])

E:\Anaconda3\lib\site-packages\pandas_profiling_init_.py in init(self, df, **kwargs)
64 sample = kwargs.get('sample', df.head())
65
---> 66 description_set = describe(df, **kwargs)
67
68 self.html = to_html(sample,

E:\Anaconda3\lib\site-packages\pandas_profiling\describe.py in describe(df, bins, check_correlation, correlation_threshold, correlation_overrides, check_recoded, pool_size, **kwargs)
390 if name not in names:
391 names.append(name)
--> 392 variable_stats = pd.concat(ldesc, join_axes=pd.Index([names]), axis=1)
393 variable_stats.columns.names = df.columns.names
394

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

[sbrugman]

Could you provide the minimal information to reproduce this error?

• the minimal code you are using to generate the report
• which environment you are using (jupyter notebook, console or IDE) and packages (pip freeze > packages.txt)
• a sample or description of the dataset (df.head(), df.info())

[learninlearn]

Could you provide the minimal information to reproduce this error?

• the minimal code you are using to generate the report
• which environment you are using (jupyter notebook, console or IDE) and packages (pip freeze > packages.txt)
• a sample or description of the dataset (df.head(), df.info())

Yeah, I just a few codes and I just want to check these package with jupyter notebook

[sbrugman]

Which versions of pandas as pandas-profiling do you have installed?

[learninlearn]

pandas 1.0.3
pandas-profiling 1.4.1

[janhurst]

the pd.concat join_axes kwarg was deprecated around pandas 0.25 and removed in pandas 1.0.0

https://pandas.pydata.org/pandas-docs/version/1.0.0/whatsnew/v1.0.0.html#other-api-changes

also see pandas-dev/pandas#21951 and pandas-dev/pandas#22318

[loopyme]

I think update pandas-profiling will solve this problem.

Besides, this issue is same as #401

[nickcorona]

This problem occurs on even the latest version of pandas-profiling.

[gmivan]

I fixed the same issue in the example bellow by changing "join_axes" operator to "keys" operator. It works.

Before:
dfsubmit = pd.concat([TestdataID['PassengerId'], dfPrediction['Survived']], axis = 1, join_axes=[TestdataID['PassengerId'].index])
dfsubmit = dfsubmit.reset_index(drop=True)

After:
dfsubmit = pd.concat([TestdataID['PassengerId'], dfPrediction['Survived']], axis = 1, keys=[TestdataID['PassengerId'].index])
dfsubmit = dfsubmit.reset_index(drop=True)