I am trying to display the html output or read in an html file to display in databricks notebook from pandas-profiling.
import pandas as pd import pandas_profiling
df = pd.read_csv("/dbfs/FileStore/tables/my_data.csv", header='infer', parse_dates=True, encoding='UTF-8')
profile = pandas_profiling.ProfileReport(df) Out[13]: <pandas_profiling.ProfileReport at 0x7f30e0b55780>
profile.to_html() Out[19]: '<!doctype html>\n\n<html lang="en">\n<head>\n <meta charset="utf-8">\n\n <title>Profile report</title>... WARNING: skipped 429584 bytes of output
Error on dislpayHtml()
displayHTML(profile)Py4JException: An exception was raised by the Python Proxy. Return Message: x
I could also output to html file:
profile.to_file(outputfile="/tmp/my_profiling.html")
but how would I read that in? is there a %html command?