index all rss twitter github linkedin email

Álvaro Ramírez

30 March 2019 Reading spreadsheets with python/pandas

Via Daily python tip, a snippet to read xls files in python. This will come in handy. Saving for future.

Get set up with:

pip install pandas
pip install xlrd

Read with:

import pandas
xlf = pandas.ExcelFile("sheet.xlsx")
print xlf.sheet_names
[u'my sheet']