I have an example data as below:
datetime x y
2021-05-01. 25. val1
2021-05-02. 50. val2
2021-05-03. 100 val3
2021-05-04. 25. val4
2021-05-05. 100. val5
2021-05-06. 50. val6
I would like to create a new column calle z which maps 25 to low, 50 to medium and 100 to high with the expected output shown below:
datetime x y. z
2021-05-01. 25. val1. Low
2021-05-02. 50. val2. Medium
2021-05-03. 100 val3. High
2021-05-04. 25. val4. Low
2021-05-05. 100. val5. High
2021-05-06. 50. val6. Medium