Loading...
Loading...
For more information on data and overall methodology, please see the `MWI Toolkit` page.

Loading...
For more information on data and overall methodology, please see the `MWI Toolkit` page.

Change weights to create your own Mental Wellness Index (MWI)!

Weights used in the Mental Wellness Index control the relative influence each measure has on the total MWI; higher numbers inidcate a higher influence. If you adjust the weights to 0, a measure has no influence on the MWI.

To adjust the weights in the Mental Wellness Index, follow the instructions below. If you want to add your own data to the MWI, go to the "Add Local Data to MWI" section. Note that data uploaded to this application is not kept -- it is deleted once you leave the page, including any processing done to it.

  1. Update weights for each measure in the table below as desired by doubleclicking the 'Updated Weights' column, then editing the measure to the desired amount (0 or a positive number). Click outside of that edited entry to lock it in. Note that weights do not need to add to 100 (they will be normalized, and have georgraphy/race stratification penalties applied, when the Custom MWI is calculated).

  2. Click 'Create Custom MWI' below. This will take some time.

  3. Once the custom MWI creation is complete, click 'Download Custom MWI' to download an .RData file with all of the needed information to view your MWI in this tool. Note: if you navigate away from this page, all processing will be lost! Nothing is stored within this application.

  4. To view your MWI, click the 'Custom MWI Upload' box under 'Explore States' or 'Explore ZIP Codes' and upload the downloaded '.RData' file. Once the file is fully loaded, click 'Upload' to see your Custom MWI results.




Download Custom MWI


              

Add Local Data to Mental Wellness Index (MWI)

To create your own Mental Wellness Index with your own local data, follow the instructions below to create your own MWI for your community below by adjusting weights and adding your own data and metadata. If you only want to adjust the weights in the MWI, go to the "Adjust MWI Weights" section. Note that data uploaded to this application is not kept -- it is deleted once you leave the page, including any processing done to it. However, if you would like to keep your data on your computer while creating the MWI, please see the "Add Local Data to MWI on Your Computer" section.

  1. Put each of your datasets in a CSV (comma separated value) format, with one column corresponding to the geographical ID of the data, a column corresponding to the numerator of the data, and another column corresponding to the denominator (if needed).
    • Accepted geographical ID types are always numeric and include the following:
      • ZCTA: 5 digit ZCTA (example: 35406)
      • County: 5 digit County FIPS Code (2 digits state code and 3 digit county code, example: 01001)
      • ZIP Code: US Postal Service ZIP Code (example: 35051)
      • Census Tract: 11 digit Census Tract FIPS Code (2 digits state code, 3 digit county code, and 6 digit tract code, example: 01001020100)
    • If a denominator column is provided, the final input to the MWI will be the numerator divided by the denominator, multiplied by the scaling number (specified in the metadata file, see next step).
    • Numerators and denominators must be numeric columns.
    • Missing data should have cells left blank.
    • If race stratified, there should be two columns: one ending in '_pop' corresponding to the overall population measure, and one ending in '_black' corresponding to the black populations measure. In the Metadata.xlsx file edit, that row's 'Preprocessed' column should be set to TRUE.

  2. Download Metadata.xlsx with the button below. If adding custom data, add a row and fill in information for each measure you want to add to the Mental Wellness Index. Descriptions for each column can be found in the 'Column Descriptions' sheet of the Metadata.xlsx. Note that all column names, with the exception of 'denominator', must be filled out.
    • If you have multiple measures in one file, add a row for each measure and its qualities, but specify the same file name.
    • If you would like to remove a measure in your MWI, either delete the measure row or set its weight to 0.
    • If you would only like to adjust weights, change only the weight column to the desired values. Note that penalties for race stratifications and geographic granularity are still applied and total weights are scaled to sum to 100.

  3. Upload your Metadata.xlsx and custom data files (if using) and click 'Create Custom MWI' below. Select multiple files by pressing ctrl/cmd and then clicking on each file in the file explorer box. Note: Do not have files open while uploading. This will take some time, depending on the amount of measures included.

  4. Once the custom MWI creation is complete, click 'Download Custom MWI' to download an .RData file with all of the needed information to view your MWI in this tool. Note: if you navigate away from this page, all processing and data will be lost! Nothing is stored within this application.

  5. To view your MWI, click the 'Custom MWI Upload' box under 'Explore States' or 'Explore ZIP Codes' and upload the downloaded '.RData' file. Once the file is fully loaded, click 'Upload' to see your Custom MWI results.


