Converting dataframe format in R

Question

I have a dataframe which looks as follows :

Type    Availability   Count

DayTime   Cancelled       10
Morning   Cancelled       15
Night     Cancelled       13
DayTime   Trip Completed  14
Morning   Trip Completed  71
Night     Trip Completed  32
DayTime   Not-Present     13
Morning   Not-Present     43
Night     Not-Present     23

I want to convert this data frame into a format which will have only 3 rows, namely, DayTime, Morning and Night. And 3 columns, namely, Cancelled, Trip Completed and Not-Present which will have the respective counts. How can I do that in R ? Please help.

Try `xtabs(Count ~ Type + Availability, data = dat)`. – Rui Barradas Oct 08 '17 at 11:27 — Rui Barradas, Oct 08 '17 at 11:27

amanda · Accepted Answer · 2017-10-08T11:35:53.330

0

Have a look at tidyr::spread.

my_data <- tibble::tribble(
  ~Type,    ~Availability,   ~Count,

"DayTime",   "Cancelled",       10,
"Morning",   "Cancelled",       15,
"Night",     "Cancelled",       13,
"DayTime",   "Trip Completed",  14,
"Morning",   "Trip Completed",  71,
"Night",     "Trip Completed",  32,
"DayTime",   "Not-Present",     13,
"Morning",   "Not-Present",     43,
"Night",     "Not-Present",     23
)

my_data %>% tidyr::spread(key = Availability, value = Count)

edited Oct 08 '17 at 11:35

answered Oct 08 '17 at 11:32

amanda

321
5
12

yes, Figured out that its a simple example of long to wide format. – scooby Oct 08 '17 at 11:35
yep, you got it – amanda Oct 08 '17 at 11:36

Converting dataframe format in R

1 Answers1