search

alexanderquispe / Diplomado_PUCP

This repository is for the Intensive Python Course at PUCP
36 stars 64 forks source link

Assignment 8 #161

Open anzonyquispe opened 2 years ago

anzonyquispe commented 2 years ago

Dear all,

  1. Each group must create their branch named group_#_ass_8_2022 (group_1_ass_8_2022) and save their results in the Assignment_8 folder. Name your JN like your branch.
  2. Import the data located at this link. This dataset comes from this link. It has information on all the geolocated health establishments in Cajamarca.
  3. Import the district's centroids data. It has the latitude and longitude of every district in Peru.
  4. Use these datasets and find the closest health establishment to Cajamarca district centroids. Use euclidian distance between points. DO NOT USE GOOGLE API. IT WILL BE VERY EXPENSIVE For each district, there should be only one health establishment.
  5. Use Google API Directions to find the driving travel time and distance from health establishments to district centroids. Set driving as the value of the parameter mode and Monday 4pm as departure_time. Include information on the three options of the traffic_model variable: best_guess, pessimistic, and optimistic. The final data frame output should look like the table below:
id_eess codigo_renaes categoria nombre diresa red direccion longitud latitud id_ubigeo UBIGEO CCDD NOMBDEP CCPP NOMBPROV CCDI NOMBDIST CAPITAL District Dist_Centroid_Latitude Dist_Centroid_Longitude travel_time_best_guess travel_time_pessimistic travel_time_optimistic travel_distance_best_guess travel_distance_pessimistic travel_distance_optimistic

Plot the following graphs using the final data frame:

  1. Make a histogram of travel time colored by hue = traffic_model (best_guess, pessimistic, and optimistic) for each Province..
  2. Make a histogram of travel distance colored by hue = traffic_model (best_guess, pessimistic, and optimistic) for each Province.
  3. Bar plot of the mean travel distance by Province colored by hue = traffic_model (best_guess, pessimistic, and optimistic). The x-axis should be the name of the Province.
  4. Bar plot of the mean travel time by Province colored by hue = traffic_model (best_guess, pessimistic, and optimistic). The x-axis should be the name of the Province. 10 .Make plots 10 and 11 in just one figure. Hint: Use catplot. Use this data for the following plot.
  5. Make a count plot of the number of health establishments by Department colored by hue = categoria. The x-axis should be the Department Name.
Apg91 commented 2 years ago

Hello Anzony,

I was wondering if, like in some of the past assignments, there was a reference of how our final maps should look like.

Thank you, Andrés

ReinerCruz commented 2 years ago

Dear Anzony, I do not know if we could have a zoom meeting. Let me know to send you the link.

anzonyquispe commented 2 years ago

Hi Reiner Can we talk in 1.5 hours?

El vie., 28 de ene. de 2022 8:17 p. m., ReinerCruz @.***> escribió:

Dear Anzony, I do not know if we could have a zoom meeting. Let me know to send you the link.

— Reply to this email directly, view it on GitHub https://github.com/alexanderquispe/Diplomado_PUCP/issues/161#issuecomment-1024796567, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQWBIFBX4ZVKOXAN2ND2HTDUYM5ZRANCNFSM5MWQK3MA . You are receiving this because you authored the thread.Message ID: @.***>

ReinerCruz commented 2 years ago

Ok , Anzony, at 11 pm

anzonyquispe commented 2 years ago

@Apg91,

I hope It can works District image

Province image

Department image

Year - Dpto cases_year_dpt

Quarter Include 53 week in the last quarter cases_qrtr_dpt