1. import os
2.  
3. import pandas as pd
4.  
5. FILE_PATH = r'C:\Users\tskar\Desktop\Passportization.xls'
6. BASE_DIR = r'C:\Users\tskar\Desktop\base.xlsx'
7. DIRECTORY = 'clinics'
8.  
9.  
10. def to_excel(file, out_name):
11.     file.to_excel(out_name)
12.  
13.  
14. def refine_files(file):
15.     refined = file[file['Unnamed: 1'].notna()][['Unnamed: 1', 'Unnamed: 2']]
16.     return refined
17.  
18.  
19. def main():
20.     base = pd.read_excel(BASE_DIR)
21.  
22.     # fn - daabrunebs failis saxelebs am direeqtoriashi
23.     # path.join sachiroa ro mtliani failis misamarti aawyo directorias + failis saxeli, os.join gaaaketebs magas
24.     for fn in os.listdir(DIRECTORY):
25.         file = os.path.join(DIRECTORY, fn)
26.         df = refine_files(pd.read_excel(file))
27.         # base-s daemateba da daemateba
28.         # tab-ebis da egetbs gasworreba ari ctrl+shift+l rorame
29.         base = base.merge(df, left_on='Unnamed: 1', right_on='Unnamed: 1')
30.  
31.     to_excel(base, 'res.xlsx')
32.  
33.  
34. if __name__ == "__main__":
35.     main()
36.