Ho to convert a column of object type to HexaDecimal

Question

Assume the below dataframe is having column "num" of 'object' type

The output of "print(df.dtypes)" is as:

Output:

 num       object

How to convert this object type column to Hex?

Expected Output: The output should be the same as the above mentioned 'df'. the type of the column 'num' should be changed to HEX.

I tried the below steps but not working:

df['num'] = [str(i) for i in df['num']]
df['num'] = [int(i,16) for i in df['num']]
df['num'] = [hex(i) for i in df['num']]

Expectation is that the 'num' column type should be change to Hex. everything else should be the same — SomeOne, Mar 18 '21 at 05:23
column type to hex?? these are all the available column types https://stackoverflow.com/a/29246498/6660373 I never saw hex type column. — Pygirl, Mar 18 '21 at 05:26

score 2 · Answer 1 · answered Mar 18 '21 at 05:32

2

In [391]: df['num'] = df['num'].apply(int, base=0)

In [392]: df
Out[392]: 
   num
0   17
1    3
2    5
3    4
4   26
5   29
6  130

answered Mar 18 '21 at 05:32

Mayank Porwal

score 1 · Answer 2 · answered Mar 18 '21 at 05:22

1

You can use apply:

df['num'] = df['num'].apply(lambda x: int(x, 16))

df:

answered Mar 18 '21 at 05:22

Pygirl

score 1 · Answer 3 · answered Mar 18 '21 at 05:51

1

from ast import literal_eval

df['num'] = df.num.map(literal_eval)

df

   num
0   17
1    3
2    5
3    4
4   26
5   29
6  130

answered Mar 18 '21 at 05:51

piRSquared

3 Answers3