In [675]:
import numpy as np
import pandas as pd
import scipy
import matplotlib.pyplot as plt
import itertools
import seaborn as sns
%matplotlib inline

In [676]:
#Import data
origdata = pd.read_csv('https://raw.githubusercontent.com/borja876/Thinkful-DataScience-Borja/master/WELLCOME_APCspend2013_forThinkful.csv', encoding='latin1')

In [677]:
#Creata dataframe and take a look at the data
wellcome = pd.DataFrame(origdata)
wellcome.head()


Out[677]:
PMID/PMCID Publisher Journal title Article title COST (£) charged to Wellcome (inc VAT when charged)
0 NaN CUP Psychological Medicine Reduced parahippocampal cortical thickness in ... £0.00
1 PMC3679557 ACS Biomacromolecules Structural characterization of a Model Gram-ne... £2381.04
2 23043264 PMC3506128 ACS J Med Chem Fumaroylamino-4,5-epoxymorphinans and related ... £642.56
3 23438330 PMC3646402 ACS J Med Chem Orvinols with mixed kappa/mu opioid receptor a... £669.64
4 23438216 PMC3601604 ACS J Org Chem Regioselective opening of myo-inositol orthoes... £685.88

In [678]:
wellcome.dtypes


Out[678]:
PMID/PMCID                                             object
Publisher                                              object
Journal title                                          object
Article title                                          object
COST (£) charged to Wellcome (inc VAT when charged)    object
dtype: object

In [679]:
#Check how dirty is the data trying a count approach for the first questions
grouped = wellcome.groupby('Journal title').count()
#Sort the number of articles per journal in a decreasing number and inspect for dirty duplicates
grouped1 = grouped.sort_values('Article title', ascending = False).reset_index()
grouped1.head()
#There are white spaces, inconsistency in the use of 'and' and &, inconsistency in the use of '.' at the end of the words and inconsistent use of upper and lowwer case
#Additionally, the GBP symbol will not allow to calculate stats.


Out[679]:
Journal title PMID/PMCID Publisher Article title COST (£) charged to Wellcome (inc VAT when charged)
0 PLoS One 91 92 92 92
1 PLoS ONE 62 62 62 62
2 Journal of Biological Chemistry 47 48 48 48
3 Nucleic Acids Research 20 21 21 21
4 Proceedings of the National Academy of Sciences 19 19 19 19

In [680]:
#Rename titles in Capital letters
wellcome1 = wellcome.rename(columns={'Journal title': 'JOURNAL TITLE', 'Publisher': 'PUBLISHER', 'Article title': 'ARTICLE TITLE', 'COST (£) charged to Wellcome (inc VAT when charged)': 'COST (GBP) INC. VAT'})
wellcome1.head()


Out[680]:
PMID/PMCID PUBLISHER JOURNAL TITLE ARTICLE TITLE COST (GBP) INC. VAT
0 NaN CUP Psychological Medicine Reduced parahippocampal cortical thickness in ... £0.00
1 PMC3679557 ACS Biomacromolecules Structural characterization of a Model Gram-ne... £2381.04
2 23043264 PMC3506128 ACS J Med Chem Fumaroylamino-4,5-epoxymorphinans and related ... £642.56
3 23438330 PMC3646402 ACS J Med Chem Orvinols with mixed kappa/mu opioid receptor a... £669.64
4 23438216 PMC3601604 ACS J Org Chem Regioselective opening of myo-inositol orthoes... £685.88

In [681]:
#Strip blank spaces
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].str.strip()
#Consistency in not using '.' at the end or words: Delete '.'
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].str.replace('.', '')
#Consistency in the use of &: substitute all 'AND' by & - IT DIDN´T WORK
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].str.replace('AND','&')
#Change all the cases to upper cases to check for duplicates
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].str.upper()
#Show results
wellcome1.head()


Out[681]:
PMID/PMCID PUBLISHER JOURNAL TITLE ARTICLE TITLE COST (GBP) INC. VAT
0 NaN CUP PSYCHOLOGICAL MEDICINE Reduced parahippocampal cortical thickness in ... £0.00
1 PMC3679557 ACS BIOMACROMOLECULES Structural characterization of a Model Gram-ne... £2381.04
2 23043264 PMC3506128 ACS J MED CHEM Fumaroylamino-4,5-epoxymorphinans and related ... £642.56
3 23438330 PMC3646402 ACS J MED CHEM Orvinols with mixed kappa/mu opioid receptor a... £669.64
4 23438216 PMC3601604 ACS J ORG CHEM Regioselective opening of myo-inositol orthoes... £685.88

In [682]:
#Clean misspellings in JOURNAL TITLE
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PLOSONE', 'PLOS  ONE', 'PLOS 1', 'PLOS'], 'PLOS ONE')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['ACTA D', 'ACTA CRYSTALLOGRAPHICA SECTION D', 'ACTA CRYSTALLOGRAPHY D', 'ACTA CRYSTALLOGRAPHICA, SECTION D', 'ACTA CRYSTALLOGRAPHICA SECTION D,  BIOLOGICAL CRYSTALLOGRAPHY'], 'ACTA CRYSTALLOGRAPHICA SECTION D: BIOLOGICAL CRYSTALLOGRAPHY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['AMERICAN JNL EPIDEMIOLOGY'], 'AMERICAN JOURNAL OF EPIDEMIOLOGY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['AMERICAN JOURNAL OF MEDICAL GENETICS PART A'], 'AMERICAN JOURNAL OF MEDICAL GENETICS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['ANTIMICROBIAL AGENTS AND CHEMOTHERAPY', 'ANTIMICROBIAL AGFENTS AND CHEMOTHERAPY'], 'ANTIMICROBIAL AGENTS & CHEMOTHERAPY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['ANGEWANDE CHEMIE', 'ANGEWANDTE CHEMIE INTERNATIONAL EDITION','ANGEW CHEMS INT ED' ], 'ANGEWANDTE CHEMIE')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['BEHAVIOUR RESEARCH AND THERAPY'], 'BEHAVIOR RESEARCH & THERAPY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['BIOCHEM JOURNAL', 'BIOCHEMICAL JOURNALS'], 'BIOCHEMICAL JOURNAL')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['BIOCHEM SOC TRANS'], 'BIOCHEMICAL SOCIETY TRANSACTIONS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['BRITISH JOURNAL OF OPHTHALMOLOGY'], 'BRITISH JOURNAL OF OPTHALMOLOGY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['CELL DEATH DIFFERENTIATION'], 'CELL DEATH & DIFFERENTIATION')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['CHILD: CARE, HEALTH DEVELOPMENT'], 'CHILD: CARE, HEALTH & DEVELOPMENT')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['CURR BIOL'], 'CURRENT BIOLOGY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['DEV. WORLD BIOETH'], 'DEVELOPING WORLD BIOETHICS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['EUROPEAN CHILD AND ADOLESCENT PSYCHIATTY'], 'EUROPEAN CHILD & ADOLESCENT PSYCHIATRY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['FEBS J'], 'FEBS JOURNAL')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['HUM RESOUR HEALTH'], 'HUMAN RESOURCES FOR HEALTH')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['INTERNATIONAL JOURAL OF EPIDEMIOLOGY'], 'INTERNATIONAL JOURNAL OF EPIDEMIOLOGY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['INTERNATIONAL JOURNAL OF BEHAVIOURAL NUTRITION AND PHYSICAL ACTIVITY'], 'INTERNATIONAL JOURNAL OF BEHAVIORAL NUTRITION AND PHYSICAL ACTIVITY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['J BIOL CHEM'], 'J BIOL CHEMISTRY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['JOURNAL OF AUTISM AND DEVELOPMENTAL DISORDERS'], 'JOURNAL OF AUTISM & DEVELOPMENT DISORDERS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['JOURNAL OF THE ROYAL SOCIETY, INTERFACE'], 'JOURNAL OF THE ROYAL SOCIETY INTERFACE')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['JOURNAL OF VIROL'], 'JOURNAL OF VIROLOGY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['JOURNAL OF VISUALIZED EXPERIEMENTS', 'JOURNAL OF VISULAIZED EXPERMIMENTS'], 'JOURNAL OF VISUALIZED EXPERIMENTS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['MICROBES INFECT'], 'MICROBES & INFECTION')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['NUCLEIC ACID RESEARCH', 'NA'], 'NUCLEIC ACIDS RESEARCH')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PARASIT VECTORS'], 'PARASITES & VECTORS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PHILOS TRANS R SOC LONDON B BIOL SCI', 'PHILOSOPHICAL TRANSACTIONS OF THE ROYAL SOCIETY OF LONDON. SERIES B, BIOLOGICAL SCIENCES'], 'PHILOSOPHICAL TRANSACTIONS B')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PFLUGERS ARCHIV'], 'PFLUGERS ARCHIVE')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PLOS MEDICINE JOURNAL'], 'PLOS MEDICINE')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PLOS NEGECTED TROPICAL DISEASES'], 'PLOS NEGLECTED TROPICAL DISEASES')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES (PNAS)','PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES OF THE UNITED STATES OF AMERICA','PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES OF THE USA','PNAS (PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES OF THE UNITED STATES OF AMERICA','PNAS','PNAS USA'], 'PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['PROCEEDINGS B', 'PROCEEDINGS OF THE ROYAL SOCIETY'], 'PROCEEDINGS OF THE ROYAL SOCIETY B: BIOLOGICAL SCIENCES')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['SCI REP','SCIENTIFIC REPORTS-11-00861B'], 'SCIENTIFIC REPORTS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['SEX TRANSM INFECT'], 'SEXUALLY TRANSMITTED INFECTIONS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['STUDIES IN HISTORY & PHILOSOPHY OF SCIENCE PART C: STUDIES IN HISTORY AND PHILOSOPHY OF BIOLOGICAL AND BIOMEDICAL SCIENCES'], 'STUDIES IN HISTORY AND PHILOSOPHY OF SCIENCE PART C')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['THE AMERICAL JOURNAL OF HUMAN GENETICS'], 'THE AMERICAN JOURNAL OF HUMAN GENETICS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['THORAX'], 'THORAX AN INTERNATIONAL JOURNAL FOR RESPIRATORY MEDICINE')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['TROP MED INT HEALTH'], 'TROPICAL MEDICINE & INTERNATIONAL HEALTH')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['MARTEN CHILD NUTR'], 'MATERNAL & CHILD NUTRITION')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['SOCIAL PSYCHIATRY & PSYCHIATRIC EPIDEMIOL'], 'SOCIAL PSYCHIATRY & PSYCHIATRIC EPIDEMIOLOGY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['AIDS UK', 'AIDS','JOURNAL OF ACQUIRED IMMUNE DEFICIENCY SYNDROMES','JAIDS JOURNAL OF ACQUIRED IMMUNE DEFICIENCY SYNDROMES','JOURNAL OF ACQUIRED IMMUNE DEFICIENCY SYNDROMS (JAIDS)', 'JOURNAL OF AIDS'], 'AIDS JOURNAL')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['ZOONOSES AND PUBLIC HEALTH'], 'ZOONOSES & PUBLIC HEALTH')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['AMERICAL JOURNAL OF PSYCHIATRY'], 'AMERICAN JOURNAL OF PSYCHIATRY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['BIOLOGICIAL CHEMISTRY'], 'BIOLOGICAL CHEMISTRY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['STUDIES IN HISTORY AND PHILOSOPHY OF SCIENCE PART C: STUDIES IN HISTORY AND PHILOSOPHY OF BIOLOGICAL AND BIOMEDICAL SCIENCES'], 'STUDIES IN HISTORY AND PHILOSOPHY OF SCIENCE PART C')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['JOURNAL OF NEUROLOGY, NEUROSURGERY & PSYCHIATRY'], 'JOURNAL OF NEUROLOGY, NEUROSURGERY AND PSYCHIATRY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['BMJ OPEN'], 'BMJ')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['JNL BIOLOGICAL CHEMISTRY','JOURNAL OF BIOL CHEM'], 'JOURNAL BIOLOGICAL CHEMISTRY')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['MCP (MOLECULAR & CELLULAR PROTEOMICS)'], 'MOLECULAR AND CELLULAR PROTEOMICS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['HAEMATOLOGICA/THE HAEMATOLOGY JOURNAL'], 'HAEMATOLOGICA')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['IJTLD'], 'INTERNATIONAL JOURNAL OF TUBERCULOSIS  AND LUNG DISEASE')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['EPIGENTICS'], 'EPIGENETICS')
wellcome1['JOURNAL TITLE'] = wellcome1['JOURNAL TITLE'].replace(['EMBO'], 'EMBO JOURNAL')
wellcome1.head()


