How to get values from first column of excel file as array?

Question

Hi I want to get values from first column of excel file as array.

Already I wrote this code-

import os
import pandas as pd

for file in os.listdir("./python_files"):
    if file.endswith(".xlsx"):
        df = pd.read_excel(os.path.join("./python_files", file))   
        print(df.iloc[:,1])

What i got in output now

0       172081
1       163314
2       173547
3       284221
4       283170
         ...
3582    163304
3583    160560
3584    166961
3585    161098
3586    162499
Name: Organization CRD#, Length: 3587, dtype: int64

What I whish to get

Can somebody help? Thanks :D

Antoine Delia · Accepted Answer · 2021-02-06 19:53:04Z

3

You will just need to use the tolist function from pandas:

import os
import pandas as pd

for file in os.listdir("./python_files"):
    if file.endswith(".xlsx"):
        df = pd.read_excel(os.path.join("./python_files", file)) 
        print(df.iloc[:,1].tolist())

Output

edited Feb 6, 2021 at 19:53

answered Feb 6, 2021 at 19:47

Antoine Delia

1,8456 gold badges30 silver badges45 bronze badges

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

1 Comment

Adam Szymański Over a year ago

This is exactly what I was looking for :D Thanks a lot

Rafael Valero · Accepted Answer · 2021-02-06 19:48:58Z

1

As an array:

df.iloc[:,1].values

As a list:

df.iloc[:,1].values.tolist()

answered Feb 6, 2021 at 19:48

Rafael Valero

2,84623 silver badges29 bronze badges

Collectives™ on Stack Overflow

How to get values from first column of excel file as array?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related