TST: GH26650, added new test to validate numpy matmul function with dataframes
- [X] closes #26650 
- [X] [Tests added and passed]
- [X] All [code checks passed]

Please let the reviewer resolve the conversations Thanks @carbonleakage  Thanks @mroeschke and @phofl!