Groupby in Pandas

Question

My code is working, which is good lol, but the output needs to be different in how it is viewed.

UPDATED CODE SINCE RECIEVING ANSWER

import pandas as pd

# Import File
YMM = pd.read_excel('C:/Users/PCTR261010/Desktop/OMIX_YMM_2016.xlsx').groupby(['Make','Model']).agg({'StartYear':'min', 'EndYear':'max'})

print(YMM)

The output looks like Make | Model | StartYear | EndYear, with all the makes listed down column the Make Column next to the Model Column. But the Makes are filtered like a Pivot table.

Here is a screen shot:

I need American Motors next to every American Motors Model, every Buick next to every Buick Model and so on.

Here is the link to sample data: http://jmp.sh/KLZKWVZ

Answer 1

Try this:

res = YMM.groupby(['Make','Model'], as_index=False).agg({'StartYear':'min', 'EndYear':'max'})

or

res = YMM.groupby(['Make','Model']).agg({'StartYear':'min', 'EndYear':'max'}).reset_index()

Answer 2

With your own code

Min = YMM.groupby(['Make','Model']).StartYear.min()
Max = YMM.groupby(['Make','Model']).EndYear.max()

Min['Endyear']=Max.EndYear