Pandas XLSX File Manipulation

1. Introduction

In this article we list all the functions in Pandas related to XLSX files, which are generated by Microsoft Excel software.

Before using Pandas to manipulate XLSX file, first you should install xlrd package either by pip or conda:

# pip install xlrd # pip
conda install -c anaconda xlrd #conda

2. Read XLSX file

We can set an ExcelFile object as the XLSX file IO engine:

xlsx_fid = pd.ExcelFile(path)

From this IO engine object, we can inquire some general information regarding to the XLSX file. For example, we can list all the sheet names:

xlsx_fid.sheet_names