I have a lottery project that depends on the user uploading an Excel file, specifying the number of winners, entering the filtering conditions, and the file is filtered according to the conditions, and then the winners are drawn from the filtering variable based on percentages, but he does not adhere to the filtering. Requirements Number of Winners:10 Filtering Conditions:Age(العمر):Onlyselectparticipantsbetween 25 and 70 years old.Selection Percentages:Gender (الجنس):Male (ذكر) → 60% of winnersFemale (أنثى) → 40% of winners City (المدينة):Baghdad (بغداد) → 40%Basra (البصرة) → 20%Karbala (كربلاء) → 20%Erbil (أربيل) → 20% This request is sent and the data is filtered based on the numerical ratios and textual values. The filtering is stored in a variable and the winners are drawn from the filtering variable randomly based on the textual ratios. If there is a text value whose required ratio is not found in the data, a message is returned to the user if he wants to complete the data randomly or return only the available data. Continue reading...
