OpenRefine Tasks

[mbaguiar]

steam.csv

• [x] - Add attributes from other files: detailed_description, website
• [x] - Delete extra attributes
• [x] - Delete duplicates of categories (Multiplayer, Singleplayer)
• [x] - Transform numeric booleans into true and false
• [x] - Transform bucket intervals into enums (10-20 into 20)
• [ ] - Remove reviews of certain games
• [x] - Remove special characters (such as TM and such)
• [x] - Trim/Cut developers / publisher names on steam-store.csv. Some have "name, Ltd." or have even two names in the same row, keep only the first one or the things to the left of the separator.

steam_reviews.csv

• clean whites spaces and new lines

[pmscosta]

Regarding the last step (Trim / Cut): Some games have the following entry on the developer: "CINEMAX, s.r.o." - the expected output is CINEMAX. Other have Infinity Ward;Aspyr (Mac) - the expected output is Infinity Ward