search

joshmiller17 / foldit-view-data

Tools for exploring Foldit's view data.
MIT License
0 stars 1 forks source link

Write is_expert to db #16

Closed joshmiller17 closed 5 years ago

joshmiller17 commented 5 years ago

As #10 but for the options table, tracking whether the entry comes from an expert or not. Two ways to determine is_expert:

lee-vivian commented 5 years ago

As #10 but for the options table, tracking whether the entry comes from an expert or not. Two ways to determine is_expert:

  • Using the first row of the experts.csv file, which is sorted by the composite key of (uid, pid, timestamp) concatenated. All entries in this file describe experts
  • Using the get_all_experts function directly, or copying/modifying that code

I believe experts.csv only has two columns (uid, num highscores associated with that uid), which is sorted by the num highscores, and does not contain the pid or timestamp (unless the comment is referring to something else that I'm missing)

joshmiller17 commented 5 years ago

Ah, you are correct. This should in fact make it easier to figure out experts, as it looks like you've already done.