We don't have your sample data so won't be able to answer these questions.
If you're after some feed-back then may-be best provide your answers and explain how you got there/how you've approached the questions and what code you've used (post the code using the running man icon).
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Registration is open
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!