How to read merged excel column in python?

Question

Hello I want to read an excel file in python using pandas. Because later I want to add values that file. However I can not read it properly because I have merged columns ,every label consists of 2 column. I searched it but did't find anything usefull.

i know, but the label column is the problem, After "Tarix" column there are two unnamed columns, but they must be "Tarix" this name — Nihad Qurbanov
– Nihad Qurbanov, Commented Jun 20, 2020 at 9:49
I just tried with an excel document with merged rows but your function is working. It seems to be something about the document. But I'm happy that the awnser works for you :) — EdKenbers
– EdKenbers, Commented Jun 20, 2020 at 10:09

Christian Eslabon · Accepted Answer · 2020-06-20 09:50:19Z

2

df = pd.read_excel(r'C:/Users/USER1/Desktop/report.xlsx')
df = df.reset_index()
df = df.drop(labels = df.filter(regex = 'Unnamed').columns, axis = 1)
df

answered Jun 20, 2020 at 9:50

Christian Eslabon

1854 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to read merged excel column in python?

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