Open In App

How to convert table to dataframe in R?

In this article, we will discuss how to convert a given table to a dataframe in the R programming language.

Functions Used

Syntax: as.data.frame.matrix(x)



Parameter:

  • x: name of the table which is to be converted into dataframe

Returns: It will return the dataframe which is converted from the given data.



Syntax: table(…,exclude = if (useNA == “no”) c(NA, NaN),useNA = c(“no”, “ifany”, “always”),dnn = list.names(…), deparse.level = 1)

Returns:

This function will be returning the frequency table of the provided data back to the user.

Thus, we will first create a contingency table using table() function from a dataframe and then convert this table to a dataframe.

Given below are some implementations for this.

Example 1:




data_gfg=data.frame(x=c(1,3,5,3,4),
                    y=c(1,5,1,4,5))
 
table_gfg=table(data_gfg$x,data_gfg$y)
print("table in use: ")
table_gfg
 
new_data_gfg=as.data.frame.matrix(table_gfg)
print("converted to dataframe: ")
new_data_gfg

Output:

Example 2:




data_gfg=data.frame(x=c("a","b","c","d","e"),
                    y=c("1","2","3","4","5"))
 
table_gfg=table(data_gfg$x,data_gfg$y)
print("table in use: ")
table_gfg
 
new_data_gfg=as.data.frame.matrix(table_gfg)
print("dataframe after conversion :")
new_data_gfg

Output:


Article Tags :