-: Hey, welcome, and in this video,
we're gonna explore how we can use ChatGPT
to generate things other than just images and text.
So how can ChatGPT transform your data?
Well, ChatGPT is capable of not only just generating text,
but also other file formats.
These could include, for example, CSV files, text files,
markdown files, or even .PPT files,
which are Microsoft PowerPoint files.
Why is this important?
If you're spending less time
converting the same information into a different format,
that can be a great time saver at your work.
Also, you can take unstructured texts
and convert that into a structured output for data analysis
or for another downstream task.
Okay, so what are the two main ways that you use this?
One is to take some texts
and convert that into a structured output file.
Another way is to convert files
back into text or put a link in the video
so you can download this social_media_posts.TXT file
and then we're gonna analyze this.
So if I go and open this, this is a text file
and it has a bunch of different social media posts
that we want to extract some structured data from,
and we're gonna get it to generate a CSV file.
So take all of that information, copy these to to ChatGPT,
I want you to post these in,
and then I want you to say,
I want you to generate some structured data
in the form of a CSV.
For each social media post,
we would like to extract
topic, length, engagement rating from one to 10,
10 being the most engaging and hashtags.
And so what we have here is we have our data,
which is in raw text,
and we've told ChatGPT exactly how we want
to structure this data.
We want to export a CSV file.
And for each of these, what we want to extract is the topic,
the length, the engagement rating
so we're gonna leave it up to ChatGPT to decide
what the engagement rating is and the hashtags.
Cool, so I'm gonna leave this to run now.
ChatGPT has decided to use Pandas
and it's decided to use the code execution.
It's creating this data so you can see
that if you click on the analyzing,
it's filling all this information in.
And then we'll just give it a second to see what happens.
So it's figured out what the topics are,
the engagement ratings,
and then it's also then creating this data.
And there we go, we have our interactive table
that's been produced here with the topic,
the length of the engagement rating and the hashtags.
And we can download that if we click on the download
and you can see this is the social post analysis.
So we can click on that, download it,
and if we have a look at the CSV,
you'll see that we've now got the data in a CSV file format.
So that is a great way for us
to be able to easily get access
to structured data directly using ChatGPT,
and its code execution functionality.
The next thing I want to show you is let's go back
and use the students.CSE file
that we had in a previous lecture.
I'm gonna go and click on a new chat,
and then I'm gonna add the plus from the students.csv.
And then we're gonna say, can you generate a summary
for this CSV file?
And what we're doing here is taking structured data
and we're then getting ChatGPT
to create a summary for this.
And here you go, so it's done some code execution
on the data
and then it's identified some of the key columns,
the highlights, and so we can actually take structured data,
like a CSV file
and get directly some text
that represents what's in that data.
So the final thing I wanna show you is you can make this
into a PowerPoint presentation
as well using chat's code execution.
So we can say, can you take these insights
and make this into a Microsoft PowerPoint presentation
so that I can easily show this with my boss?
So now what we're gonna do is tell ChatGPT,
now that it's got that data,
it's now gonna use a different package called PPTX,
which allows it to create slides.
So you can see it's adding a title slide here,
some general information.
It's adding some key columns here,
so it's actually adding some information
and creating a Microsoft PowerPoint out the back of this.
So we'll just wait for this to finish
and then I'll show you the end result.
Cool, so now that it's finished,
we're gonna go and download this file
and I'm gonna go and have a look at that.
And here is the PowerPoint presentation.
So you can see we've got like a title slide
and we've got a general info.
We have some key columns that it's identified,
the highlights and the academic performance.
Now I know what you're thinking, this isn't styled well,
but we can keep going with ChatGPT,
telling it to add styling,
telling it to add different formatting,
and we can get PowerPoint presentations made
off of real data that we can easily transform from a CSV
or some text into a PowerPoint presentation.
So hopefully this helps you to go beyond just using ChatGPT
to generate a text, thinking about lots
of different output formats
that you can use when you are at work or at home.
Cool, I'll see you in the next one.