Follow the steps below to replicate the study. The preprocessing results are available here.
- Run the queries from queries.sql in Google BigQuery.
- Download the results by clicking on
SAVE RESULTSand- for
BadgesselectCSV (local file) - for
CommentsandPostsselectCSV (Google Drive), wait for the transfer to complete and download from there
- for
- Rename the files to
badges.csv,comments.csvandposts.csvand place them into a directorydatanext topreprocessing.py.
- Use
python>=3.7 - Install required packages with
python -m pip install -r requirements.txt - Execute
python preprocessing.py
- Create a directory
results - Open
analysis.Rmdand run all chunks (t-test results and plots will be saved to./results)