Convert a pandas column with lists of floats to a column with lists of ints

Question

I have the following pandas dataframe with distance column as a lists of floats.

   event  type    distance
0  5      open    [59235.1953125, 34893.48046875, 35969.94921875]
1  3      open    [67613.8828125, 49029.328125, 85592.8828125]
2  2      close   [2827.9968261719, 1665.8785400391, 1717.271240]

How can I convert the distance column to have lists of ints?

   event  type    distance
0  5      open    [59235, 34893, 359670]
1  3      open    [67614, 49029, 85593]
2  2      close   [2828, 1666, 1717]

Quang Hoang · Accepted Answer · 2020-11-13 15:59:16Z

4

Just a loop/apply:

df['distance'] = [[round(y) for y in x] for x in df['distance']]

edited Nov 13, 2020 at 15:59

answered Nov 13, 2020 at 15:57

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tom Ron · Accepted Answer · 2020-11-13 15:58:32Z

2

Use pandas apply -

df['distances'] = df['distances'].apply(lambda x: [round(y) for y in x])

answered Nov 13, 2020 at 15:58

Tom Ron

6,2413 gold badges28 silver badges43 bronze badges

Comments

Ruthger Righart · Accepted Answer · 2020-11-13 17:26:36Z

1

There is another way to do it. Note that solutions using list comprehension are (often) considered to be better practice.

Create a function:

def make_integer(dat):
    return(list(map(int, dat)))

The created function is used in another map function:

df['distance2'] = list(map(make_integer, df['distance']))

answered Nov 13, 2020 at 17:26

Ruthger Righart

4,9692 gold badges32 silver badges35 bronze badges

Collectives™ on Stack Overflow

Convert a pandas column with lists of floats to a column with lists of ints

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related