DIGITAL.CSIC. Repositorio Institucional del CSIC
Publicación
Otros (Other)
EverGlass Database
Author contact information: g.gorni@csic.es, CODE DOCUMENTATION FOR: [EVERGLASS DATABASE]
1. Document your code, including coding conventions, such as file organization, comments, naming conventions, programming practices (Repeat this section for each dataset, folder or file, as appropriate)
- File Organization: The main script contains all GUI logic, data loading functions, and visualization tools. It is structured around a central class GlassPropertiesApp.
- Naming Conventions: Variables and functions follow descriptive naming using snake_case, consistent with Python standards.
- Comments: Inline comments are used to explain key steps, especially in data processing and GUI setup. Docstrings are provided for most functions.
- Modularity: Each dataset type (chemical, viscosity, physical, thermal) has its own loading and display logic, improving readability and maintainability.
- Error Handling: The code uses try-except blocks and messagebox alerts to handle file errors and missing data gracefully.
- Data Validation: CSV files are checked for required columns. Missing values (e.g., molar %) are recalculated using a built-in molar mass dictionary.
- Interactive Features: Viscosity curves are plotted using VFT parameters (A, B, T₀), with cursor tracking and real-time coordinate display.
- Export Functionality: Displayed tables can be exported to CSV via a dedicated button.
Each dataset (chemical, viscosity, physical, thermal) is:
- Loaded via a dedicated menu option.
- Validated and cleaned.
- Displayed in a tab with dynamically generated buttons for each glass type.
- Shown in a formatted table or plot upon selection, EVERGLASS DATABASE is a Python-based graphical application (Tkinter-based) designed to manage and visualize datasets related to glass properties.
-Users can load CSV files containing chemical compositions, viscosity data, physical properties, and general thermal properties of glasses.
-The software automatically recalculates missing chemical values (e.g., molar % from weight %) using an internal molar mass dictionary.
-It provides interactive visualization of viscosity curves based on Vogel–Fulcher–Tammann (VFT) parameters (A, B, T₀), with real-time cursor tracking.
-Data is displayed in organized tabs and tables, and users can export results to CSV.
-The interface includes contextual help, an info viewer, and a logo-branded welcome screen., SOFTWARE & FILE OVERVIEW
1. EVERGLASS DATABASE PYTHON.rar (Python code and .txt files that works on any operative systems provided that Python 3 is installed)
- EVERGLASS_DATABASE.py: main Python program.
- EVERGLASS_LOGO.png: logo displayed in the GUI.
- Glasses_INFO.txt / .dat: optional info files with descriptions of glass families.
- Properties_INFO.txt / .dat: optional info files with property descriptions.
- The Glass_INFO.txt and Properties_INFO.txt must be located in the same directory of the EVERGLASS_DATABASE.py., 2. EVERGLASS DATABASE EXE.rar folder (only for Windows, no Python installation is required). It contains:
- _internal (folder) (Don't separate the .exe file from the _internal folder. Use shortcut to send the .exe to another directory/folder).
- EVERGLASS DATABASE.exe, 3. EVERGLASS DATA
- 4 CVS files containing data (these are the files to be used for the EVERGLASS DATABASE. They can be edited directly or if prefered, their .xlsx version can be edited and then converted to CSV files. An additional software "Convert XLS O CSV" is available for this scope).
- 4 .xlsx files containing the same data. (These files can be edited and then converted into CSV files for the EVERGLASS DATABASE or, if preferred, the CSV files can be updated/modified directly)., 4. CONVERT XLS TO CSV EXE.rar (additional files, not necessary for the corret working of the EVERGLASS DATABASE)
- Convert_XLS_TO_CSV.py (Python file to convert Excel files into comma separated value (CSV) file)
- Convert_XLS_TO_CSV.exe (executable file for Window to convert Excel files into comma separated value (CSV) file) (Don't separate the .exe file from the _internal folder. Use shortcut to send the .exe to another directory/folder).
- _internal (folder)
2. Relationship between files, if important:
- The Python script loads and displays data from CSV input files, optionally showing text from info files and a logo., European Union’s Horizon Europe research and innovation programme under grant agreement No 101129967.
HORIZON-EIC-2023-PATHFINDEROPEN-01-Proposal number 101129967, No
Proyecto:
EC / HE 101129967