California Grants Portal Data Set EDA

[akhaleghi]

Overview

We want to analyze the California Grants Portal Dataset to determine the feasibility of building a tool for public use.

Action Items

• [x] Perform exploratory data analysis [EDA] on the Grants Portal dataset.
  • [x] See EDA section of tutorial here
• [x] Attach findings (write-ups, notebooks, etc.) to this issue.

Resources/Instructions

California Grants Portal Website Data Analysis tutorial with EDA instructions

[jossus657]

California_Grants_Dataset_EDA.pdf

[jossus657]

CaliforniaG… (auto-x 2) - JupyterLab.pdf

[jossus657]

Updates (8/18):

• analysis on money per grant by agency
• crated csv files for cleaned datasets
• binary columns created for each unique category

[akhaleghi]

Hey @jossus657, how is your EDA coming along?

[jossus657]

Hi! I'm pretty much done with all of the goals I set with my second notebook. I presented last week but forgot to update here, sorry. I'm looking forward to more feedback and direction next meeting!

Updates (8/25):

• Explored distinction between loans and grants
• Polished binary column creating function
• Wrote function to explore grants' descriptions using keyword analysis

[akhaleghi]

Hey @jossus657 could you attach the latest updates you presented last night to this issue?

[jossus657]

Updates 9/15;

• created keyword analysis function using yake
• analyzed which two columns were most statistically similar in terms of their keyword analyses

[jossus657]

Updates 9/29:

• Started presentation to convey results of the EDA in an accessible and concise way

[jossus657]

Updates 10/13:

• Presentation completed: https://docs.google.com/presentation/d/1TL-M1Nsd0WnMkY_ThLH7hS3ibXWFCo6bjW6n43lMsA4/edit?usp=sharing