如何将数据框中的NaN值转换为0.0小数形式？

The issue you're running into is that as.character(0.0) in R automatically simplifies the numeric value 0.0 to the string "0"—it doesn’t retain the decimal point by default. That’s why you’re ending up with "0%" instead of the "0.0%" you want.

Here’s a straightforward fix using sprintf() to explicitly format the number to keep one decimal place:

T1[, 2] <- ifelse(T1[, 2] == "NaN", sprintf("%.1f%%", 0.0), paste0(T1[, 2], "%"))

Breakdown of the fix: #

• sprintf("%.1f%%", 0.0) formats 0.0 as a string with exactly one decimal place, then appends the percent sign (we use %% to escape the % character in sprintf).
• For non-"NaN" values, it still appends "%" to your original entries just like you intended.

If you want all values in the column to follow the same decimal format (not just the replaced 0.0), a cleaner approach is to convert the column to numeric first, handle the missing values, then format everything consistently:

# Convert the column to numeric (turns "NaN" strings into NA)
T1[, 2] <- as.numeric(T1[, 2])
# Replace NA values with 0.0
T1[, 2][is.na(T1[, 2])] <- 0.0
# Format all values to one decimal place with a percent sign
T1[, 2] <- sprintf("%.1f%%", T1[, 2])

This way, every entry in the column will have the same decimal structure, which is great for consistency if your original data has a mix of integer and decimal strings.

内容的提问来源于stack exchange，提问作者sanuali0123