Free 7 Day Trial
Try the Data Import Tool in Canopy for FREE. See how.
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.
Once you have cleaned your data, you can take control of the underlying data frame. You can also export a Python (Pandas) script of the commands that you used, so that you can perform those same manipulations again.
With the Data Import Tool you can:
Click on any screen element below for expanded details
The DataFrame View is used to view the data and perform basic manipulations. Cells can be edited by double-clicking on them, with each cell’s editor corresponding to its column type. For example, a date/time column uses a time and calendar editor widget. Many transformations can be accessed by right-clicking on a column or row. The rest can be accessed through the Transforms menu.
As commands are executed they are logged in a visible command history stack. This allows you to see the exact steps that have been taken while you transform your data.
Commands in the command history can be enabled, disabled, or removed. These operations can be done to a command at any point in the history, and the other commands in the history will be reverted and re-executed accordingly to ensure that all commands are performed correctly.
Once you have completed your data cleanup, you can