Reference 'count' is ambiguous, could be count, count.

[waghts95]

Current Behaviour

Pyspark.sql.utils.AnalysisException : Reference 'count' is ambiguous, could be count, count.

Expected Behaviour

Code should save html file.

Data Description

could not provide data.
It is confidential.

Code that reproduces the bug

report.to_file("/tmp/report.html")

pandas-profiling version

4.3.2

Dependencies

pandas==1.3.5
numpy==1.21.6

OS

Amazon linux 2

Checklist

• There is not yet another bug report for this issue in the issue tracker
• The problem is reproducible from this bug report. This guide can help to craft a minimal bug report.
• The issue has not been resolved by the entries listed under Common Issues.

[waghts95]

Column names should be like count, percent, sum as Y-data profiling might use these names. So if such names are used, ambiguity is created.
My issue got resolved when I rename column name from 'count' to 'patient_count'.