Ultrasound–Microwave Assisted Extraction and Insect Repellency Dataset of Calotropis procera Seeds

Description

This dataset contains experimental and analytical data supporting the optimization of metabolite extraction from Calotropis procera seeds using a sequential ultrasound–microwave (US–MO) assisted extraction process, its comparison with conventional Soxhlet extraction, and the evaluation of insect repellency activity against Sitophilus zeamais. The dataset integrates raw experimental measurements, processed design and response data, and statistical analysis outputs derived from Response Surface Methodology (RSM) based on a Box–Behnken experimental design. Extraction outcomes include yield and chemical composition, specifically total phenolics, flavonoids, sesquiterpene lactones, and terpenes. Bioassay data quantify insect distribution and repellency performance of the resulting extracts. The dataset is structured to support exploratory data analysis, process optimization, method comparison between US–MO and Soxhlet extraction, and assessment of relationships between chemical composition and bioactivity. All files are provided in interoperable CSV format, enabling direct reuse in statistical, chemometric, and bioactivity modeling studies focused on natural product extraction and botanical pest control.

Steps to reproduce

Steps to Reproduce Load the data Download the dataset and load the CSV files using any standard data analysis software (e.g., Excel, R, Python, or MATLAB). All files are provided in UTF‑8, comma‑delimited format and require no preprocessing. Inspect raw experimental data Begin with the raw data files in the data_raw/ directory. Use extractions_raw.csv to examine individual extraction replicates (yields and compound concentrations) and bioassays_raw.csv to inspect insect count data and initial repellency outcomes. Reconstruct the experimental design Use Cprocera_ExtractionDesign.csv to identify the Box–Behnken design structure and factor levels for ultrasound–microwave (US–MO) extraction experiments, including coded and real values of process variables. Link design factors to responses Combine Cprocera_ExtractionDesign.csv with Cprocera_ExtractionRuns.csv to associate experimental conditions with extraction yield and chemical composition responses. Reproduce statistical analyses Fit Response Surface Methodology (RSM) models using the processed extraction data and compare results with the coefficients and significance levels reported in RSM_models_ANOVA.csv. Evaluate optimal conditions Compare model-based predictions obtained from your analysis with the optimal extraction conditions provided in RSM_predictions_optimal.csv. Compare extraction methods Assess differences between ultrasound–microwave and conventional Soxhlet extraction by comparing Cprocera_ExtractionRuns.csv with summary statistics in Cprocera_SoxhletResults.csv. Analyze bioactivity and correlations Use Cprocera_BioassaysRepellency.csv and Cprocera_RepellencySummary.csv to evaluate insect repellency performance, and explore relationships between chemical composition and repellency using composition_repellency_correlation.csv.

Institutions

• University of Atlántico

  Atlántico, Barranquilla

Categories

Licence