4. 
A Ivkovic
6. 
A. IVKOVIC
12. ADAM IVKOVIC
13. ADAM IVKOVIC
15. ADRIANA MARIE IVKOVIC
19. AGOSLAV IVKOVIC
22. ALAN IVKOVIC
23. Aleksanda Ivkovic ♂
24. Aleksandar Ivkovic
25. Aleksandar IVKOVIC
26. Aleksandar IVKOVIC
28. ALEKSANDAR IVKOVIC
import pandas as pd import numpy as np import matplotlib.pyplot as plt from fuzzywuzzy import fuzz pd.set_option(`max_columns`, 50) import pyodbc from pandas.io import sql cols=[`ISSUER_NAME`,`CPTY_NAME`,`SIMILARITY_1`,`SIMILARITY_2`,`FLAG`] data = [] sql_conn=pyodbc.connect(`DRIVER={ODBC Driver 11 for SQL Server}; SERVER=RADO-THINKPAD; DATABASE=IVAN; Trusted_Connection=yes`) query = SELECT * FROM dbo.issuer TABLE = pd.read_sql(query, sql_conn) final = fuzz.token_set_ratio(s1, s2) for s1, s2 in TABLE.itertuples(index=False): final = fuzz.token_set_ratio(s1, s2) final1 = fuzz.partial_ratio(s1, s2) if final>50 and final1>50: flag=`YES` else: flag=`NO` data.append((s1, s2, final, final1, flag)) result = pd.DataFrame(data, columns=cols) result.to_csv(file_name, sep=`,`) 
©
29. ALEKSANDAR IVKOVIC
30. ALEKSANDAR IVKOVIC
31. ALEKSANDAR IVKOVIC
32. ALEKSANDAR IVKOVIC
33. ALEKSANDAR IVKOVIC
34. ALEKSANDAR IVKOVIC
35. ALEKSANDAR IVKOVIC
36. ALEKSANDAR IVKOVIC
37. ALEKSANDAR IVKOVIC
38. ALEKSANDAR IVKOVIC
39. ALEKSANDAR IVKOVIC
40. ALEKSANDAR IVKOVIC
43. ALEKSANDAR IVKOVIC
45. Aleksander Ivkovic ♂
46. Alen IVKOVIC
47. Alen IVKOVIC
48. ALEN IVKOVIC
49. ALES IVKOVIC
50. ALES IVKOVIC
51. ALES IVKOVIC
52. Alex Ivkovic ♂
53. Alex Ivkovic ♂
54. ALEX IVKOVIC
55. ALEXANDER P IVKOVIC ♐
57. Alexandra Ivkovic ♀