Plot graph from Excel using Matplotlib
What I want to do in iPython Notebook are as follows:
1. read an Excel table and name it as 'hsif' in pandas
2. skip the first 6 rows from the Excel worksheet because my Excel table starts from row 7
3. make a new table called 'hsifNew' in iPython Notebook
4. such new table 'hsifNew' only shows part of the old table 'hsif'
-5.plot the column 'Close' of the new table 'hsifNew'
syntax used includes
1. pd.read_excel()
2. pd.read_excel(, skiprows=6)
3 & 4. hsifNew = hsif['ColA', 'ColB'... and so on]
5. plt.plot()
On this page of the site you can watch the video online Plot graph from Excel using Matplotlib with a duration of hours minute second in good quality, which was uploaded by the user clueple c 14 August 2016, share the link with friends and acquaintances, this video has already been watched 48,222 times on youtube and it was liked by 240 viewers. Enjoy your viewing!
