Fix remaining tests for pandas 2 compatibility

[caneff]

Fix the remaining tests without open questions.

1. Fix doctests. The new skips are all just new examples in Pandas 2 docs of things we were already skipping with Pandas 1.x doctests.
2. Expose set_eng_float_format, not new with Pandas 2 but has doc examples now where it didn't before so they caught that this should be exposed.
3. Skip remaining tests that have level in them that I missed earlier
4. Explicitly set numeric_only=True in the interactive runner test as I have in other tests (this test is not testing the functionality of numeric_only so it doesn't matter).

Umbrella Issue: #27221

[caneff]

R: @tvalentyn

[github-actions]

Stopping reviewer notifications for this pull request: review requested by someone other than the bot, ceding control

[codecov]

Codecov Report

Merging #28524 (6f1b655) into master (17db78c) will increase coverage by 0.01%.
Report is 1 commits behind head on master.
The diff coverage is 100.00%.

@@            Coverage Diff             @@
##           master   #28524      +/-   ##
==========================================
+ Coverage   72.23%   72.25%   +0.01%     
==========================================
  Files         684      684              
  Lines      100992   100931      -61     
==========================================
- Hits        72951    72926      -25     
+ Misses      26466    26430      -36     
  Partials     1575     1575              

Flag	Coverage Δ
python	82.82% <100.00%> (+<0.01%)	⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

Files Changed	Coverage Δ
...pache_beam/dataframe/pandas_top_level_functions.py	90.62% <100.00%> (+0.09%)	⬆️

... and 15 files with indirect coverage changes

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[tvalentyn]

noticing some assertion errors in https://ci-beam.apache.org/job/beam_PreCommit_Python_Coverage_Commit/4145/testReport/junit/apache_beam.dataframe.pandas_doctests_test/DoctestTest/test_groupby_tests/

[tvalentyn]

Run Python_Coverage PreCommit

[caneff]

PTAL. Skipped the xs test as discussed, and pytest passes everything for me lets see if it fails again here.

[tvalentyn]

which of the 1-4 chages affected pandas 1.4 ?

[caneff]

None, I had just removed a doc test thinking it was covered by something else but it wasn't.

…

On Wed, Sep 20, 2023, 6:17 PM tvalentyn ***@***.***> wrote: which of the 1-4 chages affected pandas 1.4 ? — Reply to this email directly, view it on GitHub <#28524 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABG4SH4Z4TH4JKCO7KQRPMTX3NTNZANCNFSM6AAAAAA46BSVAU> . You are receiving this because you authored the thread.Message ID: ***@***.***>