News for hackers. Stuff that matters.
Re:Y Combinator Dataset Of Posts by xirium on Thursday April 24, 2008 @09:22PM (#173121)
Thank you. You may also want to mirror user data ( http://news.ycombinator.com/item?id=173045 ).
Re:Y Combinator Dataset Of Posts by mattjaynes on Thursday April 24, 2008 @10:19PM (#173172)
Re:Y Combinator Dataset Of Posts by palish on Thursday April 24, 2008 @10:34PM (#173183)
Re:Y Combinator Dataset Of Posts by xirium on Friday April 25, 2008 @03:05AM (#173381)
Thank you.

You also want to mirror the update utility ( http://news.ycombinator.com/item?id=173354 ).

Re:Y Combinator Dataset Of Posts by palish on Friday April 25, 2008 @03:22AM (#173393)
Re:Y Combinator Dataset Of Posts by petercooper on Friday April 25, 2008 @02:54PM (#173819)
If anyone wants to turn that user data into a CSV of username,age,karma, run this Ruby script in the folder with all the HTML files in it:

  Dir['*.html'].each do |user_file|
    user_data = File.read(user_file)
    user_name = user_file.chomp('.html')
    age = user_data[/created:<\/td><td>(\d+)/, 1]
    karma = user_data[/karma:<\/td><td>([\d\-]+)/, 1]
    puts "#{user_name},#{age},#{karma}"
  end
Re:Y Combinator Dataset Of Posts by petercooper on Friday April 25, 2008 @03:06PM (#173829)
Once you've done that, you can load it into Excel (or Numbers, or whatever) and play with sorting it, adding formulas, and what not. Only semi-interesting one I found was this:

Top users by "karma earned per day of membership":

            Username   Age Karma   K/A
  ------------------------------------
                 dhh     1    48    48
                  pg   563 17544    31
            oldgregg     3    87    29
               nickb   429 11672    27
                donw     3    52    17
                pius   210  2803    13
              edw519   428  5316    12
                 rms   427  5017    11
              drm237   271  2851    10
                 hhm   246  2475    10
             keating    10   103    10
                 sah    42   411     9
               freax     5    45     9
           further08     2    19     9
The ones who got their karma very quickly are the interesting ones to check out.