Out[682]:
PMID/PMCID PUBLISHER JOURNAL TITLE ARTICLE TITLE COST (GBP) INC. VAT
0 NaN CUP PSYCHOLOGICAL MEDICINE Reduced parahippocampal cortical thickness in ... £0.00
1 PMC3679557 ACS BIOMACROMOLECULES Structural characterization of a Model Gram-ne... £2381.04
2 23043264 PMC3506128 ACS J MED CHEM Fumaroylamino-4,5-epoxymorphinans and related ... £642.56
3 23438330 PMC3646402 ACS J MED CHEM Orvinols with mixed kappa/mu opioid receptor a... £669.64
4 23438216 PMC3601604 ACS J ORG CHEM Regioselective opening of myo-inositol orthoes... £685.88

In [683]:
#Take away currency symbols before and after numbers and convert into float
wellcome1['COST (GBP) INC. VAT'] = wellcome1['COST (GBP) INC. VAT'].str.lstrip('£').str.rstrip('$').astype(float)
wellcome1


Out[683]:
PMID/PMCID PUBLISHER JOURNAL TITLE ARTICLE TITLE COST (GBP) INC. VAT
0 NaN CUP PSYCHOLOGICAL MEDICINE Reduced parahippocampal cortical thickness in ... 0.00
1 PMC3679557 ACS BIOMACROMOLECULES Structural characterization of a Model Gram-ne... 2381.04
2 23043264 PMC3506128 ACS J MED CHEM Fumaroylamino-4,5-epoxymorphinans and related ... 642.56
3 23438330 PMC3646402 ACS J MED CHEM Orvinols with mixed kappa/mu opioid receptor a... 669.64
4 23438216 PMC3601604 ACS J ORG CHEM Regioselective opening of myo-inositol orthoes... 685.88
5 PMC3579457 ACS JOURNAL OF MEDICINAL CHEMISTRY Comparative Structural and Functional Studies ... 2392.20
6 PMC3709265 ACS JOURNAL OF PROTEOME RESEARCH Mapping Proteolytic Processing in the Secretom... 2367.95
7 23057412 PMC3495574 ACS MOL PHARM Quantitative silencing of EGFP reporter gene b... 649.33
8 PMCID: PMC3780468 ACS (Amercian Chemical Society) Publications ACS CHEMICAL BIOLOGY A Novel Allosteric Inhibitor of the Uridine Di... 1294.59
9 PMCID: PMC3621575 ACS (Amercian Chemical Society) Publications ACS CHEMICAL BIOLOGY Chemical proteomic analysis reveals the drugab... 1294.78
10 PMCID: PMC3739413 ACS (Amercian Chemical Society) Publications JOURNAL OF CHEMICAL INFORMATION AND MODELING Locating Sweet Spots for Screening Hits and Ev... 1329.69
11 PMCID: PMC3530961 ACS (Amercian Chemical Society) Publications JOURNAL OF MEDICINAL CHEMISTRY Synthesis and evaluation of ?-thymidine analog... 1287.20
12 PMCID: PMC3624797 ACS (Amercian Chemical Society) Publications JOURNAL OF MEDICINAL CHEMISTRY Discovery and structure-activity relationships... 1324.66
13 PMC3413243 ACS Publications BIOCHEMISTRY Monomeric 14-3-3 has a chaperone-like activity... 665.64
14 PMC3694353 ACS Publications JOURNAL OF MEDICINAL CHEMISTRY Synthesis and in vitro and in vivo characteriz... 1006.72
15 PMC3572711 AGA Institute GASTROENTEROLOGY Much of the genetic risk of colorectal cancer ... 238.08
16 22610094 AMBSB JOURNAL OF BIOLOGICAL CHEMISTRY Annexin-1 interaction with FPR2/ALX 265.67
17 PMCID: PMC3586974 American Association of Immunologists JOURNAL OF IMMUNOLOGY Sialoadhesin ligand expression identifies a su... 2035.00
18 23455506 PMCID: PMC3607399 American Association of Immunologists JOURNAL OF IMMUNOLOGY Regulation of Foxp3+ Inducible Regulatory T Ce... 3108.08
19 PMID: 24015914 PMC3833349 American Chemical Society ACS CHEMICAL BIOLOGY Discovery of an allosteric inhibitor binding s... 1267.76
20 : PMC3805332 American Chemical Society ACS CHEMICAL BIOLOGY Synthesis of alpha-glucan in mycobacteria invo... 2286.73
21 NaN American Chemical Society ACS CHEMICAL BIOLOGY Discovery of ?2 Adrenergic Receptor Ligands Us... 947.07
22 PMCID:\n PMC3656742\n American Chemical Society ACS CHEMICAL NEUROSCIENCE Continuous online microdialysis using microflu... 1186.80
23 PMCID: 3584654 AMERICAN CHEMICAL SOCIETY ACS NANO HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART... 642.89
24 22971149 PMC3466778 American Chemical Society AMERICAN CHEMICAL SOCIETY Characterizing the Fatty Acid Binding Site in ... 1533.29
25 23072351 American Chemical Society ANALYTICAL CHEMISTRY Amphipathic polymers facilitate the study of f... 2082.74
26 PMC3477822 American Chemical Society ANALYTICAL CHEMISTRY Quantitative dynamics of phosphorproteome: the... 2314.10
27 PMC3530960 American Chemical Society ANALYTICAL CHEMISTRY Variable-Pitch Rectangular Cross-section Radio... 759.67
28 23458425 PMC3630740 American Chemical Society BIOCONJUGATE CHEMISTRY Design, synthesis and functional activity of l... 1565.26
29 PMID: 20146481 American Chemical Society JOURNAL OF MEDICINAL CHEMISTRY Toward biophysical probes for the 5-HT3 recept... 572.74
... ... ... ... ... ...
2097 3575693 Wiley-Blackwell MOLECULAR MICROBIOLOGY Shigella IpaD has a Dual Role: Signal Transduc... 2236.02
2098 PMID: 22188548 PMC3492912 Wiley-Blackwell OBESITY REVIEWS Does maternal body mass index during pregnancy... 2275.02
2099 PMID: 22764734 PMC3798095 Wiley-Blackwell OBESITY REVIEWS Obesity and socioeconomic status in developing... 2373.57
2100 PMID: 23703895 Wiley-Blackwell STATISTICS IN MEDICINE Combining multiple imputation and meta-analysi... 791.19
2101 PMCID: PMC3664106 Wiley-Blackwell STEM CELLS Matrix remodelling maintains ESC self-renewal ... 1551.49
2102 PMID: 23649934 Wiley-Blackwell SYNAPSE Presynaptic pH and vesicle fusion in Drosophil... 1961.68
2103 PMC2955965 Wiley-Blackwell THE EUROPEAN JOURNAL OF NEUROSCIENCE Hyperpolarization-activated ion channels as ta... 1982.35
2104 PMID: 19948006 PMC3551259 Wiley-Blackwell TRAFFIC Efficient internalization of MHC I requires ly... 2239.22
2105 PMID: 23305527 Wiley-Blackwell TRAFFIC Proteomic analysis of clathrin interactions in... 2377.65
2106 PMCID: PMC3600532 Wiley-Blackwell ZOONOSES & PUBLIC HEALTH Ecology of zoonotic infectious diseases in bat... 2272.15
2107 PMC3440570 Wiley-Blackwell, John Wiley & Sons AMERICAN JOURNAL OF TRANSPLANTATION Low dose rapamycin treatment increases the abi... 1900.70
2108 23670821 PMC3738939 Wiley-VCH ANGEWANDTE CHEMIE Design and synthesis of cyclic ADP-4-thioribos... 3026.17
2109 23640856 Wiley-VCH CHEMBIOCHEM A Prototypical Small-Molecule Modulator Uncoup... 1851.15
2110 PMID: 23918316 Wiley-VCH CHEMMEDCHEM Structure-Activity Relationship Studies of Pyr... 1812.89
2111 PMCID: PMC3728731 Wiley-VCH CHEMMEDCHEM From On-Target to Off-Target Activity: Identif... 1816.70
2112 23495205685.88 PMC3743159 Wiley-VCH CHEMMEDCHEM Synthesis and structure-activity relationship ... 2168.05
2113 PMID:22997008 PMC3569869 Wiley-VCH PROTEMICS Carbon source-induced reprogramming of the cel... 1409.96
2114 3708104 Wliey-Blackwell JOURNAL OF SMALL ANIMAL PRACTICE Prevalence, outcome and risk factors for post-... 2400.00
2115 PMC3713766 Wolters Kluwer AIDS JOURNAL HIV infected adolescents in Southern Africa ca... 1968.63
2116 PMC3819359 Wolters Kluwer AIDS JOURNAL Short title: TB and VL breakthrough and failur... 2015.72
2117 PMC3773237 Wolters Kluwer AIDS JOURNAL Sexual behaviour in a rural high HIV prevalence 1836.92
2118 PMC3815011 Wolters Kluwer AIDS JOURNAL HIV incidence and survival from age-specific s... 1836.92
2119 PMC3805356 Wolters Kluwer AIDS JOURNAL Accelerated biological ageing in HIV-infected ... 1375.80
2120 Epub Wolters Kluwer AIDS JOURNAL Reduction in early mortality on antiretroviral... 1836.92
2121 PMC3707567 Wolters Kluwer AIDS JOURNAL Risk factors for seropositivity to Kaposi sarc... 2009.65
2122 2901593 Wolters Kluwer Health CIRCULATION RESEARCH Mechanistic Links Between Na+ Channel (SCN5A) ... 1334.15
2123 3748854 Wolters Kluwer Health AIDS JOURNAL Evaluation of an empiric risk screening score ... 1834.77
2124 3785148 Wolters Kluwer Health PEDIATR INFECT DIS J Topical umbilical cord care for prevention of ... 1834.77
2125 PMCID:\n PMC3647051\n Wolters Kluwer N.V./Lippinott AIDS JOURNAL Grassroots Community Organisations' Contributi... 2374.52
2126 PMID: 23846567 (Epub July 2013) Wolters Kluwers AIDS JOURNAL A novel community health worker tool outperfor... 2034.75

