I have a data frame of the form:
pd.DataFrame({
"key": [100, 2000, 100, 5],
"val": [1, 10, 2, 8]
})
I'd like to relabel key
values into 0, 1, 2, ... that is:
pd.DataFrame({
"key": [100, 2000, 100, 5],
"val": [1, 10, 2, 8],
"key2": [0, 1, 0, 2]
})
and know how to convert between key
and key2
, e.g. by a dictionary:
{
100: 0,
2000: 1,
5: 2
}
I know that I could create manually a function creating a dictionary from key
to key2
and apply it to the key
column, but I hope that there exists a pandastic approach.