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 Image
Let's ask #ChatGPT to give us the main language, latitude, longitude, and country code for each of these countries Image
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 Image
Uber cool! 😎

Let's ask ChatGPT to wrap these results in a table Image
Magic! ✨

Now we'll add an index to that table Image
Boom! 💥

No #Python, PowerBI or code was needed!

Now let's try something a bit harder by asking #ChatGPT to add crime rates and COVID death tolls for the year 2020 Image
No sweat!

... and it's not even limited to tabular data!

Let's ask #ChatGPT to convert our table to a JSON file Image
Pretty impressive, right?

Now say you want to store that data in a database (e.g. the excellent @detahq), but you're not sure how to do it.

You bet! We can ask #ChatGPT how to do that Image
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! 👏 Image
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

.
If you found this helpful, two requests:

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
 

Keep Current with DataChazGPT (not a bot) 🤯

DataChazGPT (not a bot) 🤯 Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @DataChaz

Dec 5
#ChatGPT launched on Wednesday and already reached 1 million users.

It took only 5 days.

Try out 15 cool things you can do with @OpenAI’s new groundbreaking Chatbot! 🧵 👇
Explaining and fixing bugs in your code
Help you detect security vulnerabilities in your code
Read 20 tweets
Dec 30, 2021
2021's been an eventful year!

- Spoke at @brighonSEO & #TechSEOBoost
- Created seopythonistas.com in @hamletbatista's honour
- Got my 1st #Python contract, then an ace DevRel job at @streamlit 🎈
- Published 7 apps used by SEOs & Data scientists

Apps recap is here! ↓🧵 Image
1. Keyword Clustering app

My 1st collab with the great @LeeFootSEO!

Cluster your keywords & calculate:

✓ Traffic/volume per cluster
✓ CPC/KW difficulty
✓ Much more!

🎈 App → share.streamlit.io/charlywargnier…
📰 Post → charlywargnier.com/post/introduci…
⚡ Powered by Polyfuzz Image
2. What The FAQ

Leverage the power of Google T5 & @huggingface Transformers to generate FAQs directly from URLs! 🤗

🎈 App → share.streamlit.io/charlywargnier…
📰 Post → charlywargnier.com/post/wtfaq-an-…
⚡Powered by NLTK & @Google T5 via @huggingface Image
Read 16 tweets
Jul 26, 2021
🥁 New @streamlit app! 🎈

WTFaq leverages the power of @huggingface Transformers & @Google T5 to generate quality question & answer pairs from URLs!

Select your best Q&As on the fly & export them to CSV!

🎲App bit.ly/3zzS4us
📬Post bit.ly/3kUz59O

#SEO

↓🧵 Image
First things first, pick a URL!

The app will crawl the URL's content & retrieve it back in the app.

Server side only for now. I'm planning to add the ability to crawl client-side rendered URLs soon, stay tuned! 🤗

2/10 Image
Once a URL is crawled, you can check its scraped content in the toggleable section (see below👇)

As we're still in beta and want to monitor memory spikes closely, built Q&A pairs are based on the first thousand scraped characters only.

We will increase that limit soon!😉

3/10 Image
Read 10 tweets
Apr 14, 2021
Alrighty then! Here's StreamProphet in über early Beta! 🤗

- Connect to GSC
- Visualise forecasted #SEO traffic + time series' trends & seasonality
- Export predictions to CSV + models to JSON! 🔥

🎲 App: bit.ly/3a6oliw
📬Post: bit.ly/3sfSoKT

@streamlit

🧵↓
🚀 How to get started!

- Click the 'sign-in w/ Google' button to reach the consent screen
- Copy the Oauth token & paste it back in the app
- Type the web property you want to review
- Define your forecast horizon
- Press the 'Fetch GSC data & get predictions' button! 🔥

2/8
📈 Checking predictions

- You can visualise past data & predictions in the right-hand side chart
- Left charts show the decomposed trend, weekly & yearly seasonality (when avail.) of the time series
- You can export predictions via CSV + your forecast model via JSON 🤗

3/8
Read 9 tweets
Feb 19, 2021
Introducing Wiki Topic Grapher! 👾🐍🔥

Leverage the power of Google #NLP to retrieve entity relationships from Wikipedia URLs or topics!

+ Get interactive graphs of connected entities
+ Export results w/ ent. types+salience to CSV!

▶️share.streamlit.io/charlywargnier…

h/t @Streamlit 🧵
Many cool #SEO use cases! 🔥

+ Research any topic then get entity associations that exist from that seed topic
+ Map out related entities with your product, service or brand
+ Find how well you've covered a specific topic on your website
+ Differentiate your pages!

2/8
About the stack, it's 100% #Python! 🐍🔥

+ @GCPcloud Natural Language API
+ PyWikibot
+ Networkx
+ PyVis
+ @Streamlit
+ Streamlit Components -> streamlit.io/components

3/8
Read 9 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(