BUG: SparseSeries.value_counts ignores fill_value by sinhrks · Pull Request #12835 · pandas-dev/pandas (original) (raw)
Found current master doesn't work for datetimetz. Let me check.
values = [pd.Timestamp('2011-01-01 09:00', tz='US/Eastern'),
pd.Timestamp('2011-01-01 10:00', tz='US/Eastern'),
pd.Timestamp('2011-01-01 11:00', tz='US/Eastern'),
pd.Timestamp('2011-01-01 09:00', tz='US/Eastern'),
pd.Timestamp('2011-01-01 09:00', tz='US/Eastern'),
pd.Timestamp('2011-01-01 11:00', tz='US/Eastern')]
s = pd.Series(values, name='xxx')
# NG, index must have tz
s.value_counts()
# 2011-01-01 14:00:00 3
# 2011-01-01 16:00:00 2
# 2011-01-01 15:00:00 1
# Name: xxx, dtype: int64