I want to analyze what vehile make, model, year, body type, color and state occors most frequently in my data.

I can do this looking at each individual column however, i want to make the cells refrence each other to see if i have a data set that occors most frequently together. If that makes sense.


I have the max of column b make; honda. Now i want to get the mode of the other columns based on the make or the model




VEHICLE

year make model body color state
1997 honda civic 4d blk ca
2000 honda civic 2d grn ca
2000 honda civic 4d tan ca
2010 honda accord 4d gry ca
1993 honda accord 4d tan ca
2009 merz clk350 2d sil ca
2004 acura mdx suv blk ca
1992 honda accord 4d whi ca
1992 honda accord 4d blu ca