Creating an empty data frame with only column names - R

+4 votes
I want to create an empty dataframe with these column names: (Fruit, Cost, Quantity). No data, just these column names.
May 25, 2018 in Data Analytics by DataKing99
• 8,240 points
106,840 views

11 answers to this question.

0 votes
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.

answered May 25, 2018 by Bharani
• 4,660 points
0 votes

You can either NA values

data.frame(fruit=NA, cost=NA, quantity=NA)[numeric(0), ]
answered Dec 10, 2018 by Priyaj
0 votes
You can set dynamic values to your rows. Here the y length will be dynamic.

y <- data.frame(fruit=charector(), cost=numeric(), quantity=numeric())
answered Dec 10, 2018 by Keshav
0 votes
The most efficient way would be:

y <- read.csv(text="fruit,cost,quantity")
answered Dec 10, 2018 by Denis
0 votes

Try this:

names <- c("fruit","cost","quantity")
df <- data.frame()
for (k in names) df[[k]] <- as.character()
answered Dec 10, 2018 by Vedant
0 votes

You can use as.data.frame like this:

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

make sure row.names is NULL 

answered Dec 10, 2018 by Vaibhav
0 votes

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

answered Dec 10, 2018 by Kaksha
0 votes
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.


answered Mar 7, 2019 by RajkumarManiRaja
0 votes

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.

answered Aug 1, 2019 by preeti
0 votes
fruit_Frame<-data.frame(Fruit=NA, Cost=NA, Quantity=NA)[-1,];


#thank me later or never

answered May 8, 2020 by yxcv

edited May 8, 2020 by Gitika
0 votes

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
answered Dec 11, 2020 by MD
• 95,440 points

Related Questions In Data Analytics

+1 vote
3 answers

How to change column names of a Data frame?

Hi, To change the name of a column ...READ MORE

answered Oct 30, 2020 in Data Analytics by MD
• 95,440 points
1,344 views
0 votes
1 answer

How to order data frame rows according to vector with specific order using R?

You can try using match: data <- data.frame(alphabets=letters[1:4], ...READ MORE

answered Apr 30, 2018 in Data Analytics by Sahiti
• 6,370 points
6,814 views
0 votes
1 answer

How can I append rows to an R data frame?

Consider a dataSet i.e cicar(present under library ...READ MORE

answered May 9, 2018 in Data Analytics by zombie
• 3,790 points
10,473 views
0 votes
1 answer

How to filter a data frame with dplyr and tidy evaluation in R?

Requires the use of map_df to run each model, ...READ MORE

answered May 17, 2018 in Data Analytics by DataKing99
• 8,240 points
1,609 views
0 votes
1 answer

How to convert a text mining termDocumentMatrix into excel or csv in R?

By assuming that all the values are ...READ MORE

answered Apr 5, 2018 in Data Analytics by DeepCoder786
• 1,720 points
1,589 views
0 votes
1 answer

How to create a list of Data frames?

Basically all we have to do is ...READ MORE

answered Apr 9, 2018 in Data Analytics by DeepCoder786
• 1,720 points
983 views
0 votes
1 answer

How to spilt a column of a data frame into multiple columns

it is easily achievable by using "stringr" ...READ MORE

answered Apr 9, 2018 in Data Analytics by DeepCoder786
• 1,720 points
1,432 views
+1 vote
2 answers

How to sort a data frame by columns in R?

You can use dplyr function arrange() like ...READ MORE

answered Aug 21, 2019 in Data Analytics by anonymous
• 33,030 points
1,401 views
+1 vote
3 answers

Filtering R data-frame with multiple conditions

You can use the 'filter' function from ...READ MORE

answered Mar 26, 2018 in Data Analytics by Bharani
• 4,660 points
86,403 views
0 votes
1 answer

Converting R data-frame to h2o object

All you have to do is run ...READ MORE

answered Apr 3, 2018 in Data Analytics by Bharani
• 4,660 points
2,328 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP