"Original Address" http://blog.csdn.net/wangyaninglm/article/details/70188710
absrtact: We do the data analysis, the process of cleaning, many times will face a variety of data sources, to the different data sources for cleaning, warehousing work. Of course, Python this language, I prefer, the development of high efficiency, basically how to write can run, and the installation of simple configuration, basically a network of the environment Pip install all done, no net, the WHL package copy came over a line of command also resolved ( Windows python3.5 uses PIP to install the WHL package offline.
This blog is for the use of Python3 under the Windows platform (Python2 community will stop support, using 3 is the trend), read the data in the XLS,XLSX format to clean the library to do a small example.
Windows Python3 using CX_ORACLE,XLRD plugin for Excel data cleaning input