How to Paste or Enter a Table

This article describes how to manually enter or paste data from other sources such as Excel. The entered data will be converted to an R matrix, vector, or a data frame.

Requirements

• A Displayr document
• Data in another location, such as an Excel document

Method

1. From the toolbar, go to Table > Paste or Enter Table.
2. From the object inspector, click Paste or type data.
3. In the spreadsheet window pop-up, paste in existing data from another source, or type in the data manually.
4. OPTIONAL: Adjust the additional settings in the DATA MANIPULATION, ROW MANIPULATIONS, and/or COLUMN MANIPULATIONS menus, such as:

   • Automatically tidy the data - performs a variety of cleaning operations, such as removing missing values, and changing the underlying type of the data table in order to convert it into a numeric form useful for charting.

   • Automatically detect row and column names - unselect this if you want to manually adjust whether or not row or column names are present in the data.

   • First row contains column names - if selected, the first row of the table will always be interpreted as the column names.

   • First column contains row names - if selected, the first column of the table will always be interpreted as the row names.

   • Tidy labels - extracts common prefixes from the row labels or vector names to shorten the labels in the chart.

   • Autofit - set row heights and column widths of the table to fill the iframe. More formatting options are available in the Format tab when this option is selected.

5. OPTIONAL: You can update the formatting of the table by going to Properties > APPEARANCE and adjusting the decimal places, number formatting, font, table style, etc.

NOTES:

• You may enter a table that is at most 200 x 200. If you need to enter more data then upload it as a CSV file.
• An attempt will be made to interpret the entered data as a numeric vector or matrix. The numeric vector may or may not contain named elements, while the numeric matrix may either be unnamed or have row and column names. If this attempt fails, a character vector or matrix is produced instead.
• Note that the data need not be entered at the top left of the spreadsheet, as any empty rows and columns will be automatically removed.