how to change string matrix to a integer matrix

Question

I have a voting dataset like that:

republican,n,y,n,y,y,y,n,n,n,y,?,y,y,y,n,y
republican,n,y,n,y,y,y,n,n,n,n,n,y,y,y,n,?
democrat,?,y,y,?,y,y,n,n,n,n,y,n,y,y,n,n
democrat,n,y,y,n,?,y,n,n,n,n,y,n,y,n,n,y

but they are both string so I want to change them to integer matrix and make statistic hou_dat = pd.read_csv("house.data", header=None)

for i in range (0, hou_dat.shape[0]):
    for j in range (0, hou_dat.shape[1]):
        if hou_dat[i, j] == "republican":
            hou_dat[i, j] = 2
        if hou_dat[i, j] == "democrat":
            hou_dat[i, j] = 3
        if hou_dat[i, j] == "y":
            hou_dat[i, j] = 1
        if hou_dat[i, j] == "n":
            hou_dat[i, j] = 0
        if hou_dat[i, j] == "?":
            hou_dat[i, j] = -1

hou_sta = hou_dat.apply(pd.value_counts)
print(hou_sta)

however, it shows error, how to solve it?:

Exception has occurred: KeyError
(0, 0)

Umar.H · Accepted Answer · 2020-05-21 15:34:48Z

4

IIUC, you need map and stack

map_dict = {'republican' : 2,
           'democrat' : 3,
           'y' : 1,
           'n' : 0,
           '?' : -1}

df1 = df.stack().map(map_dict).unstack()

print(df1)

   0   1   2   3   4   5   6   7   8   9   10  11  12  13  14  15  16
0   2   0   1   0   1   1   1   0   0   0   1  -1   1   1   1   0   1
1   2   0   1   0   1   1   1   0   0   0   0   0   1   1   1   0  -1
2   3  -1   1   1  -1   1   1   0   0   0   0   1   0   1   1   0   0
3   3   0   1   1   0  -1   1   0   0   0   0   1   0   1   0   0   1

edited May 21, 2020 at 15:34

answered May 21, 2020 at 14:46

Umar.H

23.1k7 gold badges50 silver badges94 bronze badges

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

6 Comments

4daJKong Over a year ago

Thanks again, but where do I add path?

4daJKong Over a year ago

hou_dat = pd.read_clipboard("house.data",sep=" ", header=None) is not correct

Umar.H Over a year ago

@4daJKong you can ignore that, that was only to reproduce your data from above.

4daJKong Over a year ago

but my data from a dataset, name "house.data", how to import that?

4daJKong Over a year ago

hou_dat = pd.read_csv("house.data", header=None) you mean adding pd.read_clipboard directly? under this?

|

Roim · Accepted Answer · 2020-05-21 14:45:11Z

0

If you're dealing with data from csv, it is better to use pandas' methods. In this case, you have replace method to do exactly what you asked for.

hou_dat.replace(to_replace={'republican':2, 'democrat':3, 'y':1, 'n':0, '?':-1}, inplace=True)

You can read more about it in this documentation

answered May 21, 2020 at 14:45

Roim

3,0762 gold badges14 silver badges27 bronze badges

Collectives™ on Stack Overflow

how to change string matrix to a integer matrix

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related