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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Acura[/TD]
[TD]0.01186[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aston Martin[/TD]
[TD]0.004237[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Acura [/TD]
[TD] (( should be code for Acura))[/TD]
[/TR]
[TR]
[TD]Aston Martin[/TD]
[TD]((Code for Aston Martin))[/TD]
[/TR]
[TR]
[TD]Aston Martin[/TD]
[TD]((Code for Aston Martin)) [/TD]
[/TR]
[TR]
[TD]BMW[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]Cadillac[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chevrolet[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chrysler[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.