Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

What were the 20 questions? #6

Open
genolve opened this issue Jan 6, 2023 · 3 comments
Open

What were the 20 questions? #6

genolve opened this issue Jan 6, 2023 · 3 comments

Comments

@genolve
Copy link

genolve commented Jan 6, 2023

I'm new to sqlite so may be missing something. A dump of the tables gives:
[('survey',), ('generations',), ('images',), ('sqlite_sequence',), ('paths',), ('ratings',), ('upscales',)]
I look in ratings and find:
['sid', 'iid', 'rating', 'verified']
I match the sid to the id in the survey table which has:
['id', 'qid', 'rating']
I've sampled each table and do not see the questions that correspond to the qid in the survey table.

@ljy0ustc
Copy link

Hi, I have the same question with you. Have you figured out what are the columns mean for each table, especially for "ratings" (sid, iid, rating, verified)?

@genolve
Copy link
Author

genolve commented Mar 30, 2023

I believe the Survey table qid are not questions but these 20 images: https://github.com/JD-P/simulacra-aesthetic-captions#simulacra-aesthetic-survey
Used to detect user bias, e.g. if you were concerned with racial bias you'd weed out users who give a low rating to pictures 1 and 5.
As for the Ratings table, this is how I implemented it in my Pytorch reader near the bottom (SAC dataset) of this notebook: https://github.com/genolve/NIMA-pytorch-aesthetic-critic

@ljy0ustc
Copy link

Thanks a lot for answering! In my understanding, "ratings.sid" represents the user who scores the image. Moreover, I'm wondering that how to explain the same ("ratings.sid", "ratings.iid") have various "ratings.rating"s.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants