The Canopy Data Import Tool, new in Canopy 1.7, allows you to import and manipulate text data files in an easy, reproducible way. It is built on top of Pandas, providing an exploratory, graphical interface to data manipulation while still using a familiar Python representation of your data. When you are happy with how your data is being imported, you can take control of the underlying DataFrame from the IPython console in the Canopy Editor. You can also export your command history as a Python script so that you can perform those same manipulations again.
The Data Import Tool is available to commercial subscribers, and to free users for a single 7-day trial. The Canopy Welcome screen includes a button "Learn about the Data Import Tool", which you can use to watch an intro video, start your free 7-day trial, and (if you are a subscriber or have started your free trial) load and try several several bundled examples.
For a product overview of the Data Import Tool, please see https://www.enthought.com/products/canopy/canopy-data-import-tool/
For a list of known Issues with the Data Import Tool, please see https://support.enthought.com/hc/en-us/articles/208770616-Known-Issues-with-Data-Import-Tool
To get started, and for a walkthrough of these examples, we encourage you to browse the Data Import Tool online documentation.
* To parse data files with fixed column widths, set the DIT to both Fixed Width format and whitespace column separator.