Loading Excel in Python – Some Basic Operations

A lot of structured data which are not too heavy still comes in Excel formats. This tutorial shows some the basic operations after of loading an Excel onto Python.

Loading an Excel file

Open a Sheet

Find the Number of Rows in Variable ‘data’

Find he Number of Columns in Variable ‘data’

Print the Column Headings in Variable ‘data’

Print Rows

Read Data as a List