IR spectroscopy CSV parsing and display
- Simply run the Python script and drop the files over to the command window.
Powered by LinkStart.py, a lightweight dependency auto-installer.
You may use command-line parameter for easier specification of the file name, especially when the file is in the same directory of the script.
First copy TPU.csv from RAMAN_DATA/Group1 folder to same directory of reader.py
py reader.py TPU.csv
![image](https://private-user-images.githubusercontent.com/37951241/279914474-ade23269-8cef-4f61-a216-cc785275a431.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjI4MDY5NDcsIm5iZiI6MTcyMjgwNjY0NywicGF0aCI6Ii8zNzk1MTI0MS8yNzk5MTQ0NzQtYWRlMjMyNjktOGNlZi00ZjYxLWEyMTYtY2M3ODUyNzVhNDMxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MDQlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODA0VDIxMjQwN1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWFkZDIxZGQwZDM2NTVjNGZkOGI2NzMxODM0NTQ2OGRjM2FhZmY0OWY0ZDNjNzM4ZjQ3MzQwMjg1MDc4NGZjMTImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.RXTSvJjWem7x7lhLPJvdKaB5kdy2WDnuOKQAK5AN1k4)
Note: Not intended for end users.
- Install
xlrd
,openpyxl
andpandas
For converter_xls_RAMAN:
- Put the
converter.py
in same directory as all the .xls files - Run
converter.py
For converter_xlsx_FTIR:
- Ensure run
xlsx_to_csv("[name].xlsx")
for the xlsx files for conversion inconverter_xlsx.py
- Run
converter_xlsx.py