Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Fields name with space in R

Simple example:

Fields name containing a space, moved into a dataframe with the new R visualization: 

#Create Dataframe

#dataset <-data.frame (Order Quantity, Gross Profit)

 

How can I reference those fields? e.g plot(Order Quantity, Gross Profit)? R variables cannot have spaces.

Thanks

Francesco

 

2 Replies

  • BeardyGeorge's avatar
    BeardyGeorge
    Advocate I
    10 years ago

    I managed to find the solution, which can be found here. The R code to automatically od what you requested for all columns is:

    names(dataset) <- gsub(" ","_",names(dataset))
  • Avi_Sander's avatar
    Avi_Sander
    Microsoft Employee
    10 years ago

    Try dataset["Order Quantity"]. this should do the trick.

     

    Thanks, Avi