Modernize code base for pandas 2.x and beyond

[amotl]

Hi there,

at GH-15, @bukowa asked for some adjustments for their use case. On the other hand, I think the code should probably be validated to work with all of Python 3.11, Grafana 9, and pandas 2.x these days.

Just having a look at two forks of the project, I discovered BP2022-AP1@79ec4cfdcb67 and BP2022-AP1@dd92d43d987 by @LucasDerReisende as well as jakubjezek001@5ca76493bce0e7 by @jakubjezek001 ¹.

I think it will be sweet to integrate those modernizations into the main code base. Maybe you could submit corresponding patches?

With kind regards,
Andreas.

Footnotes

1. Using f-strings makes sense, and also using some basic list comprehensions like compressing for col in df:. However, I don't like compressing code too much like freq = str(req.get("intervalMs")) + "ms" if "intervalMs" in req else None. ↩