Getting the first value in a grouped pandas.DataFrame displays the row in each group which has the lowest index.
Solution for How to get the first value of each group in a Pandas DataFrame in Python : You can use pandas.DataFrame.groupby() and pandas.DataFrame.first() to group a DataFrame and get the first value in each group Call DataFrame.groupby(by) with by as a column name or list of column names to group DataFrame by the column by. Use DataFrame.first() with this result as DataFrame to get the first value in each group.