Creating an empty data frame with only column names - R

Question

I want to create an empty dataframe with these column names: (Fruit, Cost, Quantity). No data, just these column names.

Answer 1

Fruit_Market<-data.frame(fruit=character(0),cost=numeric(0),quantity=integer(0))

You would have to create a data.frame by using only 0-length variables and it'll give you an empty data.frame.

Become a proficient Data Analyst with our comprehensive Data Analyst Course.

Answer 2

You can either NA values

data.frame(fruit=NA, cost=NA, quantity=NA)[numeric(0), ]

Answer 3

You can set dynamic values to your rows. Here the y length will be dynamic.

y <- data.frame(fruit=charector(), cost=numeric(), quantity=numeric())

Answer 4

The most efficient way would be:

y <- read.csv(text="fruit,cost,quantity")

Answer 5

Try this:

names <- c("fruit","cost","quantity")
df <- data.frame()
for (k in names) df[[k]] <- as.character()

Answer 6

You can use as.data.frame like this:

as.data.frame(x, row.names = NULL, optional = FALSE, …)

make sure row.names is NULL 

Answer 7

as.data.frame is a good choice. For more detailed, have a look at the documentation.

Answer 8

Please try following code snippet.

df <- data.frame(matrix(ncol = 3, nrow = 0))

x <- c("name", "age", "gender")
colnames(df) <- x

For more detail, Please check this link

https://stackoverflow.com/questions/32712301/create-empty-data-frame-with-column-names-by-assigning-a-string-vector

Thanks.

Answer 9

Will the below code work to create a empty dataframe?

v=data.frame(fruit=NA, cost=NA, quantity=NA)

It show columns with no data in row.

Answer 10

fruit_Frame<-data.frame(Fruit=NA, Cost=NA, Quantity=NA)[-1,];

#thank me later or never

Answer 11

Hi,

You need to create a data frame with zero rows as shown below.

df <- data.frame(matrix(ncol = 3, nrow = 0))
x <- c("name", "age", "gender")
colnames(df) <- x