"Godot's funding over time" code

gd_funding_plots.py

import pandas as pd
import matplotlib.pyplot as plt

# I had it as an xlsx but converted to csv for github, hopefully it won't have issues
file_path = "~/Godot-Funding.csv"
df = pd.read_csv(file_path)

# Data "cleaning"
df['Year'] = df['Year'].astype(int)
df['Month'] = df['Month'].astype(int)
df['Day'] = df['Day'].astype(int)
# August is completely missing so I dropped the first month
df = df[(df['Year'] != 2023) | (df['Month'] != 7)]
df['Date'] = pd.to_datetime(df[['Year', 'Month', 'Day']])
df['Donors'] = df['Members'] + df['Sponsors']


### First plot ###
fig, ax1 = plt.subplots(figsize=(12, 6))
# Plot Income on the left y-axis
color = 'tab:blue'
ax1.set_xlabel('Date')
ax1.set_ylabel('Income', color=color)
ax1.plot(df['Date'], df['Income'], color=color)
ax1.tick_params(axis='y', labelcolor=color)
# Create a second y-axis for Donors
ax2 = ax1.twinx()
color = 'tab:red'
ax2.set_ylabel('Donors', color=color)
ax2.plot(df['Date'], df['Donors'], color=color, linestyle='--')
ax2.tick_params(axis='y', labelcolor=color)
# "Styling" and "fixes"
ax1.set_ylim([0, 65000])
ax2.set_ylim([0, 2000])
ax1.tick_params(axis='x', labelrotation=45)
plt.title('Income and Donors')
fig.tight_layout()
plt.show()


### Second plot ###
fig, ax1 = plt.subplots(figsize=(12, 6))
# End of month & diff data
df_monthly = df.resample('M', on='Date').last()
df_monthly['Income_change'] = df_monthly['Income'].diff()
df_monthly['Donors_change'] = df_monthly['Donors'].diff()
# Calculate bar positions (x-values)
bar_width = 0.35
index = range(len(df_monthly))
x_income = [i - bar_width/2 for i in index]
x_donors = [i + bar_width/2 for i in index]
# Plot Income change on the left y-axis as a bar chart
color = 'tab:blue'
ax1.set_xlabel('Date')
ax1.set_ylabel('Income', color=color)
ax1.bar(x_income, df_monthly['Income_change'], width=bar_width, color=color, alpha=0.7, label='Income Change')
ax1.tick_params(axis='y', labelcolor=color)
# Create a second y-axis for Donors change
ax2 = ax1.twinx()
color = 'tab:red'
ax2.set_ylabel('Donors', color=color)
ax2.bar(x_donors, df_monthly['Donors_change'], width=bar_width, color=color, alpha=0.7, label='Donors Change')
ax2.tick_params(axis='y', labelcolor=color)
# Set y-axis limits to align zeros
ax1.set_ylim([-6000, 8000])
ax2.set_ylim([-600, 800])
# Set x-axis ticks to match the original dates
plt.xticks(index, df_monthly.index.strftime('%Y-%m'), rotation=45, ha='right')
ax1.tick_params(axis='x', labelrotation=45)
# Add a title and show the plot
plt.title('Monthly Increase/Decrease of Income and Donors')
fig.tight_layout()
plt.show()

Godot-Funding.csv