Dataset

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

data3 = pd.read_excel('data/Data_Altar_120326_corrected.xlsx')
data2 = pd.read_excel('data/Data_Altar_21112025_corrected.xlsx')
data1 = pd.read_excel('data/Data_Altar_140225_corrected.xlsx')

data = pd.concat([data1, data2, data3])

SCOL_data = data[data['SampleType'] == "San Carlos Olivine (olivine): 0820M"]
SCOL_data.to_excel('./data/SCOL_data.xlsx', index=False)

data = data[data['SampleType'] != "San Carlos Olivine (olivine): 0820M"]
data = data.reset_index(drop=True)
data

Develidag = data.drop([11, 12, 14])
Develidag = Develidag.reset_index(drop=True)
Develidag

Develidag.to_excel('data/Develidag.xlsx', index=False)

Develidag_bulk = Develidag[Develidag['SampleType'] == "Mafic volcanics "]
Develidag_bulk