Here we go.
So in this video we are going to London how we can add any kind of file in.
Ed we have done the same thing and input output session and while installing the Jason fighting over
Ed but here we are going to do the same thing by using the data science libraries now respond as in
Siebel and we are just going to focus on pandas here right now.
Also we will focus that how we can add the files into a vote ed. note how David Funk we learned working
while we are working with them like in C and section.
But before that his few types of files that his first one Jason that you are already familiar with.
And then nothing more just dictionaries of Python informal files and they are used whenever we are working
on the desktop type of applications and we require a lot of data that are predefined in any form of
file.
So we do not require to write again and again just like that if we talk about the data science we have
a file that is in the CSB files.
These are also known as the data sheets of Python all because it did data frames of bond us that are
informal files so we can say they are just data frames informal files and when we are working with any
dataset that will be present in form of CSP file even if when you create your own dataset you need to
create that went into CSB files so that your code will not look like any mess Hayes our common example
of a CSP file if you notice these are the columns here we have rows and the values here.
This is or just a data framing pandas but informal file and just like that any data for any data can
be converted informal files after this one we have few basic ones like Excel you all are familiar with
that one SDM and files.
I think most of you are familiar with that one but no those who are not familiar with that one they
are the formal file that works on server like on our desktop.
We have Excel or PowerPoint or potato file.
But if you are working on this server or we can see any web page then these files return here.
This web page if you notice this one all the things are not in normal language.
This is SDM that is showing all these things here.
The design is refereeing to see assess all the written parts available here is in form of SDM.
So that's a basic info that what the estimate Pfizer.
So these kinds of files are also included in that one.
Like if I download this file right now just to try to see this file and not getting option
here find the file and they will go with these files.
Here it is.
And if I download this file here it's downloaded now and I try to open that one you fine.
This one is a dot SDM type of file and then I have opened this.
It's not open in any kind of Ed it's opening web.
Here we have.
If you notice this one on this safari here this is the original one is here and that one I have opened
right now.
Is this one.
So these are known as the estimate phase in which you can directly access the file into your browser.
So these are the few basic files that we need to work on.
And let me give a few of them.
And if you can just cover only one you will be able to access all the others.
But before that one one more thing if you need to work.
Let me open a new terminal here
if you need to work on SDM files then you need to install some libraries.
And if you're working on excel you need to install another library like if you are working on as general
five you need to install pip or Condi if you are using condom distribution.
So I am pressing on that right now.
So condom install and they will write SDM Al 5 and then leave denoting library hit return or enter on
Windows.
And this thing is as Yemen five lip and head start to extract fries after that.
This one is for estimable.
And you need to work with fine.
Here it is.
No no no.
If you are working on Excel file just install X L examine.
So these are a few kinds of files that you can work on by using these libraries.
If you're using obscure type of file then another kind of file well then you need to work on the database
they refer to server query languages.
Then you need to install a school well see actually.
Am I buy.
So this is the library for that one and whatever diff type file you're using just go to the Google and
right there that the library required for these kinds of file.
They will get the library and install in your terminal and then you will go with that one.
So this is not the most typical task.
I hope you get this thing and easily able to do that one.
Now let me move to C as we face that how we can upload these kinds of files.
So for that purpose I have downloaded this basic file that is 2 0 1 dot easy NTSB.
This 2 0 1 is just nothing.
It's the number you will get in a value get this fight.
This one is available with this module.
And after that
to have the file on the desktop first what you need to do you will write happy WB that will give you
the access of the location that Vale the Jupiter notebook is working or against it which is the local
server of these Jupiter notebooks.
So this is users slash Dave whatever your location is go prep for that location and what you need to
do now is just right click here so that you will get the files option there and click on go.
This one is for Mac in windows.
This is very simple just go to your drivers in which you are and install in that go to users like here.
If I go to computer on this one and this hard drive users and in users the location I have here like
Dave Hill in windows maybe you will have a different location at this point.
So in Dave Hale you need to paste this fine.
So come on see that file and paste it here.
That is I have already done here to zero wondered easy note CSP or maybe you will get a different number
because this file is included twice in this module.
So if you are getting another number just make sure that the same number is on the both side and you
are using the same number on here safari.
Now to use that one with Panda's first imported pandas here we have pandas as Billy shifted on and then
here you need to write this index for that fund like Billy dot read and then underscore the type of
file you need like CSB etched CML and any file you are using.
So I am using CSC princes courts and their right.
The name of file like that one is 2 0 1 dot ECB dot CSP.
I think that's the name of that file.
Let me check that.
So here it is 2 0 1.
Not easy CSB again.
Make sure you have this same name here.
Just like the Jason 5 maybe I have already told you and it may be possible you just get something like
only this easy dot CSP.
So I will try to upload this one by replacing the this file so that you will not get any error.
So in that case you need to do just have here seed it or CSP.
What I need to show you here.
Make sure you are writing the same name that is present there and the same here.
Otherwise you will get error student get added here because they did not focus on the number of that
one like at which number that is present.
So I believe removing the number is more efficient no.
After that one just fresh off Twitter.
You will get that file uploaded here.
So this is that file.
And it's simple like that.
You just need to do this thing.
Nothing more than this one.
You can also store this one in any variable like x is equal to this one and then print that x.
Here it is just two things here.
If the file is not present at that location like if I removed this file from here.
Come on Nick.
Sorry let me copy this one first and pasted on desktop and now remove this fight.
So here.
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
is not present at that location file not found error.
Here you will see that one.
So make sure the file.
You have pasted on the same directory that is you are getting on while you write the b.
PETER MOODY there.
So here let me again see that file.
There we go.
So now if you run that one you will have the same file and what I am showing you is GWB.
Make sure you are using this file in the same location.
Otherwise you will get a..
This is the only error you will get after this.
I think all the things are very easy.
So this is how you can have any C as we file here.
One more thing like if any file is present on the Internet like this one.
I have taken as an example.
So this is it.
Any like here.
This one you idle and we learn about these files later in the class but until now just where they are
relevant.
So if you need to add this file in directly to your editor just copy this hole you are all commanded
and command C or controlled C on windows and hear what you need to do first if you replace this one
with this you are and run that one you will get added.
Why this happens because here this is showing a CSP file.
But in actual when we have downloaded that file you have notice that that one is an extremely fine.
So you need to add here SDM and instead of CSP so make sure you are using an estimate.
So now it sat on them and if you run that file now you will get this one that file present here.
One more thing.
In few locations you will get this man like here.
This deep dysfunction is here and then all devalues so that something a different issue.
I will tell you about that one.
While we are working on these files and most of the things you will get the same like this one Sunday
No.
2 3 No.
Just this one unnamed is different one and maybe this one is not available here.
I believe yes that one is not there is just the stuff I'll get here.
So this is about how you can have the file directly from the internet.
Just the estimate here.
One more thing make sure you have already installed the library.
That's another reason you will get added there.
If you have not installed the library in your terminal or command prompt on windows you will get the
error.
So this is about the uploading fighting ed by using panels.
And if you're using Excel file then just use the Excel tag like that is l Excel whatever the file you
are using.
Use the proper attribute for that one and as things are very simple.
So this is all about the files here.
One more thing I need to add here is like if you're using any file that is already present in the library
like the pandas we have been in the library that is known as Siebel.
So if I import that one Seabourn as SS so I will.
So read this one see Bjorn.
So here we go.
So this is a library that we are going to work after the Met broadly.
And if you have noticed there I am showing the example of sable.
So these libraries are present in Siebel.
I will again tell you about these libraries when we work on Siebel.
Just a little thing that they are in Siebel.
And if you need to add any file that is already available in Siebel or any other library like abusing
pandas or met probably would have a little library I'm using then in that case you just need to do something
like if I have X any variable so x is equal to here.
If you are using disable library then just SS just like the P.T. denoting disable don't
says don't load underscored here I am using data set so dataset princes and inventors provide the name
of that like tips.
I want to add tips this one and you do not required to add NTSB just in this case you need to add tips.
Sorry this one is a small detail.
There we go.
This is a big asset now.
What I'm telling you here.
You do not need to provide extension here like we have done C S V there.
That's why I need to tell you this one.
And if you print x now you will get the same file.
That is if you notice the tape's there.
Here we have.
So this is how you can have defined that are already present in a library.
So this is the third topic here.
One more I got here now.
Like the one you have downloaded that is tips NTSB.
This one in that case also this is same.
You just need to have SDM and attribute there instead of CSB.
So done with the files.
Thanks for watching and I hope you get the idea that how we can upload these files.
And if you do not get any idea Don't worry about that fun because we are going to use these fights again
and again you will get completely perfect just in disabled section.
So this is a basic idea that how you can add files and what are the methods and ways by which you can
add defines.
So thanks for watching.
See in the next module.