1 00:00:05,870 --> 00:00:06,520 Here we go. 2 00:00:07,060 --> 00:00:11,140 So in this video we are going to London how we can add any kind of file in. 3 00:00:11,250 --> 00:00:17,200 Ed we have done the same thing and input output session and while installing the Jason fighting over 4 00:00:17,320 --> 00:00:22,700 Ed but here we are going to do the same thing by using the data science libraries now respond as in 5 00:00:22,690 --> 00:00:27,190 Siebel and we are just going to focus on pandas here right now. 6 00:00:27,260 --> 00:00:33,800 Also we will focus that how we can add the files into a vote ed. note how David Funk we learned working 7 00:00:33,800 --> 00:00:36,900 while we are working with them like in C and section. 8 00:00:37,130 --> 00:00:43,690 But before that his few types of files that his first one Jason that you are already familiar with. 9 00:00:43,940 --> 00:00:54,510 And then nothing more just dictionaries of Python informal files and they are used whenever we are working 10 00:00:54,540 --> 00:00:59,760 on the desktop type of applications and we require a lot of data that are predefined in any form of 11 00:00:59,940 --> 00:01:00,590 file. 12 00:01:00,630 --> 00:01:06,030 So we do not require to write again and again just like that if we talk about the data science we have 13 00:01:06,030 --> 00:01:08,650 a file that is in the CSB files. 14 00:01:08,840 --> 00:01:15,170 These are also known as the data sheets of Python all because it did data frames of bond us that are 15 00:01:15,210 --> 00:01:24,680 informal files so we can say they are just data frames informal files and when we are working with any 16 00:01:24,770 --> 00:01:31,040 dataset that will be present in form of CSP file even if when you create your own dataset you need to 17 00:01:31,040 --> 00:01:37,790 create that went into CSB files so that your code will not look like any mess Hayes our common example 18 00:01:37,790 --> 00:01:43,340 of a CSP file if you notice these are the columns here we have rows and the values here. 19 00:01:43,340 --> 00:01:52,310 This is or just a data framing pandas but informal file and just like that any data for any data can 20 00:01:52,310 --> 00:01:59,490 be converted informal files after this one we have few basic ones like Excel you all are familiar with 21 00:01:59,490 --> 00:02:02,350 that one SDM and files. 22 00:02:02,550 --> 00:02:07,260 I think most of you are familiar with that one but no those who are not familiar with that one they 23 00:02:07,260 --> 00:02:11,490 are the formal file that works on server like on our desktop. 24 00:02:11,610 --> 00:02:15,030 We have Excel or PowerPoint or potato file. 25 00:02:15,660 --> 00:02:21,290 But if you are working on this server or we can see any web page then these files return here. 26 00:02:21,300 --> 00:02:26,880 This web page if you notice this one all the things are not in normal language. 27 00:02:26,880 --> 00:02:30,480 This is SDM that is showing all these things here. 28 00:02:30,630 --> 00:02:36,940 The design is refereeing to see assess all the written parts available here is in form of SDM. 29 00:02:37,710 --> 00:02:41,360 So that's a basic info that what the estimate Pfizer. 30 00:02:41,460 --> 00:02:44,820 So these kinds of files are also included in that one. 31 00:02:45,030 --> 00:02:53,190 Like if I download this file right now just to try to see this file and not getting option 32 00:02:56,500 --> 00:03:01,030 here find the file and they will go with these files. 33 00:03:01,030 --> 00:03:02,350 Here it is. 34 00:03:02,350 --> 00:03:09,710 And if I download this file here it's downloaded now and I try to open that one you fine. 35 00:03:09,730 --> 00:03:13,680 This one is a dot SDM type of file and then I have opened this. 36 00:03:13,700 --> 00:03:17,000 It's not open in any kind of Ed it's opening web. 37 00:03:17,230 --> 00:03:17,800 Here we have. 38 00:03:17,800 --> 00:03:24,730 If you notice this one on this safari here this is the original one is here and that one I have opened 39 00:03:24,730 --> 00:03:25,150 right now. 40 00:03:25,150 --> 00:03:26,250 Is this one. 41 00:03:26,320 --> 00:03:31,420 So these are known as the estimate phase in which you can directly access the file into your browser. 42 00:03:32,830 --> 00:03:35,950 So these are the few basic files that we need to work on. 43 00:03:35,980 --> 00:03:38,730 And let me give a few of them. 44 00:03:39,520 --> 00:03:44,990 And if you can just cover only one you will be able to access all the others. 45 00:03:45,370 --> 00:03:51,380 But before that one one more thing if you need to work. 46 00:03:51,580 --> 00:03:53,040 Let me open a new terminal here 47 00:03:56,070 --> 00:04:01,840 if you need to work on SDM files then you need to install some libraries. 48 00:04:02,040 --> 00:04:06,900 And if you're working on excel you need to install another library like if you are working on as general 49 00:04:06,910 --> 00:04:11,720 five you need to install pip or Condi if you are using condom distribution. 50 00:04:11,820 --> 00:04:13,390 So I am pressing on that right now. 51 00:04:13,920 --> 00:04:26,950 So condom install and they will write SDM Al 5 and then leave denoting library hit return or enter on 52 00:04:26,960 --> 00:04:27,560 Windows. 53 00:04:27,650 --> 00:04:38,470 And this thing is as Yemen five lip and head start to extract fries after that. 54 00:04:38,470 --> 00:04:39,800 This one is for estimable. 55 00:04:39,840 --> 00:04:42,570 And you need to work with fine. 56 00:04:42,630 --> 00:04:43,830 Here it is. 57 00:04:43,850 --> 00:04:45,260 No no no. 58 00:04:45,640 --> 00:04:51,490 If you are working on Excel file just install X L examine. 59 00:04:51,580 --> 00:04:55,840 So these are a few kinds of files that you can work on by using these libraries. 60 00:04:55,840 --> 00:05:00,970 If you're using obscure type of file then another kind of file well then you need to work on the database 61 00:05:01,430 --> 00:05:03,610 they refer to server query languages. 62 00:05:03,610 --> 00:05:07,640 Then you need to install a school well see actually. 63 00:05:07,650 --> 00:05:08,860 Am I buy. 64 00:05:09,520 --> 00:05:16,480 So this is the library for that one and whatever diff type file you're using just go to the Google and 65 00:05:16,480 --> 00:05:19,820 right there that the library required for these kinds of file. 66 00:05:19,960 --> 00:05:25,450 They will get the library and install in your terminal and then you will go with that one. 67 00:05:26,380 --> 00:05:28,540 So this is not the most typical task. 68 00:05:28,540 --> 00:05:32,360 I hope you get this thing and easily able to do that one. 69 00:05:32,440 --> 00:05:39,760 Now let me move to C as we face that how we can upload these kinds of files. 70 00:05:39,880 --> 00:05:47,440 So for that purpose I have downloaded this basic file that is 2 0 1 dot easy NTSB. 71 00:05:47,650 --> 00:05:49,330 This 2 0 1 is just nothing. 72 00:05:49,330 --> 00:05:52,270 It's the number you will get in a value get this fight. 73 00:05:52,270 --> 00:05:54,790 This one is available with this module. 74 00:05:55,540 --> 00:05:57,970 And after that 75 00:06:00,980 --> 00:06:09,360 to have the file on the desktop first what you need to do you will write happy WB that will give you 76 00:06:09,360 --> 00:06:16,350 the access of the location that Vale the Jupiter notebook is working or against it which is the local 77 00:06:16,350 --> 00:06:19,220 server of these Jupiter notebooks. 78 00:06:19,230 --> 00:06:27,390 So this is users slash Dave whatever your location is go prep for that location and what you need to 79 00:06:27,390 --> 00:06:37,350 do now is just right click here so that you will get the files option there and click on go. 80 00:06:37,410 --> 00:06:39,030 This one is for Mac in windows. 81 00:06:39,030 --> 00:06:46,770 This is very simple just go to your drivers in which you are and install in that go to users like here. 82 00:06:46,770 --> 00:06:55,920 If I go to computer on this one and this hard drive users and in users the location I have here like 83 00:06:55,920 --> 00:07:00,180 Dave Hill in windows maybe you will have a different location at this point. 84 00:07:00,210 --> 00:07:04,000 So in Dave Hale you need to paste this fine. 85 00:07:04,050 --> 00:07:06,610 So come on see that file and paste it here. 86 00:07:06,630 --> 00:07:13,520 That is I have already done here to zero wondered easy note CSP or maybe you will get a different number 87 00:07:14,890 --> 00:07:18,660 because this file is included twice in this module. 88 00:07:20,490 --> 00:07:27,270 So if you are getting another number just make sure that the same number is on the both side and you 89 00:07:27,270 --> 00:07:32,830 are using the same number on here safari. 90 00:07:32,880 --> 00:07:43,950 Now to use that one with Panda's first imported pandas here we have pandas as Billy shifted on and then 91 00:07:43,950 --> 00:07:52,200 here you need to write this index for that fund like Billy dot read and then underscore the type of 92 00:07:52,200 --> 00:07:57,750 file you need like CSB etched CML and any file you are using. 93 00:07:57,750 --> 00:08:02,970 So I am using CSC princes courts and their right. 94 00:08:02,970 --> 00:08:09,370 The name of file like that one is 2 0 1 dot ECB dot CSP. 95 00:08:09,510 --> 00:08:11,890 I think that's the name of that file. 96 00:08:11,930 --> 00:08:12,720 Let me check that. 97 00:08:13,590 --> 00:08:15,090 So here it is 2 0 1. 98 00:08:15,090 --> 00:08:17,760 Not easy CSB again. 99 00:08:17,790 --> 00:08:21,320 Make sure you have this same name here. 100 00:08:21,450 --> 00:08:28,470 Just like the Jason 5 maybe I have already told you and it may be possible you just get something like 101 00:08:31,040 --> 00:08:36,360 only this easy dot CSP. 102 00:08:36,680 --> 00:08:42,600 So I will try to upload this one by replacing the this file so that you will not get any error. 103 00:08:42,620 --> 00:08:47,370 So in that case you need to do just have here seed it or CSP. 104 00:08:47,510 --> 00:08:49,050 What I need to show you here. 105 00:08:49,160 --> 00:08:54,060 Make sure you are writing the same name that is present there and the same here. 106 00:08:54,110 --> 00:08:59,660 Otherwise you will get error student get added here because they did not focus on the number of that 107 00:08:59,660 --> 00:09:02,540 one like at which number that is present. 108 00:09:02,540 --> 00:09:08,260 So I believe removing the number is more efficient no. 109 00:09:08,470 --> 00:09:10,620 After that one just fresh off Twitter. 110 00:09:10,720 --> 00:09:12,280 You will get that file uploaded here. 111 00:09:13,030 --> 00:09:14,230 So this is that file. 112 00:09:15,730 --> 00:09:19,020 And it's simple like that. 113 00:09:19,150 --> 00:09:22,060 You just need to do this thing. 114 00:09:22,060 --> 00:09:23,590 Nothing more than this one. 115 00:09:23,590 --> 00:09:29,340 You can also store this one in any variable like x is equal to this one and then print that x. 116 00:09:29,350 --> 00:09:32,300 Here it is just two things here. 117 00:09:32,310 --> 00:09:36,700 If the file is not present at that location like if I removed this file from here. 118 00:09:36,870 --> 00:09:37,430 Come on Nick. 119 00:09:37,590 --> 00:09:44,280 Sorry let me copy this one first and pasted on desktop and now remove this fight. 120 00:09:45,360 --> 00:09:45,870 So here. 121 00:09:45,870 --> 00:09:52,500 I did not have this file right now and if I tried to run that one now I will get at it because the file 122 00:09:52,500 --> 00:09:57,150 is not present at that location file not found error. 123 00:09:57,180 --> 00:09:58,500 Here you will see that one. 124 00:09:59,190 --> 00:10:00,640 So make sure the file. 125 00:10:01,080 --> 00:10:07,030 You have pasted on the same directory that is you are getting on while you write the b. 126 00:10:07,080 --> 00:10:07,980 PETER MOODY there. 127 00:10:08,310 --> 00:10:11,060 So here let me again see that file. 128 00:10:11,070 --> 00:10:11,720 There we go. 129 00:10:12,570 --> 00:10:21,580 So now if you run that one you will have the same file and what I am showing you is GWB. 130 00:10:21,620 --> 00:10:26,420 Make sure you are using this file in the same location. 131 00:10:26,900 --> 00:10:27,890 Otherwise you will get a.. 132 00:10:27,890 --> 00:10:30,930 This is the only error you will get after this. 133 00:10:30,980 --> 00:10:34,960 I think all the things are very easy. 134 00:10:35,380 --> 00:10:39,410 So this is how you can have any C as we file here. 135 00:10:39,430 --> 00:10:44,850 One more thing like if any file is present on the Internet like this one. 136 00:10:44,890 --> 00:10:46,750 I have taken as an example. 137 00:10:47,110 --> 00:10:47,800 So this is it. 138 00:10:47,810 --> 00:10:50,780 Any like here. 139 00:10:50,790 --> 00:10:57,400 This one you idle and we learn about these files later in the class but until now just where they are 140 00:10:57,420 --> 00:10:58,070 relevant. 141 00:10:58,110 --> 00:11:06,420 So if you need to add this file in directly to your editor just copy this hole you are all commanded 142 00:11:06,450 --> 00:11:13,370 and command C or controlled C on windows and hear what you need to do first if you replace this one 143 00:11:13,380 --> 00:11:21,890 with this you are and run that one you will get added. 144 00:11:22,020 --> 00:11:26,740 Why this happens because here this is showing a CSP file. 145 00:11:27,060 --> 00:11:33,900 But in actual when we have downloaded that file you have notice that that one is an extremely fine. 146 00:11:34,290 --> 00:11:41,870 So you need to add here SDM and instead of CSP so make sure you are using an estimate. 147 00:11:42,060 --> 00:11:47,460 So now it sat on them and if you run that file now you will get this one that file present here. 148 00:11:48,890 --> 00:11:49,870 One more thing. 149 00:11:50,080 --> 00:11:54,070 In few locations you will get this man like here. 150 00:11:54,080 --> 00:12:00,740 This deep dysfunction is here and then all devalues so that something a different issue. 151 00:12:00,740 --> 00:12:01,970 I will tell you about that one. 152 00:12:02,030 --> 00:12:08,620 While we are working on these files and most of the things you will get the same like this one Sunday 153 00:12:08,640 --> 00:12:08,960 No. 154 00:12:08,960 --> 00:12:09,850 2 3 No. 155 00:12:09,860 --> 00:12:15,390 Just this one unnamed is different one and maybe this one is not available here. 156 00:12:15,400 --> 00:12:21,120 I believe yes that one is not there is just the stuff I'll get here. 157 00:12:21,670 --> 00:12:25,970 So this is about how you can have the file directly from the internet. 158 00:12:26,110 --> 00:12:27,430 Just the estimate here. 159 00:12:27,460 --> 00:12:30,450 One more thing make sure you have already installed the library. 160 00:12:30,490 --> 00:12:32,610 That's another reason you will get added there. 161 00:12:32,620 --> 00:12:37,720 If you have not installed the library in your terminal or command prompt on windows you will get the 162 00:12:37,720 --> 00:12:37,990 error. 163 00:12:39,750 --> 00:12:44,550 So this is about the uploading fighting ed by using panels. 164 00:12:44,640 --> 00:12:52,550 And if you're using Excel file then just use the Excel tag like that is l Excel whatever the file you 165 00:12:52,550 --> 00:12:53,400 are using. 166 00:12:53,400 --> 00:12:58,160 Use the proper attribute for that one and as things are very simple. 167 00:12:58,500 --> 00:13:00,540 So this is all about the files here. 168 00:13:00,540 --> 00:13:06,720 One more thing I need to add here is like if you're using any file that is already present in the library 169 00:13:07,020 --> 00:13:10,150 like the pandas we have been in the library that is known as Siebel. 170 00:13:10,680 --> 00:13:17,800 So if I import that one Seabourn as SS so I will. 171 00:13:17,900 --> 00:13:20,970 So read this one see Bjorn. 172 00:13:21,210 --> 00:13:22,050 So here we go. 173 00:13:23,190 --> 00:13:26,430 So this is a library that we are going to work after the Met broadly. 174 00:13:26,700 --> 00:13:29,940 And if you have noticed there I am showing the example of sable. 175 00:13:30,390 --> 00:13:33,900 So these libraries are present in Siebel. 176 00:13:33,900 --> 00:13:37,250 I will again tell you about these libraries when we work on Siebel. 177 00:13:37,350 --> 00:13:40,320 Just a little thing that they are in Siebel. 178 00:13:40,830 --> 00:13:47,240 And if you need to add any file that is already available in Siebel or any other library like abusing 179 00:13:47,610 --> 00:13:52,800 pandas or met probably would have a little library I'm using then in that case you just need to do something 180 00:13:52,800 --> 00:13:59,180 like if I have X any variable so x is equal to here. 181 00:13:59,930 --> 00:14:06,980 If you are using disable library then just SS just like the P.T. denoting disable don't 182 00:14:09,650 --> 00:14:20,200 says don't load underscored here I am using data set so dataset princes and inventors provide the name 183 00:14:20,200 --> 00:14:21,840 of that like tips. 184 00:14:21,970 --> 00:14:32,490 I want to add tips this one and you do not required to add NTSB just in this case you need to add tips. 185 00:14:32,560 --> 00:14:35,350 Sorry this one is a small detail. 186 00:14:35,410 --> 00:14:37,250 There we go. 187 00:14:37,300 --> 00:14:39,040 This is a big asset now. 188 00:14:39,400 --> 00:14:40,540 What I'm telling you here. 189 00:14:40,570 --> 00:14:45,730 You do not need to provide extension here like we have done C S V there. 190 00:14:45,730 --> 00:14:47,130 That's why I need to tell you this one. 191 00:14:47,410 --> 00:14:51,760 And if you print x now you will get the same file. 192 00:14:51,760 --> 00:14:55,200 That is if you notice the tape's there. 193 00:14:55,210 --> 00:14:58,110 Here we have. 194 00:14:58,220 --> 00:15:02,790 So this is how you can have defined that are already present in a library. 195 00:15:02,840 --> 00:15:05,660 So this is the third topic here. 196 00:15:05,660 --> 00:15:06,900 One more I got here now. 197 00:15:06,920 --> 00:15:10,270 Like the one you have downloaded that is tips NTSB. 198 00:15:10,310 --> 00:15:13,170 This one in that case also this is same. 199 00:15:13,190 --> 00:15:18,880 You just need to have SDM and attribute there instead of CSB. 200 00:15:19,100 --> 00:15:22,020 So done with the files. 201 00:15:22,030 --> 00:15:26,040 Thanks for watching and I hope you get the idea that how we can upload these files. 202 00:15:26,440 --> 00:15:30,610 And if you do not get any idea Don't worry about that fun because we are going to use these fights again 203 00:15:30,610 --> 00:15:36,160 and again you will get completely perfect just in disabled section. 204 00:15:36,160 --> 00:15:41,200 So this is a basic idea that how you can add files and what are the methods and ways by which you can 205 00:15:41,200 --> 00:15:42,180 add defines. 206 00:15:42,190 --> 00:15:43,240 So thanks for watching. 207 00:15:43,240 --> 00:15:44,230 See in the next module.