← 템플릿 전체AI Basics · Spreadsheets
Data Cleaning Checklist
1. 내용 입력하기
아래 값은 예시입니다. 내 내용으로 바꾸세요. 저장되거나 전송되지 않습니다.
2. 전체 프롬프트 복사
Complete the task using these inputs. Fields: [Fields]; Problem: [Problem]. First propose a read-only inspection plan covering how duplicates are defined, missing values, date formats, and numeric anomalies. Design cleaning steps that preserve the raw data along with a change log; don't treat identical names as the same person, and output metrics to compare before and after. Structure the output as: understanding and assumptions, ready-to-use content, information I need to confirm, and next steps. Use clear, short sentences and avoid empty slogans; if key input is missing, ask at most three specific questions instead of filling gaps with guesses. Finally, check each item against my purpose and state clearly which results still need human review.
Complete the task using these inputs. Fields: [Fields]; Problem: [Problem]. First propose a read-only inspection plan covering how duplicates are defined, missing values, date formats, and numeric anomalies. Design cleaning steps that preserve the raw data along with a change log; don't treat identical names as the same person, and output metrics to compare before and after. Structure the output as: understanding and assumptions, ready-to-use content, information I need to confirm, and next steps. Use clear, short sentences and avoid empty slogans; if key input is missing, ask at most three specific questions instead of filling gaps with guesses. Finally, check each item against my purpose and state clearly which results still need human review.
3. 결과 확인하기
Are the deduplication rules clear? Can the raw data be restored? Verify names, numbers, and qualifiers from the input.
마음에 들지 않으면 변수를 하나씩 바꿔 이전 결과와 비교해 보세요.