Pivot table in pandas
pivot2 = pd.pivot_table(union,
index=['YM','Channel Name','SKU_x','Invoice Type'],
values=['Document No_','Total HL'],
aggfunc={'Document No_':pd.Series.nunique
,'Total HL': np.sum})
WHERE or IF function in Numpy
Script union['CH'] = np.where(union['Invoice Type'] == 'Normal Sales', union['Channel Name'],'Wedding & Function') Explanation IF "Invoice Type" = "Normal Sales" then union['CH'] = union['Channel Name'] Else union['CH'] = "Wedding & Function"
Comments
Post a Comment