import pandas as pd
import matplotlib.pyplot as plt
file = pd.read_excel('/full/path/to/file.xlsx')
When you run this, you may get following error.
For mentioning the sheet number in the excel sheet import.
import matplotlib.pyplot as plt
file = pd.read_excel('/full/path/to/file.xlsx')
When you run this, you may get following error.
ImportError: Install xlrd >= 0.9.0 for Excel support
To proceed further, install xlrd package using
pip install xlrd or pip3 install xlrdFor mentioning the sheet number in the excel sheet import.
df =pd.read_excel('fileName.xlsx', sheet_name='Sheet4')
