Reading Excel File as an Array in Python via Pandas

Question

So basically I want to capture sheet as array.

Excel data[][]: A / B / C // D / E / F // G / H / Z //

I want from code to return -----> data[0][0]=A , data[2][1]=F and etc. Can you help me to achieve this via pandas in python.

It is not very clear what you expect. Have a look at pandas.read_excel — mozway
– mozway, Commented Jul 13, 2021 at 11:45
Does this answer your question? How to get read excel data into an array with python — AdityaSrivast
– AdityaSrivast, Commented Jul 13, 2021 at 12:46
So I basically want to make an array out of that sheet. And use that array in my code. It has to return my choose of cell like third row and second collumn----> [1][2] — denysdios
– denysdios, Commented Jul 14, 2021 at 9:14

denysdios · Accepted Answer · 2021-07-14 09:48:20Z

0

So I achieved to solve this with numpy arrays , thanks to everyone.

answered Jul 14, 2021 at 9:48

denysdios

12 bronze badges

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

2 Comments

denysdios Over a year ago

I used Pandas first to get data template, then I convert it as numpy array.

denysdios Over a year ago

this is my code while achieving this ; -------> import pandas as pd data = pd.read_excel(r'location_of_excelfodler/excel_name.xlsx', sheet_name='Sheet_name') bdb=data.to_numpy() print(bdb[0][1])

Collectives™ on Stack Overflow

Reading Excel File as an Array in Python via Pandas

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related