creating Pandas DataFrame where each header column will have two sub columns

Question

The main columns headers will be Dates like 22-June, 23-June, 24-June. Each of these dates will have two sub columns Named "High" and "Low". Now there will be high value and low value in High column and Low column for each Date column. Please advice

Alexander · Accepted Answer · 2016-05-15 01:40:07Z

3

You can use from_product when creating a MultiIndex.

dates = ['2016-1-1', '2016-1-2', '2016-1-3']
cols = pd.MultiIndex.from_product([dates, ['High', 'Low']])

>>> pd.DataFrame(np.random.randn(1,6), columns=cols)
   2016-1-1            2016-1-2            2016-1-3          
       High       Low      High       Low      High       Low
0 -0.075206  0.464617  0.347055 -0.807486  0.871124 -0.375196

answered May 15, 2016 at 1:40

Alexander

111k32 gold badges212 silver badges208 bronze badges

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

2 Comments

user3117282 Over a year ago

Thanks a ton. It was a great help as I am new to pandas and was not aware of MultiIndex feature

Henrique Amaral Over a year ago

What About I want a custom date for each case? I cant do product

Collectives™ on Stack Overflow

creating Pandas DataFrame where each header column will have two sub columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related