은쥬라기월드

📌SQL ROW_NUMBER() PYTHON구현 KEY1 DATA1 DATA2 a 1 1 a 2 10 a 2 2 b 3 3 a 3 30 -- SQL ROW_NUMBER() RN = ROW_NUMBER() OVER (PARTITION BY Key1 ORDER BY Data1 ASC, Data2 DESC) #Python ROW_NUMBER() df['RN'] = df.sort_values(['data1','data2'],ascending=[True,False]).groupby(['key1']).cumcount() +1 KEY1 DATA1 DATA2 RN a 1 1 1 a 2 10 2 a 2 2 3 b 3 3 1 a 3 30 4 DataFrame.sort_values(by=None, axis = 0, asce..