Hi, welcome back.
And this lecture, we will learn how to use vendors to do analysis and statistics to our cities, we
find that as we learn in the last lecture, we first bought Banda's as the following bought vendors,
as did the runners.
So then we will use Banda's to read our CSP file data that read underscores the ASV between two Brackett's.
Our uploaded CSP file between two branches inside the two brackets.
Dulcy ASV and run the cell, if we want to know data type of columns in our CHP file, we will write
the following the F dot types method and run the cell after we run the cell.
We find that passenger name and partial city and rival city columns are of object data type, which
in data frame that R of string data type day and month of and sixty four, which means that these columns
are of actual data type.
The last column is SAYES, which is of float sixty four.
That means that float data ties and we will use another vendor's methods which will describe the statistics
of our data sheet of the columns that have numbers values.
The DOT described methods to witness account mean standard deviation, the minimum, the maximum values
of the three columns that contain numbers values.
It also provides the first time, which is twenty five percent and the second quartile, which is seventy
five percent and median for the median, which is fifty percent.
We will focus on sales column as this column contains the data that we can analyze and get the statistics
from the sales of tickets and our database airlines.
What is that e plus any number that the value is multiplied by ten numbers of time.
So it plus six is the means that value multiplied by ten six times the F dot sales dot described method
and run this.
So entertaining the account means standard deviation, the minimum and the maximum values of sales of
tickets.
Also it provides the first quartile, which is twenty five percent and the second quartile, which is
seventy five percent and the median which is fifty percent.
Also there are two methods.
One for ZAMEEN as the following between two square brackets, sales inside the two square brackets between
two parentheses not me method and runs SL to return the main value of the sales value inside our C as
we datasheet.
I forget to add the two brackets after that mean.
As a full two hour meeting, value of the sales is one hundred and six thousand and one hundred eighty
four point forty between two square records sales inside the two square brackets between two parentheses,
then dot median two brackets running the sell.
We get the median value of sales column, which is seventy five thousand two hundred.
Thanks for watching.
See you next week.
You.