Parsing a list and string into DataFrame header

Question

My code:

coins = ['dashcoin','litecoin','dogecoin','nxt']
pd.DataFrame(columns=['timestamp',coins])

I need a header with 5 different values, but my method create two, the first time stamp then the second 'coins' all in one header.

timestamp     dashcoin   litecoin   dogecoin    nxt

How can we separate like pd.DataFrame(columns=coins)

Anton Protopopov · Accepted Answer · 2016-02-05 10:58:18Z

1

You could wrap your string to list with [] and then use + operator with your coins:

res = pd.DataFrame(columns=[['timestamp'] + coins])

In [148]: res
Out[148]:
Empty DataFrame
Columns: [timestamp, dashcoin, litecoin, dogecoin, nxt]
Index: []

Or with one list:

new_coins = ['timestamp'] + coins
res = pd.DataFrame(columns=new_coins)

In [152]: res
Out[152]:
Empty DataFrame
Columns: [timestamp, dashcoin, litecoin, dogecoin, nxt]
Index: []

answered Feb 5, 2016 at 10:58

Anton Protopopov

31.9k13 gold badges93 silver badges96 bronze badges

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

Collectives™ on Stack Overflow

Parsing a list and string into DataFrame header

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related