Plot data from Excel in Python

Question

The code I have to read and plot data from my excel file is this:

import pandas as pd
import matplotlib.pyplot as plt
excel_file = 'file1.xlsx'
file1 = pd.read_excel(excel_file)

file1.head()

plt.plot(x,y1,y2)

plt.xlabel('wavelenghts')
plt.ylabel('reflectivity')
plt.legend(loc='upper left')
plt.show

It works.

The questions are:

I have more columns, but when I want to add y3, y4,... I get the error that y3 is undefined.
In legend I want to change the name of y1 to CK4/5-PCA82500 and others as well. Is there any way to do it?

Gen · Accepted Answer · 2019-05-21 18:33:49Z

1

f, ax = figure()
plt.plot(file1.x,file1.y1,label='')
plt.plot(file1.x,file1.y2)
plt.plot(file1.x,file1.y3)
.....

plt.xlabel('wavelenghts')
plt.ylabel('reflectivity')
plt.legend(loc='upper left')
plt.show

answered May 21, 2019 at 18:33

Gen

4915 silver badges11 bronze badges

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

2 Comments

Yasamin Over a year ago

Thank you @gen. It worked. Do you if alo I can change the name of my legends in the figure?

Gen Over a year ago

You just need to change/add "label" in plt.plot() like I did in second row of codes

Collectives™ on Stack Overflow

Plot data from Excel in Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related