The following formula for calculating the average reflectance within a wavelength range appears in many literatures.
But R(n) and E(λ) are curves obtained through testing, and there is no clear equation (if there is one, please tell me and explain the source, thank you very much).
I want to know how to calculate the integral equation in the numerator. The separate integral results of E and R can be easily obtained using origin.
import numpy as np import pandas as pd from scipy.integrate import trapz
wavelengths = np.arange(300, 2502, 2) df = pd.read_excel('filtered_data.xlsx', engine='openpyxl') reflectance = df['A'].values irradiance = df['B'].values print(wavelengths[:40]) print(reflectance[:40]) print(irradiance[:40]) product_integral = trapz(reflectance * irradiance, wavelengths) irradiance_integral = trapz(irradiance, wavelengths) weighted_reflectance = product_integral / irradiance_integral print(":", weighted_reflectance)
You should import all the python libraries: that are
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
then you canread the csv file using the commanfd
df = pd.read_csv("file_name")
df.head(
Ewnetu Abebe Kassie You are right, thanks for the addition. I included references to these libraries in the uploaded code, but I copied it directly from pycharm and the formatting looked messy.