Aylmer Britto aylmerbritto
aylmerbritto
/ tShirtGoogleFormManagement.py
Created
August 15, 2020 11:34
So in yknot we took this initiative of distributing T-shirts to our college peeps. We collected information of people who were interested in the beginning to choose their affordable price range, colour and sizes. And in the second information we collected their payment details. At the end of the day we had to spend a lot of time to manually pic…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import pandas as pd | |
| def findDuplicates(df,key): | |
| duplicates = df[df.duplicated([key], keep=False)] | |
| print(duplicates) | |
| return duplicates | |
| def notPaidList(wholeSheet,paidSheet, Key): | |
| #print("=================================") | |
| whSheetMerged= wholeSheet.merge(paidSheet, on=Key, how="left", indicator=True) |