Print Excel Data/Values on to Matplotlib

Question

It starts from the row number 3

We currently do not have PowerBi, hence i am going for the Matplotlib which can extract the saved data from EXCEL and then plot it with Matplotlib

Here's the code which i have written, and i encounter a output wherein i am unable to proceed with any changes because of confusion:

import matplotlib.pyplot as plt

import xlrd

import pandas as pd

df = pd.read_excel('C:\CATS.xls', skiprows = 3)

x = plt.plot(['Mack Trucks'], ['Volvo Construction Equipment'], ['Volvo Trucks'])


plt.ylabel('VOLVO GROUP')

plt.show()

Output

Request anyone who can help me here, i need the company brands to be in Y - AXIS and print the remaining values in the X-axis

The one provided by me is only my data, similarly i will have other 10 to 12 team mate data in it.

you didn't do a df.plot()

andreihondrari
– andreihondrari

2018-12-16 11:55:04 +00:00
Commented Dec 16, 2018 at 11:55 — andreihondrari
– andreihondrari, Commented Dec 16, 2018 at 11:55
pandas.pydata.org/pandas-docs/stable/visualization.html

andreihondrari
– andreihondrari

2018-12-16 11:55:47 +00:00
Commented Dec 16, 2018 at 11:55 — andreihondrari
– andreihondrari, Commented Dec 16, 2018 at 11:55
What is the error you are getting?

MattB
– MattB

2018-12-17 15:42:38 +00:00
Commented Dec 17, 2018 at 15:42 — MattB
– MattB, Commented Dec 17, 2018 at 15:42

MattB · Accepted Answer · 2018-12-17 15:47:05Z

1

You need to check the data you are trying to plot. What are the errors you are getting as the code doesn't seem to be calling the series (columns) from the dataframe correctly. You also import xlrd but don't use it (pandas can read excel files anyway).

For example a dataframe with 2 columns called 'xcol' and 'ycol' which are populated with values. In your example you are not referencing the dataframe in your call to plt().

To plot these you would call:

plt.plot(df['xcol'], df['ycol']) # note 'df['xcol']' not just ['xcol']
plt.show()

Also, you don't say what you are trying to plot from your data.

answered Dec 17, 2018 at 15:47

MattB

5603 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Print Excel Data/Values on to Matplotlib

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related