DOC: unpin numpydoc, fix validation script #39688
- [x] closes #39688


The breaking change was from https://github.com/numpy/numpydoc/pull/302. 

After modifying our script according to the new API. There is an AttributeError error:

```
pandas.Series.array <property object at 0x1199e99f0>
Traceback (most recent call last):
  File "scripts/validate_docstrings.py", line 438, in <module>
    main(
  File "scripts/validate_docstrings.py", line 384, in main
    return print_validate_all_results(
  File "scripts/validate_docstrings.py", line 328, in print_validate_all_results
    result = validate_all(prefix, ignore_deprecated)
  File "scripts/validate_docstrings.py", line 298, in validate_all
    doc_info = pandas_validate(func_name)
  File "scripts/validate_docstrings.py", line 241, in pandas_validate
    result["examples_errs"] = doc.examples_errors
  File "scripts/validate_docstrings.py", line 161, in examples_errors
    for test in finder.find(self.raw_doc, self.name, globs=context):
  File "/opt/homebrew/Caskroom/miniforge/base/envs/pandas-dev/lib/python3.8/site-packages/numpydoc/validate.py", line 135, in name
    return '.'.join([self.obj.__module__, self.obj.__name__])
AttributeError: 'property' object has no attribute '__module__'
``` @fangchenli is this actionable? cc @MarcoGorelli @simonjayhawkins  This pull request is stale because it has been open for thirty days with no activity. Please update or respond to this comment if you're still interested in working on this. This PR has appeared to have gone stale. Feel free to reopen if you're still interested in working on this.