How to Update CSV and Excel Files

Sometimes, when updating projects with new or revised data, additional information in the revised data file contradicts conclusions about the variable type when importing the original file. There are two relatively common scenarios where this can occur: 

• Numeric variables that become text variables
• Text variables that become numeric

Method

Numeric variables that become text variables

If a variable contains only numeric data when it is originally imported, it will be assumed to be a numeric variable from that point onward, and any non-numeric data will automatically be converted to missing data.

If it is important to change the type of a variable, the process is:

1. Open the original CSV or Excel file in Excel.
2. Create a new column, ideally immediately to the right of the original variable.
3. Make the corrections in the new variable.
4. Import the updated data file in Displayr by selecting the file from the Data Sources tree and then selecting Edit Data Source from Properties . 
5. Hide the original variable by selecting the variable in Data Sources by navigating to Properties and going to Data > Attributes, and checking Hidden except in the data tree.
6. Use the new variable in its place.

Text variables that become numeric

Where a variable contains information that causes Displayr to interpret the variable as being text, such as commas, dollar signs, or any other non-numeric data, Displayr will continue to interpret the data as being text, even if the underlying data is changed to text and re-imported.

You can change the variable to numeric by changing its Structure to Numeric in the variable Attributes of Properties .

Next

How to Work with Excel/CSV Files in Displayr