1
00:00:02,440 --> 00:00:02,920
Hi guys.

2
00:00:02,920 --> 00:00:03,840
Welcome to this session.

3
00:00:03,840 --> 00:00:09,440
So in this session we wanted to see how we can use ChatGPT for reorganizing any type of data.

4
00:00:09,680 --> 00:00:15,320
So you can use ChatGPT to organize data in a particular format which you want, which is easy for you

5
00:00:15,320 --> 00:00:17,960
to interpret and understand and then work on it.

6
00:00:17,960 --> 00:00:19,320
So let's have a look at this.

7
00:00:20,160 --> 00:00:27,800
So let's say I'm giving a prompt to ChatGPT where I'm saying list down the top 20.

8
00:00:31,280 --> 00:00:32,160
Events.

9
00:00:37,280 --> 00:00:39,880
Which changed the course of the world.

10
00:01:02,200 --> 00:01:06,360
So now it's giving us the list over here, 20 events specifically.

11
00:01:11,840 --> 00:01:13,770
Now once we have the data in place.

12
00:01:13,810 --> 00:01:17,290
What you can do is you can organize it in the way you want it to.

13
00:01:17,690 --> 00:01:18,130
Okay.

14
00:01:18,170 --> 00:01:23,690
So we can sort the data according to our own requirement, whichever format you want, which is easy

15
00:01:23,690 --> 00:01:24,850
for us to understand.

16
00:01:35,770 --> 00:01:41,690
Let's say I want to sort this whole data in the canonical order in the yearly fashion.

17
00:01:41,890 --> 00:01:42,130
Okay.

18
00:01:42,170 --> 00:01:49,010
So let's have a look at that, which it is already right now doing it for us in this particular manner.

19
00:01:49,010 --> 00:01:53,450
But let's say we want to sort the above data alphabetically.

20
00:02:06,210 --> 00:02:08,370
So now it is going to go ahead and do that for us.

21
00:02:10,290 --> 00:02:14,250
Let's say the next thing which we want to do is we want to see this data in a tabular format.

22
00:02:24,930 --> 00:02:28,970
So we are getting all the things in alphabetical order now, as you can see.

23
00:02:48,330 --> 00:02:50,530
And now let's say we want in a tabular format.

24
00:03:01,850 --> 00:03:07,650
Also, let's say once we get the tabular format, the table format for this particular data with us,

25
00:03:07,810 --> 00:03:09,890
then let's add another column to it.

26
00:03:26,010 --> 00:03:33,850
So now you can see it has gone ahead and created a table format of it as well in this particular manner.

27
00:03:38,090 --> 00:03:41,300
Now let's say we want to add the column over here stable.

28
00:03:41,580 --> 00:03:43,700
Let's add two columns let's say.

29
00:03:47,460 --> 00:03:48,260
Location.

30
00:03:48,540 --> 00:03:51,580
And here.

31
00:04:02,660 --> 00:04:10,100
So now what we would want is that this particular table should have three columns altogether event location

32
00:04:10,100 --> 00:04:10,860
and year.

33
00:04:11,100 --> 00:04:14,580
So that should come up out here clearly so that we can understand that better.

34
00:04:17,940 --> 00:04:24,180
So you can see there are different ways you can organize your information as per your requirement,

35
00:04:24,180 --> 00:04:26,460
and which is easy for you to interpret.

36
00:04:26,980 --> 00:04:28,900
Here we have all the information.

37
00:04:28,900 --> 00:04:30,180
So we have the event.

38
00:04:30,420 --> 00:04:32,140
We have the location as well.

39
00:04:32,420 --> 00:04:36,180
We also have the specifically the year showing up over here.

40
00:04:36,660 --> 00:04:39,220
So very clearly we can get the information out.

41
00:04:39,220 --> 00:04:41,340
And now you can download this data as well.

42
00:04:41,700 --> 00:04:42,060
Okay.

43
00:04:42,100 --> 00:04:43,420
All that will be possible.

44
00:04:43,820 --> 00:04:44,820
I hope this makes sense.

45
00:04:44,820 --> 00:04:51,020
You understand how we are able to use ChatGPT for reorganizing our data in a very easy manner.