So find us is a software library written for the Python programming language for data manipulation and
analysis.
This is specifically for data manipulation and analysis.
First we need to import minus
so we'll write import find us as speedy if we are using and I want.
And then we're not have automatically installed you find another in your system so you won't need to
install it separately.
You just have been ordered into your workspace fought by us.
We will be using our customer data so yes we find you can find this file in the resources section on
this video.
So go on download this fight and put it in your folder.
We will start by importing a customer see as we find civil right data when this is over variable then
we'll write up on notes function to import CSC that is BD dot read underscore the CSP then we provide
the location of Odysseus to find
remember routine this back slashes into forward slashes
then the file name somewhere not CSP
and then edits equate those zeros and so what for stroke and been beheaded.
Done this will get our people very well done for day to day to undertake really get the first five rows
of our data
you can see we have a somewhat idea someone a name segment each increase a b c the board and the region
as our columns then we have multiple similar details Rose first is of course somewhat I read this is
a unique idea for each customer second column is like a similar name here we have someone name for name
then there is a segment where the customer belong to and zoom on the segment or corporate segment then
we have a column for each that each your customer then the concrete city state or cell board and region
of that customer if you want to grab Motorola's you can provide the number and this record by default
it is 5 if you write then and would put you in deck then goes
now here you are seeing this 0 1 2 3 4.
This all are the index off of this table for example zero throws will be this row if you want to know
somewhat of a B as an index and so it goes his family we can add it as an index will write this CSC
file into another database that is data to really copy the outcome on
who will write another parameter that is index underscore column we are providing the location of index
column and for our data it discussed somewhat 80 which is the 0 call them off our data since this is
the first column the index is 0 that's why we are providing 0 similar to what we provided for this.
So what I had done was by then in the war before I get and 0 low vision of it it also or the next column
is 0 if we run this and again if we run the hurdle is
you can see now 0 1 2 3 4 indexes that have on and now this out of our indexes
these are important and we will discuss I ordered a short way now Hey come on let's use to you the sample
of your data if you want to know statistics of your data you write data one don't describe
don't describe this game is a killer and then this
so there are only two in beta we are losing our data.
That's why we are only getting two columns year for season and second this post syllable.
Here you can see the total account of value.
The mean not alternate the standard deviation of age minimum made maximum age.
These are the percentile value.
This the 25 percentile value so if you arrange all the agent ascending order the value present under
25 percentile of their data is this value.
Similarly this is the 50 percent and also known as the median value is the 70 percentile value of it
and is the maximum value of each.
This very discussed and unique period analysis which we will be covering in the later part of this course
there are two ways to index our data stream.
So we discuss a little while importing this data we can provide index next column for our data one index.
We did not provide any index column and four data to our index column it's got some variety.
So if you want to view the first rule of our data we have to IWC lock or I lock you.
If we use data one that I lock and then we provide 0 what I lock we do is it will grab the data that
is present in the z index of our data frame so our output is same as what the first scroll is of our
data frame.
If we want to use the index column which we defined by creating or determining we have to use lock
and in the bracket if we write the cost somewhat 80 C D 1 2 5 0 0
in the attack to be defined our index column as cost somewhat 80.
So now we can use LOC keyword to get the date of this somewhat 80 feet on this.
You can see we are getting all the details of our cost somewhat except the cost somewhat ironic since
this is the index column.
Similarly if I don't know this 80 and I just wanted to grab the first customer I can use I log
on so I am getting the same in here I was using I along with I look you have to use the serial number
0 and so on.
With lock you can use the index column that you throw away.
So if you know the position you can use a lock and if you know the value you can use the locks
just like in less than the time frame you can also mention multiple values using called an operator.
So for example if I write data to that boat I lock 0 column 5.
This will give me that data off first five rows where the index will Lewis 0 1 2 3 and 4.
Remember 5 is excluded from this research.
So I'm getting data of this paper summer you can use steps as one if I tried to run this I'm getting
on three days since I'm using the steps.
That's all on the we will be using find a lot more by doing our work and would discuss new topics than
that on.