Download Metadata.xlsx

Download Custom MWI


              

Add Local Data to Mental Wellness Index (MWI) On Your Computer

If you want to keep your data on your computer, follow the instructions below to create your own MWI for your community by adjusting weights and adding your own data and metadata.

  1. Download free versions of R and RStudio. Download a modern browser (Firefox, Chrome, Edge, etc.) and make that your default browser if you haven't already.

  2. Go to the Mental Wellness Index GitHub page and download the repository by clicking "Code" in the top right corner, then clicking "Download ZIP" from the dropdown menu. This should download a ZIP file of the MWI repository into your downloads folder, called "hse-mwi-main.zip".

  3. Unzip "hse-mwi-main.zip".

  4. In the unzipped folder, open "app.R" in RStudio. This should open RStudio and the "app.R" script in the top left hand corner of the application.

  5. In the console window, which is in the bottom left hand corner, enter the following line and answer "yes" to all prompts in the console as you install these packages:
    • install.packages('readxl', 'writexl', 'htmltools', 'shiny', 'tigris', 'leaflet', 'RColorBrewer', 'sf', 'plotly', 'ggbeeswarm', 'shinyWidgets', 'sass', 'shinycssloaders', 'shinyBS')

  6. In the top right hand corner of the "app.R" window, you should see "Run App". Click the small downward arrow to the right of that and click "Run External". Then click "Run App".

  7. After a delay (this will be slow the first time, then quicker after that), the Mental Wellness Index Tool should open in your browser. Click on the "Create Your Own MWI" tab and follow the remaining steps to create your own MWI.

  8. If you are only adjusting weights for included data, skip the next step.

  9. Put each of your datasets in a CSV (comma separated value) format, with one column corresponding to the geographical ID of the data, a column corresponding to the numerator of the data, and another column corresponding to the denominator (if needed).
    • Accepted geographical ID types are always numeric and include the following:
      • ZCTA: 5 digit ZCTA (example: 35406)
      • County: 5 digit County FIPS Code (2 digits state code and 3 digit county code, example: 01001)
      • ZIP Code: US Postal Service ZIP Code (example: 35051)
      • Census Tract: 11 digit Census Tract FIPS Code (2 digits state code, 3 digit county code, and 6 digit tract code, example: 01001020100)
    • If a denominator column is provided, the final input to the MWI will be the numerator divided by the denominator, multiplied by the scaling number (specified in the metadata file, see next step).
    • Numerators and denominators must be numeric columns.
    • Missing data should have cells left blank.
    • If race stratified, there should be two columns: one ending in '_pop' corresponding to the overall population measure, and one ending in '_black' corresponding to the black populations measure. In the Metadata.xlsx file edit, that row's 'Preprocessed' column should be set to TRUE.

  10. Download Metadata.xlsx with the button below. If adding custom data, add a row and fill in information for each measure you want to add to the Mental Wellness Index. Descriptions for each column can be found in the 'Column Descriptions' sheet of the Metadata.xlsx. Note that all column names, with the exception of 'denominator', must be filled out.
    • If you have multiple measures in one file, add a row for each measure and its qualities, but specify the same file name.
    • If you would like to remove a measure in your MWI, either delete the measure row or set its weight to 0.
    • If you would only like to adjust weights, change only the weight column to the desired values. Note that penalties for race stratifications and geographic granularity are still applied and total weights are scaled to sum to 100.

  11. Upload your Metadata.xlsx and custom data files (if using) and click 'Create Custom MWI' below. Select multiple files by pressing ctrl/cmd and then clicking on each file in the file explorer box. Note: Do not have files open while uploading. This will take some time, depending on the amount of measures included.

  12. Once the custom MWI creation is complete, click 'Download Custom MWI' to download an .RData file with all of the needed information to view your MWI in this tool. Note: if you navigate away from this page, all processing and data will be lost! Nothing is stored within this application.

  13. To view your MWI, click the 'Custom MWI Upload' box under 'Explore States' or 'Explore ZIP Codes' and upload the downloaded '.RData' file. Once the file is fully loaded, click 'Upload' to see your Custom MWI results.


Download Metadata.xlsx

Download Custom MWI