Edit Data

Edit data in the data table

In the data table view (the main view area when the data panel is open) you can edit your data directly in the table cells. Click a cell to edit it, and press Enter or click outside the cell to save your changes. You can also edit the column headers in the same way.

There are two types of columns: text columns (shown in green) and number columns (shown in blue). If there are more rows than fit on your screen, the table is paginated.

Add column

Opens a dialog with an edit field and an Add column button. Type a name for the new column and click the button. A new empty column appears in the data table, set to text type by default.

Remove column

Opens a dialog listing all columns with a trash icon next to each. Click the trash icon to delete that column — no confirmation is required. Use the close button or press Escape to close the dialog without changes.

Order columns

Opens a dialog showing all columns with up and down arrows. Use the arrows to reorder them. Column order matters because some pictas require certain columns to be first — for example, a scatter chart needs its first two columns to be numerical.

Parse columns

Opens a dialog where you can convert columns between text and number types. Be careful when changing types, as not all text can be parsed as numbers. If in doubt, save your chart first, change the type, and check if the data looks correct. You can always undo by reloading the chart.

There are no date types in DataPicta — dates are represented as text columns. With the applicable pictas you can parse date text columns into date objects.

Build column

Opens a dialog where you can create a new column with data generated from an existing column. Currently supported options include generating:

• ISO2 country codes from a column containing full country names
• Population data for countries
• Area in square kilometers for countries
• Flag image URLs for countries

More smart options may be added in the future. A new column is created and appended to your data.

Transpose data

Opens a dialog that swaps column names with the values in the first row. After transposing, your column headers become data rows and the first row of data becomes your new column headers.

Delete data

You can delete a dataset by clicking the trash icon on its panel. Note that every chart needs at least one dataset, so you cannot delete the last remaining dataset. To start completely fresh, click New blank chart from the menu in the top-right corner and choose whether to delete only the chart or both the chart and data.

Multiple datasets

Most charts use a single dataset, but DataPicta supports multiple datasets in a single chart. You can add as many datasets as you like from the Add Data dialog. When adding pictas you can choose which dataset to use for each picta, allowing you to combine multiple datasets in one chart.