 Good morning evening or afternoon ladies and gentlemen, so I wanted to talk about our project three So in the past we've done something that was like how to build a house But given the situation that we're all in it's very fresh. It's very in our everyday lives I made a judgment call And so I did want to at least talk about it because as you can clearly see from the screen What we are going to be doing is we are going to be working on COVID-19 analysis. So the entire idea is you know, I was thinking this through over our our self-quarantine and You are all Civil engineers environmental engineers. You are looking to help people, right? That is a lot of what you're hopefully looking to do with your careers and one of the things that I I imagine your department is looking for out of this class is for your ability to do Data analysis, you're going to be going out into the world You're gonna be planting sensors You're gonna be collecting data and they want you to be able to code out problems or code out solutions to Do analysis on those problems and so that's exactly what we're going to be doing with this So if you are unfamiliar with the John Hopkins University data set They have put this wonderful Dashboard that I know I check a little too often But specifically if we think about this for a second, you know, they have this data widely available It's it's perfectly fine to Collect and use and it's so specifically what we're going to be working off of is the CSC CSSE Time series data. So this is a CSV file the entire concept to this is all it is is just it's a file that is separated Or with values on lines separated by commas and so quite literally if we wanted to see the Confirmed global for every day for every country There it is now You know get hub does some fancy looking at it So it kind of parses it and makes it look like a table But that's you know, we need something that we can then take and load in to our Python programs and that's actually where you can come to this little raw button over here and Wow, look at all of those commas now the big thing is the one thing I will note is Yes, this is going to be updated on a daily basis. And so What I've done is inside of our Current model I have taken a version of it that is only from March 22nd Prior so if you want to confirm me you want to double-check your data Make sure you're using the version that I've sent you However, the way you can think about this is that you now can go to this data set that John Hopkins has made available to the world and you can Build your own little trackers you can start to will work our way up to building some kind of visualization But for at least our sake you'll be able to Load in the real-world data real real-world data So just to at least kind of go through what are you going to be doing with this? So like I said, it looks like this and this is Great for processing, but it's not really good for using in a program And so the first process that you're going to need to do is you're going to need to load this into Python via the CSV Python library so Make sure to read that page and you are going to need to convert that Long amount of data into dictionaries. So quite literally let's say for example. I wanted to have an entry For Australia. Well, this would be what it looks like. I would have one Option inside of Australia that is going to have states the entire idea there is Certain countries do have states you can see France does So if they do you have to tell it say that this is true Then list out all of the state names Then for each one of those states as you can you know, this is France, but For each one of those states They should have a list with the the day-to-day confirmed cases of COVID-19 Now there are some states that don't have that so say for example Angola Angola does not have any states So what do we do there? I you can see that there are blanks And if you've seen this one there are blanks and there's Angola right there So what do I do in that case when you find those situations the state name is just going to be Angola So it can stay blank From there you're going to do Effectively to programs you're going to make a massive program where you are asking the user to Select an option either get the latest confirmed from a country or get a timeline of their data So the entire flow chart is kind of broken down. This should help you at least build your main program and As you can see you're going to be required to build Four library of four functions a main function a load data set function. This is what we'll be doing the Processing of the file into a dictionary the get latest confirmed where you're going to pass it that data set Pass it a country's name and potentially a state now I say potentially and you notice I say state equal none here What we're doing with this is we're actually giving it a default parameter the entire idea here is now I could do say for example get Australia get data set Australia Victoria, so I've said the data set the country and the state But again, there are some countries that do not have that and in that case get Data set Angola now all I have to do is say Angola and I can cut sort of well Cut the the The function so I'm only passing it two parameters instead of the full three And so the same thing will happen with your fourth function get timeline same kind of concept what you should be returning is a function or sorry a list of Numerical numbers for That in particular region country state, etc. You will need to go through and build some tests You are going to be required. Where are they? You are required to develop ten test cases Based off of at least five countries so pick five other countries in the world that I have not used in this example and Three of those must have states, so I am going to make you do both of them From there you can continue to test them and make sure that you are confirming what you see That's about it. So with that again as always if you have questions make sure to post them And with that let's get into lecture one