Diffusion Open Access Compliance Check Tool (OACCT) (issn4frontend) Browse

06_oacct_sherpa.md
64642b6ac544issn4frontend

06_oacct_sherpa.md
View Options

			# Projet Open Access Compliance Check Tool (OACCT)

			Projet P5 de la bibliothèque de l'EPFL en collaboration avec les bibliothèques des Universités de Genève, Lausanne et Berne : https://www.swissuniversities.ch/themen/digitalisierung/p-5-wissenschaftliche-information/projekte/swiss-mooc-service-1-1-1-1

			Ce notebook permet d'extraire les données de Sherpa/Romeo obtenues par API et les traiter pour les rendre exploitables dans l'application OACCT.

			Auteur : Pablo Iriarte, Université de Genève (pablo.iriarte@unige.ch)
			Date de dernière mise à jour : 16.07.2021

			## Données de Sherpa/Romeo

			### Exemple

			https://v2.sherpa.ac.uk/cgi/retrieve_by_id?item-type=publication&api-key=EEE6F146-678E-11EB-9C3A-202F3DE2659A&format=Json&identifier=17601


			```python
			import pandas as pd
			import csv
			import json
			import numpy as np
			import os
			# afficher toutes les colonnes
			pd.set_option('display.max_columns', None)
			```

			## Table publisher_sherpa


			```python
			# creation du DF
			col_names = ['journal',
			'publisher_id',
			'name',
			'country',
			'type',
			'url'
			]
			publisher_sherpa = pd.DataFrame(columns = col_names)
			publisher_sherpa
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>publisher_id</th>
			<th>name</th>
			<th>country</th>
			<th>type</th>
			<th>url</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>



			## Table sherpa match issn


			```python
			# creation du DF
			col_names = ['issn',
			'sherpa_match',
			]
			sherpa_match_issn = pd.DataFrame(columns = col_names)
			sherpa_match_issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>sherpa_match</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>



			## Table sherpa issns


			```python
			# creation du DF
			col_names = ['issn',
			'type',
			]
			sherpa_issn = pd.DataFrame(columns = col_names)
			sherpa_issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>type</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>



			## Table sherpa journals


			```python
			# creation du DF
			col_names = ['journal',
			'title',
			'url',
			]
			sherpa_journal = pd.DataFrame(columns = col_names)
			sherpa_journal
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>title</th>
			<th>url</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>



			## Import table Journals et ISSN


			```python
			journal = pd.read_csv('sample/journals_publishers_brut.tsv', encoding='utf-8', header=0, sep='\t')
			journal
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>issn</th>
			<th>issnl</th>
			<th>title</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>url</th>
			<th>name_short_iso_4</th>
			<th>language</th>
			<th>country</th>
			<th>doaj_title</th>
			<th>doaj_seal</th>
			<th>APC</th>
			<th>doaj_status</th>
			<th>lockss_title</th>
			<th>lockss</th>
			<th>portico_status</th>
			<th>portico</th>
			<th>nlch_title</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			<th>doublon_issnl</th>
			<th>oa_status</th>
			<th>publisher</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>1660-9379</td>
			<td>1660-9379</td>
			<td>Revue médicale suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td>NaN</td>
			<td>Rev. méd. suisse</td>
			<td>138</td>
			<td>215</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>1</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>0031-9007</td>
			<td>0031-9007</td>
			<td>Physical review letters (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>1.0</td>
			<td>1</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2</td>
			<td>3</td>
			<td>1932-6203</td>
			<td>1932-6203</td>
			<td>PloS one</td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>NaN</td>
			<td>124</td>
			<td>236</td>
			<td>PLoS ONE</td>
			<td>1.0</td>
			<td>Yes</td>
			<td>1.0</td>
			<td>PLoS One</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>4.035714</td>
			<td>NaN</td>
			<td>5</td>
			<td>3</td>
			</tr>
			<tr>
			<td>3</td>
			<td>4</td>
			<td>2174-8454</td>
			<td>2174-8454</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td>NaN</td>
			<td>EU-topías</td>
			<td>124, 138, 402, 292</td>
			<td>209</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>4, 5</td>
			</tr>
			<tr>
			<td>4</td>
			<td>5</td>
			<td>1098-0121</td>
			<td>1098-0121</td>
			<td>Physical review. B, Condensed matter and mater...</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://ojps.aip.org/prbo/</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>1.0</td>
			<td>1</td>
			<td>6</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>906</td>
			<td>997</td>
			<td>0964-1726</td>
			<td>0964-1726</td>
			<td>Smart materials and structures (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>NaN</td>
			<td>Smart mater. struct. (Print)</td>
			<td>124</td>
			<td>234</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>47</td>
			</tr>
			<tr>
			<td>907</td>
			<td>998</td>
			<td>0022-3468</td>
			<td>0022-3468</td>
			<td>Journal of pediatric surgery (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>75</td>
			</tr>
			<tr>
			<td>908</td>
			<td>999</td>
			<td>1432-2064</td>
			<td>0178-8051</td>
			<td>Probability theory and related fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>124</td>
			<td>83</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>8</td>
			</tr>
			<tr>
			<td>909</td>
			<td>1000</td>
			<td>0960-1481</td>
			<td>0960-1481</td>
			<td>Renewable energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>NaN</td>
			<td>Renew. energy</td>
			<td>124</td>
			<td>234</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>119</td>
			</tr>
			<tr>
			<td>910</td>
			<td>1001</td>
			<td>0161-7567</td>
			<td>0161-7567</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>217</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 24 columns</p>
			</div>




			```python
			issn = pd.read_csv('sample/issn_brut.tsv', encoding='utf-8', header=0, sep='\t')
			issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>issnl</th>
			<th>journal</th>
			<th>format</th>
			<th>issn_type</th>
			<th>id</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1</td>
			</tr>
			<tr>
			<td>1</td>
			<td>1399-0039</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>NaN</td>
			<td>3</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>PRINT</td>
			<td>1</td>
			<td>3</td>
			</tr>
			<tr>
			<td>3</td>
			<td>1520-4898</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>NaN</td>
			<td>3</td>
			<td>4</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4966</td>
			<td>0001-4966</td>
			<td>789</td>
			<td>PRINT</td>
			<td>1</td>
			<td>5</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1755</td>
			<td>2470-0045</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>OTHER</td>
			<td>3</td>
			<td>1756</td>
			</tr>
			<tr>
			<td>1756</td>
			<td>2470-0053</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>NaN</td>
			<td>3</td>
			<td>1757</td>
			</tr>
			<tr>
			<td>1757</td>
			<td>2475-9953</td>
			<td>2475-9953</td>
			<td>608</td>
			<td>ELECTRONIC</td>
			<td>2</td>
			<td>1758</td>
			</tr>
			<tr>
			<td>1758</td>
			<td>2504-4427</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1759</td>
			</tr>
			<tr>
			<td>1759</td>
			<td>2504-4435</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>NaN</td>
			<td>3</td>
			<td>1760</td>
			</tr>
			</tbody>
			</table>
			<p>1760 rows × 6 columns</p>
			</div>




			```python
			issn_ids = pd.read_csv('sample/issn_ids.tsv', encoding='utf-8', header=0, sep='\t')
			issn_ids
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>issn</th>
			<th>issnl</th>
			<th>journal</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>0001-2815</td>
			<td>0001-2815</td>
			<td>532</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>1399-0039</td>
			<td>0001-2815</td>
			<td>532</td>
			</tr>
			<tr>
			<td>2</td>
			<td>3</td>
			<td>0001-4842</td>
			<td>0001-4842</td>
			<td>498</td>
			</tr>
			<tr>
			<td>3</td>
			<td>4</td>
			<td>1520-4898</td>
			<td>0001-4842</td>
			<td>498</td>
			</tr>
			<tr>
			<td>4</td>
			<td>5</td>
			<td>0001-4966</td>
			<td>0001-4966</td>
			<td>789</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1755</td>
			<td>1756</td>
			<td>2470-0045</td>
			<td>2470-0045</td>
			<td>533</td>
			</tr>
			<tr>
			<td>1756</td>
			<td>1757</td>
			<td>2470-0053</td>
			<td>2470-0045</td>
			<td>533</td>
			</tr>
			<tr>
			<td>1757</td>
			<td>1758</td>
			<td>2475-9953</td>
			<td>2475-9953</td>
			<td>608</td>
			</tr>
			<tr>
			<td>1758</td>
			<td>1759</td>
			<td>2504-4427</td>
			<td>2504-4427</td>
			<td>994</td>
			</tr>
			<tr>
			<td>1759</td>
			<td>1760</td>
			<td>2504-4435</td>
			<td>2504-4427</td>
			<td>994</td>
			</tr>
			</tbody>
			</table>
			<p>1760 rows × 4 columns</p>
			</div>



			## Extraction de Sherpa Romeo


			```python
			# extraction des informations à partir des données Sherpa/Romeo
			for index, row in issn.iterrows():
			journal_id = row['journal']
			journal_issn = row['issn']
			# if (((index/10) - int(index/10)) == 0) :
			# print(index)
			# initialisation des variables à extraire
			publisher_id = np.nan
			publisher_name = ''
			publisher_country = ''
			publisher_type = ''
			publisher_url = ''
			# boucle des fichiers json
			# test d'existance du fichier
			# print(row['issn'])
			if os.path.exists('sherpa/data/' + journal_issn + '.json'):
			with open('sherpa/data/' + journal_issn + '.json', 'r', encoding='utf-8') as f:
			data = json.load(f)
			if (len(data['items']) > 0):
			publisher_id = data['items'][0]['publishers'][0]['publisher']['id']
			if ('country' in data['items'][0]['publishers'][0]['publisher']):
			publisher_country = data['items'][0]['publishers'][0]['publisher']['country']
			if ('relationship_type' in data['items'][0]['publishers'][0]):
			publisher_type = data['items'][0]['publishers'][0]['relationship_type']
			if ('url' in data['items'][0]['publishers'][0]['publisher']):
			publisher_url = data['items'][0]['publishers'][0]['publisher']['url']
			if ('name' in data['items'][0]['publishers'][0]['publisher']['name'][0]):
			publisher_name = data['items'][0]['publishers'][0]['publisher']['name'][0]['name']
			sherpa_match = 'OK'
			publisher_sherpa = publisher_sherpa.append({'journal' : journal_id, 'publisher_id' : publisher_id,
			'name' : publisher_name, 'country' : publisher_country,
			'type' : publisher_type, 'url' : publisher_url}, ignore_index=True)
			else :
			print(row['issn'] + ' - trouvé mais vide')
			sherpa_match = 'empty'
			else :
			print(row['issn'] + ' - pas trouvé')
			sherpa_match = 'missing'
			sherpa_match_issn = sherpa_match_issn.append({'issn' : row['issn'], 'sherpa_match' : sherpa_match}, ignore_index=True)
			```

			1399-0039 - pas trouvé
			1520-8524 - trouvé mais vide
			1520-9024 - pas trouvé
			1468-2834 - pas trouvé
			1551-2916 - pas trouvé
			1943-2984 - pas trouvé
			1555-7162 - trouvé mais vide
			2163-5773 - pas trouvé
			1873-4324 - trouvé mais vide
			1526-7598 - pas trouvé
			1673-3134 - pas trouvé
			1777-5884 - pas trouvé
			1528-1140 - pas trouvé
			1468-2060 - pas trouvé
			1552-6259 - pas trouvé
			0003-6935 - trouvé mais vide
			1520-8842 - pas trouvé
			0003-9926 - trouvé mais vide
			1538-3679 - pas trouvé
			0003-9942 - trouvé mais vide
			1538-3687 - pas trouvé
			1529-0131 - pas trouvé
			1090-2104 - trouvé mais vide
			1943-295X - pas trouvé
			1878-2434 - pas trouvé
			1873-2402 - trouvé mais vide
			1872-6240 - trouvé mais vide
			1365-2133 - pas trouvé
			0007-4403 - trouvé mais vide
			1968-3766 - pas trouvé
			0008-042X - trouvé mais vide
			2104-3329 - pas trouvé
			2268-7963 - pas trouvé
			1873-3948 - trouvé mais vide
			1873-4405 - trouvé mais vide
			1872-6836 - trouvé mais vide
			1873-4448 - trouvé mais vide
			1524-4571 - trouvé mais vide
			1873-7838 - trouvé mais vide
			1879-2944 - trouvé mais vide
			1873-3840 - trouvé mais vide
			1973-8102 - trouvé mais vide
			0011-1600 - trouvé mais vide
			1968-3901 - pas trouvé
			1879-2235 - trouvé mais vide
			1095-564X - trouvé mais vide
			1931-3543 - pas trouvé
			1385-013X - trouvé mais vide
			1873-3859 - trouvé mais vide
			1873-7315 - trouvé mais vide
			0013-8584 - trouvé mais vide
			2309-4672 - pas trouvé
			0014-2239 - trouvé mais vide
			2272-9011 - pas trouvé
			0945-5795 - pas trouvé
			1432-1033 - pas trouvé
			1365-2362 - pas trouvé
			1090-2422 - trouvé mais vide
			1026-7484 - trouvé mais vide
			1528-0012 - trouvé mais vide
			1872-9533 - trouvé mais vide
			0016-9161 - trouvé mais vide
			2297-7953 - pas trouvé
			1879-2189 - trouvé mais vide
			0018-0238 - trouvé mais vide
			2297-1971 - pas trouvé
			2334-3303 - pas trouvé
			1070-6313 - pas trouvé
			1873-3255 - trouvé mais vide
			1097-0215 - pas trouvé
			1879-2146 - trouvé mais vide
			0021-8170 - trouvé mais vide
			2114-6292 - pas trouvé
			1090-266X - trouvé mais vide
			1520-8850 - trouvé mais vide
			1879-1484 - trouvé mais vide
			1067-8832 - pas trouvé
			1067-8816 - pas trouvé
			1873-2380 - trouvé mais vide
			1090-2694 - trouvé mais vide
			1520-9032 - pas trouvé
			1873-3778 - trouvé mais vide
			1945-7197 - pas trouvé
			0021-9797 - trouvé mais vide
			1090-2716 - trouvé mais vide
			1873-5002 - pas trouvé
			0022-0728 - trouvé mais vide
			1879-2707 - trouvé mais vide
			1872-7883 - trouvé mais vide
			1527-2427 - trouvé mais vide
			1089-8638 - trouvé mais vide
			1873-4820 - trouvé mais vide
			1872-8561 - trouvé mais vide
			1531-5037 - trouvé mais vide
			1085-8695 - pas trouvé
			1097-6833 - pas trouvé
			1879-2553 - trouvé mais vide
			1097-6841 - pas trouvé
			2050-5639 - pas trouvé
			1873-4782 - trouvé mais vide
			1878-5883 - trouvé mais vide
			1085-8687 - pas trouvé
			1097-685X - pas trouvé
			1070-6321 - pas trouvé
			1091-756X - pas trouvé
			1939-5590 - trouvé mais vide
			1939-5604 - pas trouvé
			1873-1856 - trouvé mais vide
			1872-6143 - pas trouvé
			0025-6749 - trouvé mais vide
			1423-0356 - pas trouvé
			0026-4598 - pas trouvé
			1432-1874 - pas trouvé
			0027-4054 - trouvé mais vide
			1873-3514 - trouvé mais vide
			1873-0310 - trouvé mais vide
			1872-616X - pas trouvé
			1402-4896 - pas trouvé
			0031-8965 - trouvé mais vide
			1521-396X - pas trouvé
			1092-0145 - trouvé mais vide
			1873-3700 - pas trouvé
			1532-2548 - pas trouvé
			1527-2400 - trouvé mais vide
			0035-1121 - trouvé mais vide
			1760-7426 - pas trouvé
			0035-1784 - trouvé mais vide
			2297-1254 - pas trouvé
			0035-3655 - trouvé mais vide
			2104-385X - pas trouvé
			0036-7486 - trouvé mais vide
			1424-4004 - trouvé mais vide
			0036-7672 - trouvé mais vide
			0036-7699 - trouvé mais vide
			0036-7893 - trouvé mais vide
			2504-1452 - pas trouvé
			1471-1257 - pas trouvé
			1879-2766 - trouvé mais vide
			1879-2405 - trouvé mais vide
			1879-2758 - trouvé mais vide
			1464-5416 - pas trouvé
			1873-3581 - pas trouvé
			1664-2864 - pas trouvé
			1879-2731 - pas trouvé
			1534-6080 - trouvé mais vide
			1873-2623 - pas trouvé
			1096-0341 - trouvé mais vide
			1878-5646 - trouvé mais vide
			1879-2448 - pas trouvé
			1879-1298 - trouvé mais vide
			1879-2138 - trouvé mais vide
			0046-2497 - trouvé mais vide
			1776-2936 - pas trouvé
			1873-7625 - trouvé mais vide
			1879-2472 - pas trouvé
			2214-8019 - trouvé mais vide
			0065-7727 - trouvé mais vide
			1070-6283 - pas trouvé
			0066-6653 - trouvé mais vide
			0072-0585 - trouvé mais vide
			1079-2376 - pas trouvé
			1557-7988 - trouvé mais vide
			0081-1254 - trouvé mais vide
			1523-1755 - pas trouvé
			1085-8725 - pas trouvé
			1097-6825 - trouvé mais vide
			1096-0260 - pas trouvé
			1522-8541 - pas trouvé
			1551-7616 - pas trouvé
			1935-0465 - pas trouvé
			1070-633X - pas trouvé
			1873-4375 - trouvé mais vide
			1070-6291 - pas trouvé
			0108-2701 - trouvé mais vide
			1600-5759 - pas trouvé
			1879-0097 - pas trouvé
			1879-2081 - pas trouvé
			1873-7323 - trouvé mais vide
			1879-3452 - trouvé mais vide
			1878-5905 - trouvé mais vide
			1532-1991 - pas trouvé
			1071-2763 - pas trouvé
			1071-8842 - pas trouvé
			2156-2202 - pas trouvé
			1081-1281 - pas trouvé
			1873-7528 - trouvé mais vide
			1773-0406 - trouvé mais vide
			0151-0193 - trouvé mais vide
			2101-0218 - trouvé mais vide
			0161-7567 - trouvé mais vide
			2160-9292 - trouvé mais vide
			1095-3795 - trouvé mais vide
			1872-678X - trouvé mais vide
			1573-2517 - pas trouvé
			1872-7557 - trouvé mais vide
			1872-7123 - trouvé mais vide
			1872-7441 - trouvé mais vide
			1872-7999 - pas trouvé
			1879-1514 - pas trouvé
			1874-1754 - trouvé mais vide
			1872-7697 - trouvé mais vide
			1873-5568 - trouvé mais vide
			1872-7352 - pas trouvé
			1872-9584 - trouvé mais vide
			1600-0641 - trouvé mais vide
			1872-9576 - trouvé mais vide
			1873-5460 - pas trouvé
			1873-5584 - trouvé mais vide
			1872-695X - pas trouvé
			1432-0827 - pas trouvé
			1432-1262 - pas trouvé
			0181-5512 - trouvé mais vide
			1773-0597 - pas trouvé
			1879-2367 - trouvé mais vide
			1532-2939 - trouvé mais vide
			1527-3296 - pas trouvé
			1558-1497 - trouvé mais vide
			0221-5918 - trouvé mais vide
			0248-8663 - trouvé mais vide
			1768-3122 - trouvé mais vide
			0252-1881 - trouvé mais vide
			0252-2969 - trouvé mais vide
			1661-5468 - pas trouvé
			0254-945X - trouvé mais vide
			1662-9760 - pas trouvé
			0255-9005 - trouvé mais vide
			0258-6800 - trouvé mais vide
			1432-0819 - pas trouvé
			0259-6199 - trouvé mais vide
			1661-3171 - trouvé mais vide
			1532-1983 - pas trouvé
			1873-2518 - trouvé mais vide
			1365-2346 - pas trouvé
			1476-5365 - pas trouvé
			1067-8824 - pas trouvé
			0271-4302 - trouvé mais vide
			2158-1525 - pas trouvé
			1536-4801 - pas trouvé
			1873-457X - pas trouvé
			1531-5053 - pas trouvé
			1470-8752 - pas trouvé
			1879-176X - pas trouvé
			1873-4421 - pas trouvé
			1432-1998 - pas trouvé
			1873-6246 - pas trouvé
			1873-6777 - pas trouvé
			1879-3533 - trouvé mais vide
			1872-8057 - trouvé mais vide
			1872-7972 - trouvé mais vide
			1879-2723 - trouvé mais vide
			1879-2774 - pas trouvé
			1873-4766 - trouvé mais vide
			1362-4954 - pas trouvé
			1365-2842 - pas trouvé
			1361-6447 - trouvé mais vide
			1872-9118 - trouvé mais vide
			1873-7544 - trouvé mais vide
			1873-3360 - pas trouvé
			1873-2100 - pas trouvé
			1872-9657 - trouvé mais vide
			1499-2752 - pas trouvé
			2567-689X - trouvé mais vide
			1432-1238 - pas trouvé
			1873-684X - trouvé mais vide
			1879-355X - trouvé mais vide
			1879-3487 - trouvé mais vide
			1873-6785 - trouvé mais vide
			1546-3141 - pas trouvé
			0362-1340 - trouvé mais vide
			1523-2867 - pas trouvé
			1558-1160 - trouvé mais vide
			1432-2323 - pas trouvé
			0365-7116 - trouvé mais vide
			1873-2526 - pas trouvé
			0368-4466 - trouvé mais vide
			1588-2926 - pas trouvé
			0369-3392 - trouvé mais vide
			1873-2445 - trouvé mais vide
			0373-2525 - trouvé mais vide
			0373-2967 - trouvé mais vide
			2235-3658 - pas trouvé
			0373-6156 - trouvé mais vide
			2391-1336 - pas trouvé
			0374-4256 - trouvé mais vide
			0375-1457 - trouvé mais vide
			2419-8196 - pas trouvé
			1873-2429 - trouvé mais vide
			1872-6097 - pas trouvé
			1872-6860 - trouvé mais vide
			1574-6968 - pas trouvé
			1879-0038 - trouvé mais vide
			1873-3476 - trouvé mais vide
			1873-2755 - trouvé mais vide
			1872-6178 - trouvé mais vide
			1873-2046 - trouvé mais vide
			1872-6283 - trouvé mais vide
			0398-3412 - trouvé mais vide
			2297-5810 - pas trouvé
			0409-8757 - trouvé mais vide
			1461-7412 - pas trouvé
			1873-1562 - trouvé mais vide
			1089-4918 - trouvé mais vide
			1538-4500 - pas trouvé
			0570-0833 - trouvé mais vide
			0583-8401 - trouvé mais vide
			1872-7727 - trouvé mais vide
			1873-264X - trouvé mais vide
			1527-7755 - pas trouvé
			1520-8559 - trouvé mais vide
			1558-3597 - trouvé mais vide
			1873-5134 - pas trouvé
			1096-3677 - pas trouvé
			2213-0276 - pas trouvé
			1958-5381 - pas trouvé
			1651-2227 - pas trouvé
			0884-1616 - trouvé mais vide
			1091-8876 - pas trouvé
			1092-8928 - pas trouvé
			1089-8646 - pas trouvé
			0888-8809 - trouvé mais vide
			1944-9917 - trouvé mais vide
			1532-0987 - pas trouvé
			0894-8275 - trouvé mais vide
			1878-5921 - pas trouvé
			1520-636X - pas trouvé
			1399-3038 - pas trouvé
			1873-7196 - trouvé mais vide
			1873-4308 - trouvé mais vide
			1573-2509 - trouvé mais vide
			1879-0658 - trouvé mais vide
			1873-2135 - pas trouvé
			1873-2143 - pas trouvé
			1873-4936 - trouvé mais vide
			1873-4944 - pas trouvé
			1872-793X - trouvé mais vide
			1873-3069 - pas trouvé
			1872-8286 - trouvé mais vide
			1873-3077 - pas trouvé
			1873-4669 - trouvé mais vide
			1873-3883 - trouvé mais vide
			0926-9630 - trouvé mais vide
			1879-8365 - trouvé mais vide
			1879-3398 - trouvé mais vide
			1873-4359 - trouvé mais vide
			1879-0720 - trouvé mais vide
			1769-664X - pas trouvé
			1432-2218 - pas trouvé
			1866-6817 - pas trouvé
			1432-2277 - pas trouvé
			1435-4373 - pas trouvé
			1433-2965 - pas trouvé
			1873-3441 - pas trouvé
			1362-3044 - pas trouvé
			1879-0526 - trouvé mais vide
			1879-0828 - pas trouvé
			1879-0410 - trouvé mais vide
			1873-619X - trouvé mais vide
			1873-4235 - trouvé mais vide
			1362-511X - pas trouvé
			1879-0429 - trouvé mais vide
			1879-1786 - trouvé mais vide
			1879-0852 - pas trouvé
			1879-0682 - pas trouvé
			1873-2976 - trouvé mais vide
			1464-3405 - trouvé mais vide
			1466-1861 - pas trouvé
			1555-3892 - pas trouvé
			1360-0443 - pas trouvé
			1464-3391 - trouvé mais vide
			1879-2359 - pas trouvé
			0992-986X - trouvé mais vide
			2119-4130 - pas trouvé
			0995-3817 - trouvé mais vide
			2219-2840 - pas trouvé
			1010-2248 - trouvé mais vide
			1664-9885 - pas trouvé
			1873-2666 - pas trouvé
			1017-0588 - trouvé mais vide
			1018-7987 - trouvé mais vide
			1019-0406 - trouvé mais vide
			1023-2044 - trouvé mais vide
			1023-9332 - trouvé mais vide
			2235-1884 - pas trouvé
			1560-7917 - pas trouvé
			1026-7530 - pas trouvé
			1607-8489 - pas trouvé
			1127-2236 - pas trouvé
			1938-808X - pas trouvé
			1095-8657 - trouvé mais vide
			1536-3732 - pas trouvé
			1049-5258 - trouvé mais vide
			1538-4446 - pas trouvé
			1095-9572 - trouvé mais vide
			1532-6500 - trouvé mais vide
			1059-1524 - trouvé mais vide
			1095-3787 - trouvé mais vide
			1538-4519 - trouvé mais vide
			1063-6919 - trouvé mais vide
			2332-564X - pas trouvé
			2575-7075 - pas trouvé
			1940-6029 - trouvé mais vide
			1527-2435 - pas trouvé
			1527-2419 - pas trouvé
			1071-1023 - trouvé mais vide
			1520-8567 - pas trouvé
			1090-235X - trouvé mais vide
			1532-2130 - pas trouvé
			1096-0856 - trouvé mais vide
			1538-4489 - pas trouvé
			1155-4339 - trouvé mais vide
			1764-7177 - pas trouvé
			1460-9592 - pas trouvé
			1878-3511 - pas trouvé
			1778-7254 - pas trouvé
			1873-4030 - pas trouvé
			1873-2844 - trouvé mais vide
			1873-5126 - trouvé mais vide
			1873-5606 - pas trouvé
			1873-2453 - trouvé mais vide
			1872-8456 - pas trouvé
			2040-2058 - pas trouvé
			1878-5840 - trouvé mais vide
			1473-6519 - pas trouvé
			1879-0690 - trouvé mais vide
			1466-609X - pas trouvé
			1367-4811 - trouvé mais vide
			1873-4286 - pas trouvé
			1873-3212 - trouvé mais vide
			1873-1759 - pas trouvé
			1875-8908 - trouvé mais vide
			1872-8952 - trouvé mais vide
			1873-1902 - trouvé mais vide
			1600-0854 - pas trouvé
			1420-5556 - trouvé mais vide
			1420-7192 - trouvé mais vide
			1662-0879 - pas trouvé
			1422-2019 - trouvé mais vide
			1422-3449 - trouvé mais vide
			1422-5778 - trouvé mais vide
			2504-1436 - pas trouvé
			1423-3967 - trouvé mais vide
			1663-3997 - pas trouvé
			1424-1811 - trouvé mais vide
			2504-1460 - pas trouvé
			1424-4020 - pas trouvé
			1424-7410 - trouvé mais vide
			1424-7755 - trouvé mais vide
			1436-3771 - pas trouvé
			1434-6028 - trouvé mais vide
			1434-6036 - trouvé mais vide
			1439-4456 - pas trouvé
			1449-8979 - pas trouvé
			1873-6416 - trouvé mais vide
			1465-6914 - trouvé mais vide
			1478-6362 - pas trouvé
			1520-6149 - trouvé mais vide
			2379-190X - trouvé mais vide
			1522-1601 - pas trouvé
			1708-8208 - pas trouvé
			1944-7884 - pas trouvé
			1527-6473 - pas trouvé
			1947-3893 - pas trouvé
			1530-1591 - trouvé mais vide
			1558-1101 - pas trouvé
			1860-2002 - pas trouvé
			1552-5279 - pas trouvé
			1557-170X - trouvé mais vide
			1878-5530 - trouvé mais vide
			1878-1519 - trouvé mais vide
			1569-9293 - pas trouvé
			1873-376X - pas trouvé
			1720-8319 - pas trouvé
			1610-0379 - trouvé mais vide
			1610-0387 - pas trouvé
			1778-3569 - trouvé mais vide
			1660-3362 - trouvé mais vide
			1660-9379 - trouvé mais vide
			1660-9603 - trouvé mais vide
			1661-1179 - trouvé mais vide
			1661-2620 - trouvé mais vide
			1661-464X - trouvé mais vide
			1661-4941 - trouvé mais vide
			1661-8165 - pas trouvé
			1662-551X - pas trouvé
			1662-5536 - trouvé mais vide
			1662-6001 - trouvé mais vide
			1662-601X - pas trouvé
			1662-8705 - trouvé mais vide
			1777-5477 - trouvé mais vide
			1810-7621 - pas trouvé
			1863-2300 - pas trouvé
			1873-2763 - trouvé mais vide
			1876-7737 - pas trouvé
			1878-8769 - trouvé mais vide
			1939-5175 - trouvé mais vide
			1945-7928 - trouvé mais vide
			1945-7936 - pas trouvé
			1945-8452 - trouvé mais vide
			1992-2655 - trouvé mais vide
			2050-7534 - trouvé mais vide
			2101-6275 - pas trouvé
			2161-2129 - pas trouvé
			2160-5033 - trouvé mais vide
			2160-5041 - pas trouvé
			2160-9020 - trouvé mais vide
			2160-9047 - pas trouvé
			2164-3342 - trouvé mais vide
			2174-8454 - trouvé mais vide
			2340-115X - pas trouvé
			2211-3282 - trouvé mais vide
			2264-7228 - trouvé mais vide
			2297-0703 - trouvé mais vide
			2297-6981 - trouvé mais vide
			2297-7007 - pas trouvé
			2352-1791 - trouvé mais vide
			2504-4427 - trouvé mais vide
			2504-4435 - trouvé mais vide



			```python
			publisher_sherpa
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>publisher_id</th>
			<th>name</th>
			<th>country</th>
			<th>type</th>
			<th>url</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>532</td>
			<td>45</td>
			<td>John Wiley and Sons</td>
			<td>gb</td>
			<td>former_publisher</td>
			<td>http://www.wiley.com/</td>
			</tr>
			<tr>
			<td>1</td>
			<td>498</td>
			<td>4</td>
			<td>American Chemical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://pubs.acs.org/</td>
			</tr>
			<tr>
			<td>2</td>
			<td>498</td>
			<td>4</td>
			<td>American Chemical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://pubs.acs.org/</td>
			</tr>
			<tr>
			<td>3</td>
			<td>789</td>
			<td>126</td>
			<td>Acoustical Society of America</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://acousticalsociety.org/</td>
			</tr>
			<tr>
			<td>4</td>
			<td>166</td>
			<td>3291</td>
			<td>Springer</td>
			<td>gb</td>
			<td>commercial_publisher</td>
			<td>https://www.springernature.com/gp/products/jou...</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1238</td>
			<td>80</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1239</td>
			<td>80</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1240</td>
			<td>533</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1241</td>
			<td>533</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1242</td>
			<td>608</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			</tbody>
			</table>
			<p>1243 rows × 6 columns</p>
			</div>




			```python
			sherpa_match_issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>sherpa_match</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1</td>
			<td>1399-0039</td>
			<td>missing</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>3</td>
			<td>1520-4898</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4966</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1755</td>
			<td>2470-0045</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1756</td>
			<td>2470-0053</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1757</td>
			<td>2475-9953</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1758</td>
			<td>2504-4427</td>
			<td>empty</td>
			</tr>
			<tr>
			<td>1759</td>
			<td>2504-4435</td>
			<td>empty</td>
			</tr>
			</tbody>
			</table>
			<p>1760 rows × 2 columns</p>
			</div>




			```python
			# dedup
			publisher_sherpa_dedup = publisher_sherpa.drop_duplicates()
			publisher_sherpa_dedup
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>publisher_id</th>
			<th>name</th>
			<th>country</th>
			<th>type</th>
			<th>url</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>532</td>
			<td>45</td>
			<td>John Wiley and Sons</td>
			<td>gb</td>
			<td>former_publisher</td>
			<td>http://www.wiley.com/</td>
			</tr>
			<tr>
			<td>1</td>
			<td>498</td>
			<td>4</td>
			<td>American Chemical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://pubs.acs.org/</td>
			</tr>
			<tr>
			<td>3</td>
			<td>789</td>
			<td>126</td>
			<td>Acoustical Society of America</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://acousticalsociety.org/</td>
			</tr>
			<tr>
			<td>4</td>
			<td>166</td>
			<td>3291</td>
			<td>Springer</td>
			<td>gb</td>
			<td>commercial_publisher</td>
			<td>https://www.springernature.com/gp/products/jou...</td>
			</tr>
			<tr>
			<td>6</td>
			<td>807</td>
			<td>3291</td>
			<td>Springer</td>
			<td>gb</td>
			<td>commercial_publisher</td>
			<td>https://www.springernature.com/gp/products/jou...</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1235</td>
			<td>870</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1236</td>
			<td>41</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1238</td>
			<td>80</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1240</td>
			<td>533</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			<tr>
			<td>1242</td>
			<td>608</td>
			<td>10</td>
			<td>American Physical Society</td>
			<td>us</td>
			<td>society_publisher</td>
			<td>http://www.aps.org/</td>
			</tr>
			</tbody>
			</table>
			<p>808 rows × 6 columns</p>
			</div>




			```python
			sherpa_match_issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>sherpa_match</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1</td>
			<td>1399-0039</td>
			<td>missing</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>3</td>
			<td>1520-4898</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4966</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1755</td>
			<td>2470-0045</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1756</td>
			<td>2470-0053</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1757</td>
			<td>2475-9953</td>
			<td>OK</td>
			</tr>
			<tr>
			<td>1758</td>
			<td>2504-4427</td>
			<td>empty</td>
			</tr>
			<tr>
			<td>1759</td>
			<td>2504-4435</td>
			<td>empty</td>
			</tr>
			</tbody>
			</table>
			<p>1760 rows × 2 columns</p>
			</div>




			```python
			# ajout du issnl et du titre
			sherpa_match_issn = pd.merge(sherpa_match_issn, issn_ids, on='issn', how='left')
			sherpa_match_issn = pd.merge(sherpa_match_issn, journal[['issnl', 'title']], on='issnl', how='left')
			sherpa_match_issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>sherpa_match</th>
			<th>id</th>
			<th>issnl</th>
			<th>journal</th>
			<th>title</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>OK</td>
			<td>1</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>Tissue antigens</td>
			</tr>
			<tr>
			<td>1</td>
			<td>1399-0039</td>
			<td>missing</td>
			<td>2</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>Tissue antigens</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>OK</td>
			<td>3</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>Accounts of chemical research</td>
			</tr>
			<tr>
			<td>3</td>
			<td>1520-4898</td>
			<td>OK</td>
			<td>4</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>Accounts of chemical research</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4966</td>
			<td>OK</td>
			<td>5</td>
			<td>0001-4966</td>
			<td>789</td>
			<td>The Journal of the Acoustical Society of America</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1755</td>
			<td>2470-0045</td>
			<td>OK</td>
			<td>1756</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>Physical review. E (Print)</td>
			</tr>
			<tr>
			<td>1756</td>
			<td>2470-0053</td>
			<td>OK</td>
			<td>1757</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>Physical review. E (Print)</td>
			</tr>
			<tr>
			<td>1757</td>
			<td>2475-9953</td>
			<td>OK</td>
			<td>1758</td>
			<td>2475-9953</td>
			<td>608</td>
			<td>Physical review materials</td>
			</tr>
			<tr>
			<td>1758</td>
			<td>2504-4427</td>
			<td>empty</td>
			<td>1759</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>GG@G (Print)</td>
			</tr>
			<tr>
			<td>1759</td>
			<td>2504-4435</td>
			<td>empty</td>
			<td>1760</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>GG@G (Print)</td>
			</tr>
			</tbody>
			</table>
			<p>1760 rows × 6 columns</p>
			</div>




			```python
			sherpa_match_results = sherpa_match_issn[['id', 'issnl', 'sherpa_match']].groupby(['issnl', 'sherpa_match']).count()
			sherpa_match_results
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th></th>
			<th>id</th>
			</tr>
			<tr>
			<th>issnl</th>
			<th>sherpa_match</th>
			<th></th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td rowspan="2" valign="top">0001-2815</td>
			<td>OK</td>
			<td>1</td>
			</tr>
			<tr>
			<td>missing</td>
			<td>1</td>
			</tr>
			<tr>
			<td>0001-4842</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td rowspan="2" valign="top">0001-4966</td>
			<td>OK</td>
			<td>1</td>
			</tr>
			<tr>
			<td>empty</td>
			<td>1</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>2469-9950</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2470-0010</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2470-0045</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2475-9953</td>
			<td>OK</td>
			<td>1</td>
			</tr>
			<tr>
			<td>2504-4427</td>
			<td>empty</td>
			<td>2</td>
			</tr>
			</tbody>
			</table>
			<p>1302 rows × 1 columns</p>
			</div>




			```python
			sherpa_match_results = sherpa_match_results.reset_index()
			sherpa_match_results
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issnl</th>
			<th>sherpa_match</th>
			<th>id</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>OK</td>
			<td>1</td>
			</tr>
			<tr>
			<td>1</td>
			<td>0001-2815</td>
			<td>missing</td>
			<td>1</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td>3</td>
			<td>0001-4966</td>
			<td>OK</td>
			<td>1</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4966</td>
			<td>empty</td>
			<td>1</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1297</td>
			<td>2469-9950</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td>1298</td>
			<td>2470-0010</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td>1299</td>
			<td>2470-0045</td>
			<td>OK</td>
			<td>2</td>
			</tr>
			<tr>
			<td>1300</td>
			<td>2475-9953</td>
			<td>OK</td>
			<td>1</td>
			</tr>
			<tr>
			<td>1301</td>
			<td>2504-4427</td>
			<td>empty</td>
			<td>2</td>
			</tr>
			</tbody>
			</table>
			<p>1302 rows × 3 columns</p>
			</div>




			```python
			sherpa_match_results_ok = sherpa_match_results.loc[sherpa_match_results['sherpa_match'] == 'OK']
			issn_ids_issnl = issn_ids[['issnl', 'journal']].drop_duplicates(subset='issnl')
			issn_ids_issnl = pd.merge(issn_ids_issnl, sherpa_match_results_ok, on='issnl', how='left')
			issn_ids_issnl = pd.merge(issn_ids_issnl, journal[['issnl', 'title']], on='issnl', how='left')
			issn_ids_issnl
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issnl</th>
			<th>journal</th>
			<th>sherpa_match</th>
			<th>id</th>
			<th>title</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>OK</td>
			<td>1.0</td>
			<td>Tissue antigens</td>
			</tr>
			<tr>
			<td>1</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>OK</td>
			<td>2.0</td>
			<td>Accounts of chemical research</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4966</td>
			<td>789</td>
			<td>OK</td>
			<td>1.0</td>
			<td>The Journal of the Acoustical Society of America</td>
			</tr>
			<tr>
			<td>3</td>
			<td>0001-6268</td>
			<td>166</td>
			<td>OK</td>
			<td>2.0</td>
			<td>Acta neurochirurgica</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-6322</td>
			<td>807</td>
			<td>OK</td>
			<td>2.0</td>
			<td>Acta neuropathologica</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>904</td>
			<td>2469-9950</td>
			<td>41</td>
			<td>OK</td>
			<td>2.0</td>
			<td>Physical review. B</td>
			</tr>
			<tr>
			<td>905</td>
			<td>2470-0010</td>
			<td>80</td>
			<td>OK</td>
			<td>2.0</td>
			<td>Physical review. D</td>
			</tr>
			<tr>
			<td>906</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>OK</td>
			<td>2.0</td>
			<td>Physical review. E (Print)</td>
			</tr>
			<tr>
			<td>907</td>
			<td>2475-9953</td>
			<td>608</td>
			<td>OK</td>
			<td>1.0</td>
			<td>Physical review materials</td>
			</tr>
			<tr>
			<td>908</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>GG@G (Print)</td>
			</tr>
			</tbody>
			</table>
			<p>909 rows × 5 columns</p>
			</div>




			```python
			journals_not_sherpa = issn_ids_issnl.loc[issn_ids_issnl['sherpa_match'].isna()]
			journals_not_sherpa
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issnl</th>
			<th>journal</th>
			<th>sherpa_match</th>
			<th>id</th>
			<th>title</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>24</td>
			<td>0003-6935</td>
			<td>398</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Applied optics</td>
			</tr>
			<tr>
			<td>27</td>
			<td>0003-9926</td>
			<td>605</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Archives of internal medicine (1960)</td>
			</tr>
			<tr>
			<td>28</td>
			<td>0003-9942</td>
			<td>974</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Archives of neurology (Chicago)</td>
			</tr>
			<tr>
			<td>47</td>
			<td>0007-4403</td>
			<td>885</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Bulletin de psychologie</td>
			</tr>
			<tr>
			<td>48</td>
			<td>0008-042X</td>
			<td>180</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Cahiers pédagogiques (Revue)</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>889</td>
			<td>2264-7228</td>
			<td>503</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Distances et médiations des savoirs</td>
			</tr>
			<tr>
			<td>892</td>
			<td>2297-0703</td>
			<td>989</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Schweizer Krebs-Bulletin</td>
			</tr>
			<tr>
			<td>893</td>
			<td>2297-6981</td>
			<td>618</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Swiss archives of neurology, psychiatry and ps...</td>
			</tr>
			<tr>
			<td>898</td>
			<td>2352-1791</td>
			<td>639</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Nuclear materials and energy</td>
			</tr>
			<tr>
			<td>908</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>GG@G (Print)</td>
			</tr>
			</tbody>
			</table>
			<p>101 rows × 5 columns</p>
			</div>




			```python
			sherpa_match_results_empty = sherpa_match_results.loc[sherpa_match_results['sherpa_match'] == 'empty']
			sherpa_match_results_missing = sherpa_match_results.loc[sherpa_match_results['sherpa_match'] == 'missing']
			del journals_not_sherpa['sherpa_match']
			del journals_not_sherpa['id']
			journals_not_sherpa = pd.merge(journals_not_sherpa, sherpa_match_results_empty, on='issnl', how='left')
			del journals_not_sherpa['id']
			journals_not_sherpa = pd.merge(journals_not_sherpa, sherpa_match_results_missing, on='issnl', how='left')
			del journals_not_sherpa['id']
			journals_not_sherpa
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issnl</th>
			<th>journal</th>
			<th>title</th>
			<th>sherpa_match_x</th>
			<th>sherpa_match_y</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0003-6935</td>
			<td>398</td>
			<td>Applied optics</td>
			<td>empty</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>0003-9926</td>
			<td>605</td>
			<td>Archives of internal medicine (1960)</td>
			<td>empty</td>
			<td>missing</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0003-9942</td>
			<td>974</td>
			<td>Archives of neurology (Chicago)</td>
			<td>empty</td>
			<td>missing</td>
			</tr>
			<tr>
			<td>3</td>
			<td>0007-4403</td>
			<td>885</td>
			<td>Bulletin de psychologie</td>
			<td>empty</td>
			<td>missing</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0008-042X</td>
			<td>180</td>
			<td>Cahiers pédagogiques (Revue)</td>
			<td>empty</td>
			<td>missing</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>96</td>
			<td>2264-7228</td>
			<td>503</td>
			<td>Distances et médiations des savoirs</td>
			<td>empty</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>97</td>
			<td>2297-0703</td>
			<td>989</td>
			<td>Schweizer Krebs-Bulletin</td>
			<td>empty</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>98</td>
			<td>2297-6981</td>
			<td>618</td>
			<td>Swiss archives of neurology, psychiatry and ps...</td>
			<td>empty</td>
			<td>missing</td>
			</tr>
			<tr>
			<td>99</td>
			<td>2352-1791</td>
			<td>639</td>
			<td>Nuclear materials and energy</td>
			<td>empty</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>100</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>GG@G (Print)</td>
			<td>empty</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>101 rows × 5 columns</p>
			</div>




			```python
			# extraction des informations des journaux à partir des données Sherpa/Romeo
			for index, row in issn.iterrows():
			journal_id = row['journal']
			journal_issn = row['issn']
			# boucle des fichiers json
			# test d'existance du fichier
			# print(row['format'])
			if (((index/10) - int(index/10)) == 0) :
			print(index)
			if os.path.exists('sherpa/data/' + journal_issn + '.json'):
			with open('sherpa/data/' + journal_issn + '.json', 'r', encoding='utf-8') as f:
			data = json.load(f)
			title = np.nan
			url = np.nan
			if (len(data['items']) > 0):
			if ('url' in data['items'][0]):
			url = data['items'][0]['url']
			if ('title' in data['items'][0]['title'][0]):
			title = data['items'][0]['title'][0]['title']
			sherpa_journal = sherpa_journal.append({'journal' : journal_id, 'title' : title, 'url' : url}, ignore_index=True)
			```

			0
			10
			20
			30
			40
			50
			60
			70
			80
			90
			100
			110
			120
			130
			140
			150
			160
			170
			180
			190
			200
			210
			220
			230
			240
			250
			260
			270
			280
			290
			300
			310
			320
			330
			340
			350
			360
			370
			380
			390
			400
			410
			420
			430
			440
			450
			460
			470
			480
			490
			500
			510
			520
			530
			540
			550
			560
			570
			580
			590
			600
			610
			620
			630
			640
			650
			660
			670
			680
			690
			700
			710
			720
			730
			740
			750
			760
			770
			780
			790
			800
			810
			820
			830
			840
			850
			860
			870
			880
			890
			900
			910
			920
			930
			940
			950
			960
			970
			980
			990
			1000
			1010
			1020
			1030
			1040
			1050
			1060
			1070
			1080
			1090
			1100
			1110
			1120
			1130
			1140
			1150
			1160
			1170
			1180
			1190
			1200
			1210
			1220
			1230
			1240
			1250
			1260
			1270
			1280
			1290
			1300
			1310
			1320
			1330
			1340
			1350
			1360
			1370
			1380
			1390
			1400
			1410
			1420
			1430
			1440
			1450
			1460
			1470
			1480
			1490
			1500
			1510
			1520
			1530
			1540
			1550
			1560
			1570
			1580
			1590
			1600
			1610
			1620
			1630
			1640
			1650
			1660
			1670
			1680
			1690
			1700
			1710
			1720
			1730
			1740
			1750



			```python
			sherpa_journal
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>title</th>
			<th>url</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>532</td>
			<td>Tissue Antigens</td>
			<td>http://onlinelibrary.wiley.com/journal/10.1111...</td>
			</tr>
			<tr>
			<td>1</td>
			<td>498</td>
			<td>Accounts of Chemical Research</td>
			<td>http://pubs.acs.org/journal/achre4</td>
			</tr>
			<tr>
			<td>2</td>
			<td>498</td>
			<td>Accounts of Chemical Research</td>
			<td>http://pubs.acs.org/journal/achre4</td>
			</tr>
			<tr>
			<td>3</td>
			<td>789</td>
			<td>The Journal of the Acoustical Society of America</td>
			<td>http://asa.scitation.org/journal/jas</td>
			</tr>
			<tr>
			<td>4</td>
			<td>166</td>
			<td>Acta Neurochirurgica</td>
			<td>http://link.springer.com/journal/701</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1238</td>
			<td>80</td>
			<td>Physical Review D</td>
			<td>http://prd.aps.org/</td>
			</tr>
			<tr>
			<td>1239</td>
			<td>80</td>
			<td>Physical Review D</td>
			<td>http://prd.aps.org/</td>
			</tr>
			<tr>
			<td>1240</td>
			<td>533</td>
			<td>Physical Review E</td>
			<td>http://journals.aps.org/pre/abstract/10.1103/P...</td>
			</tr>
			<tr>
			<td>1241</td>
			<td>533</td>
			<td>Physical Review E</td>
			<td>http://journals.aps.org/pre/abstract/10.1103/P...</td>
			</tr>
			<tr>
			<td>1242</td>
			<td>608</td>
			<td>Physical Review Materials</td>
			<td>http://journals.aps.org/prmaterials/</td>
			</tr>
			</tbody>
			</table>
			<p>1243 rows × 3 columns</p>
			</div>




			```python
			# extraction des informations à partir des données Sherpa/Romeo
			for index, row in issn.iterrows():
			journal_id = row['journal']
			journal_issn = row['issn']
			# boucle des fichiers json
			# test d'existance du fichier
			# print(row['format'])
			if (((index/10) - int(index/10)) == 0) :
			print(index)
			if os.path.exists('sherpa/data/' + journal_issn + '.json'):
			with open('sherpa/data/' + journal_issn + '.json', 'r', encoding='utf-8') as f:
			myissn = np.nan
			mytype = np.nan
			data = json.load(f)
			if (len(data['items']) > 0):
			if ('issns' in data['items'][0]):
			issns = data['items'][0]['issns']
			for i in issns:
			if ('issn' in i):
			myissn = i['issn']
			if ('type' in i):
			mytype = i['type']
			sherpa_issn = sherpa_issn.append({'issn' : myissn, 'type' : mytype}, ignore_index=True)
			```

			0
			10
			20
			30
			40
			50
			60
			70
			80
			90
			100
			110
			120
			130
			140
			150
			160
			170
			180
			190
			200
			210
			220
			230
			240
			250
			260
			270
			280
			290
			300
			310
			320
			330
			340
			350
			360
			370
			380
			390
			400
			410
			420
			430
			440
			450
			460
			470
			480
			490
			500
			510
			520
			530
			540
			550
			560
			570
			580
			590
			600
			610
			620
			630
			640
			650
			660
			670
			680
			690
			700
			710
			720
			730
			740
			750
			760
			770
			780
			790
			800
			810
			820
			830
			840
			850
			860
			870
			880
			890
			900
			910
			920
			930
			940
			950
			960
			970
			980
			990
			1000
			1010
			1020
			1030
			1040
			1050
			1060
			1070
			1080
			1090
			1100
			1110
			1120
			1130
			1140
			1150
			1160
			1170
			1180
			1190
			1200
			1210
			1220
			1230
			1240
			1250
			1260
			1270
			1280
			1290
			1300
			1310
			1320
			1330
			1340
			1350
			1360
			1370
			1380
			1390
			1400
			1410
			1420
			1430
			1440
			1450
			1460
			1470
			1480
			1490
			1500
			1510
			1520
			1530
			1540
			1550
			1560
			1570
			1580
			1590
			1600
			1610
			1620
			1630
			1640
			1650
			1660
			1670
			1680
			1690
			1700
			1710
			1720
			1730
			1740
			1750



			```python
			sherpa_issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>type</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>print</td>
			</tr>
			<tr>
			<td>1</td>
			<td>1399-0039</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>print</td>
			</tr>
			<tr>
			<td>3</td>
			<td>1520-4898</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4842</td>
			<td>print</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>2196</td>
			<td>2470-0045</td>
			<td>print</td>
			</tr>
			<tr>
			<td>2197</td>
			<td>2470-0053</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>2198</td>
			<td>2470-0045</td>
			<td>print</td>
			</tr>
			<tr>
			<td>2199</td>
			<td>2470-0053</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>2200</td>
			<td>2475-9953</td>
			<td>electronic</td>
			</tr>
			</tbody>
			</table>
			<p>2201 rows × 2 columns</p>
			</div>




			```python
			# dedup
			sherpa_issn = sherpa_issn.drop_duplicates()
			sherpa_issn
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>type</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>print</td>
			</tr>
			<tr>
			<td>1</td>
			<td>1399-0039</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>print</td>
			</tr>
			<tr>
			<td>3</td>
			<td>1520-4898</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>6</td>
			<td>0001-4966</td>
			<td>print</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>2192</td>
			<td>2470-0010</td>
			<td>print</td>
			</tr>
			<tr>
			<td>2193</td>
			<td>2470-0029</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>2196</td>
			<td>2470-0045</td>
			<td>print</td>
			</tr>
			<tr>
			<td>2197</td>
			<td>2470-0053</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>2200</td>
			<td>2475-9953</td>
			<td>electronic</td>
			</tr>
			</tbody>
			</table>
			<p>1333 rows × 2 columns</p>
			</div>




			```python
			# completer le fichier des issns avec les types de sherpa
			issn2 = pd.merge(issn, sherpa_issn, on='issn', how='left')
			issn2
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>issnl</th>
			<th>journal</th>
			<th>format</th>
			<th>issn_type</th>
			<th>id</th>
			<th>type</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1</td>
			<td>print</td>
			</tr>
			<tr>
			<td>1</td>
			<td>1399-0039</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>NaN</td>
			<td>3</td>
			<td>2</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>PRINT</td>
			<td>1</td>
			<td>3</td>
			<td>print</td>
			</tr>
			<tr>
			<td>3</td>
			<td>1520-4898</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>NaN</td>
			<td>3</td>
			<td>4</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4966</td>
			<td>0001-4966</td>
			<td>789</td>
			<td>PRINT</td>
			<td>1</td>
			<td>5</td>
			<td>print</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1755</td>
			<td>2470-0045</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>OTHER</td>
			<td>3</td>
			<td>1756</td>
			<td>print</td>
			</tr>
			<tr>
			<td>1756</td>
			<td>2470-0053</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>NaN</td>
			<td>3</td>
			<td>1757</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>1757</td>
			<td>2475-9953</td>
			<td>2475-9953</td>
			<td>608</td>
			<td>ELECTRONIC</td>
			<td>2</td>
			<td>1758</td>
			<td>electronic</td>
			</tr>
			<tr>
			<td>1758</td>
			<td>2504-4427</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1759</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1759</td>
			<td>2504-4435</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>NaN</td>
			<td>3</td>
			<td>1760</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>1760 rows × 7 columns</p>
			</div>




			```python
			# exports csv
			publisher_sherpa_dedup.to_csv('sample/publisher_sherpa.tsv', sep='\t', encoding='utf-8', index=False)
			sherpa_match_issn.to_csv('sample/sherpa_match_issn.tsv', sep='\t', encoding='utf-8', index=False)
			sherpa_journal.to_csv('sample/sherpa_journal.tsv', sep='\t', encoding='utf-8', index=False)
			issn2.to_csv('sample/issn_sherpa.tsv', sep='\t', encoding='utf-8', index=False)
			journals_not_sherpa.to_csv('sample/journals_not_sherpa.tsv', sep='\t', encoding='utf-8', index=False)
			```


			```python
			# exports excel
			publisher_sherpa_dedup.to_excel('sample/publisher_sherpa.xlsx', index=False)
			sherpa_match_issn.to_excel('sample/sherpa_match_issn.xlsx', index=False)
			sherpa_journal.to_excel('sample/sherpa_journal.xlsx', index=False)
			issn2.to_excel('sample/issn_sherpa.xlsx', index=False)
			journals_not_sherpa.to_excel('sample/journals_not_sherpa.xlsx', index=False)
			```


			```python
			# ajout des titres Sherpa a la table des revues
			# renommer les colonnes
			sherpa_journal = sherpa_journal.rename(columns={'journal' : 'id'})
			journal = pd.merge(journal, sherpa_journal, on='id', how='left')
			journal
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>issn</th>
			<th>issnl</th>
			<th>title_x</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>url_x</th>
			<th>name_short_iso_4</th>
			<th>language</th>
			<th>country</th>
			<th>doaj_title</th>
			<th>doaj_seal</th>
			<th>APC</th>
			<th>doaj_status</th>
			<th>lockss_title</th>
			<th>lockss</th>
			<th>portico_status</th>
			<th>portico</th>
			<th>nlch_title</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			<th>doublon_issnl</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>title_y</th>
			<th>url_y</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>1660-9379</td>
			<td>1660-9379</td>
			<td>Revue médicale suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td>NaN</td>
			<td>Rev. méd. suisse</td>
			<td>138</td>
			<td>215</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>0031-9007</td>
			<td>0031-9007</td>
			<td>Physical review letters (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>1.0</td>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>http://prl.aps.org/</td>
			</tr>
			<tr>
			<td>2</td>
			<td>2</td>
			<td>0031-9007</td>
			<td>0031-9007</td>
			<td>Physical review letters (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>1.0</td>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>http://prl.aps.org/</td>
			</tr>
			<tr>
			<td>3</td>
			<td>3</td>
			<td>1932-6203</td>
			<td>1932-6203</td>
			<td>PloS one</td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>NaN</td>
			<td>124</td>
			<td>236</td>
			<td>PLoS ONE</td>
			<td>1.0</td>
			<td>Yes</td>
			<td>1.0</td>
			<td>PLoS One</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>4.035714</td>
			<td>NaN</td>
			<td>5</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td>http://www.plosone.org/</td>
			</tr>
			<tr>
			<td>4</td>
			<td>4</td>
			<td>2174-8454</td>
			<td>2174-8454</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td>NaN</td>
			<td>EU-topías</td>
			<td>124, 138, 402, 292</td>
			<td>209</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>4, 5</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1341</td>
			<td>998</td>
			<td>0022-3468</td>
			<td>0022-3468</td>
			<td>Journal of pediatric surgery (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>75</td>
			<td>Journal of Pediatric Surgery</td>
			<td>http://www.jpedsurg.org/</td>
			</tr>
			<tr>
			<td>1342</td>
			<td>999</td>
			<td>1432-2064</td>
			<td>0178-8051</td>
			<td>Probability theory and related fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>124</td>
			<td>83</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>8</td>
			<td>Probability Theory and Related Fields</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			</tr>
			<tr>
			<td>1343</td>
			<td>999</td>
			<td>1432-2064</td>
			<td>0178-8051</td>
			<td>Probability theory and related fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>124</td>
			<td>83</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>8</td>
			<td>Probability Theory and Related Fields</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			</tr>
			<tr>
			<td>1344</td>
			<td>1000</td>
			<td>0960-1481</td>
			<td>0960-1481</td>
			<td>Renewable energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>NaN</td>
			<td>Renew. energy</td>
			<td>124</td>
			<td>234</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>119</td>
			<td>Renewable Energy</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			</tr>
			<tr>
			<td>1345</td>
			<td>1001</td>
			<td>0161-7567</td>
			<td>0161-7567</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>217</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>1346 rows × 26 columns</p>
			</div>




			```python
			# choix du titre et url
			journal['url'] = journal['url_y']
			journal.loc[journal['url_y'].isna(), 'url'] = journal['url_x']
			journal['title'] = journal['title_y']
			journal.loc[journal['title_y'].isna(), 'title'] = journal['title_x']
			journal
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>issn</th>
			<th>issnl</th>
			<th>title_x</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>url_x</th>
			<th>name_short_iso_4</th>
			<th>language</th>
			<th>country</th>
			<th>doaj_title</th>
			<th>doaj_seal</th>
			<th>APC</th>
			<th>doaj_status</th>
			<th>lockss_title</th>
			<th>lockss</th>
			<th>portico_status</th>
			<th>portico</th>
			<th>nlch_title</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			<th>doublon_issnl</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>title_y</th>
			<th>url_y</th>
			<th>url</th>
			<th>title</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>1660-9379</td>
			<td>1660-9379</td>
			<td>Revue médicale suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td>NaN</td>
			<td>Rev. méd. suisse</td>
			<td>138</td>
			<td>215</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>Revue médicale suisse</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>0031-9007</td>
			<td>0031-9007</td>
			<td>Physical review letters (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>1.0</td>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>http://prl.aps.org/</td>
			<td>http://prl.aps.org/</td>
			<td>Physical Review Letters</td>
			</tr>
			<tr>
			<td>2</td>
			<td>2</td>
			<td>0031-9007</td>
			<td>0031-9007</td>
			<td>Physical review letters (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>1.0</td>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>http://prl.aps.org/</td>
			<td>http://prl.aps.org/</td>
			<td>Physical Review Letters</td>
			</tr>
			<tr>
			<td>3</td>
			<td>3</td>
			<td>1932-6203</td>
			<td>1932-6203</td>
			<td>PloS one</td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>NaN</td>
			<td>124</td>
			<td>236</td>
			<td>PLoS ONE</td>
			<td>1.0</td>
			<td>Yes</td>
			<td>1.0</td>
			<td>PLoS One</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>4.035714</td>
			<td>NaN</td>
			<td>5</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td>http://www.plosone.org/</td>
			<td>http://www.plosone.org/</td>
			<td>PLoS ONE</td>
			</tr>
			<tr>
			<td>4</td>
			<td>4</td>
			<td>2174-8454</td>
			<td>2174-8454</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td>NaN</td>
			<td>EU-topías</td>
			<td>124, 138, 402, 292</td>
			<td>209</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>4, 5</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>EU-topías</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1341</td>
			<td>998</td>
			<td>0022-3468</td>
			<td>0022-3468</td>
			<td>Journal of pediatric surgery (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>75</td>
			<td>Journal of Pediatric Surgery</td>
			<td>http://www.jpedsurg.org/</td>
			<td>http://www.jpedsurg.org/</td>
			<td>Journal of Pediatric Surgery</td>
			</tr>
			<tr>
			<td>1342</td>
			<td>999</td>
			<td>1432-2064</td>
			<td>0178-8051</td>
			<td>Probability theory and related fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>124</td>
			<td>83</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>8</td>
			<td>Probability Theory and Related Fields</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>Probability Theory and Related Fields</td>
			</tr>
			<tr>
			<td>1343</td>
			<td>999</td>
			<td>1432-2064</td>
			<td>0178-8051</td>
			<td>Probability theory and related fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>124</td>
			<td>83</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>Probability Theory and Related Fields</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>8</td>
			<td>Probability Theory and Related Fields</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>Probability Theory and Related Fields</td>
			</tr>
			<tr>
			<td>1344</td>
			<td>1000</td>
			<td>0960-1481</td>
			<td>0960-1481</td>
			<td>Renewable energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>NaN</td>
			<td>Renew. energy</td>
			<td>124</td>
			<td>234</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>preserved</td>
			<td>1.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>119</td>
			<td>Renewable Energy</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>Renewable Energy</td>
			</tr>
			<tr>
			<td>1345</td>
			<td>1001</td>
			<td>0161-7567</td>
			<td>0161-7567</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>124</td>
			<td>236</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1</td>
			<td>217</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			</tr>
			</tbody>
			</table>
			<p>1346 rows × 28 columns</p>
			</div>




			```python
			journals_export = journal[['id', 'title', 'name_short_iso_4', 'starting_year', 'end_year', 'url', 'country', 'language', 'oa_status', 'publisher', 'doaj_seal', 'doaj_status', 'lockss', 'portico', 'nlch', 'qoam_av_score']]
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>title</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>url</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td>NaN</td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>1.0</td>
			<td>0.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>2</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>1.0</td>
			<td>0.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>3</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td>NaN</td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>5</td>
			<td>3</td>
			<td>1.0</td>
			<td>1.0</td>
			<td>1.0</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>4.035714</td>
			</tr>
			<tr>
			<td>4</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td>NaN</td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>1</td>
			<td>4, 5</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1341</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>75</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>1.0</td>
			<td>0.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1342</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>1.0</td>
			<td>1.0</td>
			<td>1.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1343</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>1.0</td>
			<td>1.0</td>
			<td>1.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1344</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>119</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>1.0</td>
			<td>0.0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1345</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>217</td>
			<td>NaN</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>0.0</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>1346 rows × 16 columns</p>
			</div>




			```python
			# renommage des champs finaux
			journals_export = journals_export.rename(columns={'title' : 'name', 'url' : 'website'})
			# remplacement des vides et id à int
			journals_export['starting_year'] = journals_export['starting_year'].fillna(0)
			journals_export['end_year'] = journals_export['end_year'].fillna(9999)
			journals_export['name_short_iso_4'] = journals_export['name_short_iso_4'].fillna('')
			journals_export['website'] = journals_export['website'].fillna('')
			journals_export['doaj_seal'] = journals_export['doaj_seal'].fillna('0')
			journals_export['country'] = journals_export['country'].fillna('999999')
			journals_export['language'] = journals_export['language'].fillna('999999')
			journals_export['doaj_status'] = journals_export['doaj_status'].astype(int)
			journals_export['doaj_seal'] = journals_export['doaj_seal'].astype(int)
			journals_export['lockss'] = journals_export['lockss'].astype(int)
			journals_export['portico'] = journals_export['portico'].astype(int)
			journals_export['nlch'] = journals_export['nlch'].astype(int)
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>2</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>3</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>5</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			</tr>
			<tr>
			<td>4</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>1</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1341</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1342</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1343</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1344</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1345</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>1346 rows × 16 columns</p>
			</div>




			```python
			journals_export = journals_export.drop_duplicates(subset='id')
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>3</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>5</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			</tr>
			<tr>
			<td>4</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>1</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>5</td>
			<td>5</td>
			<td>Physical review B: Condensed matter and materi...</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://journals.aps.org/prb/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>6</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1339</td>
			<td>997</td>
			<td>Smart Materials and Structures</td>
			<td>Smart mater. struct. (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>http://iopscience.iop.org/0964-1726</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>47</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1341</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1342</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1344</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1345</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 16 columns</p>
			</div>




			```python
			# test journaux sans titre
			journals_export.loc[journals_export['name'].isna()]
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>




			```python
			# export et suppression des journaux sans titre
			# export csv
			journals_export.loc[journals_export['name'].isna()].to_csv('sample/sherpa_journals_without_title.tsv', sep='\t', encoding='utf-8', index=False)
			# export excel
			journals_export.loc[journals_export['name'].isna()].to_excel('sample/sherpa_journals_without_title.xlsx', index=False)
			journals_export = journals_export.loc[journals_export['name'].notna()]
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>3</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>5</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			</tr>
			<tr>
			<td>4</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>1</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>5</td>
			<td>5</td>
			<td>Physical review B: Condensed matter and materi...</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://journals.aps.org/prb/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>6</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1339</td>
			<td>997</td>
			<td>Smart Materials and Structures</td>
			<td>Smart mater. struct. (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>http://iopscience.iop.org/0964-1726</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>47</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1341</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1342</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1344</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1345</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 16 columns</p>
			</div>




			```python
			journals_export.loc[journals_export['name'].str.contains('(Print)')]
			```

			C:\Users\iriarte\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\strings.py:1843: UserWarning: This pattern has match groups. To actually get the groups, use str.extract.
			return func(self, args, *kwargs)





			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>86</td>
			<td>54</td>
			<td>Helvetica physica acta (Print)</td>
			<td>Helv. phys. acta (Print)</td>
			<td>1928</td>
			<td>1999</td>
			<td></td>
			<td>215</td>
			<td>124, 138, 151</td>
			<td>1</td>
			<td>41</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>239</td>
			<td>155</td>
			<td>Studies in health technology and informatics (...</td>
			<td>Stud. health technol. inform. (Print)</td>
			<td>1991</td>
			<td>9999</td>
			<td></td>
			<td>156</td>
			<td>124</td>
			<td>1</td>
			<td>90</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>441</td>
			<td>306</td>
			<td>Bioethica Forum (Basel. 2008. Print)</td>
			<td>Bioeth. Forum (Basel, 2008, Print)</td>
			<td>2008</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138, 124, 151</td>
			<td>1</td>
			<td>143</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>534</td>
			<td>373</td>
			<td>Schweizerische Ärztezeitung (Print)</td>
			<td>Schweiz. Ärzteztg. (Print)</td>
			<td>1952</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>203, 151, 138</td>
			<td>1</td>
			<td>170</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>601</td>
			<td>430</td>
			<td>The European physical journal. B, Condensed ma...</td>
			<td>Eur. phys. j., B Cond. matter phys. (Print)</td>
			<td>1998</td>
			<td>9999</td>
			<td></td>
			<td>76</td>
			<td>124</td>
			<td>1</td>
			<td>195, 43</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>1.25</td>
			</tr>
			<tr>
			<td>650</td>
			<td>467</td>
			<td>Conference on Lasers and Electro-optics (Print)</td>
			<td>Conf. Lasers Electro-opt. (Print)</td>
			<td>2003</td>
			<td>9999</td>
			<td>http://www.cleoconference.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>39</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>850</td>
			<td>618</td>
			<td>Swiss archives of neurology, psychiatry and ps...</td>
			<td>Swiss arch. neurol. psychiatry psychother. (Pr...</td>
			<td>2016</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>151, 124, 138</td>
			<td>6</td>
			<td>20</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>901</td>
			<td>660</td>
			<td>Journal der Deutschen Dermatologischen Gesells...</td>
			<td></td>
			<td>2003</td>
			<td>9999</td>
			<td></td>
			<td>234</td>
			<td>151, 124</td>
			<td>1</td>
			<td>283</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>957</td>
			<td>702</td>
			<td>IEEE/LEOS International Conference on Optical ...</td>
			<td>IEEE/LEOS Int. Conf. Opt. MEMS Nanophotonics (...</td>
			<td>2007</td>
			<td>20uu</td>
			<td>http://ieeexplore.ieee.org/xpl/conhome.jsp?pun...</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>280</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1104</td>
			<td>814</td>
			<td>Forumpoenale (Print)</td>
			<td>Forumpoenale (Print)</td>
			<td>2008</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>151, 203, 138</td>
			<td>1</td>
			<td>204</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1182</td>
			<td>877</td>
			<td>Gesnerus (Print)</td>
			<td>Gesnerus (Print)</td>
			<td>1943</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>124, 138, 151, 203</td>
			<td>1</td>
			<td>143</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1336</td>
			<td>994</td>
			<td>GG@G (Print)</td>
			<td>GG@G (Print)</td>
			<td>2000</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>124</td>
			<td>1</td>
			<td>380</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			</div>




			```python
			journals_export.loc[journals_export['name'].str.contains('(Online)')]
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>1257</td>
			<td>936</td>
			<td>Plastic and reconstructive surgery (Online)</td>
			<td>Plast. reconstr. surg. (Online)</td>
			<td>1963</td>
			<td>9999</td>
			<td>http://gateway.ovid.com/ovidweb.cgi?T=JS&MODE=...</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>363</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			</div>




			```python
			# remplacement des mentions " (Print)" et " (Online)" dans les titres
			journals_export['name'] = journals_export['name'].str.replace('(Print)', '')
			journals_export['name'] = journals_export['name'].str.replace('(Online)', '')
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>3</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>5</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			</tr>
			<tr>
			<td>4</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>1</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>5</td>
			<td>5</td>
			<td>Physical review B: Condensed matter and materi...</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://journals.aps.org/prb/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>6</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1339</td>
			<td>997</td>
			<td>Smart Materials and Structures</td>
			<td>Smart mater. struct. (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>http://iopscience.iop.org/0964-1726</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>47</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1341</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1342</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1344</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1345</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 16 columns</p>
			</div>




			```python
			journals_export.loc[journals_export['name'].str.contains('(Print)')]
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>




			```python
			journals_export.loc[journals_export['name'].str.contains('(Online)')]
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>



			## Table sherpa_policies


			```python
			# creation du DF
			col_names = ['journal',
			'issn',
			'sherpa_id',
			'sherpa_uri',
			'open_access_prohibited',
			'additional_oa_fee',
			'article_version',
			'license',
			'embargo',
			'prerequisites',
			'prerequisite_funders',
			'prerequisite_funders_name',
			'prerequisite_funders_fundref',
			'prerequisite_funders_ror',
			'prerequisite_funders_country',
			'prerequisite_funders_url',
			'prerequisite_funders_sherpa_id',
			'prerequisite_subjects',
			'location',
			'locations_ir',
			'locations_not_ir',
			'named_repository',
			'named_academic_social_network',
			'copyright_owner',
			'publisher_deposit',
			'archiving',
			'conditions',
			'public_notes'
			]
			sherpa_policies = pd.DataFrame(columns = col_names)
			sherpa_policies
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>issn</th>
			<th>sherpa_id</th>
			<th>sherpa_uri</th>
			<th>open_access_prohibited</th>
			<th>additional_oa_fee</th>
			<th>article_version</th>
			<th>license</th>
			<th>embargo</th>
			<th>prerequisites</th>
			<th>prerequisite_funders</th>
			<th>prerequisite_funders_name</th>
			<th>prerequisite_funders_fundref</th>
			<th>prerequisite_funders_ror</th>
			<th>prerequisite_funders_country</th>
			<th>prerequisite_funders_url</th>
			<th>prerequisite_funders_sherpa_id</th>
			<th>prerequisite_subjects</th>
			<th>location</th>
			<th>locations_ir</th>
			<th>locations_not_ir</th>
			<th>named_repository</th>
			<th>named_academic_social_network</th>
			<th>copyright_owner</th>
			<th>publisher_deposit</th>
			<th>archiving</th>
			<th>conditions</th>
			<th>public_notes</th>
			</tr>
			</thead>
			<tbody>
			</tbody>
			</table>
			</div>




			```python
			# dédoublonage par journal id
			issn_dedup = issn.drop_duplicates(subset='journal')
			issn_dedup
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>issn</th>
			<th>issnl</th>
			<th>journal</th>
			<th>format</th>
			<th>issn_type</th>
			<th>id</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>0001-2815</td>
			<td>0001-2815</td>
			<td>532</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1</td>
			</tr>
			<tr>
			<td>2</td>
			<td>0001-4842</td>
			<td>0001-4842</td>
			<td>498</td>
			<td>PRINT</td>
			<td>1</td>
			<td>3</td>
			</tr>
			<tr>
			<td>4</td>
			<td>0001-4966</td>
			<td>0001-4966</td>
			<td>789</td>
			<td>PRINT</td>
			<td>1</td>
			<td>5</td>
			</tr>
			<tr>
			<td>7</td>
			<td>0001-6268</td>
			<td>0001-6268</td>
			<td>166</td>
			<td>PRINT</td>
			<td>1</td>
			<td>8</td>
			</tr>
			<tr>
			<td>9</td>
			<td>0001-6322</td>
			<td>0001-6322</td>
			<td>807</td>
			<td>PRINT</td>
			<td>1</td>
			<td>10</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>1751</td>
			<td>2469-9950</td>
			<td>2469-9950</td>
			<td>41</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1752</td>
			</tr>
			<tr>
			<td>1753</td>
			<td>2470-0010</td>
			<td>2470-0010</td>
			<td>80</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1754</td>
			</tr>
			<tr>
			<td>1755</td>
			<td>2470-0045</td>
			<td>2470-0045</td>
			<td>533</td>
			<td>OTHER</td>
			<td>3</td>
			<td>1756</td>
			</tr>
			<tr>
			<td>1757</td>
			<td>2475-9953</td>
			<td>2475-9953</td>
			<td>608</td>
			<td>ELECTRONIC</td>
			<td>2</td>
			<td>1758</td>
			</tr>
			<tr>
			<td>1758</td>
			<td>2504-4427</td>
			<td>2504-4427</td>
			<td>994</td>
			<td>PRINT</td>
			<td>1</td>
			<td>1759</td>
			</tr>
			</tbody>
			</table>
			<p>909 rows × 6 columns</p>
			</div>




			```python
			# type de repositories qui provoquent archiving = 1 :
			# tous les types : 'academic_social_network', 'any_repository', 'any_website', 'authors_homepage',
			# 'funder_designated_location', 'institutional_repository', 'institutional_website', 'named_academic_social_network',
			# 'named_repository', 'non_commercial_institutional_repository', 'non_commercial_repository',
			# 'non_commercial_social_network', 'non_commercial_subject_repository', 'non_commercial_website',
			# 'preprint_repository', 'subject_repository', 'this_journal'
			repositories_archiving = ['any_repository',
			'institutional_repository',
			'institutional_website',
			'non_commercial_institutional_repository',
			'non_commercial_repository',
			'any_website',
			'non_commercial_website']

			# extraction des termes
			for index, row in issn_dedup.iterrows():
			journal_id = row['journal']
			journal_issn = row['issn']
			# boucle des fichiers json
			# print(row['format'])
			if (((index/10) - int(index/10)) == 0) :
			print(index)
			# test d'existance du fichier
			if os.path.exists('sherpa/data/' + journal_issn + '.json'):
			with open('sherpa/data/' + journal_issn + '.json', 'r', encoding='utf-8') as f:
			data = json.load(f)
			# initialisation des variables à extraire
			sherpa_id = np.nan
			sherpa_uri = np.nan
			open_access_prohibited = np.nan
			location = np.nan
			locations_ir = ''
			locations_not_ir = ''
			additional_oa_fee = np.nan
			article_versions = np.nan
			article_version = np.nan
			licenses = []
			embargo = 0
			prerequisites = np.nan
			prerequisite_funders = np.nan
			prerequisite_funders_name = np.nan
			prerequisite_funders_fundref = np.nan
			prerequisite_funders_ror = np.nan
			prerequisite_funders_country = np.nan
			prerequisite_funders_url = np.nan
			prerequisite_funders_sherpa_id = np.nan
			prerequisite_subjects = np.nan
			named_repository = np.nan
			named_academic_social_network = np.nan
			copyright_owner = np.nan
			publisher_deposit = np.nan
			archiving = np.nan
			conditions = np.nan
			public_notes = np.nan
			if (len(data['items']) > 0):
			if ('id' in data['items'][0]):
			sherpa_id = data['items'][0]['id']
			# test si l'id est déjà présent
			if sherpa_id in sherpa_policies['sherpa_id'] :
			print('SKIP ' + str(sherpa_id))
			else :
			poilicies = data['items'][0]['publisher_policy']
			for poilicy in poilicies:
			# initialisation des variables à extraire
			sherpa_uri = np.nan
			open_access_prohibited = np.nan
			if ('uri' in poilicy):
			sherpa_uri = poilicy['uri']
			if ('open_access_prohibited' in poilicy):
			open_access_prohibited = poilicy['open_access_prohibited']
			if ('permitted_oa' in poilicy):
			poas = poilicy['permitted_oa']
			for poa in poas:
			additional_oa_fee = np.nan
			article_versions = np.nan
			article_version = np.nan
			licenses = []
			embargo = 0
			prerequisites = np.nan
			prerequisite_funders = np.nan
			prerequisite_funders_name = np.nan
			prerequisite_funders_fundref = np.nan
			prerequisite_funders_ror = np.nan
			prerequisite_funders_country = np.nan
			prerequisite_funders_url = np.nan
			prerequisite_funders_sherpa_id = np.nan
			prerequisite_subjects = np.nan
			named_repository = np.nan
			named_academic_social_network = np.nan
			locations_ir = ''
			locations_not_ir = ''
			copyright_owner = np.nan
			conditions = np.nan
			public_notes = np.nan
			if ('additional_oa_fee' in poa):
			additional_oa_fee = poa['additional_oa_fee']
			if ('location' in poa):
			archiving = 0
			location = ''
			mylocations = poa['location']['location']
			mylocations_text = poa['location']['location_phrases']
			if (type(mylocations) is not list):
			mylocations = [mylocations]
			location = ' ; '.join(mylocations)
			for locationi in mylocations:
			if locationi in repositories_archiving :
			archiving = archiving + 1
			for locationi_text in mylocations_text:
			if locationi_text['value'] == locationi :
			if locations_ir == '':
			locations_ir = locations_ir + locationi_text['phrase']
			else :
			if locationi_text['phrase'] not in locations_ir :
			locations_ir = locations_ir + ' ; ' + locationi_text['phrase']
			else :
			for locationi_text in mylocations_text:
			if locationi_text['value'] == locationi :
			if locations_not_ir == '':
			locations_not_ir = locations_not_ir + locationi_text['phrase']
			else :
			if locationi_text['phrase'] not in locations_not_ir :
			locations_not_ir = locations_not_ir + ' ; ' + locationi_text['phrase']
			# print (archiving)
			if archiving > 0:
			archiving = True
			else :
			archiving = False
			if ('named_repository' in poa['location']):
			if (type(poa['location']['named_repository']) is list):
			named_repository = ' ; '.join(poa['location']['named_repository'])
			else :
			named_repository = poa['location']['named_repository']
			locations_not_ir = locations_not_ir.replace('Named Repository', named_repository)
			locations_ir = locations_ir.replace('Named Repository', named_repository)
			if ('named_academic_social_network' in poa['location']):
			if (type(poa['location']['named_academic_social_network']) is list):
			named_academic_social_network = ' ; '.join(poa['location']['named_academic_social_network'])
			else :
			named_academic_social_network = poa['location']['named_academic_social_network']
			locations_not_ir = locations_not_ir.replace('Named Academic Social Network', named_academic_social_network)
			locations_ir = locations_ir.replace('Named Academic Social Network', named_academic_social_network)
			if ('embargo' in poa):
			# print(poa['embargo'])
			embargo_amount = 0
			if ('amount' in poa['embargo']):
			embargo_amount = poa['embargo']['amount']
			if ('units' in poa['embargo']):
			if (poa['embargo']['units'] == 'months') :
			embargo = embargo_amount
			elif (poa['embargo']['units'] == 'years') :
			embargo = embargo_amount*12
			elif (poa['embargo']['units'] == 'weeks') :
			embargo = int(embargo_amount/4)
			if (embargo == 0):
			embargo = 1
			elif (poa['embargo']['units'] == 'days') :
			embargo = int(embargo_amount/30)
			if (embargo == 0):
			embargo = 1
			else :
			embargo = embargo_amount
			if ('prerequisites' in poa):
			if 'prerequisites' in poa['prerequisites'] :
			if (type(poa['prerequisites']['prerequisites']) is list):
			prerequisites = ' ; '.join(poa['prerequisites']['prerequisites'])
			else:
			prerequisites = poa['prerequisites']['prerequisites']
			if ('prerequisite_funders' in poa['prerequisites']):
			prerequisite_funders = True
			# prerequisite_funders = poa['prerequisites']['prerequisite_funders']
			# if (type(poa['prerequisites']['prerequisite_funders']) is list):
			# prerequisite_funders = ' ; '.join(poa['prerequisites']['prerequisite_funders'])
			# else:
			# prerequisite_funders = poa['prerequisites']['prerequisite_funders']
			if ('prerequisite_subjects' in poa['prerequisites']):
			prerequisite_subjects = True
			# prerequisite_subjects = poa['prerequisites']['prerequisite_subjects']
			# if (type(poa['prerequisite_subjects']) is list):
			# prerequisite_subjects = ' ; '.join(poa['prerequisite_subjects'])
			# else:
			# prerequisite_subjects = poa['prerequisite_subjects']
			if ('copyright_owner' in poa):
			copyright_owner = poa['copyright_owner']
			if ('publisher_deposit' in poa):
			publisher_deposit = ''
			if (type(poa['publisher_deposit']) is list):
			for deposit in poa['publisher_deposit']:
			if 'type' in deposit['repository_metadata']:
			publisher_deposit = publisher_deposit + deposit['repository_metadata']['type']
			if 'name' in deposit['repository_metadata']:
			publisher_deposit = publisher_deposit + ' (' + deposit['repository_metadata']['name'][0]['name'] + ')'
			else :
			if 'name' in deposit['repository_metadata']:
			publisher_deposit = publisher_deposit + deposit['repository_metadata']['name'][0]['name']
			publisher_deposit = publisher_deposit + ' ; '
			else :
			deposit = poa['publisher_deposit']
			if 'type' in deposit['repository_metadata']:
			publisher_deposit = publisher_deposit + deposit['repository_metadata']['type']
			if 'name' in deposit['repository_metadata']:
			publisher_deposit = publisher_deposit + ' (' + deposit['repository_metadata']['name'][0]['name'] + ')'
			else :
			if 'name' in deposit['repository_metadata']:
			publisher_deposit = publisher_deposit + deposit['repository_metadata']['name'][0]['name']
			publisher_deposit = publisher_deposit + ' ; '
			# print (publisher_deposit)
			if ('conditions' in poa):
			if (type(poa['conditions']) is list):
			conditions = ' ; '.join(poa['conditions'])
			else:
			conditions = poa['conditions']
			if ('public_notes' in poa):
			if (type(poa['public_notes']) is list):
			public_notes = ' ; '.join(poa['public_notes'])
			else:
			public_notes = poa['public_notes']
			if ('license' in poa):
			licenses = poa['license']
			if (type(licenses) is not list):
			licenses = [licenses]
			else :
			licenses = ['']
			# avec article version
			if ('article_version' in poa):
			article_versions = poa['article_version']
			for article_version in article_versions:
			for license in licenses:
			if ('license' in license):
			mylicense = license['license']
			else :
			mylicense = ''
			# avec prerequisites
			if ('prerequisites' in poa) :
			# avec prerequisites_funders
			if ('prerequisite_funders' in poa['prerequisites']):
			for prerequisite_fundersi in poa['prerequisites']['prerequisite_funders'] :
			prerequisite_funders_name = prerequisite_fundersi['funder_metadata']['name'][0]['name']
			if 'acronym' in prerequisite_fundersi['funder_metadata']['name'][0]:
			prerequisite_funders_name = prerequisite_funders_name + ' (' + prerequisite_fundersi['funder_metadata']['name'][0]['acronym'] + ')'
			if 'identifiers' in prerequisite_fundersi['funder_metadata'] :
			for fund_identifier in prerequisite_fundersi['funder_metadata']['identifiers'] :
			if fund_identifier['type'] == 'fundref':
			prerequisite_funders_fundref = fund_identifier['identifier']
			if fund_identifier['type'] == 'ror':
			prerequisite_funders_ror = fund_identifier['identifier']
			if 'country' in prerequisite_fundersi['funder_metadata']:
			prerequisite_funders_country = prerequisite_fundersi['funder_metadata']['country']
			if 'url' in prerequisite_fundersi['funder_metadata']:
			prerequisite_funders_url = prerequisite_fundersi['funder_metadata']['url'][0]['url']
			prerequisite_funders_sherpa_id = prerequisite_fundersi['funder_metadata']['id']
			sherpa_policies = sherpa_policies.append({'journal' : journal_id,
			'issn' : journal_issn,
			'sherpa_id' : sherpa_id,
			'sherpa_uri' : sherpa_uri,
			'open_access_prohibited' : open_access_prohibited,
			'additional_oa_fee' : additional_oa_fee,
			'article_version' : article_version,
			'license' : mylicense,
			'embargo' : embargo,
			'prerequisites' : prerequisites,
			'prerequisite_funders' : prerequisite_funders,
			'prerequisite_funders_name' : prerequisite_funders_name,
			'prerequisite_funders_fundref' : prerequisite_funders_fundref,
			'prerequisite_funders_ror' : prerequisite_funders_ror,
			'prerequisite_funders_country' : prerequisite_funders_country,
			'prerequisite_funders_url' : prerequisite_funders_url,
			'prerequisite_funders_sherpa_id' : prerequisite_funders_sherpa_id,
			'prerequisite_subjects' : prerequisite_subjects,
			'location' : location,
			'locations_ir' : locations_ir,
			'locations_not_ir' : locations_not_ir,
			'named_repository' : named_repository,
			'named_academic_social_network' : named_academic_social_network,
			'copyright_owner' : copyright_owner,
			'publisher_deposit' : publisher_deposit,
			'archiving' : archiving,
			'conditions' : conditions,
			'public_notes' : public_notes
			}, ignore_index=True)
			# sans prerequisites_funders
			else :
			sherpa_policies = sherpa_policies.append({'journal' : journal_id,
			'issn' : journal_issn,
			'sherpa_id' : sherpa_id,
			'sherpa_uri' : sherpa_uri,
			'open_access_prohibited' : open_access_prohibited,
			'additional_oa_fee' : additional_oa_fee,
			'article_version' : article_version,
			'license' : mylicense,
			'embargo' : embargo,
			'prerequisites' : prerequisites,
			'prerequisite_funders' : prerequisite_funders,
			'prerequisite_funders_name' : prerequisite_funders_name,
			'prerequisite_funders_fundref' : prerequisite_funders_fundref,
			'prerequisite_funders_ror' : prerequisite_funders_ror,
			'prerequisite_funders_country' : prerequisite_funders_country,
			'prerequisite_funders_url' : prerequisite_funders_url,
			'prerequisite_funders_sherpa_id' : prerequisite_funders_sherpa_id,
			'prerequisite_subjects' : prerequisite_subjects,
			'location' : location,
			'locations_ir' : locations_ir,
			'locations_not_ir' : locations_not_ir,
			'named_repository' : named_repository,
			'named_academic_social_network' : named_academic_social_network,
			'copyright_owner' : copyright_owner,
			'publisher_deposit' : publisher_deposit,
			'archiving' : archiving,
			'conditions' : conditions,
			'public_notes' : public_notes
			}, ignore_index=True)
			# sans prerequisites
			else :
			sherpa_policies = sherpa_policies.append({'journal' : journal_id,
			'issn' : journal_issn,
			'sherpa_id' : sherpa_id,
			'sherpa_uri' : sherpa_uri,
			'open_access_prohibited' : open_access_prohibited,
			'additional_oa_fee' : additional_oa_fee,
			'article_version' : article_version,
			'license' : mylicense,
			'embargo' : embargo,
			'prerequisites' : prerequisites,
			'prerequisite_funders' : prerequisite_funders,
			'prerequisite_funders_name' : prerequisite_funders_name,
			'prerequisite_funders_fundref' : prerequisite_funders_fundref,
			'prerequisite_funders_ror' : prerequisite_funders_ror,
			'prerequisite_funders_country' : prerequisite_funders_country,
			'prerequisite_funders_url' : prerequisite_funders_url,
			'prerequisite_funders_sherpa_id' : prerequisite_funders_sherpa_id,
			'prerequisite_subjects' : prerequisite_subjects,
			'location' : location,
			'locations_ir' : locations_ir,
			'locations_not_ir' : locations_not_ir,
			'named_repository' : named_repository,
			'named_academic_social_network' : named_academic_social_network,
			'copyright_owner' : copyright_owner,
			'publisher_deposit' : publisher_deposit,
			'archiving' : archiving,
			'conditions' : conditions,
			'public_notes' : public_notes
			}, ignore_index=True)

			# sans article version
			else :
			if (type(licenses) is not list):
			licenses = [licenses]
			for license in licenses:
			if ('license' in license):
			mylicense = license['license']
			else :
			mylicense = ''
			# avec prerequisites
			if ('prerequisites' in poa) :
			# avec prerequisites_funders
			if ('prerequisite_funders' in poa['prerequisites']):
			for prerequisite_fundersi in poa['prerequisites']['prerequisite_funders'] :
			prerequisite_funders_name = prerequisite_fundersi['funder_metadata']['name'][0]['name']
			if 'acronym' in prerequisite_fundersi['funder_metadata']['name'][0]:
			prerequisite_funders_name = prerequisite_funders_name + ' (' + prerequisite_fundersi['funder_metadata']['name'][0]['acronym'] + ')'
			if 'identifiers' in prerequisite_fundersi['funder_metadata'] :
			for fund_identifier in prerequisite_fundersi['funder_metadata']['identifiers'] :
			if fund_identifier['type'] == 'fundref':
			prerequisite_funders_fundref = fund_identifier['identifier']
			if fund_identifier['type'] == 'ror':
			prerequisite_funders_ror = fund_identifier['identifier']
			if 'country' in prerequisite_fundersi['funder_metadata']:
			prerequisite_funders_country = prerequisite_fundersi['funder_metadata']['country']
			if 'url' in prerequisite_fundersi['funder_metadata']:
			prerequisite_funders_url = prerequisite_fundersi['funder_metadata']['url'][0]['url']
			prerequisite_funders_sherpa_id = prerequisite_fundersi['funder_metadata']['id']
			sherpa_policies = sherpa_policies.append({'journal' : journal_id,
			'issn' : journal_issn,
			'sherpa_id' : sherpa_id,
			'sherpa_uri' : sherpa_uri,
			'open_access_prohibited' : open_access_prohibited,
			'additional_oa_fee' : additional_oa_fee,
			'article_version' : article_version,
			'license' : mylicense,
			'embargo' : embargo,
			'prerequisites' : prerequisites,
			'prerequisite_funders' : prerequisite_funders,
			'prerequisite_funders_name' : prerequisite_funders_name,
			'prerequisite_funders_fundref' : prerequisite_funders_fundref,
			'prerequisite_funders_ror' : prerequisite_funders_ror,
			'prerequisite_funders_country' : prerequisite_funders_country,
			'prerequisite_funders_url' : prerequisite_funders_url,
			'prerequisite_funders_sherpa_id' : prerequisite_funders_sherpa_id,
			'prerequisite_subjects' : prerequisite_subjects,
			'location' : location,
			'locations_ir' : locations_ir,
			'locations_not_ir' : locations_not_ir,
			'named_repository' : named_repository,
			'named_academic_social_network' : named_academic_social_network,
			'copyright_owner' : copyright_owner,
			'publisher_deposit' : publisher_deposit,
			'archiving' : archiving,
			'conditions' : conditions,
			'public_notes' : public_notes
			}, ignore_index=True)
			# sans prerequisites_funders
			else :
			sherpa_policies = sherpa_policies.append({'journal' : journal_id,
			'issn' : journal_issn,
			'sherpa_id' : sherpa_id,
			'sherpa_uri' : sherpa_uri,
			'open_access_prohibited' : open_access_prohibited,
			'additional_oa_fee' : additional_oa_fee,
			'article_version' : article_version,
			'license' : mylicense,
			'embargo' : embargo,
			'prerequisites' : prerequisites,
			'prerequisite_funders' : prerequisite_funders,
			'prerequisite_funders_name' : prerequisite_funders_name,
			'prerequisite_funders_fundref' : prerequisite_funders_fundref,
			'prerequisite_funders_ror' : prerequisite_funders_ror,
			'prerequisite_funders_country' : prerequisite_funders_country,
			'prerequisite_funders_url' : prerequisite_funders_url,
			'prerequisite_funders_sherpa_id' : prerequisite_funders_sherpa_id,
			'prerequisite_subjects' : prerequisite_subjects,
			'location' : location,
			'locations_ir' : locations_ir,
			'locations_not_ir' : locations_not_ir,
			'named_repository' : named_repository,
			'named_academic_social_network' : named_academic_social_network,
			'copyright_owner' : copyright_owner,
			'publisher_deposit' : publisher_deposit,
			'archiving' : archiving,
			'conditions' : conditions,
			'public_notes' : public_notes
			}, ignore_index=True)
			# sans prerequisites
			else :
			sherpa_policies = sherpa_policies.append({'journal' : journal_id,
			'issn' : journal_issn,
			'sherpa_id' : sherpa_id,
			'sherpa_uri' : sherpa_uri,
			'open_access_prohibited' : open_access_prohibited,
			'additional_oa_fee' : additional_oa_fee,
			'article_version' : article_version,
			'license' : mylicense,
			'embargo' : embargo,
			'prerequisites' : prerequisites,
			'prerequisite_funders' : prerequisite_funders,
			'prerequisite_funders_name' : prerequisite_funders_name,
			'prerequisite_funders_fundref' : prerequisite_funders_fundref,
			'prerequisite_funders_ror' : prerequisite_funders_ror,
			'prerequisite_funders_country' : prerequisite_funders_country,
			'prerequisite_funders_url' : prerequisite_funders_url,
			'prerequisite_funders_sherpa_id' : prerequisite_funders_sherpa_id,
			'prerequisite_subjects' : prerequisite_subjects,
			'location' : location,
			'locations_ir' : locations_ir,
			'locations_not_ir' : locations_not_ir,
			'named_repository' : named_repository,
			'named_academic_social_network' : named_academic_social_network,
			'copyright_owner' : copyright_owner,
			'publisher_deposit' : publisher_deposit,
			'archiving' : archiving,
			'conditions' : conditions,
			'public_notes' : public_notes
			}, ignore_index=True)
			# sans permitted_oa
			else :
			print ('permitted_oa MISSING')
			else :
			print ('id MISSING')
			```

			0
			20
			40
			50
			60
			SKIP 321
			110
			SKIP 475
			SKIP 476
			180
			220
			250
			260
			290
			300
			330
			340
			360
			370
			380
			420
			permitted_oa MISSING
			430
			permitted_oa MISSING
			SKIP 1319
			SKIP 880
			permitted_oa MISSING
			510
			permitted_oa MISSING
			530
			540
			550
			560
			SKIP 1342
			570
			590
			SKIP 3082
			SKIP 2465
			SKIP 1682
			SKIP 325
			SKIP 3179
			670
			680
			SKIP 1641
			SKIP 1202
			720
			SKIP 3995
			730
			SKIP 3475
			SKIP 3490
			740
			750
			760
			SKIP 1383
			SKIP 1357
			permitted_oa MISSING
			830
			840
			SKIP 1868
			850
			SKIP 883
			880
			890
			SKIP 1392
			900
			910
			SKIP 1377
			920
			SKIP 3443
			930
			940
			SKIP 1123
			SKIP 3581
			SKIP 3558
			SKIP 745
			980
			990
			SKIP 11
			SKIP 2499
			1000
			SKIP 42
			1010
			1020
			SKIP 314
			1030
			1040
			SKIP 1380
			SKIP 229
			SKIP 1518
			SKIP 5682
			SKIP 4708
			SKIP 1661
			1130
			SKIP 6585
			1140
			SKIP 3212
			1150
			SKIP 335
			SKIP 6774
			1160
			SKIP 6590
			1180
			SKIP 1639
			SKIP 5094
			SKIP 1254
			1200
			SKIP 6325
			SKIP 3539
			SKIP 1444
			SKIP 250
			SKIP 1543
			SKIP 3415
			SKIP 3571
			SKIP 3474
			SKIP 3586
			SKIP 3220
			SKIP 3837
			SKIP 1650
			SKIP 1051
			SKIP 3572
			SKIP 612
			SKIP 6587
			SKIP 3567
			SKIP 1654
			SKIP 4070
			SKIP 1643
			SKIP 6588
			SKIP 1657
			SKIP 1687
			SKIP 1692
			SKIP 1341
			1320
			SKIP 7150
			SKIP 876
			1330
			SKIP 7007
			SKIP 7091
			1340
			1350
			SKIP 173
			SKIP 4703
			1360
			SKIP 2515
			1370
			SKIP 242
			SKIP 3930
			SKIP 2004
			1400
			1410
			SKIP 2123
			SKIP 1320
			SKIP 1459
			SKIP 1588
			SKIP 7678
			SKIP 1391
			SKIP 878
			SKIP 138
			SKIP 7632
			SKIP 1644
			SKIP 1637
			SKIP 2207
			SKIP 2428
			SKIP 2432
			1460
			SKIP 2477
			SKIP 2430
			SKIP 1653
			SKIP 2397
			SKIP 5935
			SKIP 3527
			SKIP 148
			SKIP 7793
			SKIP 4005
			SKIP 7768
			SKIP 3455
			SKIP 1652
			SKIP 3570
			SKIP 7792
			SKIP 3533
			SKIP 6586
			1520
			SKIP 7787
			SKIP 3355
			1530
			SKIP 226
			SKIP 1655
			SKIP 7783
			1540
			SKIP 6582
			1550
			SKIP 7762
			SKIP 4691
			SKIP 1911
			SKIP 1447
			SKIP 1778
			SKIP 1888
			SKIP 228
			SKIP 7407
			SKIP 7965
			1590
			1600
			1610
			SKIP 821
			SKIP 823
			SKIP 7714
			1620
			SKIP 172
			SKIP 2624
			SKIP 3654
			SKIP 1659
			SKIP 1656
			SKIP 1658
			SKIP 1393
			1640
			SKIP 6778
			SKIP 8220
			SKIP 7872
			SKIP 1587
			SKIP 822
			SKIP 1460
			SKIP 6581
			SKIP 3568
			1670
			SKIP 7509
			SKIP 7799
			SKIP 7765
			1680
			SKIP 7761
			SKIP 7800
			1690
			SKIP 1244
			1710
			SKIP 6222
			1730
			1740
			1750



			```python
			sherpa_policies
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>issn</th>
			<th>sherpa_id</th>
			<th>sherpa_uri</th>
			<th>open_access_prohibited</th>
			<th>additional_oa_fee</th>
			<th>article_version</th>
			<th>license</th>
			<th>embargo</th>
			<th>prerequisites</th>
			<th>prerequisite_funders</th>
			<th>prerequisite_funders_name</th>
			<th>prerequisite_funders_fundref</th>
			<th>prerequisite_funders_ror</th>
			<th>prerequisite_funders_country</th>
			<th>prerequisite_funders_url</th>
			<th>prerequisite_funders_sherpa_id</th>
			<th>prerequisite_subjects</th>
			<th>location</th>
			<th>locations_ir</th>
			<th>locations_not_ir</th>
			<th>named_repository</th>
			<th>named_academic_social_network</th>
			<th>copyright_owner</th>
			<th>publisher_deposit</th>
			<th>archiving</th>
			<th>conditions</th>
			<th>public_notes</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/2050</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; named_repository ; non_comm...</td>
			<td>Non-Commercial Institutional Repository</td>
			<td>Author's Homepage ; arXiv ; AgEcon ; PhilPaper...</td>
			<td>arXiv ; AgEcon ; PhilPapers ; PubMed Central ;...</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must acknowledge acceptance for publication ; ...</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/2050</td>
			<td>no</td>
			<td>no</td>
			<td>accepted</td>
			<td></td>
			<td>12</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; named_repository ; non_comm...</td>
			<td>Non-Commercial Institutional Repository</td>
			<td>Author's Homepage ; arXiv ; AgEcon ; PhilPaper...</td>
			<td>arXiv ; AgEcon ; PhilPapers ; PubMed Central ;...</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Publisher source must be acknowledged with cit...</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>2</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/3315</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_website ; institutional_repository ; named...</td>
			<td>Any Website ; Institutional Repository</td>
			<td>PubMed Central ; Subject Repository ; Journal ...</td>
			<td>PubMed Central</td>
			<td>NaN</td>
			<td>authors</td>
			<td>disciplinary (PubMed Central) ;</td>
			<td>True</td>
			<td>Published source must be acknowledged</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>3</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/3315</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by_nc_nd</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_website ; named_repository ; non_commercia...</td>
			<td>Any Website ; Non-Commercial Institutional Rep...</td>
			<td>PubMed Central ; Non-Commercial Subject Reposi...</td>
			<td>PubMed Central</td>
			<td>NaN</td>
			<td>authors</td>
			<td>disciplinary (PubMed Central) ;</td>
			<td>True</td>
			<td>Published source must be acknowledged</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>4</td>
			<td>498</td>
			<td>0001-4842</td>
			<td>7760</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/4</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>named_repository ; preprint_repository ; subje...</td>
			<td></td>
			<td>ChemRxiv ; bioRxiv ; arXiv ; Preprint Reposito...</td>
			<td>ChemRxiv ; bioRxiv ; arXiv</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>False</td>
			<td>Must not violate ACS ethical Guidelines ; Must...</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>8590</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>8591</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>accepted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>8592</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>published</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>8593</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_repository ; this_journal</td>
			<td>Any Repository</td>
			<td>Journal Website</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>8594</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_repository ; this_journal</td>
			<td>Any Repository</td>
			<td>Journal Website</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>8595 rows × 28 columns</p>
			</div>




			```python
			# convertir l'index en id
			sherpa_policies = sherpa_policies.reset_index()
			# ajout de l'id avec l'index + 1
			sherpa_policies['id'] = sherpa_policies['index'] + 1
			del sherpa_policies['index']
			sherpa_policies
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>issn</th>
			<th>sherpa_id</th>
			<th>sherpa_uri</th>
			<th>open_access_prohibited</th>
			<th>additional_oa_fee</th>
			<th>article_version</th>
			<th>license</th>
			<th>embargo</th>
			<th>prerequisites</th>
			<th>prerequisite_funders</th>
			<th>prerequisite_funders_name</th>
			<th>prerequisite_funders_fundref</th>
			<th>prerequisite_funders_ror</th>
			<th>prerequisite_funders_country</th>
			<th>prerequisite_funders_url</th>
			<th>prerequisite_funders_sherpa_id</th>
			<th>prerequisite_subjects</th>
			<th>location</th>
			<th>locations_ir</th>
			<th>locations_not_ir</th>
			<th>named_repository</th>
			<th>named_academic_social_network</th>
			<th>copyright_owner</th>
			<th>publisher_deposit</th>
			<th>archiving</th>
			<th>conditions</th>
			<th>public_notes</th>
			<th>id</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/2050</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; named_repository ; non_comm...</td>
			<td>Non-Commercial Institutional Repository</td>
			<td>Author's Homepage ; arXiv ; AgEcon ; PhilPaper...</td>
			<td>arXiv ; AgEcon ; PhilPapers ; PubMed Central ;...</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must acknowledge acceptance for publication ; ...</td>
			<td>NaN</td>
			<td>1</td>
			</tr>
			<tr>
			<td>1</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/2050</td>
			<td>no</td>
			<td>no</td>
			<td>accepted</td>
			<td></td>
			<td>12</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; named_repository ; non_comm...</td>
			<td>Non-Commercial Institutional Repository</td>
			<td>Author's Homepage ; arXiv ; AgEcon ; PhilPaper...</td>
			<td>arXiv ; AgEcon ; PhilPapers ; PubMed Central ;...</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Publisher source must be acknowledged with cit...</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/3315</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_website ; institutional_repository ; named...</td>
			<td>Any Website ; Institutional Repository</td>
			<td>PubMed Central ; Subject Repository ; Journal ...</td>
			<td>PubMed Central</td>
			<td>NaN</td>
			<td>authors</td>
			<td>disciplinary (PubMed Central) ;</td>
			<td>True</td>
			<td>Published source must be acknowledged</td>
			<td>NaN</td>
			<td>3</td>
			</tr>
			<tr>
			<td>3</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/3315</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by_nc_nd</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_website ; named_repository ; non_commercia...</td>
			<td>Any Website ; Non-Commercial Institutional Rep...</td>
			<td>PubMed Central ; Non-Commercial Subject Reposi...</td>
			<td>PubMed Central</td>
			<td>NaN</td>
			<td>authors</td>
			<td>disciplinary (PubMed Central) ;</td>
			<td>True</td>
			<td>Published source must be acknowledged</td>
			<td>NaN</td>
			<td>4</td>
			</tr>
			<tr>
			<td>4</td>
			<td>498</td>
			<td>0001-4842</td>
			<td>7760</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/4</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>named_repository ; preprint_repository ; subje...</td>
			<td></td>
			<td>ChemRxiv ; bioRxiv ; arXiv ; Preprint Reposito...</td>
			<td>ChemRxiv ; bioRxiv ; arXiv</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>False</td>
			<td>Must not violate ACS ethical Guidelines ; Must...</td>
			<td>NaN</td>
			<td>5</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>8590</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			<td>8591</td>
			</tr>
			<tr>
			<td>8591</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>accepted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			<td>8592</td>
			</tr>
			<tr>
			<td>8592</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>published</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			<td>8593</td>
			</tr>
			<tr>
			<td>8593</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_repository ; this_journal</td>
			<td>Any Repository</td>
			<td>Journal Website</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>8594</td>
			</tr>
			<tr>
			<td>8594</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_repository ; this_journal</td>
			<td>Any Repository</td>
			<td>Journal Website</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>8595</td>
			</tr>
			</tbody>
			</table>
			<p>8595 rows × 29 columns</p>
			</div>




			```python
			# export csv
			sherpa_policies.to_csv('sample/sherpa_policies_brut.tsv', sep='\t', encoding='utf-8', index=False)
			```


			```python
			# export excel
			sherpa_policies.to_excel('sample/sherpa_policies_brut.xlsx', index=False)
			```

			## Calcul de la catégorie "green" et export final des journaux


			```python
			sherpa_policies
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>issn</th>
			<th>sherpa_id</th>
			<th>sherpa_uri</th>
			<th>open_access_prohibited</th>
			<th>additional_oa_fee</th>
			<th>article_version</th>
			<th>license</th>
			<th>embargo</th>
			<th>prerequisites</th>
			<th>prerequisite_funders</th>
			<th>prerequisite_funders_name</th>
			<th>prerequisite_funders_fundref</th>
			<th>prerequisite_funders_ror</th>
			<th>prerequisite_funders_country</th>
			<th>prerequisite_funders_url</th>
			<th>prerequisite_funders_sherpa_id</th>
			<th>prerequisite_subjects</th>
			<th>location</th>
			<th>locations_ir</th>
			<th>locations_not_ir</th>
			<th>named_repository</th>
			<th>named_academic_social_network</th>
			<th>copyright_owner</th>
			<th>publisher_deposit</th>
			<th>archiving</th>
			<th>conditions</th>
			<th>public_notes</th>
			<th>id</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/2050</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; named_repository ; non_comm...</td>
			<td>Non-Commercial Institutional Repository</td>
			<td>Author's Homepage ; arXiv ; AgEcon ; PhilPaper...</td>
			<td>arXiv ; AgEcon ; PhilPapers ; PubMed Central ;...</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must acknowledge acceptance for publication ; ...</td>
			<td>NaN</td>
			<td>1</td>
			</tr>
			<tr>
			<td>1</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/2050</td>
			<td>no</td>
			<td>no</td>
			<td>accepted</td>
			<td></td>
			<td>12</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; named_repository ; non_comm...</td>
			<td>Non-Commercial Institutional Repository</td>
			<td>Author's Homepage ; arXiv ; AgEcon ; PhilPaper...</td>
			<td>arXiv ; AgEcon ; PhilPapers ; PubMed Central ;...</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Publisher source must be acknowledged with cit...</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/3315</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_website ; institutional_repository ; named...</td>
			<td>Any Website ; Institutional Repository</td>
			<td>PubMed Central ; Subject Repository ; Journal ...</td>
			<td>PubMed Central</td>
			<td>NaN</td>
			<td>authors</td>
			<td>disciplinary (PubMed Central) ;</td>
			<td>True</td>
			<td>Published source must be acknowledged</td>
			<td>NaN</td>
			<td>3</td>
			</tr>
			<tr>
			<td>3</td>
			<td>532</td>
			<td>0001-2815</td>
			<td>11905</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/3315</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by_nc_nd</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_website ; named_repository ; non_commercia...</td>
			<td>Any Website ; Non-Commercial Institutional Rep...</td>
			<td>PubMed Central ; Non-Commercial Subject Reposi...</td>
			<td>PubMed Central</td>
			<td>NaN</td>
			<td>authors</td>
			<td>disciplinary (PubMed Central) ;</td>
			<td>True</td>
			<td>Published source must be acknowledged</td>
			<td>NaN</td>
			<td>4</td>
			</tr>
			<tr>
			<td>4</td>
			<td>498</td>
			<td>0001-4842</td>
			<td>7760</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/4</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>named_repository ; preprint_repository ; subje...</td>
			<td></td>
			<td>ChemRxiv ; bioRxiv ; arXiv ; Preprint Reposito...</td>
			<td>ChemRxiv ; bioRxiv ; arXiv</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>False</td>
			<td>Must not violate ACS ethical Guidelines ; Must...</td>
			<td>NaN</td>
			<td>5</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>8590</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>submitted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			<td>8591</td>
			</tr>
			<tr>
			<td>8591</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>accepted</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			<td>8592</td>
			</tr>
			<tr>
			<td>8592</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>no</td>
			<td>published</td>
			<td></td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>authors_homepage ; institutional_repository ; ...</td>
			<td>Institutional Repository ; Institutional Website</td>
			<td>Author's Homepage</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>Must link to published article ; Publisher cop...</td>
			<td>NaN</td>
			<td>8593</td>
			</tr>
			<tr>
			<td>8593</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_repository ; this_journal</td>
			<td>Any Repository</td>
			<td>Journal Website</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>8594</td>
			</tr>
			<tr>
			<td>8594</td>
			<td>608</td>
			<td>2475-9953</td>
			<td>33503</td>
			<td>https://v2.sherpa.ac.uk/id/publisher_policy/10</td>
			<td>no</td>
			<td>yes</td>
			<td>published</td>
			<td>cc_by</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>any_repository ; this_journal</td>
			<td>Any Repository</td>
			<td>Journal Website</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>True</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>8595</td>
			</tr>
			</tbody>
			</table>
			<p>8595 rows × 29 columns</p>
			</div>




			```python
			sherpa_policies_ir = sherpa_policies.loc[(sherpa_policies['archiving'] == True) & (sherpa_policies['article_version'] == 'published') & (sherpa_policies['prerequisite_funders'].isna())][['journal', 'embargo', 'license', 'conditions']]
			sherpa_policies_ir
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>embargo</th>
			<th>license</th>
			<th>conditions</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>2</td>
			<td>532</td>
			<td>0</td>
			<td>cc_by</td>
			<td>Published source must be acknowledged</td>
			</tr>
			<tr>
			<td>3</td>
			<td>532</td>
			<td>0</td>
			<td>cc_by_nc_nd</td>
			<td>Published source must be acknowledged</td>
			</tr>
			<tr>
			<td>9</td>
			<td>498</td>
			<td>12</td>
			<td>cc_by</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>10</td>
			<td>498</td>
			<td>12</td>
			<td>cc_by_nc_nd</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>11</td>
			<td>498</td>
			<td>12</td>
			<td>bespoke_license</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>8588</td>
			<td>533</td>
			<td>0</td>
			<td>cc_by</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>8589</td>
			<td>533</td>
			<td>0</td>
			<td>cc_by</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>8592</td>
			<td>608</td>
			<td>0</td>
			<td></td>
			<td>Must link to published article ; Publisher cop...</td>
			</tr>
			<tr>
			<td>8593</td>
			<td>608</td>
			<td>0</td>
			<td>cc_by</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>8594</td>
			<td>608</td>
			<td>0</td>
			<td>cc_by</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>1118 rows × 4 columns</p>
			</div>




			```python
			# dedup
			sherpa_policies_ir_id = sherpa_policies_ir[['journal', 'embargo']].sort_values(by=['journal', 'embargo'])
			sherpa_policies_ir_dedup = sherpa_policies_ir_id.drop_duplicates(subset='journal')
			sherpa_policies_ir_dedup
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>embargo</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>2367</td>
			<td>2</td>
			<td>0</td>
			</tr>
			<tr>
			<td>8342</td>
			<td>3</td>
			<td>0</td>
			</tr>
			<tr>
			<td>7366</td>
			<td>5</td>
			<td>0</td>
			</tr>
			<tr>
			<td>261</td>
			<td>6</td>
			<td>12</td>
			</tr>
			<tr>
			<td>7086</td>
			<td>7</td>
			<td>0</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>6479</td>
			<td>996</td>
			<td>0</td>
			</tr>
			<tr>
			<td>6873</td>
			<td>997</td>
			<td>0</td>
			</tr>
			<tr>
			<td>1823</td>
			<td>998</td>
			<td>0</td>
			</tr>
			<tr>
			<td>3944</td>
			<td>999</td>
			<td>0</td>
			</tr>
			<tr>
			<td>6750</td>
			<td>1000</td>
			<td>0</td>
			</tr>
			</tbody>
			</table>
			<p>579 rows × 2 columns</p>
			</div>




			```python
			# ajout de la ctégorie green (2)
			sherpa_policies_ir_dedup['oa_status'] = 2
			sherpa_policies_ir_dedup
			```

			C:\Users\iriarte\AppData\Local\Continuum\anaconda3\lib\site-packages\ipykernel_launcher.py:2: SettingWithCopyWarning:
			A value is trying to be set on a copy of a slice from a DataFrame.
			Try using .loc[row_indexer,col_indexer] = value instead

			See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy






			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>journal</th>
			<th>embargo</th>
			<th>oa_status</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>2367</td>
			<td>2</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>8342</td>
			<td>3</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>7366</td>
			<td>5</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>261</td>
			<td>6</td>
			<td>12</td>
			<td>2</td>
			</tr>
			<tr>
			<td>7086</td>
			<td>7</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>6479</td>
			<td>996</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>6873</td>
			<td>997</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>1823</td>
			<td>998</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>3944</td>
			<td>999</td>
			<td>0</td>
			<td>2</td>
			</tr>
			<tr>
			<td>6750</td>
			<td>1000</td>
			<td>0</td>
			<td>2</td>
			</tr>
			</tbody>
			</table>
			<p>579 rows × 3 columns</p>
			</div>




			```python
			# merge avec les revues
			sherpa_policies_ir_dedup = sherpa_policies_ir_dedup.rename(columns={'journal' : 'id'})
			journals_export = pd.merge(journals_export, sherpa_policies_ir_dedup, on='id', how='left')
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status_x</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			<th>embargo</th>
			<th>oa_status_y</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>2</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>5</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			<td>0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>3</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>1</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			<tr>
			<td>4</td>
			<td>5</td>
			<td>Physical review B: Condensed matter and materi...</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://journals.aps.org/prb/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>6</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>906</td>
			<td>997</td>
			<td>Smart Materials and Structures</td>
			<td>Smart mater. struct. (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>http://iopscience.iop.org/0964-1726</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>47</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>907</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>908</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>909</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>910</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 18 columns</p>
			</div>




			```python
			# choix de la catégorie OA
			journals_export['oa_status'] = journals_export['oa_status_x']
			journals_export.loc[(journals_export['oa_status_x'] == 1) & (journals_export['oa_status_y'].notna()), 'oa_status'] = journals_export['oa_status_y']
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>oa_status_x</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			<th>embargo</th>
			<th>oa_status_y</th>
			<th>oa_status</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1.0</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>2</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>5</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			<td>0</td>
			<td>2.0</td>
			<td>5.0</td>
			</tr>
			<tr>
			<td>3</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>1</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1.0</td>
			</tr>
			<tr>
			<td>4</td>
			<td>5</td>
			<td>Physical review B: Condensed matter and materi...</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://journals.aps.org/prb/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>6</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>906</td>
			<td>997</td>
			<td>Smart Materials and Structures</td>
			<td>Smart mater. struct. (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>http://iopscience.iop.org/0964-1726</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>47</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>907</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>908</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>1</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>909</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>1</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>0</td>
			<td>2.0</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>910</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>1</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>NaN</td>
			<td>1.0</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 19 columns</p>
			</div>




			```python
			# 6 : Diamond
			# 5 : Gold
			# 4 : Full
			# 3 : Hybrid
			# 2 : Green
			# 1 : UNKNOWN
			journals_export['oa_status'].value_counts()
			```




			2.0 518
			1.0 306
			5.0 70
			6.0 17
			Name: oa_status, dtype: int64




			```python
			del journals_export['embargo']
			del journals_export['oa_status_x']
			del journals_export['oa_status_y']
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			<th>oa_status</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>1.0</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>2</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			<td>5.0</td>
			</tr>
			<tr>
			<td>3</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>1.0</td>
			</tr>
			<tr>
			<td>4</td>
			<td>5</td>
			<td>Physical review B: Condensed matter and materi...</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://journals.aps.org/prb/</td>
			<td>236</td>
			<td>124</td>
			<td>6</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>906</td>
			<td>997</td>
			<td>Smart Materials and Structures</td>
			<td>Smart mater. struct. (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>http://iopscience.iop.org/0964-1726</td>
			<td>234</td>
			<td>124</td>
			<td>47</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>907</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>908</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>909</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2.0</td>
			</tr>
			<tr>
			<td>910</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>1.0</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 16 columns</p>
			</div>




			```python
			journals_export['oa_status'] = journals_export['oa_status'].astype(int)
			journals_export
			```




			<div>
			<style scoped>
			.dataframe tbody tr th:only-of-type {
			vertical-align: middle;
			}

			.dataframe tbody tr th {
			vertical-align: top;
			}

			.dataframe thead th {
			text-align: right;
			}
			</style>
			<table border="1" class="dataframe">
			<thead>
			<tr style="text-align: right;">
			<th></th>
			<th>id</th>
			<th>name</th>
			<th>name_short_iso_4</th>
			<th>starting_year</th>
			<th>end_year</th>
			<th>website</th>
			<th>country</th>
			<th>language</th>
			<th>publisher</th>
			<th>doaj_seal</th>
			<th>doaj_status</th>
			<th>lockss</th>
			<th>portico</th>
			<th>nlch</th>
			<th>qoam_av_score</th>
			<th>oa_status</th>
			</tr>
			</thead>
			<tbody>
			<tr>
			<td>0</td>
			<td>1</td>
			<td>Revue médicale suisse</td>
			<td>Rev. méd. suisse</td>
			<td>2005</td>
			<td>9999</td>
			<td></td>
			<td>215</td>
			<td>138</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>1</td>
			</tr>
			<tr>
			<td>1</td>
			<td>2</td>
			<td>Physical Review Letters</td>
			<td>Phys. rev. lett. (Print)</td>
			<td>1958</td>
			<td>9999</td>
			<td>http://prl.aps.org/</td>
			<td>236</td>
			<td>124</td>
			<td>2</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>2</td>
			<td>3</td>
			<td>PLoS ONE</td>
			<td></td>
			<td>2006</td>
			<td>9999</td>
			<td>http://www.plosone.org/</td>
			<td>236</td>
			<td>124</td>
			<td>3</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>0</td>
			<td>0</td>
			<td>4.035714</td>
			<td>5</td>
			</tr>
			<tr>
			<td>3</td>
			<td>4</td>
			<td>EU-topías</td>
			<td>EU-topías</td>
			<td>2011</td>
			<td>9999</td>
			<td></td>
			<td>209</td>
			<td>124, 138, 402, 292</td>
			<td>4, 5</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>1</td>
			</tr>
			<tr>
			<td>4</td>
			<td>5</td>
			<td>Physical review B: Condensed matter and materi...</td>
			<td>Phys. rev., B, Condens. matter mater. phys.</td>
			<td>1998</td>
			<td>2015</td>
			<td>http://journals.aps.org/prb/</td>
			<td>236</td>
			<td>124</td>
			<td>6</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			<td>...</td>
			</tr>
			<tr>
			<td>906</td>
			<td>997</td>
			<td>Smart Materials and Structures</td>
			<td>Smart mater. struct. (Print)</td>
			<td>1992</td>
			<td>9999</td>
			<td>http://iopscience.iop.org/0964-1726</td>
			<td>234</td>
			<td>124</td>
			<td>47</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>907</td>
			<td>998</td>
			<td>Journal of Pediatric Surgery</td>
			<td>J. pediatr. surg. (Print)</td>
			<td>1966</td>
			<td>9999</td>
			<td>http://www.jpedsurg.org/</td>
			<td>236</td>
			<td>124</td>
			<td>75</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>908</td>
			<td>999</td>
			<td>Probability Theory and Related Fields</td>
			<td>Probab. theory relat. fields (Internet)</td>
			<td>uuuu</td>
			<td>9999</td>
			<td>http://www.springerlink.com/content/100451/?p=...</td>
			<td>83</td>
			<td>124</td>
			<td>8</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>1</td>
			<td>1</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>909</td>
			<td>1000</td>
			<td>Renewable Energy</td>
			<td>Renew. energy</td>
			<td>1991</td>
			<td>9999</td>
			<td>http://www.elsevier.com/wps/product/cws_home/9...</td>
			<td>234</td>
			<td>124</td>
			<td>119</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>1</td>
			<td>0</td>
			<td>NaN</td>
			<td>2</td>
			</tr>
			<tr>
			<td>910</td>
			<td>1001</td>
			<td>Journal of applied physiology: respiratory, en...</td>
			<td>J. appl. physiol.: respir., environ. exercise ...</td>
			<td>1977</td>
			<td>1984</td>
			<td>https://www.physiology.org/journal/jappl</td>
			<td>236</td>
			<td>124</td>
			<td>217</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>0</td>
			<td>NaN</td>
			<td>1</td>
			</tr>
			</tbody>
			</table>
			<p>911 rows × 16 columns</p>
			</div>




			```python
			# export csv
			journals_export.to_csv('sample/journal_fin_sherpa.tsv', sep='\t', encoding='utf-8', index=False)
			```


			```python
			# export excel
			journals_export.to_excel('sample/journal_fin_sherpa.xlsx', index=False)
			```


			```python
			# export csv
			sherpa_policies_ir_dedup.to_csv('sample/journal_ir.tsv', sep='\t', encoding='utf-8', index=False)
			```


			```python
			# export excel
			sherpa_policies_ir_dedup.to_excel('sample/journal_ir.xlsx', index=False)
			```


			```python

			```

rOACCT/import_scripts/06_oacct_sherpa.md64642b6ac544issn4frontend

06_oacct_sherpa.mdView Options

rOACCT/import_scripts/06_oacct_sherpa.md
64642b6ac544issn4frontend

06_oacct_sherpa.md
View Options