replacing values with special character

General
,
#1

I have a summary like below

Name Sales
AS 71.5
DY 88.4
VH 44.6
MY 86.9
HU 42.3
TT 67.2
BG 0.0
SA 85.3

so if i want to replace if value is 0 then replace with "-"
do we have any solution

output should be

Name Sales
AS 71.5
DY 88.4
VH 44.6
MY 86.9
HU 42.3
TT 67.2
BG -
SA 85.3
#2

This can be done easily but it convert all of your sales numbers into characters which will be very inconvenient if you need to do further calculations.

library(dplyr)

DF <- data.frame(Name = LETTERS[1:6], Sales = c(55.3, 78.2, 64.9, 0.0, 78.2, 32.1))
DF
#>   Name Sales
#> 1    A  55.3
#> 2    B  78.2
#> 3    C  64.9
#> 4    D   0.0
#> 5    E  78.2
#> 6    F  32.1
summary(DF)
#>  Name      Sales      
#>  A:1   Min.   : 0.00  
#>  B:1   1st Qu.:37.90  
#>  C:1   Median :60.10  
#>  D:1   Mean   :51.45  
#>  E:1   3rd Qu.:74.88  
#>  F:1   Max.   :78.20
DF <- DF %>% mutate(Sales = ifelse(Sales == 0, "-", Sales))
DF
#>   Name Sales
#> 1    A  55.3
#> 2    B  78.2
#> 3    C  64.9
#> 4    D     -
#> 5    E  78.2
#> 6    F  32.1
summary(DF)
#>  Name     Sales          
#>  A:1   Length:6          
#>  B:1   Class :character  
#>  C:1   Mode  :character  
#>  D:1                     
#>  E:1                     
#>  F:1

Created on 2020-07-16 by the reprex package (v0.3.0)

#7

yea you are right, i have values with decimal points also,
if am doing this so the values with 18.0 or 7.0 also converting to "-"
do we have any other sollution then

#8

I do not know of a way to format the value 0 to appear as "-" while remaining a number.
Why are you trying to change the appearance of the numbers?

#9

Just retain numbers as numbers for all data manipulations and change them only for presentation purposes, e.g. in output tables.

#10

tab[,2]<-ifelse(tab[,2]=="--","--",format(round(tab[,2],digits = 1),nsmall = 1))
tab[,2] <- paste0(tab[,2],"%")
tab[,2][tab[,2]==0] <- "-"

so this is part of my function and summary is coming out like below

Name Sales
AS 71.5%
DY 88.4%
VH 0.0%

so this 0.0% need to be replace with "-"
i this this will get resolved by gsub or sub i guess

#11

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

#4

A data frame can only have one type of value in a column and I do not know of a way to format the value 0 to appear as "-" while remaining a number. Can you explain why you want to do this? There may be another solution.

#3

yea further calculation also required

#6

If you run the following code, you will see that appending a % to the numbers converts them to characters, which you want to avoid. I suspect you are trying to handle an R data frame as if it were a spreadsheet. If you need to use the numbers in calculations, do not attempt to format their appearance, just leave them as numbers.

#5

I have already created a table summary

tab[,2] <- paste0(tab[,2],"%")
tab[,2] <- replace(tab[,2],tab[,2]<0,"-")

now want to change if summary have 0 or 0.0 then it should replace by "-"
i have used tab[,2] <- replace(tab[,2],tab[,2]<0,"-")
but its not giving the required output