2127 rows × 5 columns


In [684]:
#Check unique values and clean remainig misspellings
list(wellcome1['JOURNAL TITLE'].unique())


Out[684]:
['PSYCHOLOGICAL MEDICINE',
 'BIOMACROMOLECULES',
 'J MED CHEM',
 'J ORG CHEM',
 'JOURNAL OF MEDICINAL CHEMISTRY',
 'JOURNAL OF PROTEOME RESEARCH',
 'MOL PHARM',
 'ACS CHEMICAL BIOLOGY',
 'JOURNAL OF CHEMICAL INFORMATION AND MODELING',
 'BIOCHEMISTRY',
 'GASTROENTEROLOGY',
 'JOURNAL OF BIOLOGICAL CHEMISTRY',
 'JOURNAL OF IMMUNOLOGY',
 'ACS CHEMICAL NEUROSCIENCE',
 'ACS NANO',
 'AMERICAN CHEMICAL SOCIETY',
 'ANALYTICAL CHEMISTRY',
 'BIOCONJUGATE CHEMISTRY',
 'JOURNAL OF THE AMERICAN CHEMICAL SOCIETY',
 'CHEST',
 'JOURNAL OF NEUROPHYSIOLOGY',
 'JOURNAL OF PHYSIOLOGY',
 'THE JOURNAL OF NEUROPHYSIOLOGY',
 'AMERICAN JOURNAL OF PSYCHIATRY',
 'BEHAVIORAL NEUROSCIENCE',
 'EMOTION',
 'HEALTH PSYCHOLOGY',
 'JOURNAL OF ABNORMAL PSYCHOLOGY',
 'JOURNAL OF CONSULTING AND CLINICAL PSYCHOLOGY',
 'JOURNAL OF EXPERIMENTAL PSYCHOLOGY:  ANIMAL BEHAVIOUR PROCESS',
 'JOURNAL OF EXPERIMENTAL PSYCHOLOGY: HUMAN PERCEPTION AND PERFORMANCE',
 'JOURNAL OF FAMILY PSYCHOLOGY',
 'PSYCHOLOGICAL ASSESSMENT',
 'PSYCHOLOGICAL REVIEW',
 'PSYCHOLOGICAL TRAUMA: THEORY RESEARCH, PRACTICE AND POLICY',
 'AMERICAN JOURNAL OF PUBLIC HEALTH',
 'J BIOL CHEMISTRY',
 'THE JOURNAL OF BIOLOGICAL CHEMISTRY',
 'AMERICAN JOURNAL OF PATHOLOGY',
 'ANTIMICROBIAL AGENTS & CHEMOTHERAPY',
 'CLINICAL AND VACCINE IMMUNOLOGY',
 'EUKARYOTIC CELL',
 'INFECTION AND IMMUNITY',
 'JOURNAL OF BACTERIOLOGY',
 'JOURNAL OF VIROLOGY',
 'MBIO',
 'MOLECULAR AND CELLULAR BIOLOGY',
 'JOURNAL OF CLINICAL MICROBIOLOGY',
 'AMERICAN SOCIETY FOR NUTRITION',
 'BLOOD',
 'BLOOD JOURNAL 2012',
 'THE AMERICAN JOURNAL OF HUMAN GENETICS',
 'JOUNRAL OF CLINICAL MICROBIOLOGY',
 'SPEECH LANGUAGE AND HEARING RESEARCH',
 'BIOLOGICAL CHEMISTRY',
 'MOLECULAR AND CELLULAR PROTEOMICS',
 'JOURNAL BIOLOGICAL CHEMISTRY',
 'JOURNAL OF VISION',
 'CURRENT TOPICS IN MEDICINAL CHEMISTRY',
 'CURRENT ANALYTICAL CHEMISTRY',
 'EVIDENCE, ETHOS AND EXPERIMENT: THE ANTHROPOLOGY AND HISTORY OF MEDICAL RESEARCH IN AFRICA',
 'BIOCHEMICAL JOURNAL',
 'MOLECULAR CELL',
 'ARTHRITIS RESEARCH & THERAPY',
 'BIOMED CENTRAL',
 'BMC  PUBLIC HEALTH',
 'BMC BIOLOGY',
 'BMC GENETICS',
 'BMC GENOME BIOLOGY',
 'BMC GENOMICS',
 'BMC HEALTH SERVICES RESEARCH',
 'BMC MEDICAL GENETICS',
 'BMC MEDICINE',
 'BMC MICROBIOLOGY',
 'BMC MOLECULAR BIOLOGY',
 'BMC NEUROLOGY',
 'BMC NEUROSCIENCE',
 'BMC PSYCHIATRY',
 'BMC PUBLIC HEALTH',
 'BMC RESEARCH NOTES',
 'BMC VETERINARY RESEARCH',
 'BMS GENOMICS',
 'CLINICAL PROTEOMICS',
 'EVODEVO',
 'GENOME BIOLOGY',
 'GENOME MEDICINE',
 'INTERNATIONAL JOURNAL FOR EQUITY IN HEALTH',
 'INTERNATIONAL JOURNAL OF BEHAVIORAL NUTRITION AND PHYSICAL ACTIVITY',
 'INTERNATIONAL JOURNAL OF HEALTH GEOGRAPHICS',
 'JOURNAL OF CHEMINFORMATICS',
 'JOURNAL OF NEUROINFLAMMATION',
 'LIPIDS IN HEALTH AND DISEASE',
 'MALARIA JOURNAL',
 'MOLECULAR BRAIN',
 'MOLECULAR PAIN',
 'NUTRITION JOURNAL',
 'ORPHANET JOURNAL OF RARE DISEASES',
 'PARASITES AND VECTORS',
 'PUBLIC HEALTH',
 'RESPIRATORY RESEARCH',
 'VIROLOGY JOURNAL',
 'BMC INFECTIOUS DISEASES',
 'HUMAN RESOURCES FOR HEALTH',
 'IMPLEMENT SCI',
 'PARASITES & VECTORS',
 'AIDS RESEARCH AND THERAPY',
 'BMC PEDIATRICS',
 'TRIALS',
 'VETERINARY RESEARCH',
 'BIOPHYSICAL JOURNAL',
 'EUROPEAN JOURNAL OF ENDOCRINOLOGY',
 'JOURNAL OF ENDOCRINOLOGY',
 'JOURNAL OF MOLECULAR ENDOCRINOLOGY',
 'REPRODUCTION(CAMBRIDGE, ENGLAND)',
 'CELLULAR MICROBIOLOGY',
 'ARTHRITIS RESEARCH AND THERAPY',
 'BMC MEDICAL ETHICS',
 'BMC MEDICAL IMAGING',
 'COST EFFECTIVENESS AND RESOURCE ALLOCATION',
 'BJOPHTHALMOL',
 'BMJ',
 'BRITISH JOURNAL OF OPTHALMOLOGY',
 'BRITISH MEDICAL JOURNAL',
 'FRONTLINE GASTROENTEROLOGY',
 'JOURNAL OF CLINICAL PATHOLOGY',
 'JOURNAL OF EPIDEMIOLOGY & COMMUNITY HEALTH',
 'JOURNAL OF MEDICAL ETHICS',
 'JOURNAL OF MEDICAL GENETICS',
 'JOURNAL OF NEUROLOGY, NEUROSURGERY AND PSYCHIATRY',
 'SEXUALLY TRANSMITTED INFECTIONS',
 'GUT',
 'ARCHIVES OF DISEASE IN CHILDHOOD',
 'BMJ QUALITY & SAFETY',
 'HEART',
 'MEDICAL HUMANITIES',
 'THORAX AN INTERNATIONAL JOURNAL FOR RESPIRATORY MEDICINE',
 'JOURNAL OF EPIDEMIOLOGY AND COMMUNITY HEALTH',
 'POSTGRADUATE MEDICAL JOURNAL',
 'VETERINARY RECORD',
 'EUROPEAN JOURNAL OF HEALTH LAW',
 'JOURNAL OF NEUROSCIENCE',
 'HEART AND CIRCULATORY PHYSIOLOGY',
 'ANTIMICOBIAL AGENTS AND CHEMOTHERAPY',
 'J CLIN MICROBIOL',
 'INTERNATIONAL PSYCHOGERIATRICS',
 'PARASITOLOGY',
 'MEDICAL HISTORY',
 'AGEING & SOCIETY',
 'BRITISH JOURNAL FOR THE HISTORY OF SCIENCE',
 'BRITISH JOURNAL OF THE HISTORY OF SCIENCE',
 'EPIDEMIOLOGY AND INFECTION',
 'EXPERT REVIEWS IN MOLECULAR MEDICINE',
 'INTERNATIONAL JOURNAL OF LAW IN CONTEXT',
 'JNL OF THE INTERNATIONAL NEUROPSYCHOLOGICAL SOCIETY',
 'PUBLIC HEALTH NUTRITION',
 'PYSCHOLOGICAL MEDICINE',
 'URBAN HISTORY',
 'VISUAL NEUROSCIENCE',
 'AMERICAN JOURNAL OF HUMAN GENETICS',
 'STEM CELL REPORTS',
 'JOURNAL OF CLINICAL ENDOCRINOLOGY AND METABOLISM',
 'JOURNAL OF THE INTERNATIONAL AIDS SOCIETY',
 'GENES & DEVELOPMENT',
 'LEARNING AND MEMORY',
 'GENOME RESEARCH',
 'RNA',
 'JOURNAL OF CELL SCIENCE',
 'BIOLOGY OPEN',
 'DEVELOPMENT',
 'DEVELOPMENTAL CELL',
 'DISEASE MODELS AND MECHANISMS',
 'J CELL SCI',
 'INTERNATIONAL REVIEWS OF IMMUNOLOGY',
 'JOURNAL OF THE INTERNATIONAL AFRICAN INSTITUTE',
 'CELL REPORTS',
 'AMERICAN JOURNAL FOR CLINICAL NUTRITION',
 'AMERICAN JOURNAL OF CLINICAL NUTRITION',
 'CELL PRESS - CELL REPORTS',
 'G3: GENES, GENOMES, GENETICS',
 'GENETICS',
 'J IMMUNOL',
 'PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES',
 'THE JOURNAL OF IMMUNOLOGY',
 'JOURNAL OF NUTRITION',
 'NEUROIMAGE',
 'ACADEMY OF NUTRITION AND DIETETICS',
 'AMERICAN JOURNAL OF GERIATRIC PSYCHIATRY',
 'AMERICAN JOURNAL OF PREVENTIVE MEDICINE',
 'ANALYTICAL BIOCHEMISTRY',
 'ANIMAL BEHAVIOUR',
 'APPLIED ENERGY',
 'ASIAN JOURNAL OF PSYCHIATRY',
 'ATHEROSCLEROSIS',
 'BBA - MOLECULAR BASIS OF DISEASE',
 'BEHAVIOR RESEARCH AND THERAPY',
 'BEHAVIOR RESEARCH & THERAPY',
 'BEHAVIOURAL BRAIN RESEARCH',
 'BIOCHEMICAL AND BIOPHYSICAL RESEARCH COMMUNICATIONS',
 'BIOCHEMICAL PHARMACOLOGY',
 'BIOCHIMICA ET BIOOHYSICA ACTA - GENE REGULATORY MECHANISMS',
 'BIOCHIMICA ET BIOOHYSICA ACTA - MOLECULAR BASIS OF DISEASE',
 'BIOCHIMICA ET BIOPHYSICA ACTA - MOLECULAR BASIS OF DISEASE',
 'BIOCHIMICA ET BIOPHYSICA ACTA (BBA) - MOLECULAR CELL RESEARCH',
 'BIOCHIMIE',
 'BIOLOGICAL PSYCHIATRY',
 'BIOLOGICAL PSYCHOLOGY',
 'BIOMATERIALS',
 'BIOSYSTEMS',
 'BONE',
 'BRAIN AND COGNITION',
 'BRAIN AND LANGUAGE',
 'BRAIN RESEARCH',
 'CANCER LETTERS',
 'CELL',
 'CELL CALCIUM',
 'CELL HOST AND MICROBE',
 'CELL JOURNAL',
 'CELL METABOLISM',
 'CELL STEM CELL',
 'CELLULAR SIGNALLING',
 'CHEMSITRY & BIOLOGY',
 'CLINICAL NEUROLOGY AND NEUROSURGERY',
 'CLINICAL RADIOLOGY',
 'COGNITION',
 'COGNITIVE DEVELOPMENT',
 'CONSCIOUSNESS & COGNITION',
 'CONSCIOUSNESS AND COGNITION',
 'CORTEX',
 'CURRENT BIOLOGY',
 'CURRENT OPINION IN NEUROBIOLOGY',
 'CURRENT OPINION MICROBIOLOGY',
 'CURRENT OPINIONS IN NEUROBIOLOGY',
 'DEVELOPMENT CELL',
 'DEVELOPMENTAL BIOLOGY',
 'DEVELOPMENTAL COGNITIVE NEUROSCIENCE',
 'DIAGNOSTIC MICROBIOLOGY AND INFECTIOUS DISEASE',
 'ELSEVIER',
 'ENDEAVOUR',
 'EPILEPSY RESEARCH',
 'EUROPEAN JOURNAL OF CELL BIOLOGY',
 'EUROPEAN JOURNAL OF MEDICAL GENETICS',
 'EUROPEAN NEUROPSYCHOPHARMACOLOGY',
 'EXPERIMENTAL CELL RESEARCH',
 'EXPERIMENTAL EYE RESEARCH',
 'EXPERIMENTAL HEMATOLOGY',
 'EXPERIMENTAL NEUROLOGY',
 'EXPERIMENTAL PARASITOLOGY',
 'FEBS LETTERS',
 'FEBS OPEN BIO',
 'FERTILITY AND STERILITY',
 'FREE RADICAL AND BIOLOGY MEDICINE',
 'FUNGAL BIOLOGY',
 'FUNGAL ECOLOGY',
 'GENE',
 'GENE THERAPY',
 'HEALTH & PLACE',
 'HEALTH AND PLACE',
 'IMMNUNOBIOLOGY',
 'IMMUNITY',
 'IMMUNOLOGY LETTERS',
 'INFECTION GENETICS AND EVOLUTION',
 'INT JOURNAL FOR PARASITOLOGY',
 'INTERNATIONAL HEALTH',
 'INTERNATIONAL JOURNAL FOR PARASITOLOGY',
 'INTERNATIONAL JOURNAL OF APPLIED EARTH OBSERVATION AND GEOINFORMATION',
 'INTERNATIONAL JOURNAL OF BIOCHEMISTRY & CELL BIOLOGY',
 'INTERNATIONAL JOURNAL OF CARDIOLOGY',
 'INTERNATIONAL JOURNAL OF PARASITOLOGY',
 'J MOL BIOL',
 'J STEROID BIOCHEM MOL BIOL',
 'JOURNAL OF AFFECTIVE DISORDERS',
 'JOURNAL OF ALLERGY & CLINICAL IMMUNOLOGY',
 'JOURNAL OF ALLERGY AND CLINICAL IMMUNOLOGY',
 'JOURNAL OF ANTHROPOLOGICAL ARCHAEOLOGY',
 'JOURNAL OF ARCHAEOLOGICAL SCIENCE',
 'JOURNAL OF BEHAVIOR THERAPY AND EXPERIMENTAL PSYCHIATRY',
 'JOURNAL OF BEHAVIOUR THERAPY AND EXPERIMENTAL PSYCHIATRY',
 'JOURNAL OF CLINICAL EPIDEMIOLOGY',
 'JOURNAL OF CLINICAL VIROLOGY',
 'JOURNAL OF CYCSTIC FIBROSIS',
 'JOURNAL OF HEPATOLOGY',
 'JOURNAL OF HISTORICAL GEOGRAPHY',
 'JOURNAL OF HOSPITAL INFECTIONS',
 'JOURNAL OF INFECTION',
 'JOURNAL OF MECHANISMS OF AGEING AND DEVELOPMENT',
 'JOURNAL OF MOLECULAR BIOLOGY',
 'JOURNAL OF NEUROSCIENCE METHODS',
 'JOURNAL OF NUTRITION EDUCATION AND BEHAVIOUR',
 'JOURNAL OF PAEDIATRIC UROLOGY',
 'JOURNAL OF PROTEOMICS',
 'JOURNAL OF STRUCTURAL BIOLOGY',
 'JOURNAL OF THE AMERICAN ACADEMY OF CHILD AND ADOLESCENT PSYCHIATRY',
 'JOURNAL OF THE AMERICAN COLLEGE OF CARDIOLOGY',
 'JOURNAL OF THE NEUROLOGICAL SCIENCES',
 'JOURNAL OF TRANSPORT GEOGRAPHY',
 'JOURNAL OF VIROLOGICAL METHODS',
 'LANCET',
 'LANCET GLOBAL HEALTH',
 'LEARNING AND INDIVIDUAL DIFFERENCES',
 'MATRIX BIOLOGY',
 'MATURITAS',
 'MECHANISMS OF AGEING AND DEVELOPMENT',
 'MICROBES AND INFECTION',
 'MICROBES & INFECTION',
 'MOL BIO',
 'MOLECLUAR & CELLULAR ENDOCRINOLOGY',
 'MOLECULAR & BIOCHEMICAL PARASITOLOGY',
 'MOLECULAR AND CELLULAR ENDOCRINOLOGY',
 'MOLECULAR BIOLOGY',
 'MOLECULAR GENETICS AND METABOLISM',
 'MOLECULAR IMMUNOLOGY',
 'MOLECULAR PHYLOGENETICS AND EVOLUTION',
 'N BIOTECHNOL',
 'NEUROBIOLOGY OF AGING',
 'NEUROBIOLOGY OF DISEASE',
 'NEUROBIOLOGY OF LEARNING AND MEMORY',
 'NEUROCHEMISTRY INTERNATIONAL',
 'NEUROIMAGE: CLINICAL',
 'NEUROLMAGE',
 'NEUROMUSCULAR DISORDERS',
 'NEURON',
 'NEUROPHARMACOLOGY',
 'NEUROPHYSIOLOGIA',
 'NEUROPSYCHOLOGIA',
 'NEUROSCIENCE',
 'NEUROSCIENCE AND BEHAVIOURAL REVIEWS',
 'NEUROSCIENCE LETTERS',
 'NITRIC OXIDE',
 'OPHTHALMOLOGY',
 'OSTEOARTHRITIS AND CARTILAGE',
 'PAIN',
 'PARKINSONISM AND RELATED DISORDERS',
 'PARSITOLOGY',
 'PERSONALITY AND INDIVIDUAL DIFFERENCES',
 'PREVENTIVE MEDICINE',
 'PROTEIN EXPR PURIF',
 'PROTIST',
 'PULMONARY PHARMACOLOGY & THERAPEUTICS',
 'RESEARCH IN VETERINARY SCIENCE',
 'SCHIZOPHRENIA RESEARCH',
 'SEIZURE',
 'SEMINARS IN ONCOLOGY',
 'SOCIAL SCIENCE & MEDICINE',
 'SOCIAL SCIENCE AND MEDICINE',
 'STEM CELL RESEARCH',
 'STRUCTURE',
 'STUDIES IN HISTORY AND PHILOSOPHY OF SCIENCE PART C',
 'TETRAHEDRON LETTERS',
 'THE INTERNATIONAL JOURNAL OF BIOCHEMISTRY & CELL BIOLOGY',
 'THE JOURNAL OF STEROID BIOCHEMISTRY & MOLECULAR BIOLOGY',
 'THE LANCET',
 'THE LANCET NEUROLOGY',
 'THE VET JOURNAL',
 'TICKS AND TICK-BORNE DISEASES',
 'TRANSACTIONS OF THE ROYAL SOCIETY OF TROPICAL MEDICINE AND HYGIENE',
 'TRENDS IN COGNITIVE SCIENCE',
 'TRENDS IN GENETICS',
 'TRENDS IN MICROBIOLOGY',
 'TRENDS IN MOLECULAR MEDICINE',
 'TRENDS IN NEUROSCIENCE',
 'TRENDS IN NEUROSCIENCES',
 'TRENDS IN PARASITOLOGY',
 'TUBERCULOSIS',
 'VACCINE',
 'VASCULAR PHARMACOLOGY',
 'VETERINARY MICROBIOLOGY',
 'VETERINARY PARASITOLOGY',
 'VIROLOGY',
 'VIRUS RESEARCH',
 'VISION RESEARCH',
 'LANCET INFECT DIS',
 'MATH BIOSCI',
 'CELL HOST & MICROBE',
 'ENDOCRINOLOGY',
 'MOLECULAR ENDOCRINOLOGY',
 'EUROPEAN RESPIRATORY JOURNAL',
 'FASEB JOURNAL',
 'JOURNAL OF LEUKOCYTE BIOLOGY',
 'THE FASEB JOURNAL',
 'HAEMATOLOGICA',
 'FRONTIERS IN AUDITORY COGNITIVE NEUROSCIENCE',
 'FRONTIERS IN BEHAVIORAL NEUROSCIENCE',
 'FRONTIERS IN BRAIN IMAGING METHODS',
 'FRONTIERS IN CELLULAR NEUROSCIENCE',
 'FRONTIERS IN COGNITION',
 'FRONTIERS IN COGNITIVE SCIENCE',
 'FRONTIERS IN DECISION NEUROSCIENCE',
 'FRONTIERS IN DEVELOPMENTAL PSYCHOLOGY',
 'FRONTIERS IN ELECTROPHYSIOLOGY',
 'FRONTIERS IN ENDOCRINOLOGY',
 'FRONTIERS IN GENETICS',
 'FRONTIERS IN HUMAN NEUROSCIENCE',
 'FRONTIERS IN IMMUNOLOGICAL MEMORY',
 'FRONTIERS IN INFLAMMATION',
 'FRONTIERS IN INVERTEBRATE PHYSIOLOGY',
 'FRONTIERS IN MOLECULAR NEUROSCIENCE',
 'FRONTIERS IN SCHIZOPHRENIA',
 'FRONTIERS IN SYSTEMS NEUROSCIENCE',
 'FRONTIERS IN INTEGRATIVE NEUROSCIENCE',
 'FRONTIERS IN PERCEPTION SCIENCE',
 'FRONTIERS IN CONSCIOUSNESS RESEARCH',
 'FRONTIERS IN IMMUNOLOGY',
 'FRONTIERS IN NEURAL CIRCUITS',
 'FRONTIERS IN NEUROROBOTICS',
 'FRONTIERS IN T CELL BIOLOGY',
 'FUTURE NEUROLOGY',
 'FUTURE VIROLOGY',
 'FUTURE MICROBIOLOGY',
 'FUTURE MEDICINAL CHEMISTRY',
 'INTERNATIONAL JOURNAL OF RHEUMATOLOGY',
 'JOURNAL OF ALLERGY',
 'JOURNAL OF PARASITOLOGY RESEARCH',
 'OXIDATIVE MEDICINE & CELLULAR LONGEVITY',
 'METHODS IN MOLECULAR BIOLOGY',
 'ONCOTARGET',
 'MOLECULAR MEMBRANE BIOLOGY',
 'EXPERT REVIEWS IN ANTI-INFECTIVE CHEMOTHERAPY',
 'NANOTECHNOLOGY',
 'INTERNATIONAL JOURNAL OF TUBERCULOSIS  AND LUNG DISEASE',
 'ACTA CRYSTALLOGRAPHICA SECTION D: BIOLOGICAL CRYSTALLOGRAPHY',
 'ACTA F',
 'J SYNCHROTRON RADIAT',
 'JOURNAL OF APPLIED CRYSTALLOGRAPHY',
 'ACTA CRYSTALLOGRAPHICA SECTION F: STRUCTURAL BIOLOGY AND CRYSTALLIZATION COMMUNICATIONS',
 'PHYSICS IN BIOLOGY AND MEDICINE',
 'JOURNAL OF ALZHEIMER DISEASE',
 'THERANOSTICS',
 'J MED INTERNET RESEARCH',
 'AMERICAN JOURNAL OF MEDICAL GENETICS',
 'GENETIC EPIDEMIOLOGY',
 'THE JOURNAL OF PATHOLOGY',
 'EUROPEAN JOURNAL OF IMMUNOLOGY',
 'JOURNAL OF DEPRESSION & ANXIETY',
 'JOURNAL OF PATHOLOGY',
 'CLINICAL AND EXPERIMENTAL ALLERGY',
 'EMBO MOLECULAR MEDICINE',
 'BIOPOLYMERS',
 'DEVELOPMENT SCIENCE',
 'JOURNAL OF MEDICAL VIROLOGY',
 'MOLECULAR MICROBIOLOGY',
 'POPULATION, SPACE AND PLACE',
 'TRAFFIC',
 'TROPICAL MEDICINE AND INTERNATIONAL HEALTH',
 'THE JOURNAL OF PHYSIOLOGY',
 'HEPTOLOGY',
 'BULLETIN OF THE HISTORY OF MEDICINE',
 'NATIONAL ACADEMY OF SCIENCES',
 'JOURNAL OF VISUALIZED EXPERIMENTS',
 'JOURNAL OF NEUROLOGY & TRANSLATIONAL NEUROSCIENCE',
 'NEPHRON PHYSIOLOGY',
 'NEURODEGENERATIVE DISEASES',
 'NEUROEPIDEMIOLOGY',
 'NEUROPSYCHOBIOLOGY',
 'RESPIRATION',
 'AUTOPHAGY',
 'CELL ADHESION AND MIGRATION',
 'CELL CYCLE',
 'CHANNELS',
 'EPIGENETICS',
 'RNA BIOLOGY',
 'NEUROLOGY',
 nan,
 'ANTIOXIDANTS & REDOX SIGNALING',
 'ANTIOXIDANTS AND REDOX SIGNALING',
 'TISSUE ENGINEERING: PART A',
 'STEM CELLS AND DEVELOPMENT',
 'INTERNATIONAL JOURNAL OF MOLECULAR SCIENCES',
 'JERPH',
 'SENSORS',
 'JOURNAL OF COGNITIVE NEUROSCIENCE',
 'THE JOURNAL OF COGNITIVE NEUROSCIENCE',
 'PROCEDDINGS OF THE NATIONAL ACADEMY OF SCIENCES OF USA',
 'BIOSOCIETIES',
 'BRITISH JOURNAL OF CANCER',
 'CELL DEATH & DISEASE',
 'CELL DEATH AND DIFFERENTIATION',
 'CELL DEATH AND DISEASE',
 'FRONTIERS',
 'GENETICS IN MEDICINE',
 'JOURNAL OF CEREBRAL BLOOD FLOW AND METABOLISM',
 'JOURNAL OF INVESTIGATIVE DERMATOLOGY',
 'MUCOSAL IMMUNOLOGY',
 'NATURE COMMUNICATIONS',
 'SCIENTIFIC REPORTS',
 'EMBO REPORTS',
 'EUROPEAN JOURNAL OF HUMAN GENETICS',
 'LEUKEMIA',
 'NATURE NEUROSCIENCE',
 'CELL DEATH & DIFFERENTIATION',
 'EMBO JOURNAL',
 'INTERNATIONAL JOURNAL OF OBESITY',
 'KIDNEY INTERNATIONAL',
 'NATURE SCIENTIFIC REPORTS',
 'NEUROPSYCHOPHARMACOLOGY',
 'ONCOGENE',
 'THE EMBO JOURNAL',
 'THE JOURNAL OF INVESTIGATIVE DERMATOLOGY',
 'TRANSLATIONAL PSYCHIATRY',
 'OPTICS EXPRESS',
 'ALCOHOL AND ALCOHOLISM',
 'AMERICAN JOURNAL OF EPIDEMIOLOGY',
 'BRAIN',
 'BRIEFINGS IN BIOINFORMATICS',
 'BRITISH MEDICAL BULLETIN',
 'CEREBRAL CORTEX',
 'CLINICAL INFECTIOUS DISEASES',
 'CLINICAL INFECTIOUS DISEASES ONLINE',
 'EUROPEAN HEART JOURNAL ONLINE',
 'HEALTH POLICY PLANNING',
 'HUMAN MOLECULAR GENETICS',
 'INT J EPIDEMIOL',
 'INTERNATIONAL JOURNAL OF EPIDEMIOLOGY',
 'JOURNAL OF ANTIMICROBIAL CHEMOTHERAPY',
 'JOURNAL OF INFECTIOUS DISEASES',
 'JOURNAL OF THE NATIONAL CANCER INSTITUTE',
 'NUCLEIC ACIDS RESEARCH',
 'PUBLIC HEALTH ETHICS',
 'RHEUMATOLOGY',
 'SCHIZOPHRENIA BULLETIN',
 'SOCIAL COGNITIVE AND AFFECTIVE NEUROSCIENCE',
 'CARDIOVASCULAR RESEARCH',
 'CLINICLA INFECTIOUS DISEASE',
 'GLYCOBIOLOGY',
 'INYERNATIONAL JOURNAL OF EPIDEMIOLOGY',
 'JOURNAL OF GERONTOLOGY SERIES A: MEDICAL SCIENCES',
 'JOURNAL OF PUBLIC HEALTH',
 'MOLECULAR BIOLOGY AND EVOLUTION',
 'NICOTINE AND TOBACO RESEARCH',
 'SOCIAL HISTORY OF MEDICINE',
 'BIOINFORMATICS ONLINE',
 'CEREBRAL CORTEX PRINT',
 'HUMAN MOL GENETICS ONLINE',
 'AGE AND AGEING',
 'BIINFORMATICS',
 'BIOINFORMATICS',
 'BRAIN ONLINE',
 'BRIEFINGS IN FUNCTIONAL GENOMICS',
 'CEREBRAL CORTEX ONLINE',
 'DATABASE',
 'EUROPEAN JOURNAL OF PUBLIC HEALTH',
 'HEALTH PROMOTION INTERNATIONAL',
 'HISTORY WORKSHOP JOURNAL',
 'HUMAN MOLECULAR GENETICS ONLINE',
 'HUMAN REPRODUCTION',
 'INTERNATIONAL IMMUNOLOGY',
 'MEDICAL LAW REVIEW',
 'MOL BIOL AND EVOLUTION',
 'NEPHROLOGY DIALYSIS AND TRANSPLANTATION',
 'NEPHROLOGY DIALYSIS TRANSPLANTATION',
 'OXFORD JOURNALS',
 'OXFORD UNIVERSITY PRESS',
 'PROTEIN ENGINEERING, DESIGN AND SELECTION (',
 'QJM: AN INTERNATIONAL JOURNAL OF MEDICINE',
 'THE JOURNAL OF INFECTIOUS DISEASES',
 'J INFECT DIS',
 'ENVIRONMENT AND PLANNING A',
 'PLOS COMPUTATIONAL BIOLOGY',
 'PLOS GENETICS',
 'PLOS NTD',
 'PLOS ONE',
 'PLOS PATHOGENS',
 'PROC NATL ACAD SCI U S A',
 'JOURNAL OF POVERTY AND SOCIAL JUSTICE',
 'ASN NEURO',
 'BIOCHEMICAL SOCIETY TRANSACTIONS',
 'ESSAYS IN BIOCHEMISTRY',
 'THE BIOCHEMICAL JOURNAL',
 'BIOSCIENCE REPORTS',
 'BIOLOGY',
 'COMPUTATIONAL BIOLOGY',
 'NEGLECTED TROPICAL DISEASE',
 'PLOS  COMPUTATIONAL BIOLOGY',
 'PLOS BIOLOGY',
 'PLOS MEDICINE',
 'PLOS NEGLECTED TROPICAL DISEASES',
 'PMEDICINE-D-12-03130',
 'PNTD',
 'PONE-D12-17947',
 'PUBLIC LIBRARY OF SCIENCE',
 'PUBLIC LIBRARY OF SCIENCE ONE',
 'PUBLIC SERVICE REVIEW',
 'J CARDIOVASC MAGN RESON',
 'BRITISH JOURNAL OF PSYCHIATRY',
 'BRITSH JOURNAL OF PSYCHIATRY',
 'THE BRITISH JOURNAL OF PSYCHIATRY',
 'BIOLOGY LETTERS',
 'INTERFACE',
 'JOURNAL OF THE ROYAL SOCIETY INTERFACE',
 'PHILOSOPHICAL TRANSACTIONS B',
 'PROCEEDINGS OF THE ROYAL SOCIETY B: BIOLOGICAL SCIENCES',
 'PROCEEDINGS OF ROYAL SOCIETY',
 'CHEMICAL COMMUNICATION',
 'CHEMICAL SOCIETY REVIEWS',
 'DALTON TRANSACTIONS',
 'PHOTOCHEMICAL & PHOTOBIOLOGICAL SCIENCES',
 'ORGANIC & BIOMOLECULAR CHEMISTRY',
 'CHRONIC ILLNESS',
 'EUROPEAN JOURNAL OF PREVENTIVE CARDIOLOGY',
 'HEALTH: AN INTERDISCIPLINARY JOURNAL FOR THE SOCIAL STUDY OF HEALTH, ILLNESS AND MEDICINE',
 'HISTORY OF THE HUMAN SCIENCES',
 'JOURNAL OF HISTOCHEMISTRY & CYTOCHEMISTRY',
 'NEUROSCIENTIST',
 'PSYCHOLOGICAL SCIENCE',
 'SOCIAL STUDIES OF SCIENCE',
 'JOURNAL OF PSYCHOPHARMACOLOGY',
 'REPRODUCTIVE SCIENCES',
 'JOURNAL OF THE ROYAL SOCIETY OF MEDICINE SHORT REPORTS',
 'EUROPEAN HISTORY QUARTERLY',
 'QUALITATIVE RESEARCH',
 'INTERNATIONAL JOURNAL OF FINANCIAL RESEARCH',
 'JOURNAL OF BIOMEDICAL GRAPHICS AND COMPUTING',
 'HEALTH',
 'AMERICAN JOURNAL OF TROPICAL MEDICINE & HYGIENE',
 'ENDOCRINE RELATED CANCER',
 'JOURNAL OF GENERAL VIROLOGY',
 'JOURNAL OF MICROBIOLOGY',
 'MICROBIOLOGY',
 'SGM OPEN OPTION',
 'THE JOURNAL OF NEUROSCIENCE',
 'ACTA DERMATO VENEREOLOGICA',
 'ACTA DIABETOLOGICA',
 'ACTA NEUROPATHOL',
 'ACTA NEUROPATHOLOGICA',
 'ADVANCES IN EXPERIMENTAL MEDICINE AND BIOLOGY',
 'ANAL BIOANAL CHEM',
 'BIOGERONTOLOGY',
 'BIOMEDICAL MICRODEVICES',
 'BRAIN STRUCTURE AND FUNCTION',
 'BRAIN TOPOGRAPHY',
 'CALCIFIED TISSUE INTERNATIONAL',
 'CELL AND TISSUE RESEARCH',
 'CELLULAR AND MOLECULAR CELL SCIENCES',
 'CELLULAR AND MOLECULAR LIFE SCIENCES',
 'CHROMOSOME RESEARCH',
 'COGNITIVE PROCESSING',
 'COGNITIVE THERAPY AND RESEARCH',
 'CURRENT ATHEROSCLEROSIS REPORTS',
 'CURRENT OBSTETRICS AND GYNECOLOGY REPORTS',
 'DEVELOPMENT GENES AND EVOLUTION',
 'DIABETOLOGIA',
 'EUROPEAN CHILD AND ADOLESCENT PSYCHIATRY',
 'EUROPEAN CHILD & ADOLESCENT PSYCHIATRY',
 'EUROPEAN JOURNAL OF CLINICAL PHARMACOLOGY',
 'EUROPEAN JOURNAL OF EPIDEMIOLOGY',
 'EUROPEAN RADIOLOGY',
 'EXPERIMENTAL BRAIN RESEARCH',
 'HERNIA',
 'IMMUNOGENETICS',
 'INFLAMMATION RESEARCH',
 'JOURNAL OF AUTISM AND DEVELOPMENT DISORDERS',
 'JOURNAL OF AUTISM & DEVELOPMENT DISORDERS',
 'JOURNAL OF BIOETHICAL INQUIRY',
 'JOURNAL OF BIOLOGICAL PHYSICS',
 'JOURNAL OF COMPUTATIONAL NEUROSCIENCE',
 'JOURNAL OF INHERITED METABOLIC',
 'JOURNAL OF MOLECULAR NEUROSCIENCE',
 'JOURNAL OF NEUROLOGY',
 'JOURNAL OF THE ASSOCIATION FOR RESEARCH IN OTOLARYNGOLOGY',
 'MAMMALIAN GENOME',
 'METABOLOMICS',
 'MOLECULAR AND CELLULAR BIOCHEMISTRY',
 'NEUROGENETICS',
 'NEUROINFORMATICS',
 'NEUROMOLECULAR MEDICINE',
 'OSTEOPOROSIS INTERNATIONAL',
 'PFLUGERS ARCHIVE',
 'PSYCHOPHARMACOLOGY',
 'REPRODUCTIVE MEDICINE AND BIOLOGY',
 'SEMINARS IN IMMUNOPATHOLOGY',
 'SOCIAL PSYCHIATRY & PSYCHIATRIC EPIDEMIOLOGY',
 'SOCIAL PSYCHIATRY AND PSYCHIATRIC EPIDEMIOL',
 'SOCIAL PSYCHIATRY AND PSYCHIATRIC EPIDEMIOLOGY',
 'SPRINGER',
 'THE JOURNAL OF ABNORMAL CHILD PSYCHOLOGY AND PSYCHIATRY',
 'TROPICAL ANIMAL HEALTH & PRODUCTION',
 'UROLITHIASIS',
 'AIDS BEHAV',
 'OPEN CHOICE',
 'SPRINGER SCIENCE + BUSINESS MEDIA',
 'JOURNAL OF BIOENERGETICS AND BIOMEMBRANES',
 'CHILDS NERV SYST',
 'AGE',
 'BIOMOLECULAR NMR ASSIGNMENTS',
 'JOURNAL OF MOLECULAR MEDICINE',
 'JOURNAL OF NEURAL TRANSMISSION',
 'JOURNAL OF THE AMERICAN SOCIETY FOR MASS SPECTROMETRY',
 'AZANIA: ARCHAEOLOGICAL RESEARCH IN AFRICA',
 'AIDS CARE',
 'ANNALS OF SCIENCE',
 'CANADIAN JOURNAL OF AFRICAN STUDIES',
 'CHILD NEUROPSYCHOLOGY',
 'ENGLISH STUDIES',
 'EUROPEAN JOURNAL OF ENGLISH STUDIES',
 'JOURNAL OF CULTURAL ECONOMY',
 'MEDICAL ANTHROPOLOGY',
 'SCIENCE AS CULTURE',
 'AM J BIOETH',
 'ETHN HEALTH',
 'AMERICAN JOURNAL OF BIOETHICS--NEUROSCIENCE',
 'SOUTH ASIAN HISTORY AND CULTURE',
 'THE HISTORY OF THE FAMILY',
 'JOURNAL OF EXPERIMENTAL NANOSCIENCE',
 'JOURNAL OF APPLIED PHYSIOLOGY',
 'MOLECULAR & CELLULAR PROTEOMICS',
 'PEDIATRICS',
 'BIOL OPEN',
 'JOURNAL OF CLINICAL ENDOCRINOLOGY',
 'JOURNAL OD CLINICAL ENDOCRINOLOGY',
 'THE JOURNAL OF VISUALIZED EXPERIMENTS',
 'BJP',
 'PHILOSOPHICAL TRANSACTIONS OF THE ROYAL SOCIETY OF LONDON SERIES B, BIOLOGICAL SCIENCES',
 'RSTB 20120145',
 'CANCER RESEARCH',
 'SCIENCE-RESEARCH',
 'AM J TROP MED HYG',
 'DEVELOPING WORLD BIOETHICS',
 'INTERNATIONAL JOURNAL OF DEVELOPMENTAL BIOLOGY',
 'ACTA PHYSIOL',
 'ADDICTION',
 'AGING CELL',
 'ALIMENTRARY PHARMACOLOGY & THERAPEUTICS',
 'AMERICAN ETHNOLOGIST',
 'ANGEWANDTE CHEMIE',
 'ANNALS OF HUMAN GENETICS',
 'ANNALS OF NEUROLOGY',
 'ANNALS OF THE NEW YORK ACADEMY OF SCIENCES',
 'ARTHRITIS & RHEUMATISM',
 'ARTHRITIS AND RHEUMATISM',
 'BIOETHICS',
 'BIRTH DEFECTS RESEARCH PART A: CLINICAL AND MOLECULAR TERATOLOGY',
 'BRITISH JOURNAL OF CLINICAL PHARMACOLOGY',
 'BRITISH JOURNAL OF DERMATOLOGY',
 'BRITISH JOURNAL OF HAEMATOLOGY',
 'BRITISH JOURNAL OF PHARMACOLOGY',
 'CHEMBIOCHEM',
 'CHEMISTRY -  EUROPEAN JOURNAL',
 'CHILD PSYCHOLOGY PSYCHIATRY',
 'CLINICAL GENETICS',
 'CYTOSKELETON',
 'DEVELOPMENT DYNAMICS',
 'DEVELOPMENTAL SCIENCE',
 'DIABETIC MEDICINE',
 'ECOLOGY AND EVOLUTION',
 'ECOLOGY LETTERS',
 'EPILEPSIA',
 'EUROPEAN JOURNAL OF NEUROSCIENCE',
 'EVOLUTION',
 'EXPERIMENTAL PHYSIOLOGY',
 'FEBS JOURNAL',
 'FEMS MICROBIOLOGY LETTERS',
 'GENES BRAIN BEHAVIOUR',
 'GENESIS: JOURNAL OF GENETICS',
 'GLIA',
 'HBM JNL HUMAN BRAIN MAPPING',
 'HEPATOLOGY',
 'HIPPOCAMPUS',
 'HUMAN BRAIN MAPPING',
 'HUMAN MUTATION',
 'HUMAN MUTATION: VARIATION, INFORMATICS, AND DISEASE',
 'IMMUNOLOGICAL REVIEWS',
 'INFLAMMATORY BOWEL DISEASES',
 'INTERNATIONAL JOURNAL OF GERIATRIC PSYCHIATRY',
 'INTERNATIONAL JOURNAL OF STROKE',
 'JOURNAL OF BONE AND MINERAL RESEARCH',
 'JOURNAL OF CELLULAR BIOCHEMISTRY',
 'JOURNAL OF CHILD PSYCHOLOGY AND PSYCHIATRY',
 'JOURNAL OF EVOLUTIONARY BIOLOGY',
 'JOURNAL OF NEUROCHEMISTRY',
 'JOURNAL OF NEUROENDOCRINOLOGY',
 'JOURNAL OF THE HISTORY OF THE BEHAVIORAL SCIENCES',
 'JOURNAL OF THE ROYAL STATISTICAL SOCIETY: SERIES C (APPLIED STATISTICS)',
 'MAGNETIC RESONANCE IN MEDICINE',
 'MOVEMENT DISORDERS',
 'MUSCLE AND NERVE',
 'NEUROPATHOLOGY AND APPLIED NEUROBIOLOGY',
 'NMR IN BIOMEDICINE',
 'PARASITE IMMUNOLOGY',
 'PLANT BIOTECHNOLOGY JOURNAL',
 'PROTEIN SCIENCE',
 'RAPID COMMUNICATIONS IN MASS SPECTROMETRY',
 'SOCIOLOGY OF HEALTH & ILLNESS',
 'STEM CELLS',
 'THE FEBS JOURNAL',
 'BRT JNL CLINICAL PHARMACOLOGY',
 'CHILD: CARE, HEALTH & DEVELOPMENT',
 'DRUG AND ALCOHOL REVIEW',
 'EVOLUTIONARY APPLICATIONS',
 'MOLECULAR GENETICS & GENOMIC MEDICINE',
 'MATERNAL AND CHILD NUTRITION',
 'EVALUATION IN CLINICAL PRACTICE',
 'JOURNAL OF CELL PHYSIOLOGY',
 'JOURNAL OF INTERNAL MEDICINE',
 'JOURNAL OF SLEEP RESEARCH',
 'CHILD: CARE, HEATH & DEVELOPMENT',
 'DEV WORLD BIOETH',
 'EUR J IMMUNOL',
 'INFLUENZA OTHER RESPI VIRUSES',
 'MATERNAL & CHILD NUTRITION',
 'TROPICAL MEDICINE & INTERNATIONAL HEALTH',
 'CLINICAL TRANSCRIPTIONAL SCIENCE',
 'IMMUNOLOGY',
 'ACTA OPTHALMOLOGICA',
 'AMERICAN JOURNAL OF TRANSPLANTATION',
 'BRITISH JOUNAL OF PHARMACOLOGY',
 'CENTAURUS',
 'CRIMINAL BEHAVIOR AND MENTAL HEALTH',
 'DEPRESSION AND ANXIETY',
 'DERMATOLOGIC SURGERY',
 'ECONOMIC HISTORY REVIEW',
 'GENETIC EPIDEMOLOGY',
 'HPB',
 'INTERNATIONAL JOURNAL OF EXPERIMENTAL PATHOLOGY',
 'JOURNAL OF COMPARATIVE NEUROLOGY',
 'JOURNAL OF EVALUATION IN CLINICAL PRACTICE',
 'JOURNAL OF MICROSCOPY',
 'JOURNAL OF ORTHOPEDIC RESEARCH',
 'JOURNAL OF VIRAL HEPATITIS',
 'OBESITY REVIEWS',
 'STATISTICS IN MEDICINE',
 'SYNAPSE',
 'THE EUROPEAN JOURNAL OF NEUROSCIENCE',
 'ZOONOSES & PUBLIC HEALTH',
 'CHEMMEDCHEM',
 'PROTEMICS',
 'JOURNAL OF SMALL ANIMAL PRACTICE',
 'AIDS JOURNAL',
 'CIRCULATION RESEARCH',
 'PEDIATR INFECT DIS J']

