Difference between Skript and Console

Question

I want to separate a column into two columns.

When I add the code below the console says the column was split.

> separate(refine, "Product code / number", into =  c("product code", "number"), sep = "-")
# A tibble: 25 x 9
   company `product code` number             address   city         country            
   name
 *   <chr>          <chr>  <chr>               <chr>  <chr>           <chr>           
<chr>
1 philips              p      5 Groningensingel 147 arnhem the netherlands   
dhr p. jansen
2 philips              p     43 Groningensingel 148 arnhem the netherlands   
dhr p. hansen
3 philips              x      3 Groningensingel 149 arnhem the netherlands   
dhr j. Gansen
4 philips              x     34 Groningensingel 150 arnhem the netherlands   
dhr p. mansen
5 philips              x     12 Groningensingel 151 arnhem the netherlands  
dhr p. fransen
6 philips              p     23 Groningensingel 152 arnhem the netherlands 
dhr p. franssen

The Problem is when I check the result the column wasn't split.

refine[,2]
# A tibble: 25 x 1
   `Product code / number`
                 <chr>
 1                     p-5
 2                    p-43
 3                     x-3
 4                    x-34

You have a misspelled code: change `..., sep = "-")) ` to `...,) sep = "-") ` — Andrey Kolyadin, Aug 04 '17 at 11:26
Then please, provide [Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve). — Andrey Kolyadin, Aug 04 '17 at 11:33
eventually relevant: https://stackoverflow.com/questions/9959337/how-can-i-run-an-r-script-without-suppressing-output?noredirect=1&lq=1 https://stackoverflow.com/questions/19279703/how-can-i-get-the-output-of-the-summary-command-if-it-is-called-within-a-loop?noredirect=1&lq=1 — jogo, Aug 04 '17 at 11:50

score 0 · Answer 1 · answered Aug 04 '17 at 11:55

You will never see the output in the script section of rstudio... Or in an .R script file, for that matter. The script only stores the commands. Output can be seen in the console, and it can be stored as objects in the environment. In rstudio you can visualize the environment and some types of output through the command View(). Take a look at rstudio's cheat sheet: Rstudio.pdf

score 0 · Answer 2 · answered Aug 04 '17 at 12:12

You are not assigning the result. separate doesn’t modify the existing variable refine (few functions in R ever modify their arguments). It returns a new table with the split columns. You need to assign the result to a new (or existing) name:

result = separate(refine, "Product code / number", into =  c("product code", "number"), sep = "-")

Instead of creating a new variable (result), you can also overwrite refine (refine = separate(refine, …)) though I would generally recommend against modifying existing variables.

Contrary to what your question title states, there’s no difference in behaviour between R scripts and the R console. This is a fundamental, universal R behaviour.

Difference between Skript and Console

2 Answers2