Skip to content

BUG: DatetimeIndex intersection is empty or garbage #59271

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
2 of 3 tasks
yportier opened this issue Jul 18, 2024 · 4 comments · Fixed by #59280
Closed
2 of 3 tasks

BUG: DatetimeIndex intersection is empty or garbage #59271

yportier opened this issue Jul 18, 2024 · 4 comments · Fixed by #59280
Assignees
Labels
Bug Needs Triage Issue that has not been reviewed by a pandas team member

Comments

@yportier
Copy link

yportier commented Jul 18, 2024

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

index = pd.date_range('2024-01-01', '2024-02-19', unit='s')
period = pd.date_range('2024-01-01', '2024-02-09', unit='s')
index.intersection(period)  # ughh... DatetimeIndex(['2024-01-01', '2739931-01-04'], dtype='datetime64[s]', freq='D')

index = pd.date_range('2024-01-01', '2024-02-19', unit='s')
period = pd.date_range('2024-01-09', '2024-02-09', unit='s')

index.intersection(period)  # empty!

Issue Description

In the first example, the result is obviously buggy with year 2739931
The second example is empty when it shouldn't

Expected Behavior

both examples are expected to return an index equivalent to period

Installed Versions

INSTALLED VERSIONS

commit : d9cdd2e
python : 3.10.12.final.0
python-bits : 64
OS : Linux
OS-release : 6.1.85+
Version : #1 SMP PREEMPT_DYNAMIC Thu Jun 27 21:05:47 UTC 2024
machine : x86_64
processor : x86_64
byteorder : little
LC_ALL : en_US.UTF-8
LANG : en_US.UTF-8
LOCALE : en_US.UTF-8

pandas : 2.2.2
numpy : 1.25.2
pytz : 2023.4
dateutil : 2.8.2
setuptools : 67.7.2
pip : 23.1.2
Cython : 3.0.10
pytest : 7.4.4
hypothesis : None
sphinx : 5.0.2
blosc : None
feather : None
xlsxwriter : None
lxml.etree : 4.9.4
html5lib : 1.1
pymysql : None
psycopg2 : 2.9.9
jinja2 : 3.1.4
IPython : 7.34.0
pandas_datareader : 0.10.0
adbc-driver-postgresql: None
adbc-driver-sqlite : None
bs4 : 4.12.3
bottleneck : None
dataframe-api-compat : None
fastparquet : None
fsspec : 2023.6.0
gcsfs : 2023.6.0
matplotlib : 3.7.1
numba : 0.58.1
numexpr : 2.10.1
odfpy : None
openpyxl : 3.1.5
pandas_gbq : 0.19.2
pyarrow : 14.0.2
pyreadstat : None
python-calamine : None
pyxlsb : None
s3fs : None
scipy : 1.11.4
sqlalchemy : 2.0.31
tables : 3.8.0
tabulate : 0.9.0
xarray : 2023.7.0
xlrd : 2.0.1
zstandard : None
tzdata : 2024.1
qtpy : None
pyqt5 : None

@yportier yportier added Bug Needs Triage Issue that has not been reviewed by a pandas team member labels Jul 18, 2024
@Animesh-Shukla
Copy link

take

@asishm
Copy link
Contributor

asishm commented Jul 18, 2024

Thanks for the report. Can you confirm you've checked with the main branch of pandas (you have it checked) because I'm unable to reproduce. Confirmed the bug exists in pandas 2.2.2

@yportier
Copy link
Author

Apologies, I did not install the main branch correctly, I confirm the bug is not present in 3.0.0.dev0+1223.gc3b72aae6f

@asishm
Copy link
Contributor

asishm commented Jul 19, 2024

Thanks! This was fixed in #59037 and will be released in 3.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Needs Triage Issue that has not been reviewed by a pandas team member
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants