Script to clean up the data from xlsx files and export to csv using pandas
Prepare the data from xlsx files for Power Bi import:
- check all .xlsx files in selected path
- collect the data into a DataFrame
- drop some unnecessary lines; replace some text
- combine the data into a single DataFrame and export into .csv