Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "duplicates"

38 prompts matching "duplicates"

"duplicates" ✕ Clear all ✕
excel Intermediate

Excel: Detect Duplicate Rows Across Multiple Key Columns

I have an Excel sheet where 'duplicates' aren't exact matches — they share a cus...

#duplicates #dedupe #power-query
👁 4 views
data Intermediate

Data Quality Audit Checklist for New Dataset

Run a data quality audit on the dataset described below. Check for: missing valu...

#data #quality #audit
👁 3 views
data Intermediate

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#data #cleaning #preprocessing
👁 3 views
data Intermediate

Sanity-check a dataset in 30 minutes before you build anything on top of it

I just got handed a dataset I'm going to use for [analysis / model / dashboard]....

#data #sanity-check #eda
👁 3 views
data Advanced

Write a SQL query that returns the right answer when the data has duplicates

I'm writing a SQL query against tables [paste schemas, especially the join keys]...

#sql #joins #duplicates
👁 3 views
data Intermediate

Sanity-check a dataset before you trust a single number from it

You're a careful data analyst. Before I build anything on this dataset, give me ...

#data-quality #validation #checklist
👁 3 views
excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#excel #data cleaning #deduplicate
👁 3 views
excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #data cleaning #power query
👁 2 views
excel Intermediate

Build an Excel formula that flags duplicates across multiple columns

In Excel I need to find rows that are duplicates based on a *combination* of col...

#excel #duplicates #countifs
👁 2 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
coding Intermediate

Write the test cases I'd forget for this function

I'll paste a function and describe what it's supposed to do. List the test cases...

#coding #testing #edge cases
👁 2 views
data Intermediate

Clean and Deduplicate a Raw Dataset

Act as a data engineer. I have a raw dataset with these issues: [DESCRIBE — dupl...

#data #cleaning #etl
👁 2 views
excel Intermediate

Clean Messy Spreadsheet Data Step by Step

You are a data-cleaning specialist. I have a messy Excel sheet with these proble...

#excel #power-query #data-cleaning
👁 1 views
data Intermediate

Write and Explain a SQL Query From Plain English

Act as a SQL expert. I will describe what I want in plain English and you will w...

#data #sql #databases
👁 1 views
data Intermediate

Write a Data Cleaning Checklist

You are a data-quality analyst. Based on the dataset I describe, produce a thoro...

#data #data-cleaning #quality
👁 0 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval