Among all the cool things #ChatGPT can do, it is super capable of handling and manipulating data in bulk, making numerous data wrangling, scraping, and lookup tasks obsolete.
Let me show you a few cool tricks, no coding skills are required!
(A thread) 👇🧵
Let's start easy by heading to chat.openai.com/chat and pasting a list of 60 countries in the text field
Let's ask #ChatGPT to give us the main language, latitude, longitude, and country code for each of these countries
That was easy enough, right?
Now let's add more data to our output by asking #ChatGPT to provide the population of each of these countries
Uber cool! 😎
Let's ask ChatGPT to wrap these results in a table
Let's conclude this thread by asking #ChatGPT to create a @streamlit app with a CSV uploader and filter boxes to filter `longitude`, `latitude`, and `country code`.
Not only does #ChatGPT displays the code, but it also provides clear explanations for each step! 👏
This is just a quick overview of what you can do with #ChatGPT.
I'm only scratching the surface here.
For more cool things you can do with it, check out my other thread
1. Follow me @DataChaz to read more content like this. 2. Share it with an RT, so others can read it too! 🙌
Note that while #AI is capable of handling tasks such as sourcing and sorting, as well as some aspects of app development, it is not yet advanced enough to replace the need for human verification.
Even with its impressive capabilities, AI still requires human oversight.
• • •
Missing some Tweet in this thread? You can try to
force a refresh
@YCombinator’s guide to making the most of vibe coding:
Based on @benln’s excellent video here:
↳
PAGE 01
Planning process
— Create a comprehensive plan: Start by working with the AI to write a detailed implementation plan in a markdown file
— Review and refine: Delete unnecessary items, mark features as won’t do if too complex
— Maintain scope control: Keep a separate section for ideas for later to stay focused
— Implement incrementally: Work section by section rather than attempting to build everything at once
— Track progress: Have the AI mark sections as complete after successful implementation
— Commit regularly: Ensure each working section is committed to Git before moving to the next
Version control strategies
— Use Git religiously: Don’t rely solely on the AI tools’ revert functionality
— Start clean: Begin each new feature with a clean Git slate
— Reset when stuck: Use git reset –hard HEAD if the AI goes on a vision quest
— Avoid cumulative problems: Multiple failed attempts create layers and layers of bad code
— Clean implementation: When you finally find a solution, reset and implement it cleanly
Testing framework
— Prioritize high-level tests: Focus on end-to-end integration tests over unit tests
— Simulate user behavior: Test features by simulating someone clicking through the site/app
— Catch regressions: LLMs often make unnecessary changes to unrelated logic
— Test before proceeding: Ensure tests pass before moving to the next feature
— Use tests as guardrails: Some founders recommend starting with test cases to provide clear boundaries
Effective bug fixing
— Leverage error messages: Simply copy-pasting error messages is often enough for the AI
— Analyze before coding: Ask the AI to consider multiple possible causes
— Reset after failures: Start with a clean slate after each unsuccessful fix attempt
— Implement logging: Add strategic logging to better understand what’s happening
— Switch models: Try different AI models when one gets stuck
— Clean implementation: Once you identify the fix, reset and implement it on a clean codebase
You can extract content from any webpage, PDF, or image just by pasting a URL.
It pulls live data from up to 20 links per request! 🤯
No setup needed, just pass the links in your prompt.
4 killer use cases + code below 🧵↓
2/
Here are a few powerful use cases:
– Compare reports, PDFs, or articles
– Extract data (names, prices, highlights…)
– Analyze codebases, GitHub repos, or docs
– Summarize multiple sources in one go
3/
You only pay for the tokens used, there's no added cost.
This ChatGPT prompt is like hiring a $500/hr consultant
PROMPT:
You are Lyra, a master-level AI prompt optimization specialist. Your mission: transform any user input into precision-crafted prompts that unlock AI's full potential across all platforms.
## THE 4-D METHODOLOGY
### 1. DECONSTRUCT
- Extract core intent, key entities, and context
- Identify output requirements and constraints
- Map what's provided vs. what's missing
### 2. DIAGNOSE
- Audit for clarity gaps and ambiguity
- Check specificity and completeness
- Assess structure and complexity needs
**Key Improvements:**
• [Primary changes and benefits]
**Techniques Applied:** [Brief mention]
**Pro Tip:** [Usage guidance]
```
## WELCOME MESSAGE (REQUIRED)
When activated, display EXACTLY:
"Hello! I'm Lyra, your AI prompt optimizer. I transform vague requests into precise, effective prompts that deliver better results.
**What I need to know:**
- **Target AI:** ChatGPT, Claude, Gemini, or Other
- **Prompt Style:** DETAIL (I'll ask clarifying questions first) or BASIC (quick optimization)
**Examples:**
- "DETAIL using ChatGPT — Write me a marketing email"
- "BASIC using Claude — Help with my resume"
Just share your rough prompt and I'll handle the optimization!"