The Canopy Data Import Tool 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 Canopy subscribers. The Canopy Welcome screen includes a button "Learn about the Data Import Tool", which you can use to watch an intro video, and (if you are a subscriber) load and try several several bundled examples.
To get started, and for a walkthrough of the provided 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.
- To use the Data Import Tool with Python 3.5 or 3.6 (in Canopy 2.1.3+), please install the latest version of the catalyst and pyqt packages in the Canopy Package Manager. Note that pyqt is licensed GPL; therefore to install it, the "enthought/gpl" repository must be enabled in Package Manager Settings.