cns-iu / agc2-jobs Goto Github PK

Complete onboarding Documentation

https://docs.google.com/document/d/11bJf7rtN01zoorGgh3BF2TpAKtTjZEJAV-nP_Jmja8I/edit?usp=sharing

Create histograms to figure out natural breaks of 'high' areas across all three, in only two, and in only one.

Review the AGC2 proposal

https://iu.app.box.com/folder/77647776530

• Look at trends Nationally
• Work with Anurag on Normalization

Olga and Mike will check if STATA is available on CNS server

Created initial visualizations. Need to go through and clean up, as well as accompanying explanatory information.

Add to https://github.com/cns-iu/agc2-jobs/wiki#data
Each dataset will have its own wiki page with links and field descriptions

Review and download notebooks

• EDA analysis article https://towardsdatascience.com/a-gentle-introduction-to-exploratory-data-analysis-f11d843b8184
• EDA Notebook 1 - https://github.com/mrdbourke/your-first-kaggle-submission/blob/master/kaggle-titanic-dataset-example-submission-workflow.ipynb
• EDA Notebook 2 - https://github.com/dformoso/sklearn-classification/blob/master/Data%20Science%20Workbook%20-%20Census%20Income%20Dataset.ipynb

You can search for other EDA Notebook template ideas adn also add yours

Modify and Propose a template for our project

Initial set up of columns and tasks

https://public.tableau.com/profile/esm.4784#!/vizhome/ChoroplethComparisonChangeinMortalityandPrescriptionRates2006-2016/GeographicComparison

@obscrivn Do you think this is along the lines of what Kosali wanted?

Olga, Anurag, and Esmé meet to get set up for using Carbonate and Stata

bi-weekly meeting with Katy, Kosali, Coady and Olga

https://mc.manuscriptcentral.com/acij

set up a template

April 15, 2019 – Submissions due

Complete onboarding documentation

https://docs.google.com/document/d/18PIaXsxz7HLZ2xkWV9k-oFBe57awWVPEntSt7yLpAVE/edit?usp=sharing

Instructions on how to use kanban board

• Click + and create a new card
• Give your card a name
• Press the ? key to see available keyboard shortcuts
• Click on ...[three dots]
• Select convert to issue
• Add description
• Save
• Click on the issue, assign to your self and/or others
• Move to a different column based on the progress

After investigating options decided to install GitKraken instead.

When doing this, include calculations for total change (eg, 2016 Prescription - 2006 Prescription). Also working to include the annual change for both mortality and prescription. We only have enough data to calculate for 2007 to 2016 (eg, I'm defining change for 2016 to be the increase from 2015).

2017 County level prescription data is available:
https://www.cdc.gov/drugoverdose/maps/rxcounty2017.html
Not sure how this was gotten in the past -- hand compiled or is there a tool available?

We can get data from CDC Wonder for 2017 mortality rates as well, but not sure what settings were originally used for downloading.

https://public.tableau.com/views/DashboardOpioidPrescriptionandMortality2006-2016/Dashboard1?:embed=y&:display_count=yes&publish=yes

Work with Leonard to create cohesive color palette across the project.

• Prescription rates - Diverging Colors
• Death rates - Quantitative, non-diverging
• Jobs all versus Jobs in healthcare - We have ~21 job categories that we need a color palette for. This is going to be very hard to differentiate between the different job categories no matter what, I'm not sure what the best approach here would be.
• Training all versus Healthcare training; At least two to differentiate between healthcare and non-healthcare. If we also want to differentiate within healthcare training opportunities we may need more -- Olga?
• Addiction treatment centers; Not sure on this one -- Olga?

Need to finalize DS talk for Bledi's visit

Looking at the above and below (I copied the schedule) I would say that the following dates are available for a 10:30 am talk.

1/18/19

The following dates are available for a 10:00 am talk.

2/8/19
4/5/19
4/12/19
4/19/19
4/26/19

However, you could have a talk at from 11:30- 1:00 pm on the following dates.

2/22/19
3/1/19
3/22/19