Skip to content

merge_asof timeseries don't preserve categories Pandas 0.19.0 #14351

Closed
@existeundelta

Description

@existeundelta

from the timeseries realease example: http://pandas.pydata.org/pandas-docs/version/0.19.0/whatsnew.html#merge-asof-for-asof-style-time-series-joining
making ticker as category:

trades.ticker = trades.ticker.astype('category') 
quotes.ticker = quotes.ticker.astype('category') 

merge = pd.merge_asof(trades, quotes,
                  on='time',
                  by='ticker')

Expected Output

merge.dtypes
Out[31]:
time datetime64[ns]
ticker category
price float64
quantity int64
bid float64
ask float64

geting :
time datetime64[ns]
ticker object
price float64
quantity int64
bid float64
ask float64

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions