Graphing Data from a Local Music Database

Operating Systems & Open Source Linux
1

I'm going to start this with a question about performing a specific function, but I'd like to leave it open to suggestions for other ways to generate graphs based on my music collection.

My first goal is to generate a bar graph with the x-axis representing year and the y-axis representing the matching number of albums.

My music directory contains folders organized like this:

%album artist% - %year% - %album%

So by performing

ls | grep -wc 2015

for example I could easily see the number of albums from 2015.

I'd like to know how to automate the process of creating a comma-separated list for each year from 1949-2015 that I can import into Excel to easily generate a bar graph. Something like this:

1949, 1
1950, 2
1951, 0
...
2013, 127
2014, 68
2015, 41

EDIT

This is as far as I've gotten. I created this bash script which outputs just the results to a file.

!/bin/bash

for i in seq 1949 2015;
do
ls /mnt/earth/v/Music | grep -wc $i >> ~/music.txt
done

2 
#!/bin/bash
for i in seq 1949 2015;
do
echo "$i", "$(ls /mnt/earth/v/Music | grep -wc $i)" >> ~/music.txt
done