WEBVTT

00:01.180 --> 00:06.100
In the last video we handled missing values and the Titanic data frame and we created kind of a clean

00:06.100 --> 00:07.140
data frame.

00:07.360 --> 00:13.840
And now it might be the case that we want to terminate our stupid obsession and save our progress locally

00:13.840 --> 00:21.340
on our computer and one way to do this is by exporting and saving the clean data frame in a new CSP

00:21.340 --> 00:22.300
file.

00:22.300 --> 00:24.100
So we have still import it here.

00:24.100 --> 00:31.150
The clean Titanic data frame and we can also look at the first five rows and then we can actually export

00:31.180 --> 00:36.310
and save our data frame and you see as we file and we can do this.

00:36.320 --> 00:38.670
So the method to CSP.

00:39.220 --> 00:42.470
And here we have to pass our new desire the file name.

00:42.580 --> 00:45.950
So here for example clean data frame dot CSP.

00:46.300 --> 00:52.190
And let's run the site here and actually pan this creates a UCSB file in the folder.

00:52.240 --> 01:00.400
Also the Jupiter notebook here is located and we can also re import our clean data frame CSP with the

01:00.430 --> 01:09.880
read CSP method and we can see that we have an additional column which was actually the form our range

01:09.940 --> 01:11.140
index.

01:11.140 --> 01:14.280
And whenever we say for x part a data frame.

01:14.290 --> 01:15.750
But they range index.

01:15.850 --> 01:19.000
Then we also say if they range index in the CSP file.

01:19.630 --> 01:27.390
And when we re import the data from the CSP file then penned us by default creates another Range Index.

01:27.460 --> 01:35.110
If we do not determine a index column and therefore whenever we want to export a data frame with a range

01:35.140 --> 01:41.370
index it might be the best option to pass falls to the index per.

01:41.380 --> 01:43.840
So here we have an index parameter.

01:44.440 --> 01:53.010
And here we have to pass false and when we pass false panels that drops the the index and does not export

01:53.170 --> 01:54.370
the index.

01:54.370 --> 01:58.180
So let's run the sale and we actually overwrite the CSP file.

01:59.050 --> 02:06.630
And again we can re import the CSP file and we can see that now we do not have this additional column.

02:06.760 --> 02:09.290
We just have here the arranged index.

02:09.450 --> 02:13.510
And with this we are finished here and hope to see also in the next video by.