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

Job	Run time
Test Conda Forge Recipe	2m 38s
Install Extras - parquet	3m 58s
Install Extras - gcp	4m 8s
Install Extras - sql-other	4m 59s
Install Extras - fss	4m 5s
Install Extras - output-formatting	3m 59s
Install Extras - hdf5	4m 3s
Install Extras - test	4m 2s
Install Extras - aws	4m 1s
Install Extras - performance	4m 14s
Install Extras - spss	4m 1s
Install Extras - postgresql	4m 15s
Install Extras - excel	4m 13s
Install Extras - computation	4m 8s
Install Extras - clipboard	4m 4s
Install Extras - mysql	4m 4s
Install Extras - compression	4m 0s
Install Extras - html	4m 8s
Install Extras - all	4m 48s
Install Extras - feather	4m 5s
Install Extras - plot	4m 3s
Install Extras - pyarrow	4m 4s
Install Extras - xml	3m 57s
	1h 33m 57s

Provide feedback