Welcome to Deepnote

Run to view results

# Harris Visits import matplotlib.pyplot as plt import pandas as pd plt.bar(PivotDF['DOOR-OPEN'], PivotDF['Harris_frequency']) plt.title('Uses per Hour for Harris Pantry') plt.xlabel('Hour') plt.xticks(rotation=55) plt.ylabel('Number of Uses')

Run to view results

import matplotlib.pyplot as plt plt.bar(Spring2023['Month'], Spring2023['Count']) plt.title('Spring 2023 Uses per Month') plt.xlabel('Month') plt.xticks(rotation=55) # rename the months custom_labels = ['Jan', 'Feb', 'Mar', 'Apr', 'May'] plt.xticks(Spring2023['Month'], custom_labels, rotation=55) plt.ylabel('Number of Uses') plt.show()

Run to view results

import matplotlib.pyplot as plt plt.bar(Fall2022['Month'], Fall2022['Count']) plt.title('Fall 2022 Uses per Month') plt.xlabel('Month') plt.xticks(rotation=55) # rename the months custom_labels = ['Aug', 'Sep', 'Oct', 'Nov', 'Dec'] plt.xticks(Fall2022['Month'], custom_labels, rotation=55) plt.ylabel('Number of Uses') plt.show()

Run to view results

import matplotlib.pyplot as plt plt.bar(Fall2023['Month'], Fall2023['Count']) plt.title('Fall 2023 Uses per Month') plt.xlabel('Month') plt.xticks(rotation=55) # rename the months custom_labels = ['Aug', 'Sep', 'Oct', 'Nov', 'Dec'] plt.xticks(Fall2022['Month'], custom_labels, rotation=55) plt.ylabel('Number of Uses') plt.show()

Run to view results

-- Summer 2023 -- display frequency per semester -- https://academiccalendars.vcu.edu/AC_view.aspx?term=Fall+2023 SELECT LEFT(Date, 2) AS Month, COUNT(*) AS Count FROM( SELECT * FROM DF WHERE (Date BETWEEN '05/12/23' AND '08/21/23') AND (Status = 'DOOR-OPEN') )GROUP BY LEFT(Date, 2);

Run to view results

-- Counts for Fall, Summer, Spring 2023 SELECT "Month", SUM("Count") AS Total_Count FROM ( SELECT "Month", "Count" FROM Fall2023 UNION ALL SELECT "Month", "Count" FROM Summer2023 UNION ALL SELECT "Month", "Count" FROM Spring2023 ) AS CombinedData GROUP BY "Month" ORDER BY "Month" ASC;

Run to view results

# Fall, Summer, Spring 2023 trends import matplotlib.pyplot as plt plt.bar(All2023['Month'], All2023['Total_Count']) plt.title('2023 Uses per Month') plt.xlabel('Month') plt.xticks(rotation=55) # rename the months custom_labels = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'] plt.xticks(All2023['Month'], custom_labels, rotation=55) plt.ylabel('Number of Uses') plt.show()

Run to view results

The data presented in our dashboard shows the usage patterns and impact of the LRP pilot program for addressing food insecurity among people on VCU campus. We hope that this information can be used to improve the LRP program and help fight food insecurity on this campus and eventually campuses across the country. There is also room for further analysis when more data becomes available and as the program expands. We look forward to seeing future impact as this program grows because, as the data shows, the LRP plays a crucial role in combating food insecurity.