Create a Dataframe from an excel file

Question

I want create a Dataframe from excel file. I am using pandas read_excel function. My requirement is to create a Dataframe for all elements if the column matches some value.

For eg:- Below is my excel file and I want to create the Dataframe with all elements that has Module equal to 'DC-Prod'

Exccel File Image

Does this answer your question? Reading an Excel file in python using pandas — Soumendra Mishra
– Soumendra Mishra, Commented Sep 27, 2020 at 12:06

user13212784 · Accepted Answer · 2020-09-27 09:58:09Z

1

Welcome, Saagar Sheth!

to make a Dataframe, just import "pandas" it like so...

import pandas as pd

then create a variable for the file to access, like this;

file_var_pandas = 'customer_data.xlsx'

and then, create its dataframe using the read_excel;

customers = pd.read_excel(file_var_pandas,
sheetname=0,
header=0,
index_col=False,
keep_default_na=True
)

finally, use the head() command like so;

customers.head()

if you want to know more just go to this website!

Packet Pandas Dataframe

and have fun!

answered Sep 27, 2020 at 9:58

user13212784

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

3 Comments

Saagar Sheth Over a year ago

Hi Ron, Thanks for the reply. However if you could please refer the snippet of excel file as my requirement is not just creating a dataframe but reading all the row which will have the value in Module column as 'DC-Prod'

user13212784 Over a year ago

maybe this would help; pandas.pydata.org/pandas-docs/stable/reference/api/…

Saagar Sheth Over a year ago

Thanks but i have already checked the pandas documentation. Not much help

Collectives™ on Stack Overflow

Create a Dataframe from an excel file

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related