diff options
Diffstat (limited to 'tutorials/module_4/spectroscopy problem')
| -rw-r--r-- | tutorials/module_4/spectroscopy problem/Calibrare Intensitate Oxigen.xlsx | bin | 64999 -> 0 bytes | |||
| -rw-r--r-- | tutorials/module_4/spectroscopy problem/Intensity_Calibration_Oxygen_Discharge_Solution.xlsx | bin | 402305 -> 0 bytes | |||
| -rw-r--r-- | tutorials/module_4/spectroscopy problem/Lampa_Calibrare_Mercur.xlsx | bin | 135793 -> 0 bytes | |||
| -rw-r--r-- | tutorials/module_4/spectroscopy problem/Spectru Descarcare Argon.xlsx | bin | 74877 -> 0 bytes | |||
| -rw-r--r-- | tutorials/module_4/spectroscopy problem/spectroscopy.py | 51 |
5 files changed, 0 insertions, 51 deletions
diff --git a/tutorials/module_4/spectroscopy problem/Calibrare Intensitate Oxigen.xlsx b/tutorials/module_4/spectroscopy problem/Calibrare Intensitate Oxigen.xlsx Binary files differdeleted file mode 100644 index f18e170..0000000 --- a/tutorials/module_4/spectroscopy problem/Calibrare Intensitate Oxigen.xlsx +++ /dev/null diff --git a/tutorials/module_4/spectroscopy problem/Intensity_Calibration_Oxygen_Discharge_Solution.xlsx b/tutorials/module_4/spectroscopy problem/Intensity_Calibration_Oxygen_Discharge_Solution.xlsx Binary files differdeleted file mode 100644 index cdeec66..0000000 --- a/tutorials/module_4/spectroscopy problem/Intensity_Calibration_Oxygen_Discharge_Solution.xlsx +++ /dev/null diff --git a/tutorials/module_4/spectroscopy problem/Lampa_Calibrare_Mercur.xlsx b/tutorials/module_4/spectroscopy problem/Lampa_Calibrare_Mercur.xlsx Binary files differdeleted file mode 100644 index b429c6d..0000000 --- a/tutorials/module_4/spectroscopy problem/Lampa_Calibrare_Mercur.xlsx +++ /dev/null diff --git a/tutorials/module_4/spectroscopy problem/Spectru Descarcare Argon.xlsx b/tutorials/module_4/spectroscopy problem/Spectru Descarcare Argon.xlsx Binary files differdeleted file mode 100644 index 7c98481..0000000 --- a/tutorials/module_4/spectroscopy problem/Spectru Descarcare Argon.xlsx +++ /dev/null diff --git a/tutorials/module_4/spectroscopy problem/spectroscopy.py b/tutorials/module_4/spectroscopy problem/spectroscopy.py deleted file mode 100644 index e195fbd..0000000 --- a/tutorials/module_4/spectroscopy problem/spectroscopy.py +++ /dev/null @@ -1,51 +0,0 @@ -#!/usr/bin/env python3 -# -*- coding: utf-8 -*- -""" -Created on Wed Nov 5 12:58:59 2025 - -@author: christian -""" - - -""" -Problem: - -- Import xls data into Python -- Plot the Intensity [a.u.] vs pixels -- Interpolate and convert x-axis from pixels to nm (true wavelength) using Hg lamp data (using data in file: **Lampa_Calibrare_Mercur.xlsx**) -- Find response function of the spectrometer using the tungsten lamp data from file: "**Calibrare Intensitate Oxigen.xlsx**)": $R=\frac{I_{measured}}{I_{true}}$ (where True is computed by Planck's law of radiation (see notes in the pptx above) -- Convert y-axis from Intensity [a.u.] into Intensity in [W/(cm^2*sr*nm)] by dividing the measured Oxygen spectrum with the response function: $I_{oxygen, true}=\frac{I_{oxygen, measured}}{R}$ -- Once the spectra is in real units: compute the density of one of the oxygen lines by integrating underneath one of the peaks (see equation from Slide 39 - bottom). We will give all of the constants that are in this equation (see the "I**ntensity_Calibration_Oxygen_Discharge_Solution.xlsx**") -""" - -import pandas as pd -import matplotlib.pyplot as plt - -Hg_data = 'Lampa_Calibrare_Mercur.xlsx' -#Ar_data = 'Spectru Descarcare Argon.xlsx' -Ox_data = 'Calibrare Intensitate Oxigen.xlsx' - -df_Hg = pd.read_excel(Hg_data, header=11, engine='openpyxl') -df_Ox = pd.read_excel(Ox_data, header=3, engine='openpyxl') -#df_Ar = pd.read_excel(Ar_data, header=14, engine='openpyxl') - - -# Trims mercury data to the first 2000 pixels -df_Hg = df_Hg[df_Hg['Pixels']<2000] - -"Plot Intensity vs Pixels for mercury" - -# Plot Hg intensity-pixel plot -plt.figure(figsize=(8,5)) -plt.plot(df_Hg['Pixels'], df_Hg['Intensity'], linestyle='-') -plt.xlabel('Pixels') -plt.ylabel('Intensity [a.u.]') -plt.title('Pixel-Intensity (Hg)') -plt.grid(True) -plt.show() - - - - - - |