Write the data to your database tables in the location

Assignment Help Python Programming

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.

Reference no: EM133731024

Questions Cloud

Discuss importance of educating pregnant patients : Discuss the importance of educating pregnant patients, what signs and symptoms would you teach them to report?

Nursing in the med and surgical nursing course : Your students consist of 30 baccalaureate students at the Denver College of Nursing in the med/surgical nursing course.

Explain the teachers primary role when feeding toddlers : Name 3 ways to make mealtimes comfortable and pleasant for children. Explain the teacher's primary role when feeding toddlers.

Athletic teenager involved in automobile accident : Case study involves a 17-year-old athletic teenager involved in an automobile accident resulting in him obtaining a physical-motor disability.

Write the data to your database tables in the location : In the database, create another table called Location. Write this data to your database tables in the Location and Precipitation tables.

Monoamine oxidase inhibitor for depression : A client is prescribed a monoamine oxidase inhibitor (MAOI) for depression.

Which nursing interventions would be beneficial to client : A client reports irregular menses, weight gain, and difficulty in conceiving. Which nursing interventions would be beneficial to this client?

Advocate for equal access to electronic technologies : Identify and discuss these implications and propose ways that social workers can advocate for equal access to electronic technologies.

How the main themes intersect with the thesis : The second section is a critical summary of the text. Herein you engage the thesis of the writer, showing how the main themes intersect with the thesis.

User Account

All Pages