Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
We focus on the function that processes a list of client data and calculates the total hours and minutes spent on each client. Using tools like `relativedelta`, `strptime`, and simple arithmetic, you'll learn how to turn raw data into valuable insights.
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
Next up, we're gonna work on this
function, the display_all_totals function.
0:00
Now this is what gets run if a user
tries to get all the data for
0:05
a client,
no matter when that client's job was.
0:10
So we get a client passed in.
0:14
And we're also using a get_by_client
function in the utils file,
0:17
which would grab all the jobs
from that one client and
0:21
it gets stored in
the client_jobs variable.
0:25
So we've got some reference
print statements here.
0:28
So let's just run the app
to see what we're getting.
0:30
So we'll do python3 main and
we're gonna calculate totals and
0:34
we'll just use ACME because
it is shortest, and
0:39
this will be retrieved all data so
it's number 3.
0:43
And it looks like we're
getting quite a bit of data.
0:48
We're getting our ACME, which is our
client, this is our print client line.
0:51
And then for our client jobs,
0:58
we're getting a list this entire
list right here of dictionaries.
1:00
Dictionaries that contain the client,
the description, the start time,
1:05
and the end time for
one job that's been tracked.
1:09
So here is one dictionary and
1:12
you can see that all of our jobs
here are for the client ACME only.
1:14
So that is what this
get_by_client function was doing.
1:19
Okay, so
we're getting client as a string and
1:25
then client jobs as
a list of dictionaries.
1:29
So that is what we're working with.
1:32
So let's make this a little
bit smaller again, but
1:34
I will just highlight one of them just so
we can see it.
1:38
Let's have a look at the instructions
that was left for us.
1:43
We've got a TODO: List out
all the different jobs, and
1:47
then a total time spent.
1:49
For example, if the user chooses Emmerton,
1:51
we have to have the description,
and then how long, description,
1:54
how long, and then finally a total at
the bottom of everything added up.
1:58
So it looks like we're going to have
to loop through all the dictionaries
2:03
in this list and then add up the total
number of hours and minutes.
2:07
So we'll start with a loop.
2:11
So for job in client_jobs.
2:14
In order to work with the start time and
end time, we will have to convert
2:17
those from strings to datetime objects,
just like we did before with our last app.
2:22
So just like before, we will start
with a format string, format_string,
2:28
and here we need to crack open
our reference guide yet again.
2:35
We are looking at our minute AM or
PM and then the date,
2:40
you know what, we've already done this,
2:45
we can come up here and
grab this format string that we had for
2:49
our last function and
just pop it right here.
2:54
Now we'll simply need to use
string it past time twice once for
2:58
the start datetime and
once for the end datetime.
3:03
So we'll do start_dt and
3:07
that is datetime.datetime.strptime.
3:11
Now this is the date string and
3:18
again pi charm coming in hot
with with some tips for me.
3:20
This is the date string so
that would be job ['start_time'] and
3:24
then followed by the format
string which we already wrote up,
3:30
easy peasy, and we'll just copy this for
our end datetime.
3:35
End_dt and we'll change this too end_time.
3:40
Okay now that we've got both of these
we can now calculate the difference or
3:46
the time spent on this particular job.
3:51
And for that we'll be using relative
delta so that we get our minutes and
3:54
hours laid out for us very nicely.
3:59
So, let's calculate away,
4:01
time_spent = relativedelta.relativedelta.
4:04
Now again, this first one is
the most recent datetime,
4:09
which is when we ended and
then we started.
4:13
Now's a really good time for us to just
check that were doing the right thing.
4:16
So let's print a time_spent and
4:21
then we will reload the app.
4:26
Let's calculate totals, let's do Emmerton,
4:30
since that was the example, and
we'll retrieve all data for Emmerton.
4:33
Okay, it looks like we've got
our relativedeltas up here.
4:38
So, there was 1 hour,
2 hours, and then 24 minutes,
4:46
which doesn't quite match the 28,
but that's okay, and 24 minutes.
4:49
So we've got three relative deltas
here that all contain a time interval.
4:54
Now we'll simply have to add them up,
5:00
now we'll need to add things
up outside of the loop, so
5:03
we'll actually come back out of
the loop here, let's call it total,
5:07
and this will be a relativedelta,
which at the moment is 0.
5:13
So we'll just do
relativedelta.relativedelta with nothing.
5:18
Okay, so
now that we've got the time spent,
5:23
we'll just have to add
it to total time_spent.
5:28
Okay now we do also have to
print out the job itself.
5:32
So we'll grab this it's
not quite a template but
5:38
we can certainly replace parts of it.
5:41
Let's F string.
5:43
Okay, so
this first bit is the description.
5:45
So all we have to do here is
job description, good, good.
5:48
And here we can't just plug in
the time spent because that's
5:55
actually a relativedelta object.
5:59
So let's pull out the individual parts.
6:02
So this hours will be time_spent.hours and
6:05
then minutes will be time_spent.minutes.
6:11
Okay, now we'll exit
the loop because the loop
6:17
was there to print out the description and
6:20
then also add that time spent to
our total, so we can exit it now.
6:23
And we can do Total for client,
6:29
now we do know the client,
the client was provided for
6:32
us in this Argument right here.
6:38
And then we have,
let's just do X hours and X minutes.
6:43
And now let's fill it in.
6:50
Okay, so we want the total.
6:52
Now total is a relative delta as
you can see by me hovering over it.
6:54
It is a relative delta object,
which means we can access the hours and
6:58
minutes directly.
7:03
So let's do that totals.hours and
total.minutes and
7:04
we will comment these out and
it looks like I didn't follow
7:09
my own instructions,
we'll just get rid of that.
7:14
And we will restart the app let's make
7:19
it a bit bigger, we will quit the app,
7:24
reload the app and then calculate totals.
7:29
Let's do Emmerton again and retrieve
all data and look at that we've got our
7:34
monthly meeting for 1 hour,
our onboarding replacement for 2 hours.
7:39
Follow up questions for 24 minutes total
for Emmerton, 3 hours and 24 minutes.
7:43
Great, we've completed our next function,
and
7:49
we're well on our way
to completing the rest.
7:52
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up