Exception: cannot handle a non-unique multi-index

Question

I am trying to read a csv, add columns and then set values for each cell in the new columns. but I can the below error

 raise Exception("cannot handle a non-unique multi-index!")
Exception: cannot handle a non-unique multi-index!

My csv data does not have any index column, I don't know how add an incremental numeric index column to it.

I tried print("data.columns = ", data.columns) but I can see all of the columns are part of the index which is incorrect.

data = pd.read_csv( filename, names=colnames, header=None )
# data = data.drop(['datetime'], axis=1)
data[ "positive" ] = 0
data[ "negative" ] = 0
data[ "hate_speech" ] = 0
data[ "neither" ] = 0
data[ "count" ] = 0
data[ "class" ] = -1
print("data.columns = ", data.columns)
for j in range(0, data.shape[0]):
    tweet_set = set( str(data[ "tweet" ][ j ]).split() )

    pos_count = len(pos_set.intersection( tweet_set ))
    data.at[ j , "positive"] = pos_count

Please add the complete error message.

DYZ
– DYZ

2019-05-05 05:33:15 +00:00
Commented May 5, 2019 at 5:33 — DYZ
– DYZ, Commented May 5, 2019 at 5:33

J_H · Accepted Answer · 2019-05-05 17:39:46Z

1

You want to reset the index:

data.reset_index(inplace=True)

answered May 5, 2019 at 17:39

J_H

21.3k5 gold badges29 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

Exception: cannot handle a non-unique multi-index

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