Reference no: EM133731024
Homework: Python- The International Space Station Location Project
For this homework, we are going to utilize an open API to get information about the International Space Station location.
Directions:
1. Use the API documentation at this site your API request
2. Find out the current location of the ISS and print it to the console
3. Find out the names of the current residents of the ISS and print it to the console
4. Find out the timestamp of the next 5 times the ISS will pass over Ankeny, IA (You'll need to determine the lat/long for Ankeny to do this)
5. Print these timestamps in the console
6. Your outputs should be formatted to answer the questions. This needs to be beyond just printing the json to the console.
Directions:
1. After importing the data integration module create a database called weather_tracking
2. In the database, create a table called Precipitation
a. The table should have the columns: location (foreign key to county in Location table), date (text), precipitation (float), precip_type(text)
3. In the database, create another table called Location
a. The table should have the columns county (primary key)(text), state (text)
4. Output the database information in the console with your program (table names and column names)
Using the database structure created in the previous homework, populate the database with some information.
Directions:
1. Gather weather data from at least two different counties for a range of 30 days
2. Import this data into your program
3. Write this data to your database tables in the Location and Precipitation tables
4. Now bring this data back into your program to create a visual of the precipitation data
Continuing to use your existing database, let's make some changes to it:
Directions
1. Create a copy of your database (You can do this in Python or whatever way you prefer)
2. If you used inches for your original precipitation, read them in from your database and replace them with millimeters. Do the opposite if you started with millimeters.
3. Make the date on each of your readings 1 day earlier (because you realized the reading date was actually the day after the actual precipitation)
4. Delete one of your cities and all of the data associated with it.