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
What you will learn
- Identify the observational unit
- Check data types
- Handle missing values
- Check units
- Audit duplicates
- Verify summaries
- Choose a useful chart
- Separate training and testing
- Review generated code
- 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 startedLoading your course…
