Molecular Diagnostics AI Academy

FREE INTRODUCTORY SHORT COURSE

Analyse Scientific Data with AI: Excel & Python

Clean a small dataset, check calculations and produce a reproducible chart.

For scientists, laboratory professionals, researchers and undergraduate/postgraduate students.

Format
1 practical module
Study time
About 60 minutes
Assessment
10 questions · 80% pass
Learning
Free

Start the course

What you will learn

  1. Identify the observational unit
  2. Check data types
  3. Handle missing values
  4. Check units
  5. Audit duplicates
  6. Verify summaries
  7. Choose a useful chart
  8. Separate training and testing
  9. Review generated code
  10. Make analysis reproducible

Your practical project

Create a synthetic table with donor_id values 001, 002 and 003 and concentrations 2, 4 and 6 mg/L. Add a fourth row with a missing concentration and a repeat visit for donor 001. Preserve IDs as text, distinguish missing from zero, and define the visit-level record key. Verify that the original three concentrations have a mean of 4 mg/L. Plot the original measurements and label the axes. Record every cleaning decision.

Use an AI tool you already have access to, or complete the manual comparison alternative. No paid AI subscription is required for the lessons or assessment.

This is an introductory short course. Course-specific CPD accreditation has not been confirmed.

Further reading: pandas getting started

Loading your course…