Pandas cannot use datetime in multiindex

Question

I spend lots of time try to insert data into pandas' DataFrame
but just cannot as I expected.
there are two index:
1. current_time
2. company_name

After I use data.ix[] to insert a row,
the Dataframe create another column (named by the company_name)
Can anyone give me some advice, please.

import pandas
data=pandas.DataFrame(columns=['Date', 'Name', 'd1'])
data.set_index(['Date', 'Name'], inplace=True)
now = pandas.datetime.now()
data.ix[now, 'ACompany'] = [1]

joris · Accepted Answer · 2016-02-17 09:40:01Z

1

To let pandas know the now, 'ACompany' are the levels of the index, you have to use some extra parantheses:

data.ix[(now, 'ACompany'), :] = 1

By just doing data.ix[now, 'ACompany'], pandas will by default try to interpret this as index=now, column='ACompany' (in the sense of .ix[rows, columns])

Further, it is recommended to use .loc instead of .ix if you want to index solely by the labels.

answered Feb 17, 2016 at 9:40

joris

140k37 gold badges258 silver badges207 bronze badges

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

1 Comment

Kevin Lo Over a year ago

Thanks a lot. It's really helpful.

Collectives™ on Stack Overflow

Pandas cannot use datetime in multiindex

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related