StatisticsBeginner
Data Cleaning and Statistical Analysis
A workflow from raw tables through cleaning, descriptive statistics, significance testing and figure export, ready for a paper's results.
OpenRefineJamovi
1–3 hours 6 stepsView workflow
Free, open-source data cleaning tool for tidying messy tables and standardising text in bulk.
OpenRefine is a powerful free, open-source data cleaning tool for handling messy tables, duplicate names, inconsistently formatted fields, bulk text transformations and data completion. It is better suited than Excel to building reproducible data cleaning workflows, and can connect to external data services to enrich data.
Use cases: table cleaning, species name standardisation, place name tidying, literature data organisation, bulk text processing