python pandas reading excel file

Question

I have a xlsx file which has headers in column A and values in columns B through Z. How do I use pandas to read the excel file so that it reads the column names from column A and fills those columns with values from columns B through Z.

Right now when I try to read the excel file it uses the top row value in columns A through Z as column names and uses the values in row second and on for filling the columns.

MaxU - stand with Ukraine · Accepted Answer · 2016-07-13 18:16:27Z

2

you can do it this way:

In [8]: df = pd.read_excel(fn, header=None, index_col=0).T

In [9]: df
Out[9]:
0  col1  col2  col3   col4
1     1    10   100   1000
2    11   101  1001  10001

Source Excel file:

answered Jul 13, 2016 at 18:16

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Collectives™ on Stack Overflow

python pandas reading excel file

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