how to use column value as index to a list in a dictionary.

[Hasham04]

I have a dictionary like this

dictionary={somekey:[v1,v2,v3,v4,v5,v6,v7]}

I want to assign values to a column based on the value of another column.

col1 col2
1 v2
1 v2
1 v2
1 v2

here 1 in col1 represents dictionary[somekey][1]

I have tried this.

df['col2']=df.func.where(df.col1=='1' #example,dictionary['somekey'][int(df.col1)],'')

this says the index of a dictionary cant be an expression which makes sense because columns are expressions, but still, need a way to do this.

Thanks in advance for any help.

[JovanVeljanoski]

I really don't understand what you are trying to do. Can you also use code formatting please?
Would the map method help?

[Hasham04]

Please let me know if I am still unclear. I appreciate your help.

[JovanVeljanoski]

I am sorry I want to help but I don't understand your case. Maybe somebody else understands it better.

[Hasham04]

Appreciate it regardless. Thanks you. I will play around with joins and post my findings here.

[maartenbreddels]

This would be a pure Python thing:

dict(zip(df.x.tolist(), df.y.tolist()))

But then I don't see a reason to use Vaex

[Hasham04]

hey Maarten. I was able to accomplish this using joins. thankyou for your response.