Guest User

Untitled

a guest
Aug 5th, 2020
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.71 KB | None | 0 0
  1.  
  2. def fillDatabase():
  3.     df = pd.read_excel("/Users/farmaceut/Sites/journals_database/journals.xlsx", header=[2, 3])
  4.     df = df.replace(np.nan, '', regex=True)
  5.     for col in df.columns[8:]:
  6.         Domain.objects.update_or_create(domain_name=col[0])
  7.         print("DOMAIN")
  8.     for index, col in df.iterrows():
  9.         print("ITERROWS")
  10.         obj, created = Journal.objects.update_or_create(title=col[1], abbreviation=col[4], impact_factor=0,
  11.                                                         ministerial_points=col[7])
  12.         i = 8
  13.         for cell in col[i:51]:
  14.             if cell == 'x':
  15.                 column_name = df.columns[i][0]
  16.                 obj.domain.add(column_name)
  17.             i = i + 1
Add Comment
Please, Sign In to add comment