How to use pandas?#

Reading excel files#

I will be referencing the following sites:

  1. We will use Python 3 and Jupyter Notebook to demonstrate the code in this tutorial. In addition to Python and Jupyter Notebook, you will need the following Python modules:
    • matplotlib – data visualization
    • NumPy – numerical data functionality
    • OpenPyXL – read/write Excel 2010 xlsx/xlsm files
    • pandas – data import, clean-up, exploration, and analysis
    • xlrd – read Excel data
    • xlwt – write to Excel
    • XlsxWriter – write to Excel (xlsx) files