Create data frame from another data frame

Question

I have below data frame

df1:
Q1(25%)  Q2(50%)    Q3(75%)
438.55   654.78     870.34

in df1 Q1(25%), Q2(50%), Q3(75%) are column names. want to convert the above data frame df1 as below

df2:
quant     points
25         438.55
50         654.78
75         870.34

I need quant column as an integer and values should be 25, 50, 75 not q25, q50, q75 — Hmm, Jul 07 '22 at 10:17
Does this answer your question? [Reshaping data.frame from wide to long format](https://stackoverflow.com/questions/2185252/reshaping-data-frame-from-wide-to-long-format) — Limey, Jul 07 '22 at 10:20

score 0 · Answer 1 · answered Jul 07 '22 at 10:09

You actually want to go from wide form of data to long form of data

library(dplyr)
library(tidyr)

df <- data.frame(q25 = 123, q50 = 345, q75 = 678)

df %>% 
  pivot_longer(everything(), names_to = "quant", values_to = "points")

#> # A tibble: 3 × 2
#>   quant points
#>   <chr>  <dbl>
#> 1 q25      123
#> 2 q50      345
#> 3 q75      678

^{Created on 2022-07-07 by the reprex package (v2.0.1)}

score 0 · Accepted Answer · answered Jul 07 '22 at 10:26

You could use stack() and extract the 2-digit numbers from the quant column.

transform(
  setNames(stack(df)[2:1], c("quant", "points")),
  quant = as.integer(regmatches(quant, regexpr("\\d{2}", quant)))
)

#   quant points
# 1    25 438.55
# 2    50 654.78
# 3    75 870.34

Data

df <- data.frame("Q1(25%)" = 438.55, "Q2(50%)" = 654.78, "Q3(75%)" = 870.34,
                 check.names = FALSE)

Create data frame from another data frame

2 Answers2

Data