data pre-processing

data pre-processing

Prompting Warming Stripes: A No-Code Way to Visualise Meteorological Data

Creating visualisations from raw meteorological data no longer requires programming skills. In this post, we demonstrate how researchers can generate a warming stripes diagram – a simple yet powerful visualisation of long-term temperature trends – using only a natural language prompt. We recommend using GPT-4o or GPT-4.5 for this task, as

No-Code Data Pre-processing and Descriptive Analysis with GenAI: Exploring the Nobel Prize Dataset

In this case study, we demonstrate how generative AI can be used to carry out a full data pre-processing and descriptive analysis workflow on the Nobel Prize dataset. Our objective was to prepare and explore the data in a methodologically sound manner—converting numerical types, handling missing values, verifying completeness,

Prompt-based JSON to .xlsx Conversion: Turning Interview Metadata into a Structured Excel File

Interview metadata often arrives in semi-structured formats, making it difficult to analyse or integrate into standard research workflows. This short prompt-based approach shows how GenAI can transform a JSON file containing interview-related metadata into a clean, structured Excel (.xlsx) file—in seconds, without requiring any programming knowledge. The method enables

Data Pre-processing with GenAI: Standardising Geographic Location Data in an Input CSV

Data pre-processing is a crucial but often tedious stage in research, particularly when standardising complex CSV datasets. This blog demonstrates how GenAI can systematically structure geographic location data directly from an input CSV file without coding. Our primary objective was to ensure consistent and accurate categorisation, preparing the data for

Analysing US State Temperature Trends Using GenAI: A No-Code Approach for Researchers

Time series analysis is a powerful tool for researchers across disciplines, yet its reliance on programming can pose a challenge for those without coding expertise. This blog demonstrates how AI-driven prompts can enable researchers to perform simple time series analyses without writing a single line of code, making data insights