Reading and writing Excel files with Python
Microsoft Excel files are arguably the most widely used format to exchange data in a tabular form. In the newest incarnation of the XLSX format, Excel can store over one million rows and over 16 thousand columns in a single worksheet.
Getting ready
To execute this recipe, you will need the pandas module installed. No other prerequisites are required.
How to do it…
The following is the code to read the Excel file. Note that we assume the pandas module is already imported and aliased as pd (the read_xlsx.py file):
# name of files to read from and write to r_filenameXLSX = '../../Data/Chapter01/realEstate_trans.xlsx' w_filenameXLSX = '../../Data/Chapter01/realEstate_trans.xlsx' # open the Excel file xlsx_file ...
Get Practical Data Analysis Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
