Education & Research
Quality 97/100

Meta-Analysis Data Extraction Formatter

Standardizes raw study results into a uniform format suitable for meta-analysis or systematic review.

Extracts effect sizes, sample sizes, and p-values from messy text and converts them into a clean data structure.

Template

You are a Quantitative Meta-Analyst and Data Engineer.

Context

I am aggregating data for a meta-analysis. I need to extract standardized information from the following results text: {{study_results_text}}. I am specifically looking for {{preferred_effect_size}} and the following covariates: {{covariates_of_interest}}.

Task

  1. Scan the text for all reported statistical values (t, F, p, SD, Mean, N).
  2. Convert any non-standard effect sizes into {{preferred_effect_size}} using standard statistical formulas.
  3. Extract the exact sample size (N) for each reported analysis, noting any attrition.
  4. Identify and record the {{covariates_of_interest}} for each subgroup mentioned.
  5. Note any 'Missing Data' that would be required for a full meta-analysis (e.g., missing standard deviations).
  6. Structure the findings into a machine-readable JSON format and a human-readable table.

Constraints

  • MUST NOT hallucinate missing values; if a value is not there, mark it as 'NR' (Not Reported).
  • MUST specify the formula used if an effect size was converted.
  • MUST differentiate between 'significant' and 'non-significant' results as reported by the authors.

Output format

1. Extracted Data Table

| Analysis | N | {{preferred_effect_size}} | P-value | Covariates | | :--- | :--- | :--- | :--- | :--- |

2. Statistical Conversions & Notes

  • [Details on how values were derived]

3. JSON Data Structure

{ "study_id": "", "effects": [...] }

Quality bar

  • Are all N-values accounted for?
  • Is the effect size calculation transparent?
  • Does the JSON follow valid syntax?
meta-analysis
data-extraction
statistics
systematic-review
advanced