Using the Canopy Data Import Tool

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 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.

Useful Links:

Data Import Tool product overview

Known Issues with the Data Import Tool

To get started, and for a walkthrough of the provided examples, we encourage you to browse the Data Import Tool online documentation.

 

FAQ:

  • 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.
Have more questions? Submit a request

Comments

Powered by Zendesk