Learning Timeline
Key Insights
Advantages of the Chain of Thought Technique
Asking the AI to 'take a deep breath' and 'think step by step' helps it process data rows one by one instead of trying to solve everything at once, which often causes the AI to get confused or overlook details.
Hallucination & Randomness Risks
AI has an inherent 'randomness' that is useful for creativity but can lead to 'hallucinations' (false information). Always perform a manual double-check before using the data for official business.
Additional Automation Steps
Don't panic if ChatGPT stops processing before all cells are filled. This is a common limitation; simply type 'continue' or 'fill in the remaining' to force it to complete the task.
Prompts
Chain of Thought Prompt for Data Recovery
Target:
ChatGPT
Here's a database of [insert content type here]. Some of them are missing a field. Please take a deep breath, think step by step and then fill in the missing fields for me.
Step by Step
How to Fill Missing Excel Data Using GPT-4o
- Prepare an Excel or CSV file that contains empty cells or incomplete data.
- Ensure your file name is descriptive (e.g., 'artist_database.xlsx') to help the AI understand the context faster.
- Open ChatGPT and make sure you are using the GPT-4o model.
- Click the 'Paperclip' icon or the 'Attach' button in the chat box to upload your file.
- Enter a prompt explaining the nature of the data and include 'Chain of Thought' instructions.
- Press Enter and let the AI run 'Data Analysis' (Code Interpreter) to identify patterns and fill in the blanks.
- Review the interactive table displayed by ChatGPT to check the initial results.
- If the AI missed any sections, type a follow-up command: 'Fill in the remaining fields'.
- Click the 'Download' button (usually a downward arrow icon) on the file updated by the AI.
- Open the downloaded file and perform a 'spot check' on at least 5 data points to ensure information accuracy.
