Python Script Writer

I have around 5000 excel csv files with different titles but I want to divided them different parameters like I want to divided them into industry name, company size, location etc.

If you are Python expert, only apply.