Extracting Data from an Imported Excel File on Python

Question

I have been taking a course that shows how to use Seaborn and matplotlib on Jupiter in order to create various data visualization models. I also just learned how to import excel files into Jupiter but the problem I am having is that the data cannot be taken out of the excel file as it is not a data frame.

Does anyone know how to extract data from an imported excel file so that it can be used in data visualization? I appreciate any help.

Does this answer your question? How to convert a worksheet to a Data frame in Pandas? — Tomerikoo
– Tomerikoo, Commented Jun 11, 2020 at 9:47

Mazziotti Raffaele · Accepted Answer · 2021-01-08 06:45:30Z

1

You can use Pandas library. There is a method called pandas.read_excel that reads .xls files easily.

import pandas as pd
import seaborn as sns 
df = pd.read_excel('name.xlsx') # reads the excel file
sns.scatterplot(x="xvar",y="yvar",data=df) # creates a scatter plot with columns xvar and yvar

Then you can directly use pandas data frames to visualize data using seaborn library.

edited Jan 8, 2021 at 6:45

answered Jun 10, 2020 at 22:59

Mazziotti Raffaele

4215 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Extracting Data from an Imported Excel File on Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related