Proper way to handle host data coming from multiple CSV files

Hi,
I’m new to ansible and coming from a system where we have multiple CSV files defining
projects, hosts, and users which I cannot easily change.

If I want to run certain commands I need to gather info from several files.

Is there is recommended way of doing this ?

I have been looking at the dynamic inventory, but I was hoping to us something better than
passing environment variables to the inventory.

(Actually I’m a python guy and I was hoping that the inventory module could be written in python
and actually called as a module internally by ansible rather than an executable script.)

Any direction or pointers would be appreciated,
Con