Exporting images and data

Visplore supports multiple ways of exporting information. The most important ones are exporting images, and exporting data tables to the Clipboard, as files, or to Python/R/Matlab.

To follow the examples, please load the Solar Power demo dataset and start the 'Trends and Distributions' Cockpit, as described in the beginning of the first lesson.

Export plots as image

It is possible to export every plot in Visplore as an image. For example, let's export a Time Series plot.

Click the button "Export" in the top right area of a plot. Then, select the option "Image export".

The dialog allows to change parameters of the image export:

Choose the target of the export. This can either be "Clipboard" (default) or "File".
Preview of the image to be exported in the full resolution.
Overview of the image, can be used to navigate in the full resolution preview.
Change parameters such as the resulting image size, visibility of parts of the diagram (e.g. the color legend), or other appearance aspects (e.g. the used font).

Note: Changes to these parameters are saved for the next time you export this plot again.

Confirm the export by clicking "OK" in the dialog.

By default, this results in the image being copied to the clipboard. The image can then be pasted into other applications, such as Microsoft Word or Excel, by using Ctrl + V.

Export data from plots (e.g. pivot tables)

Many visualizations in Visplore are essentially a data table, which can be exported. For example, pivot tables, bar charts, heatmaps, statistics overviews, correlation matrices, any many others.

Let's export a pivot table TODO HIER WARST DU Export the data of the displayed "Statistics" table to the clipboard and paste the resulting table into another application of your choice (e.g. Microsoft Excel):

Similar to the image export dialog, the data export dialog allows to change some parameters of the export:

Choose the target of the export. This can either be "Clipboard" (default) or "File".
Preview of the data table to be exported.
Change parameters of the export such as the format (e.g. the column separators), visibility of parts of the table (e.g. the diagram title), or other appearance aspects.

Export the data table

The currently selected data subset (i.e. the data in "focus") can be exported by pressing the "export" button in the focus bar, either to the clipboard, or to a file.

Export selected data to clipboard: By pressing the button in the title bar, the data records in focus are copied to the clipboard, in one of three ways. Then they can be inserted directly into tools such as Excel.

as indicator variable (0/1), marking data records in focus: This exports a single, new time series as a column that is as long as the entire table, but has a "1" value in those rows that are in focus (i.e. have been selected). For non-selected records, the indicator time series has a value of "0". This column can be inserted directly in tools such as Excel next to the original table, for example, to process the selection information further using formulas.
as indicator variable (0/1), plus time stamp and user-defined data attributes: In addition to the indicator time series, the respective time stamp (date/time) is written into a second column. Additionally, any user-defined data attributes such as named conditions, classifications, and predictions of trained regression models are exported.
data records in focus (all data attributes, including user-defined): The actual values of the selected times are exported in tabular form. Rows of the table are only the records in focus, columns are all data attributes that are available in the cockpit (i.e. variables, categories). Additionally, any user-defined data attributes such as named conditions, classifications, and predictions of trained regression models are exported.

For all three types, the order of the rows corresponds to the order of the data records loaded into the cockpit in ascending order. When you press CTRL+C, the type of clipboard export that was last selected by mouse click is always executed (during the current execution of the cockpit, is not persistent). If no export has been performed yet (e.g. immediately after cockpit start), all records in focus are exported with CTRL+C (Third option of the list).

Export selected data as CSV: Exports records in focus to a csv-file. After selecting the export format and specifying a file name, the actual values of the selected records are exported in table form. This also includes user-defined data attributes such as predictions of trained regression models. Rows of the table are only all times in the focus, columns in this case are all imported time series (that is, independent of role assignment).

Using the "export" action in the focus bar is a simple way of making the results of data labeling and data editing available for other tools.

Export plots and data to Python, R, Matlab

See the API documentations of these connectors for examples, how to retrieve Visplore data from these environments

Well done! You have mastered the basics of exporting, to get your insights out of Visplore and back into your analytics workflow :)

>> Continue with Next lesson: Filtering data