'how to determine the total number matches of data using python in excel spreadsheet?
how to determine the total matches of data using python excel? For E.g. X,Y found in "Ameloginin" is considered as a count of 1 as it matches baby Johnathon value of X,Y or partial match Baby Johnathon D8S1179 value is 11,12 and M1 D8S1179 value is 11,16 so +1 as there is a match of 11 on both ends.
Link to full data that is unclean https://wetransfer.com/downloads/de3384467a25b7148255c6d9ef022c0f20220203043147/95d780
Solution 1:[1]
If you can update it use the string replace function in python
stringvariable.replace(' ','')
That should do it
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | somebody coding |