WEBVTT 00:00.540 --> 00:09.480 Hello and welcome in this tutorial, you will learn how to export data from comScore so that you can 00:09.630 --> 00:12.870 use your plot in any other plodding software. 00:13.440 --> 00:20.790 So let's say you have a console file where you have done some simulation and there is some kind of plot 00:21.270 --> 00:28.950 and you want to export the data to either Microsoft Excel or, let's say notepad so that you can use 00:28.950 --> 00:36.480 the data to plot in some other software, let's say Matlab or Origin Jianyu plot or any other software 00:36.510 --> 00:37.770 you wish to. 00:37.810 --> 00:38.650 So how to do that? 00:39.090 --> 00:41.560 So let's jump back to our software. 00:41.940 --> 00:44.460 So we are here in console. 00:44.670 --> 00:49.670 Let's say you have done some kind of a simulation and you have a plot. 00:50.400 --> 00:57.600 So I purposely chose this plot where we have two graphs to show you different ways in which you can 00:57.600 --> 00:58.930 exploit your data. 00:59.460 --> 01:06.690 First of all, the easiest and most convenient way, which I like to use is just right. 01:06.690 --> 01:11.220 Click on the graph, not on the group, but on the graph. 01:11.370 --> 01:12.300 Just right click. 01:12.810 --> 01:16.800 Click on Copy Blood Data to Klippel. 01:17.700 --> 01:18.540 Just copy. 01:18.840 --> 01:25.530 And let's say you have Microsoft Excel or any other Excel tool just right. 01:25.530 --> 01:27.360 Click and paste. 01:28.080 --> 01:30.300 When you paste, you'll have a problem. 01:30.540 --> 01:35.730 The problem is you'll see that all the data will be in a single column to fix this. 01:36.150 --> 01:39.030 Go to data here. 01:39.030 --> 01:39.840 You will have data. 01:40.500 --> 01:47.880 Then with the columns selected, click on text to column and select delimited. 01:48.540 --> 01:53.520 Click next and check the space after this. 01:53.520 --> 02:00.600 Click next and finish you will see that your X and Y data will be separated. 02:01.140 --> 02:14.040 Now you can click and drag the for these roles which are not that useful or you can delete and now you 02:14.040 --> 02:15.920 have your X and Y. 02:16.200 --> 02:20.700 So this is basically your X and this is your Y. 02:21.000 --> 02:22.050 You can delete this. 02:22.050 --> 02:22.460 Right. 02:22.950 --> 02:25.860 So this is your X Y data to check. 02:26.130 --> 02:29.130 You can select the two data, go to insert. 02:30.310 --> 02:37.150 Here, plot, and you can see that this is the same data that we had in common. 02:37.190 --> 02:38.190 All right. 02:38.470 --> 02:48.010 So this is quite a good and quick way to export your data from Komsomol to excel. 02:48.880 --> 02:56.520 Now, let us learn how to export your data to a file which is generally used by everyone. 02:56.530 --> 02:59.290 So you have your plot here. 02:59.320 --> 03:03.480 Just click and click on add blah data to export. 03:04.030 --> 03:08.350 When you click on add plot data to export, you'll get few options. 03:09.250 --> 03:10.630 So what is this? 03:11.060 --> 03:12.780 Let's say you have multiple cards. 03:12.790 --> 03:14.830 So here I have two cards, right? 03:14.860 --> 03:16.120 One green and one blue. 03:17.110 --> 03:24.670 So what you can do is let's say I want to keep it as a column and then I want to have it as a text file. 03:24.700 --> 03:28.530 Well, you can have multiple files here. 03:28.540 --> 03:31.590 You have unstructured file format and something like that. 03:32.080 --> 03:40.690 So here, click, browse and let's write a demo and click on Save Now. 03:40.930 --> 03:46.150 And the file will not be saved until we click on export, so click on export. 03:46.420 --> 03:52.660 So now if I minimize my console, you'll see that I saved a file in my desktop that is demoed out. 03:53.770 --> 04:01.720 If I open the file, you'll see that since I selected if multiple card, apparently Scholem's, I'll 04:01.720 --> 04:05.710 have the data as two different Y values. 04:06.250 --> 04:12.430 So what is the advantage of this press control aid to select all the data and I will just copy. 04:13.480 --> 04:17.440 And now what I do is I will create a new sheet and I will paste it. 04:17.830 --> 04:21.880 OK, so Excel is smart enough so it will automatically. 04:22.990 --> 04:32.830 Divide the space into columns, I'll just delete this, and now you see, if I select this and click 04:32.950 --> 04:37.520 on plot, I have one plot. 04:38.200 --> 04:45.480 Now if I select these two and then if I click on plot, I have another plot. 04:46.870 --> 04:54.130 And if I select the three columns and I have a plot, you will see that. 04:55.320 --> 05:01.950 I have to plants, but with two different columns, so if I select this graph, you can see that the 05:01.950 --> 05:03.750 first and the third column is selected. 05:03.750 --> 05:06.780 If I select this, these two columns are selected. 05:07.170 --> 05:10.920 So basically, let's say you have multiple graphs, income. 05:10.930 --> 05:20.490 So what you can do is you can instead of, um, having this right copy to click, but the best way would 05:20.490 --> 05:23.070 be you go to plaudit or to export. 05:23.550 --> 05:34.670 And in that section here, if multiple car Savitar's columns and save your file as text and then you 05:34.680 --> 05:42.600 will have your column, four separate graphs, and depending on the type of study you are doing, you 05:42.600 --> 05:45.510 can, uh, carry on with your analysis. 05:45.950 --> 05:48.270 So thanks for watching. 05:48.690 --> 05:54.780 If you are enjoying my course and you are learning something new, I would really love if you read my 05:54.780 --> 05:57.060 course, preferably five star. 05:57.210 --> 06:04.500 It will really help me to get motivated and create more courses also to provide feedback so that I can 06:04.500 --> 06:05.820 improve my course. 06:06.030 --> 06:06.570 Thank you.