# 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 de modifier les données extraites des differentes sources et les exporter dans les tables de l'application OACCT.
Auteur : **Pablo Iriarte**, Université de Genève (pablo.iriarte@unige.ch)
Date de dernière mise à jour : 08.09.2021
```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)
# definir le debut des ids
id_start = 1
```
## Ajout des rabais pour les revues des licences Read & Publish
* Cambridge University Press (CUP) : CC-BY, CC-BY-NC, CC-BY-NC-ND, CC-BY-NC-SA
Special conditions :
* Cambridge University Press (CUP) : Only the following article types are covered: Research Articles, Review Articles, Rapid Communication, Brief Reports and Case Reports
<td>Abhandlungen aus dem Mathematischen Seminar de...</td>
<td>1865-8784</td>
<td>https://www.springer.com/journal/12188</td>
</tr>
<tr>
<td>...</td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>2035</td>
<td>Zeitschrift für Religion, Gesellschaft und Pol...</td>
<td>2510-1226</td>
<td>https://www.springer.com/journal/41682</td>
</tr>
<tr>
<td>2036</td>
<td>Zeitschrift für Rheumatologie</td>
<td>1435-1250</td>
<td>https://www.springer.com/journal/393</td>
</tr>
<tr>
<td>2037</td>
<td>Zeitschrift für Vergleichende Politikwissenschaft</td>
<td>1865-2654</td>
<td>https://www.springer.com/journal/12286</td>
</tr>
<tr>
<td>2038</td>
<td>Zentralblatt für Arbeitsmedizin, Arbeitsschutz...</td>
<td>2198-0713</td>
<td>https://www.springer.com/journal/40664</td>
</tr>
<tr>
<td>2039</td>
<td>Zoomorphology</td>
<td>1432-234X</td>
<td>https://www.springer.com/journal/435</td>
</tr>
</tbody>
</table>
<p>2040 rows × 3 columns</p>
</div>
```python
# ajout du champ license
# cc_by, cc_by_nc
springer['article_version'] = 'published'
springer['license'] = 'cc_by'
springer['Springer Nature'] = 'x'
# ajout des dates
springer['valid_from'] = '2020-01-01'
springer['valid_until'] = '2022-12-31'
# ajout du embargo et archiving
springer['embargo_months'] = 0
springer['archiving'] = True
```
```python
# append
rp = rp.append(springer, ignore_index=True)
springer['license'] = 'cc_by_nc'
rp = rp.append(springer, ignore_index=True)
rp
```
C:\Users\iriarte\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\frame.py:7123: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version
of pandas will change to not sort by default.
To accept the future behavior, pass 'sort=False'.
To retain the current behavior and silence the warning, pass 'sort=True'.
sort=sort,
<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>Elsevier</th>
<th>ISSN</th>
<th>Springer Nature</th>
<th>Title</th>
<th>URL</th>
<th>archiving</th>
<th>article_version</th>
<th>embargo_months</th>
<th>license</th>
<th>valid_from</th>
<th>valid_until</th>
</tr>
</thead>
<tbody>
<tr>
<td>0</td>
<td>x</td>
<td>1876-2859</td>
<td>NaN</td>
<td>Academic Pediatrics</td>
<td>NaN</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by</td>
<td>2020-01-01</td>
<td>2023-12-31</td>
</tr>
<tr>
<td>1</td>
<td>x</td>
<td>0001-4575</td>
<td>NaN</td>
<td>Accident Analysis and Prevention</td>
<td>NaN</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by</td>
<td>2020-01-01</td>
<td>2023-12-31</td>
</tr>
<tr>
<td>2</td>
<td>x</td>
<td>0361-3682</td>
<td>NaN</td>
<td>Accounting, Organizations and Society</td>
<td>NaN</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by</td>
<td>2020-01-01</td>
<td>2023-12-31</td>
</tr>
<tr>
<td>3</td>
<td>x</td>
<td>0094-5765</td>
<td>NaN</td>
<td>Acta Astronautica</td>
<td>NaN</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by</td>
<td>2020-01-01</td>
<td>2023-12-31</td>
</tr>
<tr>
<td>4</td>
<td>x</td>
<td>1742-7061</td>
<td>NaN</td>
<td>Acta Biomaterialia</td>
<td>NaN</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by</td>
<td>2020-01-01</td>
<td>2023-12-31</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>
</tr>
<tr>
<td>8565</td>
<td>NaN</td>
<td>2510-1226</td>
<td>x</td>
<td>Zeitschrift für Religion, Gesellschaft und Pol...</td>
<td>https://www.springer.com/journal/41682</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by_nc</td>
<td>2020-01-01</td>
<td>2022-12-31</td>
</tr>
<tr>
<td>8566</td>
<td>NaN</td>
<td>1435-1250</td>
<td>x</td>
<td>Zeitschrift für Rheumatologie</td>
<td>https://www.springer.com/journal/393</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by_nc</td>
<td>2020-01-01</td>
<td>2022-12-31</td>
</tr>
<tr>
<td>8567</td>
<td>NaN</td>
<td>1865-2654</td>
<td>x</td>
<td>Zeitschrift für Vergleichende Politikwissenschaft</td>
<td>https://www.springer.com/journal/12286</td>
<td>True</td>
<td>published</td>
<td>0</td>
<td>cc_by_nc</td>
<td>2020-01-01</td>
<td>2022-12-31</td>
</tr>
<tr>
<td>8568</td>
<td>NaN</td>
<td>2198-0713</td>
<td>x</td>
<td>Zentralblatt für Arbeitsmedizin, Arbeitsschutz...</td>