Stack Overflow Statistical Analysis

• CSVs Folder has the following files:

  • questions.csv
  • answers.csv
  • comments.cv
  • tags.cv
  • answersReputationH.csv
  • questionsReputationH.csv
  • questionsReputationL.csv

• Queries Folder has the all the queries that we ran over the schemas:

  • QuestionsQuery.sql
  • AnswersQuery.sql
  • CommentsQuery.sql
  • AnswersQueryReputation.sql
  • QuestionsQueryReputation.sql

• Scripts Folder has 4 scripts written in R:

  • Plotting_Distributions.R -> Answers all the RQs except RQ7 (about tags)
  • Top_10_Tags_in_Questions_Answers_Comments.R -> Answer RQ7- Part 1
  • Top_10_Tag_in_Answers_UsersReputation.R -> Answer RQ7- Part 2
  • Top_10_Tag_in_Questions_UsersReputation.R -> Answer RQ7- Part 3

• In every script please make sure to change the PATH to the one which has all the CSVs files

• Make sure that Plotting_Distributions.R and Top_10_Tags_in_Questions_Answers_Comments.R are sharing the same workspace name