CI: Fix scripts tests when running from another directory#62181

mroeschke merged 2 commits intopandas-dev:mainpandas-dev/pandas:mainfrom

rhshadrach:scripts_testsrhshadrach/pandas:scripts_testsCopy head branch name to clipboard