You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
importpandasaspdfrompandas_profilingimportProfileReportimportpandasaspdfromydata_profiling.utils.cacheimportcache_filefromydata_profilingimportProfileReportfile_name=cache_file(
"pollution_us_2000_2016.csv",
"https://query.data.world/s/mz5ot3l4zrgvldncfgxu34nda45kvb",
)
df=pd.read_csv(file_name, index_col=[0])
df["Date Local"] =pd.to_datetime(df["Date Local"])
type_schema= {
"NO2 Mean": "timeseries",
"NO2 1st Max Value": "timeseries",
"NO2 1st Max Hour": "timeseries",
"NO2 AQI": "timeseries",
}
# Filtering time-series to profile a single sitesite=df[df["Site Num"] ==2]
site_2=site[["NO2 Mean", "NO2 1st Max Value", "NO2 1st Max Hour", "NO2 AQI", "Date Local"]]
#Enable tsmode to True to automatically identify time-series variables#Provide the column name that provides the chronological order of your time-seriesprofile=ProfileReport(
site_2,
tsmode=True,
type_schema=type_schema,
sortby="Date Local",
title="Time-Series EDA for site",
)
profile.to_file("report_timeseries.html")
pandas-profiling version
4.6.0
Dependencies
pandas==2.0.3
OS
windows 10
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.
The text was updated successfully, but these errors were encountered:
Current Behaviour
When attempting to generate a report for time series data, sometimes I receive a NaTType error. The dataset used is the example dataset from tutorials https://github.com/ydataai/ydata-profiling/blob/develop/examples/usaairquality/usaairquality.ipynb. If trying to load the full dataset into the report or filtered to a specific site num such as 2, the time series profiling will fail.
Expected Behaviour
A time series profile report should be generated
Data Description
https://github.com/ydataai/ydata-profiling/blob/develop/examples/usaairquality/usaairquality.ipynb
Code that reproduces the bug
pandas-profiling version
4.6.0
Dependencies
OS
windows 10
Checklist
The text was updated successfully, but these errors were encountered: