Make 0/1 columns cod_flag (from cod) and returned_flag (from returned), 1 meaning Yes. The inputs X are category, order_value, discount_pct, delivery_days, customer_orders and cod_flag, with category one-hot encoded by pd.get_dummies(..., columns=["category"], dtype=int). The answer y is returned_flag. Split with train_test_split (test_size=0.25, random_state=42, stratify=y).
Train RandomForestClassifier(n_estimators=100, random_state=0) and store its ROC-AUC on the test part, rounded to 3 decimals, in result.
import io
import pandas as pd
orders = pd.read_csv(io.StringIO("""order_id,category,order_value,discount_pct,delivery_days,customer_orders,cod,returned
80001,Home,1303,20,8,33,No,No
80002,Electronics,1064,30,3,1,Yes,No
80003,Fashion,1295,40,3,2,Yes,No
80004,Fashion,993,30,4,2,No,No
80005,Fashion,1595,20,7,1,No,No
80006,Electronics,2002,50,6,0,No,No
80007,Fashion,906,10,7,1,Yes,No
80008,Home,859,20,6,3,Yes,No
80009,Home,1017,40,2,5,No,No
80010,Fashion,441,10,4,28,No,No
80011,Fashion,1103,30,2,11,No,No
80012,Fashion,521,10,2,8,No,No
80013,Home,1077,40,1,2,No,No
80014,Fashion,1368,50,6,2,No,Yes
80015,Home,1097,30,7,11,Yes,No
80016,Fashion,1007,40,1,1,No,Yes
80017,Home,1168,20,3,21,Yes,No
80018,Electronics,1178,0,2,8,Yes,No
80019,Fashion,931,0,5,11,No,No
80020,Fashion,377,40,8,3,No,No
80021,Beauty,1566,30,2,10,Yes,No
80022,Fashion,473,20,7,0,No,No
80023,Home,2605,20,1,5,Yes,No
80024,Fashion,401,60,3,18,No,No
80025,Fashion,946,20,4,0,No,No
80026,Fashion,1311,60,6,10,Yes,No
80027,Beauty,487,60,5,6,No,No
80028,Electronics,1629,30,2,24,No,No
80029,Fashion,2337,10,2,5,No,No
80030,Fashion,1270,30,5,22,No,No
80031,Electronics,2245,0,2,0,No,No
80032,Fashion,1842,50,8,7,Yes,Yes
80033,Beauty,2250,50,3,1,No,No
80034,Home,757,30,2,7,No,No
80035,Beauty,1192,0,7,0,Yes,No
80036,Home,554,10,4,19,No,No
80037,Home,1116,40,3,2,Yes,No
80038,Fashion,1583,60,3,3,No,No
80039,Home,2431,0,2,2,Yes,No
80040,Fashion,476,60,8,5,No,No
80041,Beauty,682,40,7,8,Yes,No
80042,Beauty,766,60,7,21,Yes,No
80043,Home,529,40,7,7,Yes,No
80044,Beauty,474,20,2,18,Yes,No
80045,Fashion,2518,30,4,14,No,No
80046,Electronics,910,30,6,2,Yes,No
80047,Beauty,1064,0,8,1,Yes,No
80048,Electronics,845,50,2,5,Yes,No
80049,Home,736,20,5,3,Yes,No
80050,Fashion,678,30,1,7,No,No
80051,Electronics,413,10,5,2,Yes,No
80052,Electronics,264,0,6,11,No,No
80053,Electronics,1282,20,5,0,No,No
80054,Fashion,975,10,4,19,Yes,No
80055,Fashion,329,30,3,7,No,Yes
80056,Fashion,1191,40,3,4,No,Yes
80057,Fashion,1114,60,2,18,Yes,No
80058,Beauty,1061,30,6,17,No,Yes
80059,Beauty,1203,30,1,0,Yes,No
80060,Fashion,1092,30,7,10,No,No
80061,Electronics,1454,40,1,1,No,No
80062,Beauty,919,40,5,1,Yes,No
80063,Electronics,494,40,7,8,Yes,No
80064,Fashion,1176,0,5,5,No,Yes
80065,Electronics,379,50,8,5,Yes,No
80066,Fashion,1744,50,7,5,No,No
80067,Fashion,883,30,2,42,No,No
80068,Fashion,586,0,2,6,No,No
80069,Fashion,787,0,1,0,Yes,Yes
80070,Fashion,1319,30,3,11,No,No
80071,Beauty,457,30,7,9,No,No
80072,Beauty,868,20,1,5,Yes,No
80073,Home,560,30,6,7,No,No
80074,Home,567,30,8,7,Yes,No
80075,Fashion,783,40,3,4,Yes,No
80076,Fashion,1379,60,1,0,Yes,Yes
80077,Fashion,1283,0,3,5,No,No
80078,Beauty,823,60,2,1,Yes,No
80079,Fashion,339,40,6,5,Yes,Yes
80080,Electronics,587,20,5,1,No,No
80081,Home,914,20,8,12,No,No
80082,Fashion,1373,60,2,7,No,No
80083,Electronics,2065,60,2,19,No,No
80084,Fashion,1966,30,8,3,No,Yes
80085,Fashion,1513,30,4,6,Yes,No
80086,Home,1210,60,6,5,No,No
80087,Electronics,1377,60,1,1,Yes,No
80088,Electronics,499,10,5,4,No,No
80089,Beauty,1120,20,2,2,Yes,No
80090,Fashion,469,60,1,0,Yes,No
80091,Fashion,1367,60,5,1,No,Yes
80092,Beauty,677,10,6,11,No,No
80093,Fashion,3086,40,5,6,No,No
80094,Electronics,1580,60,6,3,Yes,No
80095,Beauty,1058,20,5,4,Yes,No
80096,Home,611,50,4,21,No,No
80097,Fashion,253,0,6,0,Yes,Yes
80098,Fashion,343,20,6,1,Yes,Yes
80099,Fashion,374,40,6,15,No,No
80100,Beauty,1428,30,5,0,No,No
80101,Home,418,20,7,0,Yes,No
80102,Electronics,486,20,8,6,No,No
80103,Fashion,914,20,5,4,Yes,No
80104,Fashion,903,0,6,5,No,No
80105,Fashion,1917,10,4,0,Yes,No
80106,Fashion,551,0,2,1,No,Yes
80107,Electronics,850,20,2,9,No,No
80108,Fashion,2142,60,4,0,Yes,Yes
80109,Beauty,1031,20,2,0,No,No
80110,Home,325,0,4,2,No,No
80111,Beauty,706,10,8,9,No,No
80112,Fashion,565,30,6,4,No,Yes
80113,Fashion,833,0,4,0,Yes,No
80114,Fashion,2137,50,3,8,Yes,No
80115,Home,1129,60,5,0,No,No
80116,Beauty,957,10,7,3,No,Yes
80117,Fashion,814,50,5,3,Yes,No
80118,Home,1426,30,7,14,No,No
80119,Fashion,1059,50,2,0,Yes,Yes
80120,Electronics,2095,50,6,2,Yes,Yes
80121,Beauty,1081,10,6,2,No,No
80122,Home,431,10,2,8,Yes,No
80123,Home,1193,50,7,3,No,No
80124,Electronics,2546,40,5,4,No,No
80125,Beauty,1494,20,4,4,Yes,No
80126,Home,301,10,7,9,No,No
80127,Fashion,1213,60,4,3,Yes,Yes
80128,Fashion,632,50,1,8,No,No
80129,Fashion,3256,0,1,8,Yes,No
80130,Home,1452,10,7,0,No,No
80131,Electronics,1059,60,3,5,No,No
80132,Fashion,230,30,1,3,No,No
80133,Fashion,1038,20,2,5,Yes,Yes
80134,Beauty,2039,40,6,2,No,Yes
80135,Fashion,2534,40,2,7,No,No
80136,Fashion,589,40,1,12,No,No
80137,Home,2636,0,2,18,Yes,No
80138,Home,1167,20,6,0,No,Yes
80139,Home,1240,30,7,20,No,No
80140,Fashion,1998,30,2,0,No,No
80141,Beauty,485,10,8,5,Yes,No
80142,Fashion,746,40,5,4,No,No
80143,Fashion,1184,0,8,5,Yes,No
80144,Fashion,1176,0,7,3,No,No
80145,Fashion,1346,10,4,0,Yes,Yes
80146,Fashion,288,10,3,8,No,No
80147,Fashion,553,30,3,0,No,No
80148,Electronics,920,50,8,12,Yes,No
80149,Fashion,1221,10,4,9,No,No
80150,Home,492,50,4,6,No,No
80151,Fashion,3160,60,8,19,No,No
80152,Home,529,60,2,2,Yes,No
80153,Fashion,512,30,2,7,No,No
80154,Fashion,150,0,5,2,No,Yes
80155,Electronics,1488,20,3,10,Yes,No
80156,Fashion,857,50,5,9,Yes,No
80157,Fashion,445,0,8,7,No,No
80158,Fashion,1491,60,8,11,Yes,No
80159,Beauty,586,40,5,4,No,No
80160,Beauty,542,60,7,7,No,No
80161,Fashion,4079,30,7,5,Yes,No
80162,Electronics,1980,40,8,2,Yes,No
80163,Fashion,999,20,7,3,Yes,No
80164,Fashion,1600,30,8,3,No,No
80165,Fashion,1089,0,8,3,No,Yes
80166,Home,619,30,2,1,Yes,Yes
80167,Home,244,0,8,9,Yes,No
80168,Fashion,817,30,2,4,No,Yes
80169,Beauty,636,40,3,4,No,No
80170,Electronics,669,30,2,14,Yes,No
80171,Home,504,20,4,10,Yes,No
80172,Beauty,880,0,2,4,Yes,No
80173,Fashion,353,20,1,13,No,No
80174,Electronics,805,0,3,6,Yes,No
80175,Fashion,2105,60,4,4,No,No
80176,Fashion,721,40,8,0,No,No
80177,Beauty,1111,30,3,10,No,No
80178,Fashion,1455,0,7,2,Yes,No
80179,Fashion,833,50,1,2,Yes,No
80180,Home,1013,0,6,0,Yes,No
80181,Beauty,923,40,4,4,Yes,No
80182,Fashion,2535,10,2,4,Yes,Yes
80183,Electronics,1354,60,4,2,Yes,No
80184,Fashion,1064,60,6,11,Yes,No
80185,Beauty,573,30,3,1,No,No
80186,Home,2463,50,8,2,Yes,No
80187,Fashion,443,20,6,6,Yes,No
80188,Fashion,4015,10,8,3,No,Yes
80189,Electronics,1751,50,5,1,No,Yes
80190,Fashion,1696,50,7,0,No,No
80191,Beauty,564,60,2,2,Yes,No
80192,Fashion,849,30,8,2,Yes,No
80193,Electronics,844,10,1,0,Yes,No
80194,Fashion,1721,10,4,9,Yes,No
80195,Fashion,499,60,2,7,No,Yes
80196,Fashion,990,50,1,10,Yes,No
80197,Fashion,670,20,8,9,No,No
80198,Beauty,506,30,6,0,Yes,No
80199,Fashion,267,50,7,5,No,No
80200,Electronics,639,20,7,6,No,Yes
80201,Electronics,1792,60,8,5,Yes,No
80202,Fashion,1112,20,3,5,No,No
80203,Fashion,1599,60,2,0,No,No
80204,Fashion,1369,0,4,11,No,No
80205,Fashion,698,60,7,0,No,Yes
80206,Beauty,1775,0,5,13,Yes,No
80207,Fashion,533,30,4,35,No,No
80208,Fashion,494,60,1,10,Yes,No
80209,Fashion,416,60,1,4,Yes,Yes
80210,Beauty,1645,30,6,13,No,No
80211,Beauty,150,10,3,4,Yes,No
80212,Beauty,3779,50,8,2,Yes,No
80213,Fashion,1565,10,7,9,No,No
80214,Electronics,1021,20,8,8,Yes,Yes
80215,Fashion,3366,0,5,0,Yes,Yes
80216,Home,2303,40,6,9,Yes,No
80217,Electronics,1444,50,8,6,No,No
80218,Electronics,1593,40,4,0,Yes,No
80219,Home,246,60,6,0,No,No
80220,Fashion,1939,10,5,26,No,No
80221,Electronics,589,10,6,2,Yes,No
80222,Home,1369,20,8,3,No,No
80223,Fashion,2168,10,4,0,No,No
80224,Fashion,2225,0,7,0,Yes,Yes
80225,Fashion,2155,30,5,15,Yes,No
80226,Beauty,1733,40,5,2,No,No
80227,Beauty,995,0,4,7,Yes,No
80228,Home,217,0,8,3,Yes,No
80229,Fashion,1366,0,2,1,Yes,Yes
80230,Beauty,1091,50,1,0,No,No
80231,Electronics,869,60,3,13,No,No
80232,Home,1936,60,3,3,Yes,Yes
80233,Fashion,467,0,5,1,Yes,Yes
80234,Beauty,589,20,8,15,No,No
80235,Beauty,938,20,7,5,No,No
80236,Beauty,247,60,4,20,No,No
80237,Beauty,866,0,5,0,Yes,No
80238,Fashion,1637,10,8,3,No,No
80239,Home,761,50,2,6,No,No
80240,Electronics,524,50,1,4,No,No
80241,Fashion,1233,0,3,0,No,No
80242,Beauty,592,50,7,2,No,Yes
80243,Fashion,1206,30,6,0,Yes,Yes
80244,Beauty,1069,60,8,0,No,Yes
80245,Beauty,1869,10,5,3,No,No
80246,Beauty,1107,10,6,1,Yes,Yes
80247,Home,305,50,5,6,No,No
80248,Home,972,0,7,11,No,No
80249,Electronics,1261,60,5,5,Yes,No
80250,Electronics,1792,0,1,1,No,No
80251,Home,1517,10,7,0,No,No
80252,Fashion,432,10,1,2,Yes,Yes
80253,Beauty,1321,50,8,0,No,No
80254,Electronics,579,0,8,11,Yes,No
80255,Fashion,610,30,1,1,Yes,Yes
80256,Beauty,284,0,8,7,No,Yes
80257,Fashion,3147,10,8,0,No,Yes
80258,Fashion,2148,20,6,14,No,Yes
80259,Beauty,954,10,1,7,Yes,No
80260,Beauty,1435,10,4,11,No,No
80261,Home,824,20,1,9,No,No
80262,Fashion,402,10,8,1,No,No
80263,Beauty,1100,30,6,0,Yes,No
80264,Fashion,863,60,5,2,Yes,Yes
80265,Fashion,1674,60,5,12,No,No
80266,Home,955,60,2,25,Yes,Yes
80267,Fashion,486,30,5,29,Yes,No
80268,Beauty,2643,50,2,4,No,No
80269,Fashion,820,60,7,2,No,No
80270,Fashion,986,0,3,8,Yes,No
80271,Electronics,441,30,5,2,No,No
80272,Home,674,60,7,2,Yes,No
80273,Beauty,2915,50,4,1,Yes,No
80274,Fashion,742,20,7,3,No,No
80275,Fashion,1826,20,5,10,No,Yes
80276,Fashion,450,10,1,7,No,No
80277,Beauty,1250,20,7,8,No,No
80278,Fashion,420,30,3,1,No,No
80279,Fashion,1335,30,7,3,No,No
80280,Fashion,1197,10,3,6,Yes,No
80281,Fashion,411,40,7,8,Yes,No
80282,Fashion,1281,30,7,14,Yes,No
80283,Electronics,779,50,2,4,Yes,Yes
80284,Beauty,412,10,3,5,No,No
80285,Beauty,618,20,8,12,No,No
80286,Fashion,499,0,2,10,Yes,No
80287,Beauty,180,0,8,4,No,No
80288,Fashion,1894,60,7,1,No,Yes
80289,Electronics,2306,30,6,4,Yes,No
80290,Electronics,633,0,7,11,No,No
80291,Electronics,1665,10,1,2,Yes,No
80292,Fashion,1113,10,6,0,Yes,Yes
80293,Fashion,727,50,4,1,No,Yes
80294,Fashion,2384,50,8,3,No,Yes
80295,Home,646,50,5,14,Yes,No
80296,Fashion,3032,50,5,8,Yes,No
80297,Beauty,456,30,5,0,No,No
80298,Home,1951,60,1,2,Yes,No
80299,Beauty,1557,20,5,4,No,No
80300,Electronics,412,30,2,3,No,No
80301,Electronics,2828,0,3,1,No,No
80302,Beauty,507,40,2,10,Yes,No
80303,Fashion,3898,40,8,0,No,Yes
80304,Home,896,10,2,19,Yes,No
80305,Fashion,1418,10,1,0,Yes,Yes
80306,Fashion,645,60,2,0,Yes,Yes
80307,Fashion,1139,60,2,11,Yes,No
80308,Electronics,649,0,2,1,No,No
80309,Beauty,1858,40,3,7,Yes,No
80310,Beauty,616,10,5,3,Yes,No
80311,Fashion,485,10,8,4,Yes,No
80312,Electronics,580,50,3,4,No,No
80313,Fashion,524,30,1,1,No,No
80314,Home,967,30,3,2,Yes,No
80315,Home,1283,10,4,7,No,No
80316,Fashion,1883,60,6,3,No,No
80317,Fashion,342,0,6,13,No,No
80318,Electronics,293,50,8,18,No,No
80319,Fashion,2221,60,7,31,Yes,No
80320,Home,701,60,4,5,No,No"""))Store your final answer in a variable named result.
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.