确保CSV输出中保留长数字

问题描述

我有一个R数据框，需要保存为csv文件，但是当保存为csv文件时，一个数字列会更改其格式。

I have an R data frame which needs to be saved as a csv file however one numeric column changes its format when saved as a csv file.

我有一个名为ID的字符列如下：

I have a character column named ID as below:

df <- data.frame(ID = as.character(1181050000000002, 1189050000000003),
                 Other = c("John", "Mary"))

当我另存为r上的一个csv文件，它将更改为

When I save as a csv file on r, it changes to

write.csv(df, "df.csv", row.names = FALSE)

df <- read.csv("df.csv")

df$ID

ID
1181050000000000
1189050000000000

打开csv文件时的输出应显示为原始

The output when I open the csv file should appear as original

ID
1181050000000002
1189050000000003

推荐答案

以下是使用 readr 的方法对我有用：

Here's an approach that worked for me using readr:

library(readr)

write_csv(df, "df.csv")

options(scipen=999)

df1 <- read.csv("df.csv")

df1

#                ID
#1 1181050000000002
#2 1189050000000003

这是一个屏幕截图：

这篇关于确保CSV输出中保留长数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！