‫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.