BrandonFors/pandas-github-issues huggingface dataset:
#56696  Added Cheatsheet Section and cheatsheet link to pandas home page
State: closed

- [x] closes #56696 (Replace xxxx with the GitHub issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


## This is space where i wanted to add the link to the cheatsheet and small cheatsheet section

![image](https://github.com/pandas-dev/pandas/assets/89439095/79d7da05-b31f-4186-a38e-ae0af846bcee)

## This is the section i have added and changed in the "pandas/blob/main/doc/source/getting_started/index.rst"

![image](https://github.com/pandas-dev/pandas/assets/89439095/e721bed4-4a5f-4b99-bc27-3a3fac0cf6fc)


Labels:
name: Docs

Comments:
Thanks for the contribution @gyanavardhana. I think I prefer how the cheatsheet is mentioned now. And I guess nobody else is looking forward to get this merged after 3 weeks. Closing.
fix: add pytest-qt deps to dockerfile
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:

Comments:
Thanks @edydfang
TST: Don't ignore tolerance for integer series
State: closed

- [ ] closes #56646 (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

cc @lithomas1 

Labels:
name: Testing
description: pandas testing functions or related to the test suite

Comments:
Thanks, can you also update the docstrings?

(e.g. https://github.com/pandas-dev/pandas/pull/56724/files#diff-9157afe37d6dba4c96d24fce3cf8290e3810b4662f77abf4a71719bbee795a25R845)
done
Looks like 2 more places need to be updated.

https://github.com/pandas-dev/pandas/blob/8b287cfe887a9952eea96c39527e6647be95581b/pandas/_testing/asserters.py#L718-L719

https://github.com/pandas-dev/pandas/blob/8b287cfe887a9952eea96c39527e6647be95581b/pandas/_testing/asserters.py#L1124-L1125
Oh sorry, I think I got everything now
Fix for #56716: Use assert_produces_warning instead of pytest.raises to show FutureWarning
State: closed

- [1] closes #56716
- [2] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [3] Replaced FutureWarning using pytest: pytest.raises(FutureWarning, match=msg): 
        with tm.assert_produces_warning


Labels:

Comments:
I solved my earlier PR on my main branch which is still open and updated all the code to this branch during commit. I will be careful hereon to create branches for new feature/bug. Any help so that the code in my main branch won't be reflected here.I am new and currently learning git.
Closed by https://github.com/pandas-dev/pandas/pull/56974
DOC: Fixup read_csv docstring
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Docs
name: IO CSV
description: read_csv, to_csv

Comments:
Thanks @phofl
Fix integral truediv and floordiv for pyarrow types with large divisors
State: closed

- [ ] closes #56706(Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:

Comments:
Combined fix into https://github.com/pandas-dev/pandas/pull/56677 to reduce confusion.
DOC: Corrected typo in warning on coerce
State: closed

Low priority.

I encountered this warning message:

> "Setting an item of incompatible dtype is deprecated and will raise in a future **error** of pandas."

Which I believe should read:

> "Setting an item of incompatible dtype is deprecated and will raise **an error** in a future **version** of pandas."

Labels:
name: Docs

Comments:
OK merge for 2.2. Thanks @aaron-robeson-8451
[pre-commit.ci] pre-commit autoupdate
State: closed

<!--pre-commit.ci start-->
updates:
- [github.com/hauntsaninja/black-pre-commit-mirror: 23.11.0 → 23.12.1](https://github.com/hauntsaninja/black-pre-commit-mirror/compare/23.11.0...23.12.1)
- [github.com/astral-sh/ruff-pre-commit: v0.1.6 → v0.1.9](https://github.com/astral-sh/ruff-pre-commit/compare/v0.1.6...v0.1.9)
- [github.com/pylint-dev/pylint: v3.0.1 → v3.0.3](https://github.com/pylint-dev/pylint/compare/v3.0.1...v3.0.3)
- [github.com/PyCQA/isort: 5.12.0 → 5.13.2](https://github.com/PyCQA/isort/compare/5.12.0...5.13.2)
<!--pre-commit.ci end-->

Labels:
name: Code Style
description: Code style, linting, code_checks

Comments:
Couldn't we still bump these versions since the bumped version of ruff doesn't format by default? The black-ruff replacement could follow up on this one
Let's just wait for the next one
implement mod and divmod for pyarrow types
State: closed

- [ ] closes #56693(Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:

Comments:
Not overflow safe.
Bug pyarrow implementation of str.fullmatch matches partial string. issue #56652
State: closed

- [x] closes #56652
- [x] Tests updated and passed
- [x] All code checks passed

Changed array.py: Makes Series(["abc$abc]).str.fullmatch("abc\\$") give the same result as when dtype = pyarrow.string as opposed to dtype = str.

Issue reporter (Issue-[#56652](https://github.com/pandas-dev/pandas/issues/56652)) requested change "//$" to "\\$", but this resulted in DepreciationWarnng in pytest, so used "\\\\$" instead.

Change test_arrow.py: updated test_str_fullmatch to account for edge cases where string starts with and ends with literal $ as well as ends with the string.


Labels:
name: Strings
description: String extension data type and string data
name: Arrow
description: pyarrow functionality

Comments:
Thanks @asishm , I can shortly make a commit which makes the changes in `./pandas/core/arrays/string_arrow.py`
and also updates the fullmatch test in `./pandas/tests/strings/test_find_replace.py`

To clarify, from testing, the changes to  ./pandas/core/arrays/arrow/array.py also affect `test_str_fullmatch` even though it does so via `str.fullmatch()`.
Updated PR. 
Question: For consistency, I formatted test_fullmatch_dollar_literal() to match other unit tests in .py - Should I instead aim to implement @pytest.mark.parametrize, which is inconsistent with its neighbour tests, but more in-line with developer guidelines?
Thanks @mroeschke that update to `v2.2.0.rst` is added now. 
Resolved merge conflict by rebasing off upstream main. 
Thanks @JackCollins91 
Owee, I'm MrMeeseeks, Look at me.

There seem to be a conflict, please backport manually. Here are approximate instructions:

1. Checkout backport branch and update it.

```
git checkout 2.2.x
git pull
```

2. Cherry pick the first parent branch of the this PR on top of the older branch:
```
git cherry-pick -x -m1 dc94b987a0c6920c0e14351372a374d566313cef
```

3. You will likely have some merge/cherry-pick conflict here, fix them and commit:

```
git commit -am 'Backport PR #56691: Bug pyarrow implementation of str.fullmatch matches partial string. issue #56652'
```

4. Push to a named branch:

```
git push YOURFORK 2.2.x:auto-backport-of-pr-56691-on-2.2.x
```

5. Create a PR against branch 2.2.x, I would have named this PR:

> "Backport PR #56691 on branch 2.2.x (Bug pyarrow implementation of str.fullmatch matches partial string. issue #56652)"

And apply the correct labels and milestones.

Congratulations — you did some good work! Hopefully your backport PR will be tested by the continuous integration and merged soon!

Remember to remove the `Still Needs Manual Backport` label once the PR gets merged.

If these instructions are inaccurate, feel free to [suggest an improvement](https://github.com/MeeseeksBox/MeeseeksDev).
Added validation check for integer value for series.df
State: closed

- [1] closes #56607 
- [2] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [3 ] Imported is_float from from pandas.core.dtypes.common for the check and added an if statement to raise the ValueError. 

Labels:
name: Error Reporting
description: Incorrect or improved errors from pandas
name: Series
description: Series data structure
name: Transformations
description: e.g. cumsum, diff, rank

Comments:
Can you add a test case and a whatsnew comment like I mentioned in my original comment [here](https://github.com/pandas-dev/pandas/issues/56607#issuecomment-1871321061)?

This is on the right track, though.
@lithomas, I also found that algorithms.py should also need the check for the diff method. Do we have to open a new issue or shall I update both series.py and algorithms.py with the checks.My PR is updating the algorithms.py file but I can commit again with a series.py changes.
I have added the mentioned testcase and whatsnew update @lithomas1. 
Hi @lithomas1, I have completed all the checks.Can you let me know the next steps to close the PR? Also, thank you for all your help in setting up the environment. Looking forward to become active contributor to pandas hereon.
thanks @pmhatre1
add test for concating tzaware series with empty series. Issue: #34174
State: closed

- [x] closes #34174
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Testing
description: pandas testing functions or related to the test suite

Comments:
Thanks @xiaohuanlin
CLN: NEP 50 followups
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Clean

Comments:
Thanks @lithomas1
DEPR: utcnow, utcfromtimestamp
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

The stdlib has deprecated these, let's do it too!

Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
ok with the idea - looks like ci is red?
Thanks @jbrockmendel
Fix integral truediv and floordiv for pyarrow types with large divisor and avoid floating points for floordiv
State: closed

- [x] closes #56676(Replace xxxx with the GitHub issue number)
- [x] closes #56706(Replace xxxx with the GitHub issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Arrow
description: pyarrow functionality

Comments:
> Of course the pyarrow compute kernel would be ideal, but I would be OK with this for now and we can always switch to that kernel as it becomes available.

Agreed, however, even in the best case if this is added in arrow 15 (next major release), given that pandas supports a minimum of pyarrow 10, it may be a while before the minimum pyarrow version supported by pandas has a floordiv kernel, so I think this code would still be useful for the near future.
Yeah I'm OK with this workaround until pyarrow may introduce a floordiv kernel we can replace this with
Thanks for identifying and fixing these @rohanjain101
TYP: more misc annotations
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Typing
description: type annotations, mypy/pyright type checking

Comments:
Thanks @twoertwein
BUG: dictionary type astype categorical using dictionary as categories
State: closed

Currently, we use a dictionary array as categories, which is weird, this just uses the underlying dictionary and extracts the codes, which should be fine for us. The dictionary array causes all kinds of trouble when sorting and doing similar things



Labels:
name: Categorical
description: Categorical Data Type
name: Arrow
description: pyarrow functionality

Comments:
We use arrow to cast on construction which does this properly, so we should be good,
ENH: Implement categorical accessor for arrow arrays
State: closed

Implements the first few methods for the categorical accessor, we could backport, but not sure if I get all of them until the release happens

Labels:
name: Categorical
description: Categorical Data Type
name: Stale
name: Arrow
description: pyarrow functionality

Comments:
This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this.
I think we would want this, but it appears this has gone stale so going to close to clear the queue
TYP: misc annotations
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Typing
description: type annotations, mypy/pyright type checking

Comments:
Thanks @twoertwein
Pyarrow stringmatch fix
State: closed

closes #56652  
 Added the change for partial string matching.

Labels:
name: Strings
description: String extension data type and string data
name: Arrow
description: pyarrow functionality

Comments:
Could you please add a test?
I tried adding a test and running it. I'm running into an issue with the pandas version.
`UserWarning: pyarrow requires pandas 1.0.0 or above, pandas 0+untagged.34041.g62dbbe6 is installed. Therefore, pandas-specific integration is not used.`

This is my first open source contribution and I am confused about how I can proceed further. Please let me know if there is any documentation about this.
@neha3004 - have you followed this? https://pandas.pydata.org/pandas-docs/stable/development/contributing_environment.html
Thanks for the pull request, but this has been addressed by https://github.com/pandas-dev/pandas/pull/56691 so closing
BUG: bar and line plots are not aligned on the x-axis/xticks
State: closed

- [x] closes #56460
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Added a test which will fail on main's self.tick_pos = np.arange(len(data)), which in this test will result in actual_bar_x of [0,1,2,3,4].

```
def test_bar_plot_x_axis(self, plot_data):
    df = DataFrame(plot_data)
    ax_bar = df["bars"].plot(kind="bar")
    df["pct"].plot(kind="line")
    actual_bar_x = [bar.get_x() + bar.get_width() / 2.0 for bar in ax_bar.patches]
    expected_x = [-1, 0, 1, 2, 3]
    assert actual_bar_x == expected_x
        ```

Labels:
name: Visualization
description: plotting
name: Stale

Comments:
@rhshadrach or anyone interested in reviewing, welcoming comments
This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this.
I think this fix is actually irrelevant now because of the discussion in the issue.
@sharonwoo - no problem, will close for now. If you'd like to take up the fix discussed in the issue, feel free to either reuse this PR (we can reopen) or open a new one.
ENH: Implement dt methods for pyarrow duration types
State: closed

- [x] closes #52284 (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Timedelta
description: Timedelta data type
name: Arrow
description: pyarrow functionality

Comments:
thx @mroeschke
floordiv fix for large values
State: closed

- [ ] closes #56645 (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Arrow
description: pyarrow functionality

Comments:
thx @rohanjain101
BUG: Series.to_numpy raising for arrow floats to numpy floats
State: closed

- [ ] xref #56267 (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Arrow
description: pyarrow functionality

Comments:
Thanks @phofl
DOC: Add optional dependencies table in 2.2 whatsnew
State: closed


Labels:
name: Docs

Comments:
End of this section or the whatsnew doc?

I suppose this is the `Backwards incompatible API changes` since bumped versions may have removed functionality
End of the doc, I am also fine with keeping it here
I'll keep it for now. We can reorganize the whatsnew for 3.0