Group By + Min

* pandas.csv

RV,LPG,1997
RV,가솔린,1997
RV,디젤,1998
SUV,LPG,1996
SUV,가솔린,1992
SUV,디젤,1993
SUV,수소,2015
SUV,전기,2005

 

 

 

* groupbymin.py

import pandas as pd

data=pd.read_csv("Desktop\\pandas.csv", delimiter=",", dtype="unicode", names=["A", "B", "C", "D", "E"], header=None)

 

datamin = data.groupby(['A','C'])['E'].min()

 

datamin.to_csv(r"Desktop\\pandas.result.csv")