[FIXED] Convert Id type object to integer

Issue

I'm very new to python and i'm trying to do a project for college. The dataframe model is like this,

[Dataframe structure image]

I want to generate an integer value for each costumer_id, this new value being the new costumer_id, where the customer_id appears several times, I would like to convert this value to an integer, so that each time this Id appears it receives it, it always receives the same integer value.

I've tried some procedures so far, but it didn't work, one of them was

data['customer_id'] = data['customer_id'].rank(method='dense', ascending=False).astype(int)

But without success, is there any way to do this?

Solution

If you want to generate an integer value for each costumer_id :

1. store Unique values of the ID column into array array_ = df.ID.unique()
2. make a dictionary of this array d = dict(enumerate(array_) then exchange keys and values res = dict((v,k) for k,v in d.items())
3. and final step : map this dictionary with the id column df['newId'] = df['ID'].map(res)

Answered By - oussama Seffai