¿How can I classify an object based on conditions?

andersson_morales19 · 2022-10-04T15:15:32+00:00

There was an error rendering this rich post.

Hello Community,

I have a dataset in which I have the course code, name and number of tools used. What I require is to be able to classify these courses by levels, which to be at level 1 must use at least 2 tools from an established list. To be level 2 you must use at least two tools from level 1 and three established for level 2.

Level 1 [Low]

 * News

 * Mail

 * Contents

 * Evaluations (Types of questions: Multiple choice, multiple answer, true and false)

Conditions: You must use at least two level 1 tools.

Level 2 [Medium]

 * Evaluations (Types of advanced questions).

 * Forums

 * Activities

 * Rubrics (online and face-to-face activities)

 * Class progress

Conditions: You must use at least two level 1 tools and three level 2 tools.

Level 3 [Advanced]

 * Groups

 * Intelligent Agents

 * Awards

 * Competencies.

Conditions: You must use at least one level 1 tool, three level 2 tools and one level 3 tool.

I tried to create a segment and add a CASE with several conditions, but this option does not work for me.

ANY HELP PLEASE.

THANK YOU

Find more posts tagged with

Accepted answers

All comments

RobSomers

@andersson_morales19 You're case when statement isn't working because of the waterfall. CASE WHEN statement go through each part of the statement and once a condition is met, it doesn't evaluate anything else. So in the case of your beast mode, if a row meets the 'Basico' condition, it assigns it as 'Basico' and won't evaluate it further, even if it meets other conditions in the statement. So level two and level three will always meet level one conditions, so as you have it right now, you'll never find level two and three, everything will just be level one. You would need to reorganize your case when statement to start with the conditions for level three, then level two, and end with level one. Hope that makes sense!

andersson_morales19

Hello @RobSomers,

Thank you very much for your help. Reviewing what you tell me I have proposed the solution as follows:

I have raised the AND - OR conditions based on the requirements of each level, I appreciate if you can help me.

Thank you so much.

RobSomers

@andersson_morales19 I would modify your statement further. Right now when you look at how many tools are used and you look at 'Basico', if they just used one 'cantidad _noticias' an that was it, they would qualify for Basico even though they only used one tool. For level one, does it have to be two different tools, or could it be two of the same (Ex: two 'cantidad_noticias' and nothing else)? This will determine how complex your beast mode will be.

andersson_morales19

@RobSomers

To rank at the [Basic] level you must use at least 2 tools, it doesn't matter if you use it at least 1 time.

The tools for level 1 are: News, content and questionnaires.

If a course uses at least one tool from the basic level, it would be advisable to classify it in the basic level even if it does not meet the conditions because the idea is that it does not remain unclassified. For a case that does not use any tools then it is classified [No Use].

Thank you very much for your help.

I apologize if my translation is not correct. 😳

jaeW_at_Onyx

@andersson_morales19 post a sample of your dataset please.

andersson_morales19

Hello @jaeW_at_Onyx ,

Niveles de uso [Pruebas].xlsx

I add this Levels of Use [Tests] dataset to analyzer and create a beast modes segment with the following conditions:

---------------------------------------

CASE

WHEN 'Básico'>=1 AND 'Medio'>=3 AND `cantidad_grupos`>=1 OR `cantidad_agentes_inteligentes`>=1 OR `cantidad_competencias`>=1 OR `cantidad_premios` THEN

'Avanzado'

WHEN 'Básico' >=2 AND `cantidad_foros` >=1 OR `cantidad_rúbricas` >=1 OR `cantidad_actividades` >=1 THEN

'Medio'

WHEN `cantidad_noticias` >= 1 OR `cantidad_contenidos` >= 1 OR `cantidad_cuestionarios` >=1 THEN

'Básico'

ELSE

'Sin Uso'

END

---------------------------------------

After creating the segment, I add it as a column so that the level of use can be classified.

The conditions for it to be classified must be the following:

Level 1 [Low]

* News

* Mail

* Contents

* Assessments (Types of questions: Multiple choice, multiple answer, true and false)

Conditions: You must use at least two level 1 tools.

Level 2 [Medium]

* Assessments (Types of advanced questions).

* Forums

* Activities

* Rubrics (online and face-to-face activities)

* Class progress

Conditions: You must use at least two level 1 tools and three level 2 tools.

Level 3 [Advanced]

* Groups

* Intelligent Agents

* Awards

* Competencies.

Conditions: You must use at least one level 1 tool, three level 2 tools, and one level 3 tool.

Thank you very much for your help.

jaeW_at_Onyx

@andersson_morales19 i think you need CASE and aggregation.

so something like

CASE

WHEN

count(column) + count(other_colum) <= 3

AND

count(column_3) + count(column_7) <= 3

THEN ...

WHEN

count(column) + count(other_colum) <= 3

AND

count(column_3) + count(column_7) <= 3

THEN ...

END