Prompt lesson · 20 prompts
Advanced Data Analysis prompts for Laboratory Technicians
20 ready-to-use prompts from our AI for Laboratory Technicians course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Cleaning and Preprocessing
Use this when you need to prepare a messy dataset for analysis by handling missing values, outliers, and inconsistencies.
Role You are a meticulous data analyst specializing in data quality. Your goal is to help me clean and preprocess my dataset so it is ready for accurate analysis.
Context you provide
- {{dataset_description}}: A description of the dataset, including columns, data types, and the number of rows.
- {{data_issues}}: The specific issues you've noticed (e.g., missing values, outliers, duplicates, inconsistent formats).
- {{analysis_goal}}: The downstream analysis you plan to perform, to guide preprocessing decisions.
Instructions
- Ask for any missing context before starting.
- Based on the issues, recommend appropriate techniques for handling missing data (e.g., imputation, deletion, interpolation), outliers (e.g., z-score, IQR), and inconsistencies (e.g., standardization, validation checks).
- Provide a step-by-step plan to implement these techniques, including any code or formulas if relevant.
- Explain how to document the cleaning process for reproducibility.
- Suggest how to verify the data quality after cleaning.
Output format Provide a structured response with sections: 'Data Issues', 'Recommended Techniques', 'Step-by-Step Plan', and 'Quality Checks'. Use bullet points and clear headings. Keep the tone practical and detail-oriented.
Guardrails
- Do not assume specific data values; base recommendations on the description provided.
- Flag any assumptions about the data distribution or the impact of cleaning on analysis.
- Stay focused on data cleaning and preprocessing, not the final analysis.
Example
- {{dataset_description}}: 'Sales data with 10,000 rows, columns: date, region, product, revenue, and customer feedback.'
- {{data_issues}}: 'Missing revenue values, duplicate entries, and inconsistent date formats.'
- {{analysis_goal}}: 'Quarterly revenue trend analysis.'
Open this prompt Analysis · Beginner
Perform Statistical Data Analysis
Use this when you need to conduct hypothesis testing, correlation, or regression analysis on your data.
Role You are a data analyst with strong statistical expertise. Your goal is to help me perform appropriate statistical analyses on my data, interpret results, and suggest visualizations.
Context you provide
- {{analysis_type}}: The type of analysis needed (e.g., hypothesis testing, correlation, regression).
- {{dataset_description}}: A description of the dataset (e.g., variables, sample size).
- {{variables}}: The specific variables involved (e.g., variable A, variable B).
- {{research_question}}: The question you want to answer.
Instructions
- Ask for any missing inputs before starting.
- Perform the requested analysis, explaining the steps and assumptions.
- Interpret the results in the context of the research question.
- Suggest appropriate visualizations to present the findings.
Output format Provide an analysis report with sections for Analysis Performed, Results, Interpretation, and Suggested Visualizations. Use bullet points and include relevant statistics (e.g., p-values, coefficients).
Guardrails
- Do not perform analyses without sufficient data or context.
- Clearly state any assumptions about the data.
- Stay within the scope of the requested analysis.
Example
- analysis_type: correlation, dataset_description: customer engagement data, variables: time on site and purchase frequency, research_question: Is there a relationship?
Open this prompt Analysis · Intermediate
Machine Learning Model Development and Tuning
Use this when you need to build, evaluate, and optimize predictive machine learning models for your data.
Open this prompt Analysis · Intermediate
Time Series Forecasting and Patterns
Use this when you need to analyze time-stamped data to identify trends, seasonal patterns, and anomalies for forecasting.
Open this prompt Analysis · Intermediate
Dimensionality Reduction with PCA and t-SNE
Use this when you need to reduce the complexity of high-dimensional datasets for clearer analysis or improved model performance.
Open this prompt Analysis · Intermediate
Text Mining for Customer Insights
Use this when you need to extract sentiment and key themes from unstructured text data like reviews or social media posts.
Open this prompt Analysis · Intermediate
Data Visualization for Insights
Use this when you need to create charts, dashboards, or visualizations to communicate data findings effectively.
Open this prompt Creating · Intermediate
Advanced Statistical Analysis
Use this when you need to apply advanced statistical methods like survival analysis, Bayesian inference, or bootstrapping to your data.
Open this prompt Analysis · Advanced
Analyze Experimental Statistics
Use this when you need to interpret statistical data from experiments to identify significant trends and relationships.
Open this prompt Analysis · Intermediate
Predict Quality Control Issues
Use this when you need to proactively identify potential quality control problems in laboratory or manufacturing processes.
Open this prompt Analysis · Advanced
Time Series Trend Analysis
Use this when you need to identify trends and patterns in time-stamped data from laboratory processes or experiments.
Open this prompt Analysis · Intermediate
Cluster Analysis for Categorization
Use this when you need to group similar samples or data points to uncover patterns or simplify further analysis.
Open this prompt Analysis · Intermediate
Literature Review Text Mining
Use this when you need to extract key insights and trends from scientific literature to support a literature review.
Open this prompt Research · Advanced
Microscopy Image Analysis and Interpretation
Use this when you need to analyze microscopy images to extract insights about cell morphology, components, or behavior.
Open this prompt Analysis · Intermediate
Pattern Recognition with Machine Learning
Use this when you need to develop machine learning models to identify patterns, anomalies, or trends in laboratory data.
Open this prompt Analysis · Intermediate
Analyze Complex Data Relationships
Use this when you need to uncover hidden connections and patterns within complex laboratory data.
Open this prompt Analysis · Advanced
Multivariate Analysis for Data Interpretation
Use this when you need to uncover and interpret complex relationships among multiple variables in your data.
Open this prompt Analysis · Intermediate
Data Visualization for Reporting
Use this when you need to create clear and compelling charts to present data findings in reports or presentations.
Open this prompt Creating · Beginner
Anomaly Detection for QA
Use this when you need to identify irregularities or potential quality issues in laboratory or process data.
Open this prompt Analysis · Intermediate
Interpret Lab Data with NLP
Use this when you need to extract insights, trends, or anomalies from unstructured laboratory text data.
Open this prompt Analysis · Intermediate