sfu-db / dataprep

Open-source low code data preparation library in python. Collect, clean and visualization your data in python with a few lines of code.
http://dataprep.ai
MIT License
2.06k stars 206 forks source link

[DataPrep.EDA] create_report cannot interpret 'Int64Dtype()' as a data type #733

Closed jnwang closed 2 years ago

jnwang commented 3 years ago

Describe the bug I loaded a table from sqlite using connector into a dataframe. When calling create_report on this dataframe, it reported an error (see below).

Dataset: https://github.com/MIT-LCP/mimic-workshop/blob/master/data/mimicdata.sqlite

import dataprep.connector as cx
from dataprep.eda import plot, create_report

sqlite_url = “sqlite:///Users/mimicdata.sqlite”
query = “SELECT * FROM ADMISSIONS”

df = cx.read_sql(sqlite_url, query)
create_report(df)
Screen Shot 2021-11-01 at 10 56 55 AM

Desktop (please complete the following information):