Sample programs and data files to exercise Python and the xlwt module
Python
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
README
README.md
boston_corrected.txt
hospdata.txt
xlwt_bostonhousing.py
xlwt_hospdata.py

README.md

XLWT Examples from PythonExcels

This repository contains examples of Python scripts that generate Excel spreadsheets from other raw data.

xlwt_hospdata.py

This script reads some raw text containing account information for hospital, parses the account number and account name information, then writes the result to an excel spreadsheet using the XLWT module. A complete description of this script can be found at http://www.pythonexcels.com/2009/09/using-xlwt-to-write-spreadsheets-without-excel.

xlwt_bostonhousing.py

This script opens a URL to a tab delimited file containing location and pricing data on the Boston housing market. The data for this example is saved in this repository as boston_corrected.txt and comes from research done by David Harrison and Daniel L. Rubinfeld in "Hedonic Housing Prices and the Demand for Clean Air", published in the Journal of Environmental Economics and Management, Volume 5, (1978). The data is read, parsed and written to a spreadsheet using the XLWT module. a reads some raw text containing account information for hospital, parses the account number and account name information, then writes the result to an excel spreadsheet using the XLWT module. A complete description of this script can be found at http://www.pythonexcels.com/2009/09/another-xlwt-example.

boston_corrected.txt

This is a copy of the data read by the xlwt_bostonhousing.py script.

hospdata.txt

This is a copy of the data file read by the xlwt_hospdata.py script.