Using R, Find the average miles per gallon (city and highway both listed separately) for each car model. From a .CSV file

I have attached a photo of the .csv file below

Please show the code. Thank you!

1 manufactimodel displ trans 4 auto(15) f 4 manual(mf 4 manual(mf 4 auto(av) f 6 auto(15) f 6 manual(mf 6 auto(av) f 4 manual( 4 auto(I5) 4 manual( 4 auto(s 6 auto(15) 6 manual( 6 auto(s 6 manual( 6 auto(15) 6 auto(s 8 auto(s 8 auto(14) r 8 auto(14) r 8 auto(14) r 8 auto(14) r 8 auto(14) r 8 manual(mr 8 auto(14) r 8 manual(mr 8 auto(s6) r 8 manual(mr 8 auto(14) 8 auto(14) 8 auto(14) 8 auto(14) 4 auto(14) f class compact compact compact compact compact compact compact compact compact compact compact compact compact compact compact midsize midsize midsize suv suv suv suv suv 2seater 2seater 2seater 2seater 2seater suv suv suv suv midsize year rv 8 audi 9 audi 10 audi a4 quattrc a4 quattrc a4 quattrc a4 quattrc a4 quattrc a4 quattrc a4 quattrc a4 quattrc quattrc quattrc quattrc 15 14 audi 16 audi 17 audi 18 audi 15 15 20 chevrolet c1500 sub 21 chevrolet c1500 sub 22 chevrolet c1500 sub 23 chevrolet c1500 sub 24 chevrolet c1500 sub 25 chevrolet corvette 26 chevrolet corvette 27 chevrolet corvette 28 chevrolet corvette 29 chevrolet corvette 30 chevrolet k1500 tah 31 chevrolet k1500 tah 32 chevrolet k1500 tah 33 chevrolet k1500 tah 34 chevrolet malibu 12 19 r 17 d