How to read the excel column as list using python?

Question

Excel data: Input File(input.xlsx)

Column1      Column2  Column3  Column4 
one          two      three    four    
22/03/1997   six      7        eight

code

book = xlrd.open_workbook("input.xlsx")
sheet = book.sheet_by_index(0)

col = []

for i in range(1,sheet.nrows):
  col.append(str(sheet.row_values(i)))

But my code will print in row wise but i want to read data in column wise

Expected Output:

[[Column1,one,22/03/1997],[Column2,two,six],[Column3,three,7,],[ Column4,four,eight]]

stackoverflow.com/questions/45708626/…

Avinash Singh
– Avinash Singh

2019-04-05 11:11:41 +00:00
Commented Apr 5, 2019 at 11:11 — Avinash Singh
– Avinash Singh, Commented Apr 5, 2019 at 11:11

Alderven · Accepted Answer · 2019-04-05 11:43:14Z

1

You can use pandas:

import pandas as pd

df = pd.read_excel('file.xlsx', header=None)
result = [list(df[x].values) for x in df.columns.values]

Output:

[['Column1', 'one', '22/03/1997'], ['Column2', 'two', 'six'], ['Column3', 'three', 7], ['Column4', 'four', 'eight']]

edited Apr 5, 2019 at 11:43

answered Apr 5, 2019 at 11:28

Alderven

8,2885 gold badges28 silver badges42 bronze badges

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

Comments

Bharath · Accepted Answer · 2019-04-05 11:32:31Z

0

import xlrd
book = xlrd.open_workbook("input.xlsx")
sheet = book.sheet_by_index(0)
col = []
for i in range(0,sheet.ncols):
    col.append(str(sheet.col_values(i)))
print col

answered Apr 5, 2019 at 11:32

Bharath

1131 gold badge1 silver badge10 bronze badges

Collectives™ on Stack Overflow

How to read the excel column as list using python?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related