R语言中如何将table对象转换为指定结构的DataFrame

Here's a simple, flexible function that will convert any one-dimensional table object into the DataFrame structure you need—no hardcoding required, so it works regardless of how many categories your table has.

Step 1: The Custom Function #

table_to_df <- function(input_table) {
  data.frame(
    type = names(input_table),
    count = as.numeric(input_table),
    stringsAsFactors = FALSE
  )
}

Step 2: Test It With Your Data #

First, let's recreate your original data and table:

# Your original data
user <- c(1, 1, 1, 1, 2, 2, 2, 2, 3, 3, 3, 3)
type <- c('new', 'recent', 'recent', 'old', 'recent', 'new', 'new', 'old', 'new', 'new', 'new', 'recent')
df <- data.frame(user, type)

# Generate the table
type_table <- table(df$type)
type_table

This outputs:

new    old recent 
     6      2      4 

Now run the function:

# Convert to DataFrame
result_df <- table_to_df(type_table)

# View the result
result_df

Output #

type count
1     new     6
2     old     2
3 recent     4

How It Works #

• names(input_table) grabs the category labels (like "new", "old") directly from the table—so it adapts automatically to any number of categories.
• as.numeric(input_table) converts the table's integer values to a standard numeric vector (avoids any weird table-specific data type quirks).
• stringsAsFactors = FALSE ensures the type column stays as character strings instead of factors, which is usually more convenient for downstream work.

Alternative Base R Method (No Custom Function) #

If you prefer not to write a function, you can use base R's as.data.frame() with a quick rename:

# Using base R only
df_result <- as.data.frame(type_table, responseName = "count")
colnames(df_result)[1] <- "type"
df_result

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