Pandas load_table string to tuple conversion

Question

I use a lot of tuples in my data files as record keys. When I load a table from text the tuples are strings in the dataframe.

I convert to tuple now, using:

df['KEY'] = df['KEY'].map(lambda x: eval(x))

Is it possible to get the string evaluation automatically?

Luc

A slightly safer/better way is to use literal_eval. I don't think you will be able to do this automatically... — Andy Hayden
– Andy Hayden, Commented Jan 10, 2013 at 14:49
Are these all of the same length? Does it make sense to include each item in the tuple as a separate column? — Andy Hayden
– Andy Hayden, Commented Jan 10, 2013 at 15:21

Wes McKinney · Accepted Answer · 2013-01-11 16:39:05Z

4

You could use converters={'KEY': eval} to make things a bit simpler. It would be possible to add some more optimized version of this internally, too.

answered Jan 11, 2013 at 16:39

Wes McKinney

106k32 gold badges146 silver badges109 bronze badges

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

2 Comments

user1708646 Over a year ago

The suggestion of Wes does the trick, thanks, I will need this in almost all my pandas work...

Harikrishna Over a year ago

How do we use converters={'KEY': eval} in the code you have mentioned in the question.

Collectives™ on Stack Overflow

Pandas load_table string to tuple conversion

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related