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). The support team calls every test order with a chance of return of 0.5 or more. Store [orders called, returns among them] 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.