At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

    select * from table
    where (condition1 > 5) and (condition1 <10 ) and
    (condition2 > 100) and (condition2 <1000 )
    (condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadmin or adminer.

You can even create indexes for columns that are slow to query.  Many more optimization exist if you are will to learn them.