using python how to give 0, 1 , 2 for ternary variables?

Question

I have csv file, with column names of: PH, K, Zn, S, Fe ...so on. For each column there hare 3 different types of output, for example:

PH       S       Zn     Fe         Cu   Mn
Acidic   Low    Low     Medium  High    Medium
Alkaline High   Medium  Medium  High    High
Acidic  Medium  Low     Medium  High    High
Neutral High    Low     Medium  High    High
Acidic   Low    Low     Medium  High    High
Acidic   Low    Low     Medium  High    High
Acidic  Medium  Medium  Medium  High    High

I want to give values of

Acidic = 0, Neutral = 1, Alkaline = 2
Low = 0, Medium = 1, High = 2

How to write a code which is automatic convert Acidic=0 , Neutral=1 , Alkaline=2?

@CedricDruck, Oh, Okay, How to convert Low, Medium, High in terms of 0, 1, 2 ? is it possible? — Kiran Prajapati
– Kiran Prajapati, Commented Feb 20, 2017 at 6:46
I'd use dicts .. something like ph_dict = {'Acidic': 1, 'Neutral': 2, 'Alkaline': 3} — Cedric Druck
– Cedric Druck, Commented Feb 20, 2017 at 6:47
If you are working on some machine learning tasks and are using a library for that, scikit-learn and pandas have some inbuild functions for doing that. — Vivek Kumar
– Vivek Kumar, Commented Feb 20, 2017 at 7:07

Cedric Druck · Accepted Answer · 2017-02-20 07:15:55Z

3

Ok so something like

dicts = {
   'PH' : {'Acidic': 0, 'Alkaline': 1, 'Neutral': 2},
   'S': {'Low': 0, 'High': 1, 'Medium': 2},
   # etc
} 
with open(your_file) as file:
    table = []
    reader = csv.DictReader(file)
    for row in reader:
        new_row = {key: dicts[key][value] for (key, value) in row.items()}
        table.append(new_row)

answered Feb 20, 2017 at 7:15

Cedric Druck

1,0418 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Cedric Druck Over a year ago

Yes, that's actual Python code .. what's the question?

Kiran Prajapati Over a year ago

your_file means my file name is samplefile.csv so i have use with open (samplefile.csv) as file : ?

Cedric Druck Over a year ago

you have to use some sort of path to your file, yes. See docs.python.org/2/tutorial/…

Kiran Prajapati Over a year ago

and reader = csv.DictReader(file) so, here I have use file or something my path ?

Cedric Druck Over a year ago

no, file is the result of open(your_file), you just have to adapt the "your_file" variable

|

Community · Accepted Answer · 2017-05-23 11:46:41Z

1

Python provides the Enum class. Why you want to use Enums is covered here. In your case they would look something like:

Code:

from enum import Enum
PH = Enum('PH', 'Acidic Neutral Alkaline')
Concentration = Enum('Concentration', 'Low Medium High')

Demo Code:

print(PH['Acidic'].value)
print(Concentration['Medium'].value)

Produces:

1
2

Demo Code2:

for i in range(1, 4):
    ph = PH(i)
    concentration = Concentration(i)
    print(ph, ph.name, ph.value)
    print(concentration, concentration.name, concentration.value)

Produces:

PH.Acidic Acidic 1
Concentration.Low Low 1
PH.Neutral Neutral 2
Concentration.Medium Medium 2
PH.Alkaline Alkaline 3
Concentration.High High 3

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Feb 20, 2017 at 7:13

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

2 Comments

Kiran Prajapati Over a year ago

Can I use 1,2,3, numbers output for my next analysis using enum?

Stephen Rauch Over a year ago

Yes, the value is a number, see examples.

Collectives™ on Stack Overflow

using python how to give 0, 1 , 2 for ternary variables?

2 Answers 2

6 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related