53 prompts matching "cleaning"
I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...
Write a Python script that: 1) Reads a CSV file using pandas, 2) Shows basic inf...
Write Python code to clean and prepare a messy dataset for analysis. Handle: 1) ...
I want you to act as an Excel financial analyst. My goal: turn messy bank and e...
Act as a data analyst helping me prepare a messy CSV file for analysis. I will ...
Give me a complete Excel data cleaning checklist with formulas for each step: 1)...
Act as an Excel expert. I need a formula that flags duplicate customer rows wher...
Act as a finance analyst. I need to reconcile two Excel sheets, {{Sheet A: e.g.,...
Act as a sales operations analyst. I have a messy CRM export that I want to clea...
Act as a data scientist and R programming expert. Help me perform statistical an...
Help me design a production-grade ETL (Extract, Transform, Load) pipeline for a ...
Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...
I have a single column in Excel containing messy entries like "{{example raw ent...
Act as a senior data engineer who specializes in data quality and ETL pipelines....
Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...
Help me write effective unit tests for my React application using Jest and React...
Act as a data analyst. Write a complete Python pipeline to analyze survey data f...
Create a systematic data cleaning checklist and workflow for a messy dataset in ...
I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...
I need an Excel formula to detect duplicate records based on a combination of mu...
Act as a senior Python developer specializing in web scraping and data collectio...
You are a Power Query specialist. I have raw data that needs cleaning and transf...
I have raw data in Excel that needs cleaning and transformation. Help me build a...
Write a reusable Python pandas pipeline that cleans a CSV with columns [COLUMN_L...