Hey everyone.
So in this video we are going to do some time analyses on this data.
So first of all if you move to the columns in the area you will find related to dates.
We have some columns here that is project posted it detailed on which project is posted.
Then we have this one project fully funded.
This is the date when the project is completely funded by the donors.
So we acquired these two former analyses right now because you just need that when the project posted
in when it is fully funded.
Duly denoted by any and the timing related to this would any analyses.
So now we have these two columns.
First of all we will check is there any empty value in these.
Because like many posts something then it may be possible that every project has some data because every
project is posted on a date.
In case someone has left any like any column there.
But it is not necessary that every project is fully funded.
We have approx eleven million letters.
So let we check that one.
First of all here we have project posted date maybe over that one.
After that we have project fully funded
and we we use is no method for any vacancy.
And then some so then we can have all dual use invalid system syntax fully I forget to add decodes here
Neville now here we have project posted date that is zero because we have no project that is not posted
on any date.
Then we have project fully funded it.
But here we have forty four like thirty seven thousand cases which are not completely funded so there's
something acceptable because every project is not funded.
Now we have this one and now we have a basic idea of these two columns copy this one.
Come on see.
Come on.
Dot head.
There we go with that one.
So here we have the project both to date.
And here we have defunded it.
So as you can see here in three months first project is completely funded and this one is funded in
just 12 days.
And this one is just to one day.
So there is depend on project.
But let's not overlook.
Nope one more thing here.
You cannot apply directly or patient on these dates.
Like if I want to calculate that how many days does this zero has taken then you can just noted this
one like three months.
But how will you do that one here.
So for that one we have included the liability date time if you remember this is the library which make
us to calculate the dates by performing some mathematical operations on them.
Let me show you that one.
But first of all we need to convert these by using the date time so that we can make the calculation
on them.
So first of all here we have date for sort of doubtful.
And first we will work with Project posted date and do hear something like hey we have beady note to
underscore daytime and then simply pass this one come out and see in Pence's command VE Day we have
this one shifted one.
David go with that but never tried to bring this data with this one you will get the same result as
this one.
There's nothing different but now you can perform operations on that one.
How I will show you just after this one so.
Copy this one completely.
Come on come on see.
And here we have come on me and James that one with this column.
So here we have this one here we have this one shifted on made for that one too processed so here we
have this one.
And now if I create another variable and that variable will be a column in data file with the name let's
say funding time that really present the time in between these and now we can simply just do this one
command see and here we have this one.
And the difference will be project fully funded it minus the project posted it it will provide as the
time between them.
So here we have this one.
So you copy and pasted before that one and put a minus sign in between them.
Then we have shifted on this one and now we will have all these four.
Like if I print all these here data for this one come on see.
Come on.
V and add funding time in this so funding time
should return.
Dave we have this fund now.
So one hundred two days that is we cannot count right now but we can count this one as I have only this
one can just take 12 days and this one takes just only a one day so we have no the difference in between
these dates.
That is something the daytime has done here.
The date without the time you will get added in that one because you cannot subtract the days by just
using simple mathematical patients.
And now we will check is there any null value in these now.
So just this one because we have checked only for both student and fully funded debt.
But now we have funding time also.
So is null and then not some shifted on David go the debt fund as expected.
There must be same values these because as many number of we have posted it.
We have as many number of funded except those which are not completely funded.
And as in the model funding time but the values that are taken hit also the values that are vacant here
in funding.
Diane deep study.
So there is something I hope you get that that why they are saying now here we have done this one.
And let me create a and in the data there that will be data for and here I will provide BD or not none
the values that are not empty in funding.
So I'm just creating a variable here that contains all the values of funding type expect the known values
that are empty.
So here I would just provide data for and in that one funding type.
Come on see.
And there we have come on.
We shifted on day we have the data for variable now and it pushes them until late we add another syntax
here.
That is now check these values that is there any value null of note.
So just copy this one from this to this commodity and pasted here that one is still processing.
So here it is done and now should return that man it's again processing.
Let me add and underline here until Dedmon that is import the time as duty.
We have also done this one before but again added this one with this set in which you will add this
length that is date 5.
So data type capability have the funding time is that is simply this one come on see Come on V and then
equal to data.
5 David go Dedmon.
So this is what I need to show you here that now when we have removed all the null values but not have
any empty value in funding time project posted and project fully funded it all are zero in this case.
Now now here we have this one and we will use those deeply doe base metal shifted in there we have this
one in days form now we have already that one in the days form but you need to add this line here I
know after this one if you paint all the data that is data 5 and these all currency come on we note
had
shifted in here we have dismantled old that is defunding time project posted date and budget fully funded
it we do not have any string here no that is what then here the days are already but this one is now
in days so you do not have to add this here.
So now we have our complete data frame in which you have funding time project both to date project fully
funded till now we do not have done any analyses we have just created the data in funding time for we
have budget posted date project fully funded it that we have done in different data types all we can
see in different forms so that we can make calculations there by using the underscore data then we have
calculated the funding time and now we are here with this one.
So this is about creating the daytime objects in the next video we will do analyses on this one.
So thanks for watching.
See in the next video.