0

I need to write a script in R (Rstudio) that produces a new table, with 6 rows, that aggregates the vehicle types in cars dataset. In the first field will be the type of vehicle (sports car, SUV, Wagon, Minivan, Pickup, regular), (regular, this is when everyone is zero (, and then there are the averages per value for each type of vehicle.

The table should look like this :

Type Wheel base Weight HWY MPG city MPG HP Cyl Engine size Dealer cost Retail price
Regular
Sport car
...

A photo of the file (cars dataset) is mentioned here : enter image description here

Phil
  • 7,287
  • 3
  • 36
  • 66
Jiana
  • 87
  • 1
  • 5

1 Answers1

0

It would be much easier to answer this if you posted a reproducible example.

However this should work:

library(dplyr)
cars  %>% 
    group_by(Type)  %>% 
    mutate(across(`Wheel base`:`Retail price`, mean))
SamR
  • 8,826
  • 3
  • 11
  • 33