PerspectiveWidget Doesn't Respect Pandas Datatype datetime64[ns] and others

[tlmille2]

Overview

I've noticed the PerspectiveWidget doesn't respect Pandas Datatype datetime64[ns] . For example, if a pandas dataframe contains a datetime64[ns] value, the PerspectiveWidget will display the column as a unix timestamp.

Expected Behavior

The PerspectiveWidget returns a datetime value instead of a unix timestamp

Example Working Solution Using Perspective natively

import pandas as pd
import numpy as np
from datetime import date, datetime
from perspective import PerspectiveWidget

data = pd.DataFrame({
    "int": np.arange(100),
    "float": [i * 1.5 for i in range(100)],
    "bool": [True for i in range(100)],
    "date": [date.today() for i in range(100)],
    "datetime": [datetime.now() for i in range(100)],
    "string": [str(i) for i in range(100)]
})

widget = PerspectiveWidget(data, filters=[["set", "==", True]])

Example Bug Using Panel/Lumen

import holoviews as hv
import panel as pn
import pandas as pd
import numpy as np
from datetime import date, datetime
pn.extension('perspective')

data = pd.DataFrame({
    "int": np.arange(100),
    "float": [i * 1.5 for i in range(100)],
    "bool": [True for i in range(100)],
    "date": [date.today() for i in range(100)],
    "datetime": [datetime.now() for i in range(100)],
    "string": [str(i) for i in range(100)]
})

pn.pane.Perspective(
    data, sizing_mode='stretch_width', height=400
)