Encoding categorical data

[learningstatistics]

I encoded my nominal variables and I need to fill them out in a column. In other words, here is a table that shows a certain class and its corresponding code.

Acura	0.01186
Aston Martin	0.004237

<tbody>
</tbody>

I have 100 different types of cars in the table above with each car having it's own code.


I have a column that has data in this fashion and I need to fill out the code for the car (based on the table above). How do I do that?

Acura	(( should be code for Acura))
Aston Martin	((Code for Aston Martin))
Aston Martin	((Code for Aston Martin))
BMW	...
Cadillac
Chevrolet
Chrysler

<tbody>
</tbody>

If I use if functions this will take forever. What is the most efficient way of doing this?

 

[Aladin Akyurek]

In B2 enter and copy down:

=VLOOKUP(A2,CodeTable,2,0)

where CodeTable is a 2-column table like the upper exhibit you posted.

 

[learningstatistics]

Thanks for your reply.

I do it but I am getting #N/A for some of the classes I am searching for. Any suggestions?

 

[Aladin Akyurek]

Thanks for your reply.

I do it but I am getting #N/A for some of the classes I am searching for. Any suggestions?

Assuming that they do not exist in the CodeTable...

Either...

=IFNA(VLOOKUP(A2,CodeTable,2,0),0)

Or...

=IFERROR(VLOOKUP(A2,CodeTable,2,0),0)

 

[learningstatistics]

I used absolute reference for the code table and it solved the problem.

Thanks Aladin Akyrek.

 

[Aladin Akyurek]

I used absolute reference for the code table and it solved the problem.

Thanks Aladin Akyrek.

You are welcome.