BUG: Resampling with non nano returns an error (original) (raw)

Pandas version checks

• I have checked that this issue has not already been reported.
• I have confirmed this bug exists on the latest version of pandas.
• I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

import pandas as pd import numpy as np import operator

#Load the data

url = 'https://raw.githubusercontent.com/LinkedEarth/Pyleoclim_util/master/pyleoclim/data/LR04.csv' df = pd.read_csv(url,skiprows=4,header=0)

multiplier = 1 rule = f'{1_000*multiplier}YS'

op=operator.sub

SECONDS_PER_YEAR = 31556925.974592 index = pd.DatetimeIndex(op( np.datetime64(str(1950), 's'), (df.iloc[:,0]SECONDS_PER_YEAR10**3).astype('timedelta64[s]') ),name='datetime')

value = df.iloc[:,1].to_numpy()

ser = pd.Series(value, index=index) ser2 = ser.resample(rule)

Issue Description

Produces the following error:

Traceback (most recent call last):

  Cell In[13], line 1
    ser2 = ser.resample(rule)

  File ~/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/pandas/core/generic.py:9765 in resample
    return get_resampler(

  File ~/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/pandas/core/resample.py:2044 in get_resampler
    return tg._get_resampler(obj, kind=kind)

  File ~/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/pandas/core/resample.py:2225 in _get_resampler
    return DatetimeIndexResampler(

  File ~/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/pandas/core/resample.py:187 in __init__
    self.binner, self._grouper = self._get_binner()

  File ~/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/pandas/core/resample.py:252 in _get_binner
    binner, bins, binlabels = self._get_binner_for_time()

  File ~/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/pandas/core/resample.py:1735 in _get_binner_for_time
    return self._timegrouper._get_time_bins(self.ax)

  File ~/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/pandas/core/resample.py:2323 in _get_time_bins
    bins = lib.generate_bins_dt64(

  File lib.pyx:891 in pandas._libs.lib.generate_bins_dt64

ValueError: Values falls before first bin

Note that this issue did not exist in 2.1.4

Expected Behavior

A resampled timeseries as of 2.1.4

Installed Versions

pd.show_versions()
/Users/deborahkhider/opt/anaconda3/envs/paleopandas/lib/python3.10/site-packages/_distutils_hack/init.py:33: UserWarning: Setuptools is replacing distutils.
warnings.warn("Setuptools is replacing distutils.")

INSTALLED VERSIONS

commit : fd3f571
python : 3.10.8.final.0
python-bits : 64
OS : Darwin
OS-release : 22.6.0
Version : Darwin Kernel Version 22.6.0: Wed Jul 5 22:21:56 PDT 2023; root:xnu-8796.141.3~6/RELEASE_X86_64
machine : x86_64
processor : i386
byteorder : little
LC_ALL : en_US.UTF-8
LANG : en_US.UTF-8
LOCALE : en_US.UTF-8

pandas : 2.2.0
numpy : 1.24.3
pytz : 2023.3
dateutil : 2.8.2
setuptools : 67.7.2
pip : 23.1.2
Cython : 0.29.33
pytest : None
hypothesis : None
sphinx : 5.0.2
blosc : None
feather : None
xlsxwriter : None
lxml.etree : 4.9.2
html5lib : None
pymysql : None
psycopg2 : None
jinja2 : 3.1.2
IPython : 8.14.0
pandas_datareader : None
adbc-driver-postgresql: None
adbc-driver-sqlite : None
bs4 : 4.12.2
bottleneck : 1.3.6
dataframe-api-compat : None
fastparquet : None
fsspec : 2023.6.0
gcsfs : None
matplotlib : 3.6.3
numba : 0.57.0
numexpr : None
odfpy : None
openpyxl : None
pandas_gbq : None
pyarrow : None
pyreadstat : None
python-calamine : None
pyxlsb : None
s3fs : None
scipy : 1.12.0
sqlalchemy : 2.0.23
tables : None
tabulate : 0.9.0
xarray : 2023.1.0
xlrd : 2.0.1
zstandard : None
tzdata : 2023.3
qtpy : 2.3.1
pyqt5 : None