|
Resurrecting an old thread because I've been playing around with the backend database as a way to practice some SQL skills (and put ChatGPT's coding skills to the test). If anyone has any ideas for analysis stuff you think would be interesting, drop them in here.
No promises on when or if I'll get to anything that you suggest, but I appreciate the fodder for things to think about. Don't worry too much about whether you think a question is answerable - that's part of the fun.
Examples of things that come to mind as stuff I might look at:
-What percentage of OG posters are still active today?
-How have participation rates in individual subforums ebbed and flowed over the years?
-How does the political leanings of the President impact the political leanings of who is active in DC? (This one will be tricky, and I might need a partner who has been a long-term DC participant help me categorize people. I think it's an interesting question, though.)
-What percentage of total posts in each forum come from that forum's top posters (e.g., how many people make up >50% of posts in each forum)?
|