Closed yuujinleee closed 3 years ago
This file is also at src/test/resources/testMultiple.csv The expected value is retained from excel
src/test/resources/testMultiple.csv
GENRE,OCCUPATION,EXPECTED Action\|Adventure\|Fantasy\|Sci-Fi,retired,3.97 Film-Noir\|Sci-Fi\|Thriller,technician,3.77 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Other,3.64 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Academic,2.83 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Artist,2.85 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Clerical,3.2 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Collegestudent,3.61 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Customerservice,3.11 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Doctor,1.86 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Executive,3 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Farmer,3 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Homemaker,NO_RATING_AVAILABLE Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,k-12student,3.8 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,lawyer,3.33 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,programmer,3.36 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,retired,NO_RATING_AVAILABLE Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,sales,4 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,scientist,3.6 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,self-employed,2 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,technician,3.15 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,tradesman,3.75 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,unemployed,3.5 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,writer,3.45
NO_RATING_AVAILABLE
Please refer to the csv files in /src/test/resources
/src/test/resources
This file is also at
src/test/resources/testMultiple.csv
The expected value is retained from excelSingle Input List
Without SUM and COUNT info
With SUM and COUNT info
Multiple Input List
GENRE,OCCUPATION,EXPECTED Action\|Adventure\|Fantasy\|Sci-Fi,retired,3.97 Film-Noir\|Sci-Fi\|Thriller,technician,3.77 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Other,3.64 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Academic,2.83 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Artist,2.85 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Clerical,3.2 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Collegestudent,3.61 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Customerservice,3.11 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Doctor,1.86 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Executive,3 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Farmer,3 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,Homemaker,
NO_RATING_AVAILABLE
Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,k-12student,3.8 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,lawyer,3.33 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,programmer,3.36 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,retired,NO_RATING_AVAILABLE
Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,sales,4 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,scientist,3.6 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,self-employed,2 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,technician,3.15 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,tradesman,3.75 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,unemployed,3.5 Action\|Animation\|Children's\|Sci-Fi\|Thriller\|War,writer,3.45NO_RATING_AVAILABLE
here means there's no rating for the genre combination & occupation input