In [685]:
#Initial size of the dataset once grouped by Journal title
len(grouped1.index)


Out[685]:
984

In [686]:
#Final size of the dataset once grouped by Journal title
len(grouped2.index)


Out[686]:
827

In [687]:
#Type of data in each column
wellcome1.dtypes


Out[687]:
PMID/PMCID              object
PUBLISHER               object
JOURNAL TITLE           object
ARTICLE TITLE           object
COST (GBP) INC. VAT    float64
dtype: object

In [688]:
#Once the data has been cleaned we proceed to answer the questions:
#Question 1: 5 most common journals and total articles for each
#Group articles by JOURNAL TITLE and count them
grouped2 = wellcome1.groupby('JOURNAL TITLE').count().reset_index()
#Sort the number of articles per journal in a decreasing number
grouped3 = grouped2.sort_values('ARTICLE TITLE', ascending = False).reset_index()
#Show the first five common journals (considering the amount of articles sold per journal)
grouped3.head(6)
#Number 3 and 4 are in the same 4th position as they have the same number of articles.


Out[688]:
index JOURNAL TITLE PMID/PMCID PUBLISHER ARTICLE TITLE COST (GBP) INC. VAT
0 692 PLOS ONE 201 211 211 211
1 463 JOURNAL OF BIOLOGICAL CHEMISTRY 52 53 53 53
2 703 PROCEEDINGS OF THE NATIONAL ACADEMY OF SCIENCES 35 35 35 35
3 633 NEUROIMAGE 28 29 29 29
4 654 NUCLEIC ACIDS RESEARCH 28 29 29 29
5 693 PLOS PATHOGENS 24 24 24 24

In [689]:
#Qestion2: Mean, median, standard deviation of open access cost per article
#Mean of the first 5 articles
grouped4 = wellcome1.groupby('JOURNAL TITLE').describe().reset_index()
grouped4.head()


Out[689]:
JOURNAL TITLE COST (GBP) INC. VAT
count mean std min 25% 50% 75% max
0 ACADEMY OF NUTRITION AND DIETETICS 1.0 2379.540 NaN 2379.54 2379.540 2379.54 2379.540 2379.54
1 ACS CHEMICAL BIOLOGY 5.0 1418.186 507.309560 947.07 1267.760 1294.59 1294.780 2286.73
2 ACS CHEMICAL NEUROSCIENCE 1.0 1186.800 NaN 1186.80 1186.800 1186.80 1186.800 1186.80
3 ACS NANO 2.0 668.140 35.708892 642.89 655.515 668.14 680.765 693.39
4 ACTA CRYSTALLOGRAPHICA SECTION D: BIOLOGICAL C... 5.0 765.338 10.987116 750.16 757.180 771.42 773.740 774.19

In [ ]: