Hi Team
I need some examples as to how to format raw data as being given below example, to be good readable data to a user.
// Raw unformatted data
2021/11/19;route_44f46f7a-0da7-4bbc-ae28-747d92643385 8
2021/11/20;route_cc4722b0-db3b-4732-9e5f-456325d59ffe 4
2021/11/12;route_03abae1a-7662-4a67-92a5-6a9649749fee 8
2021/11/08;route_68a711e1-440d-426c-a6e9-a119d98502d2 5
route_44f46f7a-0da7-4bbc-ae28-747d92643385 METRO;Politécnico - Pantitlán
// Expected output should be..
Pantitlán - Tacubaya Monday 7.89 Pantitlán -
Tacubaya Sunday 5.97 Pantitlán -
Tacubaya Tuesday 5.79 Pantitlán -
Tacubaya Wednesday 2.97 Pantitlán -
Tacubaya Thursday 2.0
Guest UserPosted Apr 6, 2022, 12:44 PM
Hi Muhammad
We this is my given rule below to clarify this more,
"We need to calculate average scores for each route, per day of the week. In other words, all the eligible scores for a Monday for a particular route needs to be added together and the average sentiment score must be calculated. This value must be rounded to 2 decimal places.
We have a hypothesis that values at the extremes of the scoring range are obscuring the real sentiment from commuters, therefore entries with an associated score of either 0 or 10 should be omitted from all calculations. "
// Result should be...
"The calculated scores for each route should be output, from highest to lowest, along with the day of the week."
Muhammad Imran AnsariPosted Apr 6, 2022, 12:28 PM