DOC: Clarify nrows behavior in read_csv
- [x] closes #59078
- [ ] [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.

Here’s the updated summary with a note section included:

Summary:

This pull request updates the `nrows` parameter documentation for `read_csv` to address ambiguity in the previous text. The original documentation was vague and did not clearly specify that `nrows` counts only the data rows returned, excluding the header, and skipped rows. The revised documentation provides a clearer definition of `nrows` and includes practical examples to better illustrate its usage, improving the overall clarity of the documentation.

Note:

Thanks to the suggestions from a previous PR made by the issuer and insights from Stack Overflow (https://stackoverflow.com/questions/23853553/python-pandas-how-to-read-only-first-n-rows-of-csv-files-in), the updated documentation hopefully clarifies that `nrows` excludes rows skipped with `skiprows`, and the header row. Please let me know if any examples should be added, revised, or removed to further enhance clarity. I understand that the example with `skiprows` might seem obvious, but it was included to address potential confusion.

Thanks @johnyu013 