WEBVTT 00:02.020 --> 00:05.010 Hello and welcome to this patented ordeal here. 00:05.200 --> 00:08.900 We will understand reading and writing files in Pandavas. 00:09.190 --> 00:10.090 Let us begin. 00:10.540 --> 00:16.770 First, we will understand reading and writing see as we Fyans import the library. 00:20.280 --> 00:24.090 Import ban does as Beadie. 00:27.090 --> 00:27.800 No tape. 00:27.910 --> 00:28.360 Come on. 00:28.390 --> 00:29.430 BWB. 00:32.720 --> 00:33.410 Great. 00:33.830 --> 00:36.000 So this is the current working directly. 00:36.740 --> 00:37.400 This one? 00:39.020 --> 00:44.090 No, applaud a fire based Darsey ASV. 00:47.300 --> 00:50.210 This one file is uploaded successfully. 00:51.250 --> 00:54.520 No, we have to read this fine IPD. 00:54.880 --> 00:57.940 DOD really underscores CSB 01:00.630 --> 01:00.960 here. 01:00.980 --> 01:06.260 We have to specify the part, copy part and based. 01:08.210 --> 01:08.780 Great. 01:09.110 --> 01:11.030 So this is the content in this file. 01:11.450 --> 01:14.240 There are four rules and four columns. 01:15.350 --> 01:17.420 We can store this in a variable. 01:17.480 --> 01:21.980 Also copy paste. 01:24.110 --> 01:28.430 No GCT variable B same result. 01:30.350 --> 01:33.580 So this is how we can read as Yasui file empanadas. 01:34.040 --> 01:38.090 Using this method really underscores the Yasui method. 01:39.440 --> 01:42.330 Now we will understand how to write in a C. 01:42.330 --> 01:45.950 S wi fi to write in a TSB file first. 01:45.980 --> 01:47.900 V how to create a data frame. 01:48.050 --> 01:50.240 And then we will save this data frame in C. 01:50.240 --> 01:53.180 S wi fi to create a data frame. 01:53.430 --> 01:54.740 Define a dictionary. 01:54.890 --> 01:59.300 The first key as name. 02:03.570 --> 02:18.530 Sara, Tom, Mark and Vinnie add second key score. 02:21.830 --> 02:26.670 75 to 80, 85 to 90. 02:27.660 --> 02:30.780 Add one more key number. 02:32.220 --> 02:34.450 Twenty to twenty for you. 02:34.760 --> 02:37.640 Twenty seven and thirty executed. 02:39.540 --> 02:43.170 No joke dictionary, be great. 02:43.440 --> 02:45.540 There are three key value pairs. 02:46.890 --> 02:48.370 No, create a data frame. 02:48.380 --> 02:48.620 B. 02:48.720 --> 02:58.740 F bd dot data frame enter parameter data is equal to dictionary B. 03:01.870 --> 03:02.890 Take the F 03:05.670 --> 03:06.270 grade. 03:06.520 --> 03:07.930 So this is data from D. 03:08.020 --> 03:08.410 F. 03:08.890 --> 03:11.710 They're out of food rules and three columns. 03:13.720 --> 03:15.850 Nobody will say this data frame in us. 03:15.960 --> 03:16.170 Yes. 03:16.350 --> 03:22.480 If I do do that, a b f dort do see the. 03:25.750 --> 03:29.430 Here we have to enter a name of defining taste. 03:30.200 --> 03:37.840 Do not see us as we execute refresh. 03:38.560 --> 03:40.380 You can see taste to see us. 03:40.450 --> 03:41.350 We created. 03:44.220 --> 03:45.700 Let us read the data in this. 03:47.100 --> 03:47.860 IBD. 03:48.050 --> 03:51.360 Dodd added, underscore CSB. 03:56.090 --> 03:59.240 Copy part and paste. 04:01.240 --> 04:01.690 Great. 04:02.390 --> 04:04.180 So this is the data in this file. 04:04.610 --> 04:06.860 These three columns and food rules. 04:07.430 --> 04:08.650 No, no, down here. 04:08.840 --> 04:10.910 One unwanted column is added. 04:11.060 --> 04:12.980 This one, unnamed zero. 04:13.460 --> 04:15.620 This is the index added by default. 04:15.980 --> 04:17.300 We can disable this. 04:18.200 --> 04:21.740 Add one more parameter index. 04:21.800 --> 04:24.510 Underscore call is equal to zero. 04:26.330 --> 04:27.730 And this is a very old. 04:28.400 --> 04:31.250 Now there are three columns and four rules. 04:32.120 --> 04:34.000 Same as in this data frame. 04:34.250 --> 04:34.510 B. 04:34.610 --> 04:35.000 F. 04:36.080 --> 04:39.370 So this way we can write data into a C as we find. 04:40.010 --> 04:40.790 To do that. 04:40.940 --> 04:43.220 First we have to define a data frame. 04:44.210 --> 04:49.340 And after that, we have to use this method to underscore C as V. 04:50.900 --> 04:54.350 So this is all about deleting and writing CSB files. 04:57.590 --> 05:00.470 Let us understand, reading and writing, Excel finds. 05:16.460 --> 05:17.660 Upload, Excel file. 05:18.500 --> 05:25.110 Click on Fynes upload, upload this fine paste dot Excel OSX. 05:27.960 --> 05:28.440 Great. 05:28.710 --> 05:31.240 This one is Dot XLE six. 05:31.960 --> 05:35.350 Let us read this fine ipb dot. 05:37.320 --> 05:39.050 Read, Underscore Excel. 05:43.040 --> 05:48.750 Copy part and paste grade here. 05:49.010 --> 05:58.460 Also, index is added, this one unnamed to disable this, add a parameter index underscore call is 05:58.460 --> 06:01.650 equal to zero grade. 06:01.940 --> 06:05.780 So this is the data in this fire in an Excel file. 06:05.810 --> 06:10.700 There are various cheats adding one more parameter 06:13.100 --> 06:13.490 sheet. 06:13.520 --> 06:17.650 Name is equal to cheat one executed. 06:19.070 --> 06:20.000 Same result. 06:20.630 --> 06:24.140 So this is the data in cheat one from this Excel file. 06:24.730 --> 06:29.360 This Dot Excel is X to read any sheet from an Excel file. 06:29.600 --> 06:33.230 We have to specify name of that key here. 06:34.040 --> 06:37.340 So this is how we can read an Excel file using banned. 06:39.470 --> 06:42.080 Let us understand how to write in an Excel file. 06:42.860 --> 06:44.600 Take the data from the F. 06:47.420 --> 06:47.980 Great. 06:49.040 --> 06:52.550 We will save this data from B F into an Excel file. 06:53.360 --> 06:54.230 To do that. 06:54.480 --> 06:54.660 A. 06:54.670 --> 06:54.940 B. 06:55.070 --> 06:56.260 F dot. 06:57.920 --> 07:01.230 To excel here. 07:01.270 --> 07:01.470 V. 07:01.470 --> 07:03.420 How to enter the name of the new file. 07:04.370 --> 07:09.930 I will enter paste to dot excel s6. 07:10.700 --> 07:13.040 We can specify sheet name also. 07:15.830 --> 07:18.580 By default, sheet name is equal to sheet one. 07:19.280 --> 07:22.760 I will mention the same sheet one. 07:23.330 --> 07:27.560 You can specify any name that you want for that specific sheet. 07:28.400 --> 07:28.650 No. 07:28.760 --> 07:32.600 Execute a refresh. 07:33.620 --> 07:36.770 Great new Excel file is created. 07:36.920 --> 07:39.370 This one is to dot Excel. 07:39.380 --> 07:47.200 Essex noted this filing bd dot a real underscore Excel. 07:51.450 --> 07:54.000 Copy part and paste. 07:56.130 --> 07:56.670 Great. 07:57.330 --> 08:00.940 So we have successfully written the data into this Excel file. 08:01.800 --> 08:08.910 Disable this column, add a parameter index call is equal to zero. 08:10.050 --> 08:10.590 Great. 08:11.400 --> 08:20.370 So this is how we can break the data in an Excel filing using dependent so digit ordeal about reading 08:20.430 --> 08:27.470 and writing files and pendas NCAR in this tutorial, if we help understood how to write and read CSB 08:27.480 --> 08:31.890 files and how to read and write Excel files. 08:33.570 --> 08:37.050 I will see you in the next by tinted ordeal till then. 08:37.170 --> 08:38.180 Happy learning.