Re: Community renewal and project obsolescence

["M. Zhou" <lumin@debian.org>]

Thanks for sharing the figure. The data seems correlated with the

number of new Debian accounts. See the figure below:

Python Code for this figure:

```

# modified from ChatGPT.

# XXX: members.csv is copy-pasted from https://nm.debian.org/members/

import pandas as pd

import matplotlib.pyplot as plt

df = pd.read_csv('members.csv', sep='\t')

df = df[df['Since'] != '(unknown)'] # filter out invalid data

df['Since'] = pd.to_datetime(df['Since'])

df['Year'] = df['Since'].dt.year

account_counts = df['Year'].value_counts().sort_index()

smoothed_counts = account_counts.rolling(window=3).mean()

plt.figure(figsize=(10, 6))

plt.bar(account_counts.index, account_counts.values, color='skyblue')

plt.plot(smoothed_counts.index, smoothed_counts.values, color='orange', label=f'Smoothed (Window=3)')

plt.xlabel('Year')

plt.ylabel('Number of Accounts Created')

plt.title('Number of Accounts Created Each Year')

plt.legend()

plt.savefig('nm-year.png')

```

On Wed, 2023-12-27 at 21:12 +0100, Rafael Laboissière wrote:

Dear Debian fellows,

This is a very simple-minded analysis about the Debian community (lack

of) renewal and project obsolescence:

https://salsa.debian.org/rafael/debian-contrib-years

containing interesting comments made by Sébastien Villemot.

Best,

Rafael Laboissière, DD