Variable and Row Management Dialog
The
Variable and Row Management dialog can be accessed by clicking on the its icon
. This dialog is used for changing variable names, changing variable types, reordering and relabeling levels of factors (categorical variables), and adding rows and columns (variables) to your dataset.
Note: Categorical variables, and specifically Nominal and Ordinal variables, are referred to as Factors in Rguroo.
Changing Variable Names
In the dataset editor, the name of each variable is displayed on the column header. Default variable names are Var1, Var2, etc. You have two options, shown below, for changing variable names. The first option is useful when you need to change the names of multiple variables at the same time, while the second option is useful when you want to change the name of a single variable quickly.
Changing Variable Names: Option 1
Click on the Variable and Row Management icon . This will open the Variable and Row Management dialog.
From the list of variables displayed, select the variable that you want to rename.
Locate the Name textbox within the dialog, and type your desired new variable name in the textbox.
Press the Enter key on your keyboard. The new variable name will now appear in the header, replacing the old name.
Note: Variable names cannot contain spaces. Make sure to avoid using spaces when entering the new variable name.
Variable and Row Management Dialog: Changing Variable Names
Changing Variable Names: Option 2
Move your cursor over the variable name on the header. You will see the Variable Context Menu icon .
Click on the icon to open the variable context menu (shown on the left panel in the figure below).
From the menu select the option Rename. This will bring up the Rename Variable dialog box (shown on the right panel in the figure below).
In the dialog box, type in the new name for your variable, and press enter. The new name will now appear on the header. Note that variable names cannot have spaces.
Variable Context Menu
Adding new variables
Use the following instructions to add new variables to your dataset:
Adding Variables
Click on the Variable and Row management icon to open its dialog.
Select the Add Variables option. The dialog shown in the figure below shows.
Type in the number of variables that you want to add in the No. of Variables textbox.
Select one of the Beginning or End options to place the variables.
Type a prefix for the name of the variables in the Name textbox. If you are adding a single variable, simply type in the name of the variable. (See notes below regarding variable names when adding multiple variables).
Click on the button.
Add Variables Dialog
Notes
When adding variables to your dataset, there are two possible scenarios to consider for naming the variables:
To change the location of variables in your dataset, you have two options:
Click and hold:
- On the header, locate the variable name you want to move.
- Click and hold the variable name.
- Drag the variable name to your desired location in the header.
- Release the mouse button to place the variable in the new location.
Columns Side Bar:
- Open the Columns Side Bar.
- Click and hold the column handle the column handle associated with the variable you want to move.
- Drag the variable to your desired location within the side bar.
- Release the mouse button to position the variable in the new location.
Adding new rows
There are two options for adding rows to a dataset. The first option, described below, is useful for adding multiple rows simultaneously, while the second option is useful when you want to add one row at a time.
Adding Rows: Option 1
Click on the icon to open the Variable and Row Management dialog.
Select the Add Rows option. The dialog box shown in the figure below will appear.
Type in the number of rows that you want to add in the # of Rows textbox.
Select from one of the options Beginning, End, or Below Selected Row to indicate where you want the rows to be added.
Click on the button.
Add Rows Dialog
Notes:
To move the added rows, you can use the cut and paste option within the editor.
If a column is in sort mode and you click on the button repeatedly, each time you click the newly added rows will be placed in their appropriate sort position.
Adding a Single Row: Option 2
To add a new row above or below a selected row, follow these steps:
Select the row you want to add a new row above or below.
Right-click on the selected row to open the context menu.
Click on the Add Row option in the context menu.
Select either Below or Above to indicate where you want the new row to be added. The new row will be added either below or above the selected row, depending on your selection.
Modifying variable types and factor levels
Each variable in Rguroo is classified into one of the following types: Numerical, Nominal, Ordinal, or Label/ID. In Rguroo’s application dialog boxes, Nominal and Ordinal variables are identified as Factors. For detailed information on how Rguroo determines default variable types and how to convert one variable type to another using the Variable and Row Management dialog, refer to the section Variable Types in Rguroo. This section also provides instructions for relabeling factor levels and reordering them.
Search and Replace text
To quickly search for specific text in your dataset, type the text into the Quick Search textbox , and click on the down-arrow to search forward or the up-arrow to search backward from the current cursor. location. The first instance of the searched text will be highlighted in green, and the cursor moves to that cell. All other instances will be highlighted in yellow. You can navigate to each instance using the forward and backward arrows within the Quick Search textbox. To cancel the search, click the “X” in the Quick Search textbox.
To perform a refined search in your dataset, click on the Search and Replace icon . This will open the Search and Replace dialog box, shown in the figure below. In the Find textbox type the search text that you like to search. Optionally, refine your search by selecting one of the following: Match case, Whole word, or Starts with. Then click the button. The first instance of the searched text from the current cursor position will be highlighted in green and the cursor will move to that cell. All other instances of the searched text will be highlighted in yellow. To move to the next instance of the searched text (if exists), click on the button repeatedly. To search backwards select the backwards checkbox. If you want to search backward, select the “backwards” checkbox. You can also use the down-arrow and up-arrow buttons within the Quick Search textbox to move forward and backward. To cancel the search, close the Search and Replace dialog box, and click the “X” within the Quick Search textbox.
Search and Replace Dialog
Once you find the text that you are looking for, you can replace it by typing the replacement text in the Replace textbox. Clicking the button will replace the first instance of the searched text from the current cursor position and move the cursor to the next instance of the searched text. If you need to replace text backward, check the Backwards checkbox. If you want to replace all instances of the searched text, click the button.
Caution: You cannot undo cells that you replace using the Search and Replace dialog.