Python Random Unique Sampling from Excel
Budget: ₹750 – ₹1,250 INR
I have an excel file with 2000 rows and 13 columns. I'm trying to get the data from 3 particular columns, where I want one of the columns to drop unique results(Let's just say 'User Name'). With unique user name, I want other 2 columns('Customer ID, and one another') to show whatever the data they contains against the 'User Name'.
Of course if we can make those unique samples in a pre-defined sampling logic let's just say 10%. Also, I want to add another column where I can assign those random values(10%), suppose the values in 'Customer ID' to some random 'User'(2 customer IDs per user) and export the file in any excel format.
Of course if we can make those unique samples in a pre-defined sampling logic let's just say 10%. Also, I want to add another column where I can assign those random values(10%), suppose the values in 'Customer ID' to some random 'User'(2 customer IDs per user) and export the file in any excel format.