Gather song list by decade

readme.md

1. Get results for each year from:

• https://en.wikipedia.org/wiki/Billboard_Year-End_Hot_100_singles_of_1975

• http://billboardtop100of.com/1970-2/

• http://www.musicimprint.com/Chart.aspx?id=C000140

• Pop by year: http://tunecaster.com/years/year-end/top1970.html

• Rock by year (only after 1980): http://tunecaster.com/years/year-end/rock1997.html

2. Put results in vim and clean up
3. remove the chart rank in vim with: :%s/^\d* //
4. manually add a hyphen between track and artist
5. reverse track name and artist for tunecaster results using script below
6. concatenate year lists
7. order by artist, then track name for all year results and remove any exact match duplicates using script below
8. prefix lines with the year and a hyphen using vim (ctrl v)
9. merge all year lists into one decade list
10. run script below to sort decade list
11. manually remove any remaining duplicates selecting the earliest year
12. normalize artist names e.g.: Rolling Stones vs. The Rolling Stones
13. create a gather list using the script below

create_gather_list.rb

#!/Users/Alan/.rbenv/shims/ruby -w
output = ""
artists ||= []
tracks ||= []
File.open( File.expand_path(File.dirname(__FILE__),  'all.txt' ) ).each do |line|
  tracks << line
  artist = line.split(" - ")[1]
  artists << artist
end

records = Hash.new(0)

artists.each do |value|
  records[value] += 1
end

sortedRecords = records.sort_by { |artistname, count| count }

artisttracks ||= []
sortedRecords.reverse.each do |artistname, count|
  header = "#{count} - #{artistname}"
  puts header
  output +="#{header}\n"
  artisttracks = tracks.select { |a| a.split(" - ")[1] == artistname }
  artisttracks.each do |track|
    tracktext = "    #{track}"
    puts tracktext
    output += tracktext
  end
end

File.open("output.txt", 'w') { |file| file.write(output) }

order_tracks_by_artist_and_track_and_dedupe.rb

#!/Users/Alan/.rbenv/shims/ruby -w
Item = Struct.new(:artist, :track)
tracks = []
ARGF.each_line do |line|
    split = line.split(" - ")
    next if split[1].nil?
    tracks.push(Item.new(split[0], split[1].strip))
end
sorted = tracks.sort_by{|e| [e.artist, e.track]}
unique = sorted.uniq{|e| [e.artist, e.track]}
unique.each do |item|
    puts item.artist + " - " + item.track
end

sort_by_artist_and_track_for_decade.rb

#!/Users/Alan/.rbenv/shims/ruby -w
output = ""
Item = Struct.new(:year, :artist, :track)
tracks = []
ARGF.each_line do |line|
    split = line.split(" - ")
    next if split[1].nil?
    tracks.push(Item.new(split[0].strip, split[1].strip, split[2].strip))
end
sorted = tracks.sort_by{|e| [e.artist, e.track]}
sorted.each do |item|
    output += item.year + " - " + item.artist + " - " + item.track + "\n"
end
puts output

# File.open( File.expand_path(File.dirname(__FILE__),  'all.txt' ) ).each do |line|
File.open("sorted_decade.txt", 'w') { |file| file.write(output) }

switch_artist_and_track_name.rb

#!/Users/Alan/.rbenv/shims/ruby -w
# Reverses artist and track name for tunecaster results
output = ""

ARGF.each_line do |line|
    split = line.split(" - ")
    begin
        new_line = split[1].strip + " - " + split[0]
        output += "#{new_line}\n"
    rescue
    end
end

puts output