Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "cells": [
- {
- "cell_type": "code",
- "execution_count": 1,
- "metadata": {},
- "outputs": [],
- "source": [
- "import numpy as np\n",
- "import pandas as pd\n",
- "# articles = pd.read_csv('WELLCOME_APCspend2013_forThinkful.csv', encoding='latin1')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 2,
- "metadata": {
- "scrolled": true
- },
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- " Publisher Journal title \\\n",
- "PMID/PMCID \n",
- "NaN CUP Psychological Medicine \n",
- "PMC3679557 ACS Biomacromolecules \n",
- "23043264 PMC3506128 ACS J Med Chem \n",
- "23438330 PMC3646402 ACS J Med Chem \n",
- "23438216 PMC3601604 ACS J Org Chem \n",
- "\n",
- " Article title \\\n",
- "PMID/PMCID \n",
- "NaN Reduced parahippocampal cortical thickness in ... \n",
- "PMC3679557 Structural characterization of a Model Gram-ne... \n",
- "23043264 PMC3506128 Fumaroylamino-4,5-epoxymorphinans and related ... \n",
- "23438330 PMC3646402 Orvinols with mixed kappa/mu opioid receptor a... \n",
- "23438216 PMC3601604 Regioselective opening of myo-inositol orthoes... \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "PMID/PMCID \n",
- "NaN £0.00 \n",
- "PMC3679557 £2381.04 \n",
- "23043264 PMC3506128 £642.56 \n",
- "23438330 PMC3646402 £669.64 \n",
- "23438216 PMC3601604 £685.88 \n"
- ]
- }
- ],
- "source": [
- "df = pd.read_csv('Thinkful.csv', index_col=0)\n",
- "print(df.head(n=5))"
- ]
- },
- {
- "cell_type": "markdown",
- "metadata": {},
- "source": [
- "# Q1: Determine the five most common journals and the total articles for each"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 3,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Journal title</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>ACS Chemical Biology</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Chemical Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS NANO</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Nano</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACTA F</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AGE</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Behav</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Care</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Research and Therapy</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS UK</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ASN Neuro</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Academy of Nutrition and Dietetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D, Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D: Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section F: Structural Biology and Crystallization Communications</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica, Section D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallography D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Dermato Venereologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Diabetologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathologica</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Opthalmologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Physiol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Addiction</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Advances in Experimental Medicine and Biology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age and Ageing</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Translational Psychiatry</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Cognitive Science</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Genetics</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Molecular Medicine</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neurosciences</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Parasitology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trop Med Int Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Animal Health & Production</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Medicine and International Health</th>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tuberculosis</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urban History</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urolithiasis</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vaccine</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vascular Pharmacology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Parasitology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Record</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virus Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vision Research</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Visual Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Zoonoses and Public Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>genesis: Journal of Genetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>mBio</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>984 rows × 3 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Article title \\\n",
- "Journal title \n",
- "ACS Chemical Biology 5 5 \n",
- "ACS Chemical Neuroscience 1 1 \n",
- "ACS NANO 1 1 \n",
- "ACS Nano 1 1 \n",
- "ACTA F 1 1 \n",
- "AGE 1 1 \n",
- "AIDS 3 3 \n",
- "AIDS Behav 1 1 \n",
- "AIDS Care 2 2 \n",
- "AIDS Journal 1 1 \n",
- "AIDS Research and Therapy 1 1 \n",
- "AIDS UK 2 2 \n",
- "ASN Neuro 1 1 \n",
- "Academy of Nutrition and Dietetics 1 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 2 \n",
- "Acta Crystallographica, Section D 1 1 \n",
- "Acta Crystallography D 1 1 \n",
- "Acta D 1 1 \n",
- "Acta Dermato Venereologica 1 1 \n",
- "Acta Diabetologica 1 1 \n",
- "Acta Neuropathol 1 1 \n",
- "Acta Neuropathologica 3 3 \n",
- "Acta Opthalmologica 1 1 \n",
- "Acta Physiol 1 1 \n",
- "Addiction 2 2 \n",
- "Advances in Experimental Medicine and Biology 4 4 \n",
- "Age 1 1 \n",
- "Age and Ageing 1 1 \n",
- "... ... ... \n",
- "Translational Psychiatry 2 2 \n",
- "Trends in Cognitive Science 1 1 \n",
- "Trends in Genetics 2 2 \n",
- "Trends in Microbiology 1 1 \n",
- "Trends in Molecular Medicine 1 1 \n",
- "Trends in Neuroscience 1 1 \n",
- "Trends in Neurosciences 2 2 \n",
- "Trends in Parasitology 4 4 \n",
- "Trials 4 4 \n",
- "Trials 1 1 \n",
- "Trop Med Int Health 1 1 \n",
- "Tropical Animal Health & Production 1 1 \n",
- "Tropical Medicine and International Health 6 6 \n",
- "Tuberculosis 2 2 \n",
- "Urban History 1 1 \n",
- "Urolithiasis 1 1 \n",
- "Vaccine 5 5 \n",
- "Vascular Pharmacology 1 1 \n",
- "Veterinary Microbiology 1 1 \n",
- "Veterinary Parasitology 2 2 \n",
- "Veterinary Record 1 1 \n",
- "Veterinary Research 1 1 \n",
- "Virology 2 2 \n",
- "Virology Journal 1 1 \n",
- "Virus Research 1 1 \n",
- "Vision Research 2 2 \n",
- "Visual Neuroscience 1 1 \n",
- "Zoonoses and Public Health 1 1 \n",
- "genesis: Journal of Genetics 1 1 \n",
- "mBio 1 1 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "Journal title \n",
- "ACS Chemical Biology 5 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "AGE 1 \n",
- "AIDS 3 \n",
- "AIDS Behav 1 \n",
- "AIDS Care 2 \n",
- "AIDS Journal 1 \n",
- "AIDS Research and Therapy 1 \n",
- "AIDS UK 2 \n",
- "ASN Neuro 1 \n",
- "Academy of Nutrition and Dietetics 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 \n",
- "Acta Crystallographica, Section D 1 \n",
- "Acta Crystallography D 1 \n",
- "Acta D 1 \n",
- "Acta Dermato Venereologica 1 \n",
- "Acta Diabetologica 1 \n",
- "Acta Neuropathol 1 \n",
- "Acta Neuropathologica 3 \n",
- "Acta Opthalmologica 1 \n",
- "Acta Physiol 1 \n",
- "Addiction 2 \n",
- "Advances in Experimental Medicine and Biology 4 \n",
- "Age 1 \n",
- "Age and Ageing 1 \n",
- "... ... \n",
- "Translational Psychiatry 2 \n",
- "Trends in Cognitive Science 1 \n",
- "Trends in Genetics 2 \n",
- "Trends in Microbiology 1 \n",
- "Trends in Molecular Medicine 1 \n",
- "Trends in Neuroscience 1 \n",
- "Trends in Neurosciences 2 \n",
- "Trends in Parasitology 4 \n",
- "Trials 4 \n",
- "Trials 1 \n",
- "Trop Med Int Health 1 \n",
- "Tropical Animal Health & Production 1 \n",
- "Tropical Medicine and International Health 6 \n",
- "Tuberculosis 2 \n",
- "Urban History 1 \n",
- "Urolithiasis 1 \n",
- "Vaccine 5 \n",
- "Vascular Pharmacology 1 \n",
- "Veterinary Microbiology 1 \n",
- "Veterinary Parasitology 2 \n",
- "Veterinary Record 1 \n",
- "Veterinary Research 1 \n",
- "Virology 2 \n",
- "Virology Journal 1 \n",
- "Virus Research 1 \n",
- "Vision Research 2 \n",
- "Visual Neuroscience 1 \n",
- "Zoonoses and Public Health 1 \n",
- "genesis: Journal of Genetics 1 \n",
- "mBio 1 \n",
- "\n",
- "[984 rows x 3 columns]"
- ]
- },
- "execution_count": 3,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "# Step #1- List all of the journal names possible- field is 'Journal title'\n",
- "df.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 43,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Journal title</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID/PMCID</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Discovery of ?2 Adrenergic Receptor Ligands Us...</td>\n",
- " <td>£947.07</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>: PMC3805332</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Synthesis of alpha-glucan in mycobacteria invo...</td>\n",
- " <td>£2286.73</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3780468</th>\n",
- " <td>ACS (Amercian Chemical Society) Publications</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>A Novel Allosteric Inhibitor of the Uridine Di...</td>\n",
- " <td>£1294.59</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3621575</th>\n",
- " <td>ACS (Amercian Chemical Society) Publications</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Chemical proteomic analysis reveals the drugab...</td>\n",
- " <td>£1294.78</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID: 24015914 PMC3833349</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Discovery of an allosteric inhibitor binding s...</td>\n",
- " <td>£1267.76</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3656742\\r\\n</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Neuroscience</td>\n",
- " <td>Continuous online microdialysis using microflu...</td>\n",
- " <td>£1186.80</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: 3584654</th>\n",
- " <td>AMERICAN CHEMICAL SOCIETY</td>\n",
- " <td>ACS NANO</td>\n",
- " <td>HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART...</td>\n",
- " <td>£642.89</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23373658</th>\n",
- " <td>American Chemical Society Publications</td>\n",
- " <td>ACS Nano</td>\n",
- " <td>Skin dendritic cell targeting via microneedle ...</td>\n",
- " <td>£693.39</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3374517</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>ACTA F</td>\n",
- " <td>Crystallization and preliminary crystallograph...</td>\n",
- " <td>£754.90</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23340916</th>\n",
- " <td>Springer-Verlag GMBH & Ci</td>\n",
- " <td>AGE</td>\n",
- " <td>Voluntary exercise can strengthen the circadia...</td>\n",
- " <td>£2002.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3647051\\r\\n</th>\n",
- " <td>Wolters Kluwer N.V./Lippinott</td>\n",
- " <td>AIDS</td>\n",
- " <td>Grassroots Community Organisations' Contributi...</td>\n",
- " <td>£2374.52</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3748854</th>\n",
- " <td>Wolters Kluwer Health</td>\n",
- " <td>AIDS</td>\n",
- " <td>Evaluation of an empiric risk screening score ...</td>\n",
- " <td>£1834.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3713766</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS</td>\n",
- " <td>HIV infected adolescents in Southern Africa ca...</td>\n",
- " <td>£1968.63</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3633780</th>\n",
- " <td>Springer</td>\n",
- " <td>AIDS Behav</td>\n",
- " <td>Adherence to antiretroviral therapy and clinic...</td>\n",
- " <td>£1834.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>In Process</th>\n",
- " <td>Taylor & Francis</td>\n",
- " <td>AIDS Care</td>\n",
- " <td>Burden of HIV among primary school children an...</td>\n",
- " <td>£2145.60</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3687248\\r\\n</th>\n",
- " <td>Taylor and Francis</td>\n",
- " <td>AIDS Care</td>\n",
- " <td>WORLDBANK Special Issue: Evidence for a contri...</td>\n",
- " <td>£2232.74</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3819359</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS Journal</td>\n",
- " <td>Short title: TB and VL breakthrough and failur...</td>\n",
- " <td>£2015.72</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3765690</th>\n",
- " <td>BioMed Central Limited</td>\n",
- " <td>AIDS Research and Therapy</td>\n",
- " <td>Collective Patient behaviours derailing ART ro...</td>\n",
- " <td>£1240.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3773237</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS UK</td>\n",
- " <td>Sexual behaviour in a rural high HIV prevalence</td>\n",
- " <td>£1836.92</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3815011</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS UK</td>\n",
- " <td>HIV incidence and survival from age-specific s...</td>\n",
- " <td>£1836.92</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Portland Press</td>\n",
- " <td>ASN Neuro</td>\n",
- " <td>Astrocytes and glutamate homeostasis in Alzhei...</td>\n",
- " <td>£1453.42</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3378987\\r\\n</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Academy of Nutrition and Dietetics</td>\n",
- " <td>Parent support and parent mediated behaviours ...</td>\n",
- " <td>£2379.54</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3727331\\r\\n</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica Section D, Biological ...</td>\n",
- " <td>Clustering procedures for the optimal selectio...</td>\n",
- " <td>£771.42</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3565438</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica Section D: Biological C...</td>\n",
- " <td>Intensity statistics in the presence of transl...</td>\n",
- " <td>£773.74</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3606566</th>\n",
- " <td>International Union of Crystallography (iucr)</td>\n",
- " <td>Acta Crystallographica Section F: Structural B...</td>\n",
- " <td>Structure of Pseudomonas aeruginosa inosine 5'...</td>\n",
- " <td>£807.67</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3668577</th>\n",
- " <td>International Union of Crystallography (iucr)</td>\n",
- " <td>Acta Crystallographica Section F: Structural B...</td>\n",
- " <td>Structure of diaminohydroxyphosphoribosylamino...</td>\n",
- " <td>£785.60</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>\\r\\n PMC3498934</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica, Section D</td>\n",
- " <td>Nearest-cell: a fast and easy tool for locatin...</td>\n",
- " <td>£757.18</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID:22993091 PMC3447403</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallography D</td>\n",
- " <td>Crystallization, dehydration and experimental ...</td>\n",
- " <td>£774.19</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3087623</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta D</td>\n",
- " <td>Structure of HLA-A*0301 in complex with a pept...</td>\n",
- " <td>£750.16</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3808818</th>\n",
- " <td>Society for Publication of Acta Dermato-Venere...</td>\n",
- " <td>Acta Dermato Venereologica</td>\n",
- " <td>The Importance of a Full Clinical Examination:...</td>\n",
- " <td>£653.96</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3627817</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Maternal recall of birth weight and birth size...</td>\n",
- " <td>£1896.93</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3770928</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Epidemiology and control of trachoma: systamat...</td>\n",
- " <td>£1974.72</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Meningococcal carriage in the African meningit...</td>\n",
- " <td>£1949.32</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3717178</th>\n",
- " <td>John Wiley & Sons Ltd</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Nutritional supplementation: the additional co...</td>\n",
- " <td>£1530.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3759846</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Tuberculosis</td>\n",
- " <td>Pathways of IL-1? secretion by macrophages inf...</td>\n",
- " <td>£1999.94</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3608034</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Tuberculosis</td>\n",
- " <td>A novel assay of antimycobacterial activity an...</td>\n",
- " <td>£2322.57</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Cambridge University Press</td>\n",
- " <td>Urban History</td>\n",
- " <td>Leisure, economy and colonial urbanism: Darjee...</td>\n",
- " <td>£2034.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3599165</th>\n",
- " <td>Springer</td>\n",
- " <td>Urolithiasis</td>\n",
- " <td>Accuracy of urine pH testing in a regional met...</td>\n",
- " <td>£1112.40</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3404461</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Tailoring subunit vaccine immunogenicity: maxi...</td>\n",
- " <td>£2328.84</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3763374</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Protection against avian necrotic enteritis af...</td>\n",
- " <td>£1477.73</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID: 24035434</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Cattle immunized against the pathogenic l-?-gl...</td>\n",
- " <td>£1448.38</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3740234</th>\n",
- " <td>Elsevier Ltd</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Increased IgG but normal IgA anti-pneumococcal...</td>\n",
- " <td>£1428.68</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3763375</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Human papillomavirus (HPV) vaccine implementat...</td>\n",
- " <td>£1433.34</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23117109</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vascular Pharmacology</td>\n",
- " <td>Signal transduction and modulating pathways in...</td>\n",
- " <td>£2352.53</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3757156</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Microbiology</td>\n",
- " <td>Isolation of canine Anaplasma phagocytophilum ...</td>\n",
- " <td>£2451.49</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3611597</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Parasitology</td>\n",
- " <td>Toxocara canis: molecular basis of immune reco...</td>\n",
- " <td>£2488.17</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Parasitology</td>\n",
- " <td>Persistence of the efficacy of copper oxide wi...</td>\n",
- " <td>£999999.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3786614</th>\n",
- " <td>BMJ Publishing Group</td>\n",
- " <td>Veterinary Record</td>\n",
- " <td>Proactive dairy cattle disease control in the ...</td>\n",
- " <td>£2040.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3716626</th>\n",
- " <td>BioMed Central Ltd</td>\n",
- " <td>Veterinary Research</td>\n",
- " <td>Understanding foot-and-mouth disease virus tra...</td>\n",
- " <td>£9.93</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3791421</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Virology</td>\n",
- " <td>An essential fifth coding ORF in the sobemovir...</td>\n",
- " <td>£1435.05</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23562481</th>\n",
- " <td>The Boulevard</td>\n",
- " <td>Virology</td>\n",
- " <td>Metagenomic study of the viruses of African st...</td>\n",
- " <td>£2421.96</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3190389</th>\n",
- " <td>BioMed Central</td>\n",
- " <td>Virology Journal</td>\n",
- " <td>Label-free quantitative proteomics reveals reg...</td>\n",
- " <td>£1242.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23201205</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Virus Research</td>\n",
- " <td>Prostratin exhibits both replication enhancing...</td>\n",
- " <td>£1947.09</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23200744 PMC3552157</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vision Research</td>\n",
- " <td>Perceptual learning of second order cues for l...</td>\n",
- " <td>£999999.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>pub Aug 2013</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vision Research</td>\n",
- " <td>Sensitivity to numerosity is not a unique visu...</td>\n",
- " <td>£1456.18</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3472342\\r\\n\\r\\n</th>\n",
- " <td>Cambridge University Press</td>\n",
- " <td>Visual Neuroscience</td>\n",
- " <td>Masking within and across visual dimensions: P...</td>\n",
- " <td>£2034.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3600532</th>\n",
- " <td>Wiley-Blackwell</td>\n",
- " <td>Zoonoses and Public Health</td>\n",
- " <td>Ecology of zoonotic infectious diseases in bat...</td>\n",
- " <td>£2272.15</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23315936 PMC3638342</th>\n",
- " <td>Wiley</td>\n",
- " <td>genesis: Journal of Genetics</td>\n",
- " <td>The Caenorhabditis elegans homeobox gene ceh-1...</td>\n",
- " <td>£2376.40</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID:23232717 PMC3520108</th>\n",
- " <td>Cadmus Journal Services</td>\n",
- " <td>mBio</td>\n",
- " <td>The Evolutionary Rewiring of Ubiquitination Ta...</td>\n",
- " <td>£1355.13</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>MacMillan</td>\n",
- " <td>NaN</td>\n",
- " <td>Fungal Disease in Britain and the United State...</td>\n",
- " <td>£13200.00</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>2127 rows × 4 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher \\\n",
- "PMID/PMCID \n",
- "NaN American Chemical Society \n",
- ": PMC3805332 American Chemical Society \n",
- "PMCID: PMC3780468 ACS (Amercian Chemical Society) Publications \n",
- "PMCID: PMC3621575 ACS (Amercian Chemical Society) Publications \n",
- "PMID: 24015914 PMC3833349 American Chemical Society \n",
- "PMCID:\\r\\n PMC3656742\\r\\n American Chemical Society \n",
- "PMCID: 3584654 AMERICAN CHEMICAL SOCIETY \n",
- "23373658 American Chemical Society Publications \n",
- "PMC3374517 International Union of Crystallography \n",
- "23340916 Springer-Verlag GMBH & Ci \n",
- "PMCID:\\r\\n PMC3647051\\r\\n Wolters Kluwer N.V./Lippinott \n",
- "3748854 Wolters Kluwer Health \n",
- "PMC3713766 Wolters Kluwer \n",
- "3633780 Springer \n",
- "In Process Taylor & Francis \n",
- "PMCID:\\r\\n PMC3687248\\r\\n Taylor and Francis \n",
- "PMC3819359 Wolters Kluwer \n",
- "PMC3765690 BioMed Central Limited \n",
- "PMC3773237 Wolters Kluwer \n",
- "PMC3815011 Wolters Kluwer \n",
- "NaN Portland Press \n",
- "PMC3378987\\r\\n Elsevier \n",
- "PMCID:\\r\\n PMC3727331\\r\\n International Union of Crystallography \n",
- "PMCID: PMC3565438 International Union of Crystallography \n",
- "PMCID: PMC3606566 International Union of Crystallography (iucr) \n",
- "PMCID: PMC3668577 International Union of Crystallography (iucr) \n",
- "\\r\\n PMC3498934 International Union of Crystallography \n",
- "PMID:22993091 PMC3447403 International Union of Crystallography \n",
- "PMC3087623 International Union of Crystallography \n",
- "PMC3808818 Society for Publication of Acta Dermato-Venere... \n",
- "... ... \n",
- "PMC3627817 Wiley \n",
- "PMC3770928 Wiley \n",
- "NaN Wiley \n",
- "PMC3717178 John Wiley & Sons Ltd \n",
- "PMCID:\\r\\n PMC3759846 Elsevier \n",
- "PMCID:\\r\\n PMC3608034 Elsevier \n",
- "NaN Cambridge University Press \n",
- "PMCID: PMC3599165 Springer \n",
- "PMC3404461 Elsevier \n",
- "PMC3763374 Elsevier \n",
- "PMID: 24035434 Elsevier \n",
- "PMCID: PMC3740234 Elsevier Ltd \n",
- "PMC3763375 Elsevier \n",
- "23117109 Elsevier \n",
- "PMC3757156 Elsevier \n",
- "PMC3611597 Elsevier \n",
- "NaN Elsevier \n",
- "PMC3786614 BMJ Publishing Group \n",
- "PMC3716626 BioMed Central Ltd \n",
- "PMCID: PMC3791421 Elsevier \n",
- "23562481 The Boulevard \n",
- "PMC3190389 BioMed Central \n",
- "23201205 Elsevier \n",
- "23200744 PMC3552157 Elsevier \n",
- "pub Aug 2013 Elsevier \n",
- "PMC3472342\\r\\n\\r\\n Cambridge University Press \n",
- "PMCID: PMC3600532 Wiley-Blackwell \n",
- "23315936 PMC3638342 Wiley \n",
- "PMID:23232717 PMC3520108 Cadmus Journal Services \n",
- "NaN MacMillan \n",
- "\n",
- " Journal title \\\n",
- "PMID/PMCID \n",
- "NaN ACS Chemical Biology \n",
- ": PMC3805332 ACS Chemical Biology \n",
- "PMCID: PMC3780468 ACS Chemical Biology \n",
- "PMCID: PMC3621575 ACS Chemical Biology \n",
- "PMID: 24015914 PMC3833349 ACS Chemical Biology \n",
- "PMCID:\\r\\n PMC3656742\\r\\n ACS Chemical Neuroscience \n",
- "PMCID: 3584654 ACS NANO \n",
- "23373658 ACS Nano \n",
- "PMC3374517 ACTA F \n",
- "23340916 AGE \n",
- "PMCID:\\r\\n PMC3647051\\r\\n AIDS \n",
- "3748854 AIDS \n",
- "PMC3713766 AIDS \n",
- "3633780 AIDS Behav \n",
- "In Process AIDS Care \n",
- "PMCID:\\r\\n PMC3687248\\r\\n AIDS Care \n",
- "PMC3819359 AIDS Journal \n",
- "PMC3765690 AIDS Research and Therapy \n",
- "PMC3773237 AIDS UK \n",
- "PMC3815011 AIDS UK \n",
- "NaN ASN Neuro \n",
- "PMC3378987\\r\\n Academy of Nutrition and Dietetics \n",
- "PMCID:\\r\\n PMC3727331\\r\\n Acta Crystallographica Section D, Biological ... \n",
- "PMCID: PMC3565438 Acta Crystallographica Section D: Biological C... \n",
- "PMCID: PMC3606566 Acta Crystallographica Section F: Structural B... \n",
- "PMCID: PMC3668577 Acta Crystallographica Section F: Structural B... \n",
- "\\r\\n PMC3498934 Acta Crystallographica, Section D \n",
- "PMID:22993091 PMC3447403 Acta Crystallography D \n",
- "PMC3087623 Acta D \n",
- "PMC3808818 Acta Dermato Venereologica \n",
- "... ... \n",
- "PMC3627817 Tropical Medicine and International Health \n",
- "PMC3770928 Tropical Medicine and International Health \n",
- "NaN Tropical Medicine and International Health \n",
- "PMC3717178 Tropical Medicine and International Health \n",
- "PMCID:\\r\\n PMC3759846 Tuberculosis \n",
- "PMCID:\\r\\n PMC3608034 Tuberculosis \n",
- "NaN Urban History \n",
- "PMCID: PMC3599165 Urolithiasis \n",
- "PMC3404461 Vaccine \n",
- "PMC3763374 Vaccine \n",
- "PMID: 24035434 Vaccine \n",
- "PMCID: PMC3740234 Vaccine \n",
- "PMC3763375 Vaccine \n",
- "23117109 Vascular Pharmacology \n",
- "PMC3757156 Veterinary Microbiology \n",
- "PMC3611597 Veterinary Parasitology \n",
- "NaN Veterinary Parasitology \n",
- "PMC3786614 Veterinary Record \n",
- "PMC3716626 Veterinary Research \n",
- "PMCID: PMC3791421 Virology \n",
- "23562481 Virology \n",
- "PMC3190389 Virology Journal \n",
- "23201205 Virus Research \n",
- "23200744 PMC3552157 Vision Research \n",
- "pub Aug 2013 Vision Research \n",
- "PMC3472342\\r\\n\\r\\n Visual Neuroscience \n",
- "PMCID: PMC3600532 Zoonoses and Public Health \n",
- "23315936 PMC3638342 genesis: Journal of Genetics \n",
- "PMID:23232717 PMC3520108 mBio \n",
- "NaN NaN \n",
- "\n",
- " Article title \\\n",
- "PMID/PMCID \n",
- "NaN Discovery of ?2 Adrenergic Receptor Ligands Us... \n",
- ": PMC3805332 Synthesis of alpha-glucan in mycobacteria invo... \n",
- "PMCID: PMC3780468 A Novel Allosteric Inhibitor of the Uridine Di... \n",
- "PMCID: PMC3621575 Chemical proteomic analysis reveals the drugab... \n",
- "PMID: 24015914 PMC3833349 Discovery of an allosteric inhibitor binding s... \n",
- "PMCID:\\r\\n PMC3656742\\r\\n Continuous online microdialysis using microflu... \n",
- "PMCID: 3584654 HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART... \n",
- "23373658 Skin dendritic cell targeting via microneedle ... \n",
- "PMC3374517 Crystallization and preliminary crystallograph... \n",
- "23340916 Voluntary exercise can strengthen the circadia... \n",
- "PMCID:\\r\\n PMC3647051\\r\\n Grassroots Community Organisations' Contributi... \n",
- "3748854 Evaluation of an empiric risk screening score ... \n",
- "PMC3713766 HIV infected adolescents in Southern Africa ca... \n",
- "3633780 Adherence to antiretroviral therapy and clinic... \n",
- "In Process Burden of HIV among primary school children an... \n",
- "PMCID:\\r\\n PMC3687248\\r\\n WORLDBANK Special Issue: Evidence for a contri... \n",
- "PMC3819359 Short title: TB and VL breakthrough and failur... \n",
- "PMC3765690 Collective Patient behaviours derailing ART ro... \n",
- "PMC3773237 Sexual behaviour in a rural high HIV prevalence \n",
- "PMC3815011 HIV incidence and survival from age-specific s... \n",
- "NaN Astrocytes and glutamate homeostasis in Alzhei... \n",
- "PMC3378987\\r\\n Parent support and parent mediated behaviours ... \n",
- "PMCID:\\r\\n PMC3727331\\r\\n Clustering procedures for the optimal selectio... \n",
- "PMCID: PMC3565438 Intensity statistics in the presence of transl... \n",
- "PMCID: PMC3606566 Structure of Pseudomonas aeruginosa inosine 5'... \n",
- "PMCID: PMC3668577 Structure of diaminohydroxyphosphoribosylamino... \n",
- "\\r\\n PMC3498934 Nearest-cell: a fast and easy tool for locatin... \n",
- "PMID:22993091 PMC3447403 Crystallization, dehydration and experimental ... \n",
- "PMC3087623 Structure of HLA-A*0301 in complex with a pept... \n",
- "PMC3808818 The Importance of a Full Clinical Examination:... \n",
- "... ... \n",
- "PMC3627817 Maternal recall of birth weight and birth size... \n",
- "PMC3770928 Epidemiology and control of trachoma: systamat... \n",
- "NaN Meningococcal carriage in the African meningit... \n",
- "PMC3717178 Nutritional supplementation: the additional co... \n",
- "PMCID:\\r\\n PMC3759846 Pathways of IL-1? secretion by macrophages inf... \n",
- "PMCID:\\r\\n PMC3608034 A novel assay of antimycobacterial activity an... \n",
- "NaN Leisure, economy and colonial urbanism: Darjee... \n",
- "PMCID: PMC3599165 Accuracy of urine pH testing in a regional met... \n",
- "PMC3404461 Tailoring subunit vaccine immunogenicity: maxi... \n",
- "PMC3763374 Protection against avian necrotic enteritis af... \n",
- "PMID: 24035434 Cattle immunized against the pathogenic l-?-gl... \n",
- "PMCID: PMC3740234 Increased IgG but normal IgA anti-pneumococcal... \n",
- "PMC3763375 Human papillomavirus (HPV) vaccine implementat... \n",
- "23117109 Signal transduction and modulating pathways in... \n",
- "PMC3757156 Isolation of canine Anaplasma phagocytophilum ... \n",
- "PMC3611597 Toxocara canis: molecular basis of immune reco... \n",
- "NaN Persistence of the efficacy of copper oxide wi... \n",
- "PMC3786614 Proactive dairy cattle disease control in the ... \n",
- "PMC3716626 Understanding foot-and-mouth disease virus tra... \n",
- "PMCID: PMC3791421 An essential fifth coding ORF in the sobemovir... \n",
- "23562481 Metagenomic study of the viruses of African st... \n",
- "PMC3190389 Label-free quantitative proteomics reveals reg... \n",
- "23201205 Prostratin exhibits both replication enhancing... \n",
- "23200744 PMC3552157 Perceptual learning of second order cues for l... \n",
- "pub Aug 2013 Sensitivity to numerosity is not a unique visu... \n",
- "PMC3472342\\r\\n\\r\\n Masking within and across visual dimensions: P... \n",
- "PMCID: PMC3600532 Ecology of zoonotic infectious diseases in bat... \n",
- "23315936 PMC3638342 The Caenorhabditis elegans homeobox gene ceh-1... \n",
- "PMID:23232717 PMC3520108 The Evolutionary Rewiring of Ubiquitination Ta... \n",
- "NaN Fungal Disease in Britain and the United State... \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "PMID/PMCID \n",
- "NaN £947.07 \n",
- ": PMC3805332 £2286.73 \n",
- "PMCID: PMC3780468 £1294.59 \n",
- "PMCID: PMC3621575 £1294.78 \n",
- "PMID: 24015914 PMC3833349 £1267.76 \n",
- "PMCID:\\r\\n PMC3656742\\r\\n £1186.80 \n",
- "PMCID: 3584654 £642.89 \n",
- "23373658 £693.39 \n",
- "PMC3374517 £754.90 \n",
- "23340916 £2002.00 \n",
- "PMCID:\\r\\n PMC3647051\\r\\n £2374.52 \n",
- "3748854 £1834.77 \n",
- "PMC3713766 £1968.63 \n",
- "3633780 £1834.77 \n",
- "In Process £2145.60 \n",
- "PMCID:\\r\\n PMC3687248\\r\\n £2232.74 \n",
- "PMC3819359 £2015.72 \n",
- "PMC3765690 £1240.00 \n",
- "PMC3773237 £1836.92 \n",
- "PMC3815011 £1836.92 \n",
- "NaN £1453.42 \n",
- "PMC3378987\\r\\n £2379.54 \n",
- "PMCID:\\r\\n PMC3727331\\r\\n £771.42 \n",
- "PMCID: PMC3565438 £773.74 \n",
- "PMCID: PMC3606566 £807.67 \n",
- "PMCID: PMC3668577 £785.60 \n",
- "\\r\\n PMC3498934 £757.18 \n",
- "PMID:22993091 PMC3447403 £774.19 \n",
- "PMC3087623 £750.16 \n",
- "PMC3808818 £653.96 \n",
- "... ... \n",
- "PMC3627817 £1896.93 \n",
- "PMC3770928 £1974.72 \n",
- "NaN £1949.32 \n",
- "PMC3717178 £1530.77 \n",
- "PMCID:\\r\\n PMC3759846 £1999.94 \n",
- "PMCID:\\r\\n PMC3608034 £2322.57 \n",
- "NaN £2034.00 \n",
- "PMCID: PMC3599165 £1112.40 \n",
- "PMC3404461 £2328.84 \n",
- "PMC3763374 £1477.73 \n",
- "PMID: 24035434 £1448.38 \n",
- "PMCID: PMC3740234 £1428.68 \n",
- "PMC3763375 £1433.34 \n",
- "23117109 £2352.53 \n",
- "PMC3757156 £2451.49 \n",
- "PMC3611597 £2488.17 \n",
- "NaN £999999.00 \n",
- "PMC3786614 £2040.00 \n",
- "PMC3716626 £9.93 \n",
- "PMCID: PMC3791421 £1435.05 \n",
- "23562481 £2421.96 \n",
- "PMC3190389 £1242.00 \n",
- "23201205 £1947.09 \n",
- "23200744 PMC3552157 £999999.00 \n",
- "pub Aug 2013 £1456.18 \n",
- "PMC3472342\\r\\n\\r\\n £2034.00 \n",
- "PMCID: PMC3600532 £2272.15 \n",
- "23315936 PMC3638342 £2376.40 \n",
- "PMID:23232717 PMC3520108 £1355.13 \n",
- "NaN £13200.00 \n",
- "\n",
- "[2127 rows x 4 columns]"
- ]
- },
- "execution_count": 43,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.sort_values(by=['Journal title'])"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 35,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Journal title</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>count</th>\n",
- " <td>2127</td>\n",
- " <td>2126</td>\n",
- " <td>2127</td>\n",
- " <td>2127</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>unique</th>\n",
- " <td>299</td>\n",
- " <td>984</td>\n",
- " <td>2126</td>\n",
- " <td>1402</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>top</th>\n",
- " <td>Elsevier</td>\n",
- " <td>PLoS One</td>\n",
- " <td>Exclusive breastfeeding, diarrhoel morbidity a...</td>\n",
- " <td>£2040.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>freq</th>\n",
- " <td>387</td>\n",
- " <td>92</td>\n",
- " <td>2</td>\n",
- " <td>94</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Journal title \\\n",
- "count 2127 2126 \n",
- "unique 299 984 \n",
- "top Elsevier PLoS One \n",
- "freq 387 92 \n",
- "\n",
- " Article title \\\n",
- "count 2127 \n",
- "unique 2126 \n",
- "top Exclusive breastfeeding, diarrhoel morbidity a... \n",
- "freq 2 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "count 2127 \n",
- "unique 1402 \n",
- "top £2040.00 \n",
- "freq 94 "
- ]
- },
- "execution_count": 35,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.describe()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 51,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Journal title</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID/PMCID</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Discovery of ?2 Adrenergic Receptor Ligands Us...</td>\n",
- " <td>£947.07</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>: PMC3805332</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Synthesis of alpha-glucan in mycobacteria invo...</td>\n",
- " <td>£2286.73</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3780468</th>\n",
- " <td>ACS (Amercian Chemical Society) Publications</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>A Novel Allosteric Inhibitor of the Uridine Di...</td>\n",
- " <td>£1294.59</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3621575</th>\n",
- " <td>ACS (Amercian Chemical Society) Publications</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Chemical proteomic analysis reveals the drugab...</td>\n",
- " <td>£1294.78</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID: 24015914 PMC3833349</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Discovery of an allosteric inhibitor binding s...</td>\n",
- " <td>£1267.76</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3656742\\r\\n</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Neuroscience</td>\n",
- " <td>Continuous online microdialysis using microflu...</td>\n",
- " <td>£1186.80</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: 3584654</th>\n",
- " <td>AMERICAN CHEMICAL SOCIETY</td>\n",
- " <td>ACS NANO</td>\n",
- " <td>HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART...</td>\n",
- " <td>£642.89</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23373658</th>\n",
- " <td>American Chemical Society Publications</td>\n",
- " <td>ACS Nano</td>\n",
- " <td>Skin dendritic cell targeting via microneedle ...</td>\n",
- " <td>£693.39</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3374517</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>ACTA F</td>\n",
- " <td>Crystallization and preliminary crystallograph...</td>\n",
- " <td>£754.90</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23340916</th>\n",
- " <td>Springer-Verlag GMBH & Ci</td>\n",
- " <td>AGE</td>\n",
- " <td>Voluntary exercise can strengthen the circadia...</td>\n",
- " <td>£2002.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3647051\\r\\n</th>\n",
- " <td>Wolters Kluwer N.V./Lippinott</td>\n",
- " <td>AIDS</td>\n",
- " <td>Grassroots Community Organisations' Contributi...</td>\n",
- " <td>£2374.52</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3748854</th>\n",
- " <td>Wolters Kluwer Health</td>\n",
- " <td>AIDS</td>\n",
- " <td>Evaluation of an empiric risk screening score ...</td>\n",
- " <td>£1834.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3713766</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS</td>\n",
- " <td>HIV infected adolescents in Southern Africa ca...</td>\n",
- " <td>£1968.63</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3633780</th>\n",
- " <td>Springer</td>\n",
- " <td>AIDS Behav</td>\n",
- " <td>Adherence to antiretroviral therapy and clinic...</td>\n",
- " <td>£1834.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>In Process</th>\n",
- " <td>Taylor & Francis</td>\n",
- " <td>AIDS Care</td>\n",
- " <td>Burden of HIV among primary school children an...</td>\n",
- " <td>£2145.60</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3687248\\r\\n</th>\n",
- " <td>Taylor and Francis</td>\n",
- " <td>AIDS Care</td>\n",
- " <td>WORLDBANK Special Issue: Evidence for a contri...</td>\n",
- " <td>£2232.74</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3819359</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS Journal</td>\n",
- " <td>Short title: TB and VL breakthrough and failur...</td>\n",
- " <td>£2015.72</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3765690</th>\n",
- " <td>BioMed Central Limited</td>\n",
- " <td>AIDS Research and Therapy</td>\n",
- " <td>Collective Patient behaviours derailing ART ro...</td>\n",
- " <td>£1240.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3773237</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS UK</td>\n",
- " <td>Sexual behaviour in a rural high HIV prevalence</td>\n",
- " <td>£1836.92</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3815011</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS UK</td>\n",
- " <td>HIV incidence and survival from age-specific s...</td>\n",
- " <td>£1836.92</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Portland Press</td>\n",
- " <td>ASN Neuro</td>\n",
- " <td>Astrocytes and glutamate homeostasis in Alzhei...</td>\n",
- " <td>£1453.42</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3378987\\r\\n</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Academy of Nutrition and Dietetics</td>\n",
- " <td>Parent support and parent mediated behaviours ...</td>\n",
- " <td>£2379.54</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3727331\\r\\n</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica Section D, Biological ...</td>\n",
- " <td>Clustering procedures for the optimal selectio...</td>\n",
- " <td>£771.42</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3565438</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica Section D: Biological C...</td>\n",
- " <td>Intensity statistics in the presence of transl...</td>\n",
- " <td>£773.74</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3606566</th>\n",
- " <td>International Union of Crystallography (iucr)</td>\n",
- " <td>Acta Crystallographica Section F: Structural B...</td>\n",
- " <td>Structure of Pseudomonas aeruginosa inosine 5'...</td>\n",
- " <td>£807.67</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3668577</th>\n",
- " <td>International Union of Crystallography (iucr)</td>\n",
- " <td>Acta Crystallographica Section F: Structural B...</td>\n",
- " <td>Structure of diaminohydroxyphosphoribosylamino...</td>\n",
- " <td>£785.60</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>\\r\\n PMC3498934</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica, Section D</td>\n",
- " <td>Nearest-cell: a fast and easy tool for locatin...</td>\n",
- " <td>£757.18</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID:22993091 PMC3447403</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallography D</td>\n",
- " <td>Crystallization, dehydration and experimental ...</td>\n",
- " <td>£774.19</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3087623</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta D</td>\n",
- " <td>Structure of HLA-A*0301 in complex with a pept...</td>\n",
- " <td>£750.16</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3808818</th>\n",
- " <td>Society for Publication of Acta Dermato-Venere...</td>\n",
- " <td>Acta Dermato Venereologica</td>\n",
- " <td>The Importance of a Full Clinical Examination:...</td>\n",
- " <td>£653.96</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3627817</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Maternal recall of birth weight and birth size...</td>\n",
- " <td>£1896.93</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3770928</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Epidemiology and control of trachoma: systamat...</td>\n",
- " <td>£1974.72</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Meningococcal carriage in the African meningit...</td>\n",
- " <td>£1949.32</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3717178</th>\n",
- " <td>John Wiley & Sons Ltd</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Nutritional supplementation: the additional co...</td>\n",
- " <td>£1530.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3759846</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Tuberculosis</td>\n",
- " <td>Pathways of IL-1? secretion by macrophages inf...</td>\n",
- " <td>£1999.94</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3608034</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Tuberculosis</td>\n",
- " <td>A novel assay of antimycobacterial activity an...</td>\n",
- " <td>£2322.57</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Cambridge University Press</td>\n",
- " <td>Urban History</td>\n",
- " <td>Leisure, economy and colonial urbanism: Darjee...</td>\n",
- " <td>£2034.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3599165</th>\n",
- " <td>Springer</td>\n",
- " <td>Urolithiasis</td>\n",
- " <td>Accuracy of urine pH testing in a regional met...</td>\n",
- " <td>£1112.40</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3404461</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Tailoring subunit vaccine immunogenicity: maxi...</td>\n",
- " <td>£2328.84</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3763374</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Protection against avian necrotic enteritis af...</td>\n",
- " <td>£1477.73</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID: 24035434</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Cattle immunized against the pathogenic l-?-gl...</td>\n",
- " <td>£1448.38</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3740234</th>\n",
- " <td>Elsevier Ltd</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Increased IgG but normal IgA anti-pneumococcal...</td>\n",
- " <td>£1428.68</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3763375</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Human papillomavirus (HPV) vaccine implementat...</td>\n",
- " <td>£1433.34</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23117109</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vascular Pharmacology</td>\n",
- " <td>Signal transduction and modulating pathways in...</td>\n",
- " <td>£2352.53</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3757156</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Microbiology</td>\n",
- " <td>Isolation of canine Anaplasma phagocytophilum ...</td>\n",
- " <td>£2451.49</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3611597</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Parasitology</td>\n",
- " <td>Toxocara canis: molecular basis of immune reco...</td>\n",
- " <td>£2488.17</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Parasitology</td>\n",
- " <td>Persistence of the efficacy of copper oxide wi...</td>\n",
- " <td>£999999.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3786614</th>\n",
- " <td>BMJ Publishing Group</td>\n",
- " <td>Veterinary Record</td>\n",
- " <td>Proactive dairy cattle disease control in the ...</td>\n",
- " <td>£2040.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3716626</th>\n",
- " <td>BioMed Central Ltd</td>\n",
- " <td>Veterinary Research</td>\n",
- " <td>Understanding foot-and-mouth disease virus tra...</td>\n",
- " <td>£9.93</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3791421</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Virology</td>\n",
- " <td>An essential fifth coding ORF in the sobemovir...</td>\n",
- " <td>£1435.05</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23562481</th>\n",
- " <td>The Boulevard</td>\n",
- " <td>Virology</td>\n",
- " <td>Metagenomic study of the viruses of African st...</td>\n",
- " <td>£2421.96</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3190389</th>\n",
- " <td>BioMed Central</td>\n",
- " <td>Virology Journal</td>\n",
- " <td>Label-free quantitative proteomics reveals reg...</td>\n",
- " <td>£1242.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23201205</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Virus Research</td>\n",
- " <td>Prostratin exhibits both replication enhancing...</td>\n",
- " <td>£1947.09</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23200744 PMC3552157</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vision Research</td>\n",
- " <td>Perceptual learning of second order cues for l...</td>\n",
- " <td>£999999.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>pub Aug 2013</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vision Research</td>\n",
- " <td>Sensitivity to numerosity is not a unique visu...</td>\n",
- " <td>£1456.18</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3472342\\r\\n\\r\\n</th>\n",
- " <td>Cambridge University Press</td>\n",
- " <td>Visual Neuroscience</td>\n",
- " <td>Masking within and across visual dimensions: P...</td>\n",
- " <td>£2034.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3600532</th>\n",
- " <td>Wiley-Blackwell</td>\n",
- " <td>Zoonoses and Public Health</td>\n",
- " <td>Ecology of zoonotic infectious diseases in bat...</td>\n",
- " <td>£2272.15</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23315936 PMC3638342</th>\n",
- " <td>Wiley</td>\n",
- " <td>genesis: Journal of Genetics</td>\n",
- " <td>The Caenorhabditis elegans homeobox gene ceh-1...</td>\n",
- " <td>£2376.40</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID:23232717 PMC3520108</th>\n",
- " <td>Cadmus Journal Services</td>\n",
- " <td>mBio</td>\n",
- " <td>The Evolutionary Rewiring of Ubiquitination Ta...</td>\n",
- " <td>£1355.13</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>MacMillan</td>\n",
- " <td>NaN</td>\n",
- " <td>Fungal Disease in Britain and the United State...</td>\n",
- " <td>£13200.00</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>2127 rows × 4 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher \\\n",
- "PMID/PMCID \n",
- "NaN American Chemical Society \n",
- ": PMC3805332 American Chemical Society \n",
- "PMCID: PMC3780468 ACS (Amercian Chemical Society) Publications \n",
- "PMCID: PMC3621575 ACS (Amercian Chemical Society) Publications \n",
- "PMID: 24015914 PMC3833349 American Chemical Society \n",
- "PMCID:\\r\\n PMC3656742\\r\\n American Chemical Society \n",
- "PMCID: 3584654 AMERICAN CHEMICAL SOCIETY \n",
- "23373658 American Chemical Society Publications \n",
- "PMC3374517 International Union of Crystallography \n",
- "23340916 Springer-Verlag GMBH & Ci \n",
- "PMCID:\\r\\n PMC3647051\\r\\n Wolters Kluwer N.V./Lippinott \n",
- "3748854 Wolters Kluwer Health \n",
- "PMC3713766 Wolters Kluwer \n",
- "3633780 Springer \n",
- "In Process Taylor & Francis \n",
- "PMCID:\\r\\n PMC3687248\\r\\n Taylor and Francis \n",
- "PMC3819359 Wolters Kluwer \n",
- "PMC3765690 BioMed Central Limited \n",
- "PMC3773237 Wolters Kluwer \n",
- "PMC3815011 Wolters Kluwer \n",
- "NaN Portland Press \n",
- "PMC3378987\\r\\n Elsevier \n",
- "PMCID:\\r\\n PMC3727331\\r\\n International Union of Crystallography \n",
- "PMCID: PMC3565438 International Union of Crystallography \n",
- "PMCID: PMC3606566 International Union of Crystallography (iucr) \n",
- "PMCID: PMC3668577 International Union of Crystallography (iucr) \n",
- "\\r\\n PMC3498934 International Union of Crystallography \n",
- "PMID:22993091 PMC3447403 International Union of Crystallography \n",
- "PMC3087623 International Union of Crystallography \n",
- "PMC3808818 Society for Publication of Acta Dermato-Venere... \n",
- "... ... \n",
- "PMC3627817 Wiley \n",
- "PMC3770928 Wiley \n",
- "NaN Wiley \n",
- "PMC3717178 John Wiley & Sons Ltd \n",
- "PMCID:\\r\\n PMC3759846 Elsevier \n",
- "PMCID:\\r\\n PMC3608034 Elsevier \n",
- "NaN Cambridge University Press \n",
- "PMCID: PMC3599165 Springer \n",
- "PMC3404461 Elsevier \n",
- "PMC3763374 Elsevier \n",
- "PMID: 24035434 Elsevier \n",
- "PMCID: PMC3740234 Elsevier Ltd \n",
- "PMC3763375 Elsevier \n",
- "23117109 Elsevier \n",
- "PMC3757156 Elsevier \n",
- "PMC3611597 Elsevier \n",
- "NaN Elsevier \n",
- "PMC3786614 BMJ Publishing Group \n",
- "PMC3716626 BioMed Central Ltd \n",
- "PMCID: PMC3791421 Elsevier \n",
- "23562481 The Boulevard \n",
- "PMC3190389 BioMed Central \n",
- "23201205 Elsevier \n",
- "23200744 PMC3552157 Elsevier \n",
- "pub Aug 2013 Elsevier \n",
- "PMC3472342\\r\\n\\r\\n Cambridge University Press \n",
- "PMCID: PMC3600532 Wiley-Blackwell \n",
- "23315936 PMC3638342 Wiley \n",
- "PMID:23232717 PMC3520108 Cadmus Journal Services \n",
- "NaN MacMillan \n",
- "\n",
- " Journal title \\\n",
- "PMID/PMCID \n",
- "NaN ACS Chemical Biology \n",
- ": PMC3805332 ACS Chemical Biology \n",
- "PMCID: PMC3780468 ACS Chemical Biology \n",
- "PMCID: PMC3621575 ACS Chemical Biology \n",
- "PMID: 24015914 PMC3833349 ACS Chemical Biology \n",
- "PMCID:\\r\\n PMC3656742\\r\\n ACS Chemical Neuroscience \n",
- "PMCID: 3584654 ACS NANO \n",
- "23373658 ACS Nano \n",
- "PMC3374517 ACTA F \n",
- "23340916 AGE \n",
- "PMCID:\\r\\n PMC3647051\\r\\n AIDS \n",
- "3748854 AIDS \n",
- "PMC3713766 AIDS \n",
- "3633780 AIDS Behav \n",
- "In Process AIDS Care \n",
- "PMCID:\\r\\n PMC3687248\\r\\n AIDS Care \n",
- "PMC3819359 AIDS Journal \n",
- "PMC3765690 AIDS Research and Therapy \n",
- "PMC3773237 AIDS UK \n",
- "PMC3815011 AIDS UK \n",
- "NaN ASN Neuro \n",
- "PMC3378987\\r\\n Academy of Nutrition and Dietetics \n",
- "PMCID:\\r\\n PMC3727331\\r\\n Acta Crystallographica Section D, Biological ... \n",
- "PMCID: PMC3565438 Acta Crystallographica Section D: Biological C... \n",
- "PMCID: PMC3606566 Acta Crystallographica Section F: Structural B... \n",
- "PMCID: PMC3668577 Acta Crystallographica Section F: Structural B... \n",
- "\\r\\n PMC3498934 Acta Crystallographica, Section D \n",
- "PMID:22993091 PMC3447403 Acta Crystallography D \n",
- "PMC3087623 Acta D \n",
- "PMC3808818 Acta Dermato Venereologica \n",
- "... ... \n",
- "PMC3627817 Tropical Medicine and International Health \n",
- "PMC3770928 Tropical Medicine and International Health \n",
- "NaN Tropical Medicine and International Health \n",
- "PMC3717178 Tropical Medicine and International Health \n",
- "PMCID:\\r\\n PMC3759846 Tuberculosis \n",
- "PMCID:\\r\\n PMC3608034 Tuberculosis \n",
- "NaN Urban History \n",
- "PMCID: PMC3599165 Urolithiasis \n",
- "PMC3404461 Vaccine \n",
- "PMC3763374 Vaccine \n",
- "PMID: 24035434 Vaccine \n",
- "PMCID: PMC3740234 Vaccine \n",
- "PMC3763375 Vaccine \n",
- "23117109 Vascular Pharmacology \n",
- "PMC3757156 Veterinary Microbiology \n",
- "PMC3611597 Veterinary Parasitology \n",
- "NaN Veterinary Parasitology \n",
- "PMC3786614 Veterinary Record \n",
- "PMC3716626 Veterinary Research \n",
- "PMCID: PMC3791421 Virology \n",
- "23562481 Virology \n",
- "PMC3190389 Virology Journal \n",
- "23201205 Virus Research \n",
- "23200744 PMC3552157 Vision Research \n",
- "pub Aug 2013 Vision Research \n",
- "PMC3472342\\r\\n\\r\\n Visual Neuroscience \n",
- "PMCID: PMC3600532 Zoonoses and Public Health \n",
- "23315936 PMC3638342 genesis: Journal of Genetics \n",
- "PMID:23232717 PMC3520108 mBio \n",
- "NaN NaN \n",
- "\n",
- " Article title \\\n",
- "PMID/PMCID \n",
- "NaN Discovery of ?2 Adrenergic Receptor Ligands Us... \n",
- ": PMC3805332 Synthesis of alpha-glucan in mycobacteria invo... \n",
- "PMCID: PMC3780468 A Novel Allosteric Inhibitor of the Uridine Di... \n",
- "PMCID: PMC3621575 Chemical proteomic analysis reveals the drugab... \n",
- "PMID: 24015914 PMC3833349 Discovery of an allosteric inhibitor binding s... \n",
- "PMCID:\\r\\n PMC3656742\\r\\n Continuous online microdialysis using microflu... \n",
- "PMCID: 3584654 HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART... \n",
- "23373658 Skin dendritic cell targeting via microneedle ... \n",
- "PMC3374517 Crystallization and preliminary crystallograph... \n",
- "23340916 Voluntary exercise can strengthen the circadia... \n",
- "PMCID:\\r\\n PMC3647051\\r\\n Grassroots Community Organisations' Contributi... \n",
- "3748854 Evaluation of an empiric risk screening score ... \n",
- "PMC3713766 HIV infected adolescents in Southern Africa ca... \n",
- "3633780 Adherence to antiretroviral therapy and clinic... \n",
- "In Process Burden of HIV among primary school children an... \n",
- "PMCID:\\r\\n PMC3687248\\r\\n WORLDBANK Special Issue: Evidence for a contri... \n",
- "PMC3819359 Short title: TB and VL breakthrough and failur... \n",
- "PMC3765690 Collective Patient behaviours derailing ART ro... \n",
- "PMC3773237 Sexual behaviour in a rural high HIV prevalence \n",
- "PMC3815011 HIV incidence and survival from age-specific s... \n",
- "NaN Astrocytes and glutamate homeostasis in Alzhei... \n",
- "PMC3378987\\r\\n Parent support and parent mediated behaviours ... \n",
- "PMCID:\\r\\n PMC3727331\\r\\n Clustering procedures for the optimal selectio... \n",
- "PMCID: PMC3565438 Intensity statistics in the presence of transl... \n",
- "PMCID: PMC3606566 Structure of Pseudomonas aeruginosa inosine 5'... \n",
- "PMCID: PMC3668577 Structure of diaminohydroxyphosphoribosylamino... \n",
- "\\r\\n PMC3498934 Nearest-cell: a fast and easy tool for locatin... \n",
- "PMID:22993091 PMC3447403 Crystallization, dehydration and experimental ... \n",
- "PMC3087623 Structure of HLA-A*0301 in complex with a pept... \n",
- "PMC3808818 The Importance of a Full Clinical Examination:... \n",
- "... ... \n",
- "PMC3627817 Maternal recall of birth weight and birth size... \n",
- "PMC3770928 Epidemiology and control of trachoma: systamat... \n",
- "NaN Meningococcal carriage in the African meningit... \n",
- "PMC3717178 Nutritional supplementation: the additional co... \n",
- "PMCID:\\r\\n PMC3759846 Pathways of IL-1? secretion by macrophages inf... \n",
- "PMCID:\\r\\n PMC3608034 A novel assay of antimycobacterial activity an... \n",
- "NaN Leisure, economy and colonial urbanism: Darjee... \n",
- "PMCID: PMC3599165 Accuracy of urine pH testing in a regional met... \n",
- "PMC3404461 Tailoring subunit vaccine immunogenicity: maxi... \n",
- "PMC3763374 Protection against avian necrotic enteritis af... \n",
- "PMID: 24035434 Cattle immunized against the pathogenic l-?-gl... \n",
- "PMCID: PMC3740234 Increased IgG but normal IgA anti-pneumococcal... \n",
- "PMC3763375 Human papillomavirus (HPV) vaccine implementat... \n",
- "23117109 Signal transduction and modulating pathways in... \n",
- "PMC3757156 Isolation of canine Anaplasma phagocytophilum ... \n",
- "PMC3611597 Toxocara canis: molecular basis of immune reco... \n",
- "NaN Persistence of the efficacy of copper oxide wi... \n",
- "PMC3786614 Proactive dairy cattle disease control in the ... \n",
- "PMC3716626 Understanding foot-and-mouth disease virus tra... \n",
- "PMCID: PMC3791421 An essential fifth coding ORF in the sobemovir... \n",
- "23562481 Metagenomic study of the viruses of African st... \n",
- "PMC3190389 Label-free quantitative proteomics reveals reg... \n",
- "23201205 Prostratin exhibits both replication enhancing... \n",
- "23200744 PMC3552157 Perceptual learning of second order cues for l... \n",
- "pub Aug 2013 Sensitivity to numerosity is not a unique visu... \n",
- "PMC3472342\\r\\n\\r\\n Masking within and across visual dimensions: P... \n",
- "PMCID: PMC3600532 Ecology of zoonotic infectious diseases in bat... \n",
- "23315936 PMC3638342 The Caenorhabditis elegans homeobox gene ceh-1... \n",
- "PMID:23232717 PMC3520108 The Evolutionary Rewiring of Ubiquitination Ta... \n",
- "NaN Fungal Disease in Britain and the United State... \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "PMID/PMCID \n",
- "NaN £947.07 \n",
- ": PMC3805332 £2286.73 \n",
- "PMCID: PMC3780468 £1294.59 \n",
- "PMCID: PMC3621575 £1294.78 \n",
- "PMID: 24015914 PMC3833349 £1267.76 \n",
- "PMCID:\\r\\n PMC3656742\\r\\n £1186.80 \n",
- "PMCID: 3584654 £642.89 \n",
- "23373658 £693.39 \n",
- "PMC3374517 £754.90 \n",
- "23340916 £2002.00 \n",
- "PMCID:\\r\\n PMC3647051\\r\\n £2374.52 \n",
- "3748854 £1834.77 \n",
- "PMC3713766 £1968.63 \n",
- "3633780 £1834.77 \n",
- "In Process £2145.60 \n",
- "PMCID:\\r\\n PMC3687248\\r\\n £2232.74 \n",
- "PMC3819359 £2015.72 \n",
- "PMC3765690 £1240.00 \n",
- "PMC3773237 £1836.92 \n",
- "PMC3815011 £1836.92 \n",
- "NaN £1453.42 \n",
- "PMC3378987\\r\\n £2379.54 \n",
- "PMCID:\\r\\n PMC3727331\\r\\n £771.42 \n",
- "PMCID: PMC3565438 £773.74 \n",
- "PMCID: PMC3606566 £807.67 \n",
- "PMCID: PMC3668577 £785.60 \n",
- "\\r\\n PMC3498934 £757.18 \n",
- "PMID:22993091 PMC3447403 £774.19 \n",
- "PMC3087623 £750.16 \n",
- "PMC3808818 £653.96 \n",
- "... ... \n",
- "PMC3627817 £1896.93 \n",
- "PMC3770928 £1974.72 \n",
- "NaN £1949.32 \n",
- "PMC3717178 £1530.77 \n",
- "PMCID:\\r\\n PMC3759846 £1999.94 \n",
- "PMCID:\\r\\n PMC3608034 £2322.57 \n",
- "NaN £2034.00 \n",
- "PMCID: PMC3599165 £1112.40 \n",
- "PMC3404461 £2328.84 \n",
- "PMC3763374 £1477.73 \n",
- "PMID: 24035434 £1448.38 \n",
- "PMCID: PMC3740234 £1428.68 \n",
- "PMC3763375 £1433.34 \n",
- "23117109 £2352.53 \n",
- "PMC3757156 £2451.49 \n",
- "PMC3611597 £2488.17 \n",
- "NaN £999999.00 \n",
- "PMC3786614 £2040.00 \n",
- "PMC3716626 £9.93 \n",
- "PMCID: PMC3791421 £1435.05 \n",
- "23562481 £2421.96 \n",
- "PMC3190389 £1242.00 \n",
- "23201205 £1947.09 \n",
- "23200744 PMC3552157 £999999.00 \n",
- "pub Aug 2013 £1456.18 \n",
- "PMC3472342\\r\\n\\r\\n £2034.00 \n",
- "PMCID: PMC3600532 £2272.15 \n",
- "23315936 PMC3638342 £2376.40 \n",
- "PMID:23232717 PMC3520108 £1355.13 \n",
- "NaN £13200.00 \n",
- "\n",
- "[2127 rows x 4 columns]"
- ]
- },
- "execution_count": 51,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.sort_values(by=['Journal title'])"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 46,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "Publisher 2127\n",
- "Journal title 2126\n",
- "Article title 2127\n",
- "COST (£) charged to Wellcome (inc VAT when charged) 2127\n",
- "dtype: int64"
- ]
- },
- "execution_count": 46,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.sort_values(by=['Journal title']).count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 48,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "PMID/PMCID\n",
- "NaN psychological medicine\n",
- "PMC3679557 biomacromolecules\n",
- "23043264 PMC3506128 j med chem\n",
- "23438330 PMC3646402 j med chem\n",
- "23438216 PMC3601604 j org chem\n",
- "PMC3579457 journal of medicinal chemistry\n",
- "PMC3709265 journal of proteome research\n",
- "23057412 PMC3495574 mol pharm\n",
- "PMCID: PMC3780468 acs chemical biology\n",
- "PMCID: PMC3621575 acs chemical biology\n",
- "PMCID: PMC3739413 journal of chemical information and modeling\n",
- "PMCID: PMC3530961 journal of medicinal chemistry\n",
- "PMCID: PMC3624797 journal of medicinal chemistry\n",
- " PMC3413243 biochemistry\n",
- "PMC3694353 journal of medicinal chemistry\n",
- "PMC3572711 gastroenterology\n",
- "22610094 journal of biological chemistry\n",
- "PMCID: PMC3586974 journal of immunology\n",
- "23455506 PMCID: PMC3607399 journal of immunology\n",
- "PMID: 24015914 PMC3833349 acs chemical biology\n",
- ": PMC3805332 acs chemical biology\n",
- "NaN acs chemical biology\n",
- "PMCID:\\r\\n PMC3656742\\r\\n acs chemical neuroscience\n",
- "PMCID: 3584654 acs nano\n",
- "22971149 PMC3466778 american chemical society\n",
- "23072351 analytical chemistry\n",
- "PMC3477822 analytical chemistry\n",
- "PMC3530960 analytical chemistry\n",
- "23458425 PMC3630740 bioconjugate chemistry\n",
- "PMID: 20146481 journal of medicinal chemistry\n",
- " ... \n",
- "3575693 molecular microbiology\n",
- "PMID: 22188548 PMC3492912 obesity reviews\n",
- "PMID: 22764734 PMC3798095 obesity reviews\n",
- "PMID: 23703895 statistics in medicine\n",
- "PMCID: PMC3664106 stem cells\n",
- "PMID: 23649934 synapse\n",
- "PMC2955965 the european journal of neuroscience\n",
- "PMID: 19948006 PMC3551259 traffic\n",
- "PMID: 23305527 traffic\n",
- "PMCID: PMC3600532 zoonoses and public health\n",
- "PMC3440570 american journal of transplantation\n",
- "23670821 PMC3738939 angew chems int ed\n",
- "23640856 chembiochem\n",
- "PMID: 23918316 chemmedchem\n",
- "PMCID: PMC3728731 chemmedchem\n",
- "23495205685.88 PMC3743159 chemmedchem\n",
- "PMID:22997008 PMC3569869 protemics\n",
- "3708104 journal of small animal practice\n",
- "PMC3713766 aids\n",
- "PMC3819359 aids journal\n",
- "PMC3773237 aids uk\n",
- "PMC3815011 aids uk\n",
- "PMC3805356 jaids journal of acquired immune deficiency sy...\n",
- "Epub journal of acquired immune deficiency syndroms...\n",
- "PMC3707567 journal of aids\n",
- "2901593 circulation research\n",
- "3748854 aids\n",
- "3785148 pediatr infect dis j\n",
- "PMCID:\\r\\n PMC3647051\\r\\n aids\n",
- "PMID: 23846567 (Epub July 2013) journal of acquired immune deficiency syndromes\n",
- "Name: Journal title, Length: 2127, dtype: object \n",
- "\n"
- ]
- }
- ],
- "source": [
- "print(df['Journal title'].str.lower(), '\\n')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 55,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Journal title</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID/PMCID</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Discovery of ?2 Adrenergic Receptor Ligands Us...</td>\n",
- " <td>£947.07</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>: PMC3805332</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Synthesis of alpha-glucan in mycobacteria invo...</td>\n",
- " <td>£2286.73</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3780468</th>\n",
- " <td>ACS (Amercian Chemical Society) Publications</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>A Novel Allosteric Inhibitor of the Uridine Di...</td>\n",
- " <td>£1294.59</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3621575</th>\n",
- " <td>ACS (Amercian Chemical Society) Publications</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Chemical proteomic analysis reveals the drugab...</td>\n",
- " <td>£1294.78</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID: 24015914 PMC3833349</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Biology</td>\n",
- " <td>Discovery of an allosteric inhibitor binding s...</td>\n",
- " <td>£1267.76</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3656742\\r\\n</th>\n",
- " <td>American Chemical Society</td>\n",
- " <td>ACS Chemical Neuroscience</td>\n",
- " <td>Continuous online microdialysis using microflu...</td>\n",
- " <td>£1186.80</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: 3584654</th>\n",
- " <td>AMERICAN CHEMICAL SOCIETY</td>\n",
- " <td>ACS NANO</td>\n",
- " <td>HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART...</td>\n",
- " <td>£642.89</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23373658</th>\n",
- " <td>American Chemical Society Publications</td>\n",
- " <td>ACS Nano</td>\n",
- " <td>Skin dendritic cell targeting via microneedle ...</td>\n",
- " <td>£693.39</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3374517</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>ACTA F</td>\n",
- " <td>Crystallization and preliminary crystallograph...</td>\n",
- " <td>£754.90</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23340916</th>\n",
- " <td>Springer-Verlag GMBH & Ci</td>\n",
- " <td>AGE</td>\n",
- " <td>Voluntary exercise can strengthen the circadia...</td>\n",
- " <td>£2002.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3647051\\r\\n</th>\n",
- " <td>Wolters Kluwer N.V./Lippinott</td>\n",
- " <td>AIDS</td>\n",
- " <td>Grassroots Community Organisations' Contributi...</td>\n",
- " <td>£2374.52</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3748854</th>\n",
- " <td>Wolters Kluwer Health</td>\n",
- " <td>AIDS</td>\n",
- " <td>Evaluation of an empiric risk screening score ...</td>\n",
- " <td>£1834.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3713766</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS</td>\n",
- " <td>HIV infected adolescents in Southern Africa ca...</td>\n",
- " <td>£1968.63</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3633780</th>\n",
- " <td>Springer</td>\n",
- " <td>AIDS Behav</td>\n",
- " <td>Adherence to antiretroviral therapy and clinic...</td>\n",
- " <td>£1834.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>In Process</th>\n",
- " <td>Taylor & Francis</td>\n",
- " <td>AIDS Care</td>\n",
- " <td>Burden of HIV among primary school children an...</td>\n",
- " <td>£2145.60</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3687248\\r\\n</th>\n",
- " <td>Taylor and Francis</td>\n",
- " <td>AIDS Care</td>\n",
- " <td>WORLDBANK Special Issue: Evidence for a contri...</td>\n",
- " <td>£2232.74</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3819359</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS Journal</td>\n",
- " <td>Short title: TB and VL breakthrough and failur...</td>\n",
- " <td>£2015.72</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3765690</th>\n",
- " <td>BioMed Central Limited</td>\n",
- " <td>AIDS Research and Therapy</td>\n",
- " <td>Collective Patient behaviours derailing ART ro...</td>\n",
- " <td>£1240.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3773237</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS UK</td>\n",
- " <td>Sexual behaviour in a rural high HIV prevalence</td>\n",
- " <td>£1836.92</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3815011</th>\n",
- " <td>Wolters Kluwer</td>\n",
- " <td>AIDS UK</td>\n",
- " <td>HIV incidence and survival from age-specific s...</td>\n",
- " <td>£1836.92</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Portland Press</td>\n",
- " <td>ASN Neuro</td>\n",
- " <td>Astrocytes and glutamate homeostasis in Alzhei...</td>\n",
- " <td>£1453.42</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3378987\\r\\n</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Academy of Nutrition and Dietetics</td>\n",
- " <td>Parent support and parent mediated behaviours ...</td>\n",
- " <td>£2379.54</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3727331\\r\\n</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica Section D, Biological ...</td>\n",
- " <td>Clustering procedures for the optimal selectio...</td>\n",
- " <td>£771.42</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3565438</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica Section D: Biological C...</td>\n",
- " <td>Intensity statistics in the presence of transl...</td>\n",
- " <td>£773.74</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3606566</th>\n",
- " <td>International Union of Crystallography (iucr)</td>\n",
- " <td>Acta Crystallographica Section F: Structural B...</td>\n",
- " <td>Structure of Pseudomonas aeruginosa inosine 5'...</td>\n",
- " <td>£807.67</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3668577</th>\n",
- " <td>International Union of Crystallography (iucr)</td>\n",
- " <td>Acta Crystallographica Section F: Structural B...</td>\n",
- " <td>Structure of diaminohydroxyphosphoribosylamino...</td>\n",
- " <td>£785.60</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>\\r\\n PMC3498934</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallographica, Section D</td>\n",
- " <td>Nearest-cell: a fast and easy tool for locatin...</td>\n",
- " <td>£757.18</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID:22993091 PMC3447403</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta Crystallography D</td>\n",
- " <td>Crystallization, dehydration and experimental ...</td>\n",
- " <td>£774.19</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3087623</th>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>Acta D</td>\n",
- " <td>Structure of HLA-A*0301 in complex with a pept...</td>\n",
- " <td>£750.16</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3808818</th>\n",
- " <td>Society for Publication of Acta Dermato-Venere...</td>\n",
- " <td>Acta Dermato Venereologica</td>\n",
- " <td>The Importance of a Full Clinical Examination:...</td>\n",
- " <td>£653.96</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3627817</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Maternal recall of birth weight and birth size...</td>\n",
- " <td>£1896.93</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3770928</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Epidemiology and control of trachoma: systamat...</td>\n",
- " <td>£1974.72</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Wiley</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Meningococcal carriage in the African meningit...</td>\n",
- " <td>£1949.32</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3717178</th>\n",
- " <td>John Wiley & Sons Ltd</td>\n",
- " <td>Tropical Medicine and International Health</td>\n",
- " <td>Nutritional supplementation: the additional co...</td>\n",
- " <td>£1530.77</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3759846</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Tuberculosis</td>\n",
- " <td>Pathways of IL-1? secretion by macrophages inf...</td>\n",
- " <td>£1999.94</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID:\\r\\n PMC3608034</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Tuberculosis</td>\n",
- " <td>A novel assay of antimycobacterial activity an...</td>\n",
- " <td>£2322.57</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Cambridge University Press</td>\n",
- " <td>Urban History</td>\n",
- " <td>Leisure, economy and colonial urbanism: Darjee...</td>\n",
- " <td>£2034.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3599165</th>\n",
- " <td>Springer</td>\n",
- " <td>Urolithiasis</td>\n",
- " <td>Accuracy of urine pH testing in a regional met...</td>\n",
- " <td>£1112.40</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3404461</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Tailoring subunit vaccine immunogenicity: maxi...</td>\n",
- " <td>£2328.84</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3763374</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Protection against avian necrotic enteritis af...</td>\n",
- " <td>£1477.73</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID: 24035434</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Cattle immunized against the pathogenic l-?-gl...</td>\n",
- " <td>£1448.38</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3740234</th>\n",
- " <td>Elsevier Ltd</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Increased IgG but normal IgA anti-pneumococcal...</td>\n",
- " <td>£1428.68</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3763375</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vaccine</td>\n",
- " <td>Human papillomavirus (HPV) vaccine implementat...</td>\n",
- " <td>£1433.34</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23117109</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vascular Pharmacology</td>\n",
- " <td>Signal transduction and modulating pathways in...</td>\n",
- " <td>£2352.53</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3757156</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Microbiology</td>\n",
- " <td>Isolation of canine Anaplasma phagocytophilum ...</td>\n",
- " <td>£2451.49</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3611597</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Parasitology</td>\n",
- " <td>Toxocara canis: molecular basis of immune reco...</td>\n",
- " <td>£2488.17</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Veterinary Parasitology</td>\n",
- " <td>Persistence of the efficacy of copper oxide wi...</td>\n",
- " <td>£999999.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3786614</th>\n",
- " <td>BMJ Publishing Group</td>\n",
- " <td>Veterinary Record</td>\n",
- " <td>Proactive dairy cattle disease control in the ...</td>\n",
- " <td>£2040.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3716626</th>\n",
- " <td>BioMed Central Ltd</td>\n",
- " <td>Veterinary Research</td>\n",
- " <td>Understanding foot-and-mouth disease virus tra...</td>\n",
- " <td>£9.93</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3791421</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Virology</td>\n",
- " <td>An essential fifth coding ORF in the sobemovir...</td>\n",
- " <td>£1435.05</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23562481</th>\n",
- " <td>The Boulevard</td>\n",
- " <td>Virology</td>\n",
- " <td>Metagenomic study of the viruses of African st...</td>\n",
- " <td>£2421.96</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3190389</th>\n",
- " <td>BioMed Central</td>\n",
- " <td>Virology Journal</td>\n",
- " <td>Label-free quantitative proteomics reveals reg...</td>\n",
- " <td>£1242.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23201205</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Virus Research</td>\n",
- " <td>Prostratin exhibits both replication enhancing...</td>\n",
- " <td>£1947.09</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23200744 PMC3552157</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vision Research</td>\n",
- " <td>Perceptual learning of second order cues for l...</td>\n",
- " <td>£999999.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>pub Aug 2013</th>\n",
- " <td>Elsevier</td>\n",
- " <td>Vision Research</td>\n",
- " <td>Sensitivity to numerosity is not a unique visu...</td>\n",
- " <td>£1456.18</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMC3472342\\r\\n\\r\\n</th>\n",
- " <td>Cambridge University Press</td>\n",
- " <td>Visual Neuroscience</td>\n",
- " <td>Masking within and across visual dimensions: P...</td>\n",
- " <td>£2034.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMCID: PMC3600532</th>\n",
- " <td>Wiley-Blackwell</td>\n",
- " <td>Zoonoses and Public Health</td>\n",
- " <td>Ecology of zoonotic infectious diseases in bat...</td>\n",
- " <td>£2272.15</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23315936 PMC3638342</th>\n",
- " <td>Wiley</td>\n",
- " <td>genesis: Journal of Genetics</td>\n",
- " <td>The Caenorhabditis elegans homeobox gene ceh-1...</td>\n",
- " <td>£2376.40</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>PMID:23232717 PMC3520108</th>\n",
- " <td>Cadmus Journal Services</td>\n",
- " <td>mBio</td>\n",
- " <td>The Evolutionary Rewiring of Ubiquitination Ta...</td>\n",
- " <td>£1355.13</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>NaN</th>\n",
- " <td>MacMillan</td>\n",
- " <td>NaN</td>\n",
- " <td>Fungal Disease in Britain and the United State...</td>\n",
- " <td>£13200.00</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>2127 rows × 4 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher \\\n",
- "PMID/PMCID \n",
- "NaN American Chemical Society \n",
- ": PMC3805332 American Chemical Society \n",
- "PMCID: PMC3780468 ACS (Amercian Chemical Society) Publications \n",
- "PMCID: PMC3621575 ACS (Amercian Chemical Society) Publications \n",
- "PMID: 24015914 PMC3833349 American Chemical Society \n",
- "PMCID:\\r\\n PMC3656742\\r\\n American Chemical Society \n",
- "PMCID: 3584654 AMERICAN CHEMICAL SOCIETY \n",
- "23373658 American Chemical Society Publications \n",
- "PMC3374517 International Union of Crystallography \n",
- "23340916 Springer-Verlag GMBH & Ci \n",
- "PMCID:\\r\\n PMC3647051\\r\\n Wolters Kluwer N.V./Lippinott \n",
- "3748854 Wolters Kluwer Health \n",
- "PMC3713766 Wolters Kluwer \n",
- "3633780 Springer \n",
- "In Process Taylor & Francis \n",
- "PMCID:\\r\\n PMC3687248\\r\\n Taylor and Francis \n",
- "PMC3819359 Wolters Kluwer \n",
- "PMC3765690 BioMed Central Limited \n",
- "PMC3773237 Wolters Kluwer \n",
- "PMC3815011 Wolters Kluwer \n",
- "NaN Portland Press \n",
- "PMC3378987\\r\\n Elsevier \n",
- "PMCID:\\r\\n PMC3727331\\r\\n International Union of Crystallography \n",
- "PMCID: PMC3565438 International Union of Crystallography \n",
- "PMCID: PMC3606566 International Union of Crystallography (iucr) \n",
- "PMCID: PMC3668577 International Union of Crystallography (iucr) \n",
- "\\r\\n PMC3498934 International Union of Crystallography \n",
- "PMID:22993091 PMC3447403 International Union of Crystallography \n",
- "PMC3087623 International Union of Crystallography \n",
- "PMC3808818 Society for Publication of Acta Dermato-Venere... \n",
- "... ... \n",
- "PMC3627817 Wiley \n",
- "PMC3770928 Wiley \n",
- "NaN Wiley \n",
- "PMC3717178 John Wiley & Sons Ltd \n",
- "PMCID:\\r\\n PMC3759846 Elsevier \n",
- "PMCID:\\r\\n PMC3608034 Elsevier \n",
- "NaN Cambridge University Press \n",
- "PMCID: PMC3599165 Springer \n",
- "PMC3404461 Elsevier \n",
- "PMC3763374 Elsevier \n",
- "PMID: 24035434 Elsevier \n",
- "PMCID: PMC3740234 Elsevier Ltd \n",
- "PMC3763375 Elsevier \n",
- "23117109 Elsevier \n",
- "PMC3757156 Elsevier \n",
- "PMC3611597 Elsevier \n",
- "NaN Elsevier \n",
- "PMC3786614 BMJ Publishing Group \n",
- "PMC3716626 BioMed Central Ltd \n",
- "PMCID: PMC3791421 Elsevier \n",
- "23562481 The Boulevard \n",
- "PMC3190389 BioMed Central \n",
- "23201205 Elsevier \n",
- "23200744 PMC3552157 Elsevier \n",
- "pub Aug 2013 Elsevier \n",
- "PMC3472342\\r\\n\\r\\n Cambridge University Press \n",
- "PMCID: PMC3600532 Wiley-Blackwell \n",
- "23315936 PMC3638342 Wiley \n",
- "PMID:23232717 PMC3520108 Cadmus Journal Services \n",
- "NaN MacMillan \n",
- "\n",
- " Journal title \\\n",
- "PMID/PMCID \n",
- "NaN ACS Chemical Biology \n",
- ": PMC3805332 ACS Chemical Biology \n",
- "PMCID: PMC3780468 ACS Chemical Biology \n",
- "PMCID: PMC3621575 ACS Chemical Biology \n",
- "PMID: 24015914 PMC3833349 ACS Chemical Biology \n",
- "PMCID:\\r\\n PMC3656742\\r\\n ACS Chemical Neuroscience \n",
- "PMCID: 3584654 ACS NANO \n",
- "23373658 ACS Nano \n",
- "PMC3374517 ACTA F \n",
- "23340916 AGE \n",
- "PMCID:\\r\\n PMC3647051\\r\\n AIDS \n",
- "3748854 AIDS \n",
- "PMC3713766 AIDS \n",
- "3633780 AIDS Behav \n",
- "In Process AIDS Care \n",
- "PMCID:\\r\\n PMC3687248\\r\\n AIDS Care \n",
- "PMC3819359 AIDS Journal \n",
- "PMC3765690 AIDS Research and Therapy \n",
- "PMC3773237 AIDS UK \n",
- "PMC3815011 AIDS UK \n",
- "NaN ASN Neuro \n",
- "PMC3378987\\r\\n Academy of Nutrition and Dietetics \n",
- "PMCID:\\r\\n PMC3727331\\r\\n Acta Crystallographica Section D, Biological ... \n",
- "PMCID: PMC3565438 Acta Crystallographica Section D: Biological C... \n",
- "PMCID: PMC3606566 Acta Crystallographica Section F: Structural B... \n",
- "PMCID: PMC3668577 Acta Crystallographica Section F: Structural B... \n",
- "\\r\\n PMC3498934 Acta Crystallographica, Section D \n",
- "PMID:22993091 PMC3447403 Acta Crystallography D \n",
- "PMC3087623 Acta D \n",
- "PMC3808818 Acta Dermato Venereologica \n",
- "... ... \n",
- "PMC3627817 Tropical Medicine and International Health \n",
- "PMC3770928 Tropical Medicine and International Health \n",
- "NaN Tropical Medicine and International Health \n",
- "PMC3717178 Tropical Medicine and International Health \n",
- "PMCID:\\r\\n PMC3759846 Tuberculosis \n",
- "PMCID:\\r\\n PMC3608034 Tuberculosis \n",
- "NaN Urban History \n",
- "PMCID: PMC3599165 Urolithiasis \n",
- "PMC3404461 Vaccine \n",
- "PMC3763374 Vaccine \n",
- "PMID: 24035434 Vaccine \n",
- "PMCID: PMC3740234 Vaccine \n",
- "PMC3763375 Vaccine \n",
- "23117109 Vascular Pharmacology \n",
- "PMC3757156 Veterinary Microbiology \n",
- "PMC3611597 Veterinary Parasitology \n",
- "NaN Veterinary Parasitology \n",
- "PMC3786614 Veterinary Record \n",
- "PMC3716626 Veterinary Research \n",
- "PMCID: PMC3791421 Virology \n",
- "23562481 Virology \n",
- "PMC3190389 Virology Journal \n",
- "23201205 Virus Research \n",
- "23200744 PMC3552157 Vision Research \n",
- "pub Aug 2013 Vision Research \n",
- "PMC3472342\\r\\n\\r\\n Visual Neuroscience \n",
- "PMCID: PMC3600532 Zoonoses and Public Health \n",
- "23315936 PMC3638342 genesis: Journal of Genetics \n",
- "PMID:23232717 PMC3520108 mBio \n",
- "NaN NaN \n",
- "\n",
- " Article title \\\n",
- "PMID/PMCID \n",
- "NaN Discovery of ?2 Adrenergic Receptor Ligands Us... \n",
- ": PMC3805332 Synthesis of alpha-glucan in mycobacteria invo... \n",
- "PMCID: PMC3780468 A Novel Allosteric Inhibitor of the Uridine Di... \n",
- "PMCID: PMC3621575 Chemical proteomic analysis reveals the drugab... \n",
- "PMID: 24015914 PMC3833349 Discovery of an allosteric inhibitor binding s... \n",
- "PMCID:\\r\\n PMC3656742\\r\\n Continuous online microdialysis using microflu... \n",
- "PMCID: 3584654 HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART... \n",
- "23373658 Skin dendritic cell targeting via microneedle ... \n",
- "PMC3374517 Crystallization and preliminary crystallograph... \n",
- "23340916 Voluntary exercise can strengthen the circadia... \n",
- "PMCID:\\r\\n PMC3647051\\r\\n Grassroots Community Organisations' Contributi... \n",
- "3748854 Evaluation of an empiric risk screening score ... \n",
- "PMC3713766 HIV infected adolescents in Southern Africa ca... \n",
- "3633780 Adherence to antiretroviral therapy and clinic... \n",
- "In Process Burden of HIV among primary school children an... \n",
- "PMCID:\\r\\n PMC3687248\\r\\n WORLDBANK Special Issue: Evidence for a contri... \n",
- "PMC3819359 Short title: TB and VL breakthrough and failur... \n",
- "PMC3765690 Collective Patient behaviours derailing ART ro... \n",
- "PMC3773237 Sexual behaviour in a rural high HIV prevalence \n",
- "PMC3815011 HIV incidence and survival from age-specific s... \n",
- "NaN Astrocytes and glutamate homeostasis in Alzhei... \n",
- "PMC3378987\\r\\n Parent support and parent mediated behaviours ... \n",
- "PMCID:\\r\\n PMC3727331\\r\\n Clustering procedures for the optimal selectio... \n",
- "PMCID: PMC3565438 Intensity statistics in the presence of transl... \n",
- "PMCID: PMC3606566 Structure of Pseudomonas aeruginosa inosine 5'... \n",
- "PMCID: PMC3668577 Structure of diaminohydroxyphosphoribosylamino... \n",
- "\\r\\n PMC3498934 Nearest-cell: a fast and easy tool for locatin... \n",
- "PMID:22993091 PMC3447403 Crystallization, dehydration and experimental ... \n",
- "PMC3087623 Structure of HLA-A*0301 in complex with a pept... \n",
- "PMC3808818 The Importance of a Full Clinical Examination:... \n",
- "... ... \n",
- "PMC3627817 Maternal recall of birth weight and birth size... \n",
- "PMC3770928 Epidemiology and control of trachoma: systamat... \n",
- "NaN Meningococcal carriage in the African meningit... \n",
- "PMC3717178 Nutritional supplementation: the additional co... \n",
- "PMCID:\\r\\n PMC3759846 Pathways of IL-1? secretion by macrophages inf... \n",
- "PMCID:\\r\\n PMC3608034 A novel assay of antimycobacterial activity an... \n",
- "NaN Leisure, economy and colonial urbanism: Darjee... \n",
- "PMCID: PMC3599165 Accuracy of urine pH testing in a regional met... \n",
- "PMC3404461 Tailoring subunit vaccine immunogenicity: maxi... \n",
- "PMC3763374 Protection against avian necrotic enteritis af... \n",
- "PMID: 24035434 Cattle immunized against the pathogenic l-?-gl... \n",
- "PMCID: PMC3740234 Increased IgG but normal IgA anti-pneumococcal... \n",
- "PMC3763375 Human papillomavirus (HPV) vaccine implementat... \n",
- "23117109 Signal transduction and modulating pathways in... \n",
- "PMC3757156 Isolation of canine Anaplasma phagocytophilum ... \n",
- "PMC3611597 Toxocara canis: molecular basis of immune reco... \n",
- "NaN Persistence of the efficacy of copper oxide wi... \n",
- "PMC3786614 Proactive dairy cattle disease control in the ... \n",
- "PMC3716626 Understanding foot-and-mouth disease virus tra... \n",
- "PMCID: PMC3791421 An essential fifth coding ORF in the sobemovir... \n",
- "23562481 Metagenomic study of the viruses of African st... \n",
- "PMC3190389 Label-free quantitative proteomics reveals reg... \n",
- "23201205 Prostratin exhibits both replication enhancing... \n",
- "23200744 PMC3552157 Perceptual learning of second order cues for l... \n",
- "pub Aug 2013 Sensitivity to numerosity is not a unique visu... \n",
- "PMC3472342\\r\\n\\r\\n Masking within and across visual dimensions: P... \n",
- "PMCID: PMC3600532 Ecology of zoonotic infectious diseases in bat... \n",
- "23315936 PMC3638342 The Caenorhabditis elegans homeobox gene ceh-1... \n",
- "PMID:23232717 PMC3520108 The Evolutionary Rewiring of Ubiquitination Ta... \n",
- "NaN Fungal Disease in Britain and the United State... \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "PMID/PMCID \n",
- "NaN £947.07 \n",
- ": PMC3805332 £2286.73 \n",
- "PMCID: PMC3780468 £1294.59 \n",
- "PMCID: PMC3621575 £1294.78 \n",
- "PMID: 24015914 PMC3833349 £1267.76 \n",
- "PMCID:\\r\\n PMC3656742\\r\\n £1186.80 \n",
- "PMCID: 3584654 £642.89 \n",
- "23373658 £693.39 \n",
- "PMC3374517 £754.90 \n",
- "23340916 £2002.00 \n",
- "PMCID:\\r\\n PMC3647051\\r\\n £2374.52 \n",
- "3748854 £1834.77 \n",
- "PMC3713766 £1968.63 \n",
- "3633780 £1834.77 \n",
- "In Process £2145.60 \n",
- "PMCID:\\r\\n PMC3687248\\r\\n £2232.74 \n",
- "PMC3819359 £2015.72 \n",
- "PMC3765690 £1240.00 \n",
- "PMC3773237 £1836.92 \n",
- "PMC3815011 £1836.92 \n",
- "NaN £1453.42 \n",
- "PMC3378987\\r\\n £2379.54 \n",
- "PMCID:\\r\\n PMC3727331\\r\\n £771.42 \n",
- "PMCID: PMC3565438 £773.74 \n",
- "PMCID: PMC3606566 £807.67 \n",
- "PMCID: PMC3668577 £785.60 \n",
- "\\r\\n PMC3498934 £757.18 \n",
- "PMID:22993091 PMC3447403 £774.19 \n",
- "PMC3087623 £750.16 \n",
- "PMC3808818 £653.96 \n",
- "... ... \n",
- "PMC3627817 £1896.93 \n",
- "PMC3770928 £1974.72 \n",
- "NaN £1949.32 \n",
- "PMC3717178 £1530.77 \n",
- "PMCID:\\r\\n PMC3759846 £1999.94 \n",
- "PMCID:\\r\\n PMC3608034 £2322.57 \n",
- "NaN £2034.00 \n",
- "PMCID: PMC3599165 £1112.40 \n",
- "PMC3404461 £2328.84 \n",
- "PMC3763374 £1477.73 \n",
- "PMID: 24035434 £1448.38 \n",
- "PMCID: PMC3740234 £1428.68 \n",
- "PMC3763375 £1433.34 \n",
- "23117109 £2352.53 \n",
- "PMC3757156 £2451.49 \n",
- "PMC3611597 £2488.17 \n",
- "NaN £999999.00 \n",
- "PMC3786614 £2040.00 \n",
- "PMC3716626 £9.93 \n",
- "PMCID: PMC3791421 £1435.05 \n",
- "23562481 £2421.96 \n",
- "PMC3190389 £1242.00 \n",
- "23201205 £1947.09 \n",
- "23200744 PMC3552157 £999999.00 \n",
- "pub Aug 2013 £1456.18 \n",
- "PMC3472342\\r\\n\\r\\n £2034.00 \n",
- "PMCID: PMC3600532 £2272.15 \n",
- "23315936 PMC3638342 £2376.40 \n",
- "PMID:23232717 PMC3520108 £1355.13 \n",
- "NaN £13200.00 \n",
- "\n",
- "[2127 rows x 4 columns]"
- ]
- },
- "execution_count": 55,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.sort_values(by=['Journal title'])"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 70,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "2126 \n",
- "\n"
- ]
- }
- ],
- "source": [
- "print(df['Journal title'].str.lower().count, '\\n')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 79,
- "metadata": {},
- "outputs": [],
- "source": [
- "titles = df['Journal title'].groupby(df['Journal title']).value_counts()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 82,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "Journal title Journal title \n",
- "ACS Chemical Biology ACS Chemical Biology 5\n",
- "ACS Chemical Neuroscience ACS Chemical Neuroscience 1\n",
- "ACS NANO ACS NANO 1\n",
- "ACS Nano ACS Nano 1\n",
- "ACTA F ACTA F 1\n",
- "AGE AGE 1\n",
- "AIDS AIDS 3\n",
- "AIDS Behav AIDS Behav 1\n",
- "AIDS Care AIDS Care 2\n",
- "AIDS Journal AIDS Journal 1\n",
- "AIDS Research and Therapy AIDS Research and Therapy 1\n",
- "AIDS UK AIDS UK 2\n",
- "ASN Neuro ASN Neuro 1\n",
- "Academy of Nutrition and Dietetics Academy of Nutrition and Dietetics 1\n",
- "Acta Crystallographica Section D, Biological Crystallography Acta Crystallographica Section D, Biological Crystallography 1\n",
- "Acta Crystallographica Section D: Biological Crystallography Acta Crystallographica Section D: Biological Crystallography 1\n",
- "Acta Crystallographica Section F: Structural Biology and Crystallization Communications Acta Crystallographica Section F: Structural Biology and Crystallization Communications 2\n",
- "Acta Crystallographica, Section D Acta Crystallographica, Section D 1\n",
- "Acta Crystallography D Acta Crystallography D 1\n",
- "Acta D Acta D 1\n",
- "Acta Dermato Venereologica Acta Dermato Venereologica 1\n",
- "Acta Diabetologica Acta Diabetologica 1\n",
- "Acta Neuropathol Acta Neuropathol 1\n",
- "Acta Neuropathologica Acta Neuropathologica 3\n",
- "Acta Opthalmologica Acta Opthalmologica 1\n",
- "Acta Physiol Acta Physiol 1\n",
- "Addiction Addiction 2\n",
- "Advances in Experimental Medicine and Biology Advances in Experimental Medicine and Biology 4\n",
- "Age Age 1\n",
- "Age and Ageing Age and Ageing 1\n",
- " ..\n",
- "Translational Psychiatry Translational Psychiatry 2\n",
- "Trends in Cognitive Science Trends in Cognitive Science 1\n",
- "Trends in Genetics Trends in Genetics 2\n",
- "Trends in Microbiology Trends in Microbiology 1\n",
- "Trends in Molecular Medicine Trends in Molecular Medicine 1\n",
- "Trends in Neuroscience Trends in Neuroscience 1\n",
- "Trends in Neurosciences Trends in Neurosciences 2\n",
- "Trends in Parasitology Trends in Parasitology 4\n",
- "Trials Trials 4\n",
- "Trials Trials 1\n",
- "Trop Med Int Health Trop Med Int Health 1\n",
- "Tropical Animal Health & Production Tropical Animal Health & Production 1\n",
- "Tropical Medicine and International Health Tropical Medicine and International Health 6\n",
- "Tuberculosis Tuberculosis 2\n",
- "Urban History Urban History 1\n",
- "Urolithiasis Urolithiasis 1\n",
- "Vaccine Vaccine 5\n",
- "Vascular Pharmacology Vascular Pharmacology 1\n",
- "Veterinary Microbiology Veterinary Microbiology 1\n",
- "Veterinary Parasitology Veterinary Parasitology 2\n",
- "Veterinary Record Veterinary Record 1\n",
- "Veterinary Research Veterinary Research 1\n",
- "Virology Virology 2\n",
- "Virology Journal Virology Journal 1\n",
- "Virus Research Virus Research 1\n",
- "Vision Research Vision Research 2\n",
- "Visual Neuroscience Visual Neuroscience 1\n",
- "Zoonoses and Public Health Zoonoses and Public Health 1\n",
- "genesis: Journal of Genetics genesis: Journal of Genetics 1\n",
- "mBio mBio 1\n",
- "Name: Journal title, Length: 984, dtype: int64\n"
- ]
- }
- ],
- "source": [
- "print(titles)"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 83,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "Journal title\n",
- "ACS Chemical Biology 1\n",
- "ACS Chemical Neuroscience 1\n",
- "ACS NANO 1\n",
- "ACS Nano 1\n",
- "ACTA F 1\n",
- "AGE 1\n",
- "AIDS 1\n",
- "AIDS Behav 1\n",
- "AIDS Care 1\n",
- "AIDS Journal 1\n",
- "AIDS Research and Therapy 1\n",
- "AIDS UK 1\n",
- "ASN Neuro 1\n",
- "Academy of Nutrition and Dietetics 1\n",
- "Acta Crystallographica Section D, Biological Crystallography 1\n",
- "Acta Crystallographica Section D: Biological Crystallography 1\n",
- "Acta Crystallographica Section F: Structural Biology and Crystallization Communications 1\n",
- "Acta Crystallographica, Section D 1\n",
- "Acta Crystallography D 1\n",
- "Acta D 1\n",
- "Acta Dermato Venereologica 1\n",
- "Acta Diabetologica 1\n",
- "Acta Neuropathol 1\n",
- "Acta Neuropathologica 1\n",
- "Acta Opthalmologica 1\n",
- "Acta Physiol 1\n",
- "Addiction 1\n",
- "Advances in Experimental Medicine and Biology 1\n",
- "Age 1\n",
- "Age and Ageing 1\n",
- " ..\n",
- "Translational Psychiatry 1\n",
- "Trends in Cognitive Science 1\n",
- "Trends in Genetics 1\n",
- "Trends in Microbiology 1\n",
- "Trends in Molecular Medicine 1\n",
- "Trends in Neuroscience 1\n",
- "Trends in Neurosciences 1\n",
- "Trends in Parasitology 1\n",
- "Trials 1\n",
- "Trials 1\n",
- "Trop Med Int Health 1\n",
- "Tropical Animal Health & Production 1\n",
- "Tropical Medicine and International Health 1\n",
- "Tuberculosis 1\n",
- "Urban History 1\n",
- "Urolithiasis 1\n",
- "Vaccine 1\n",
- "Vascular Pharmacology 1\n",
- "Veterinary Microbiology 1\n",
- "Veterinary Parasitology 1\n",
- "Veterinary Record 1\n",
- "Veterinary Research 1\n",
- "Virology 1\n",
- "Virology Journal 1\n",
- "Virus Research 1\n",
- "Vision Research 1\n",
- "Visual Neuroscience 1\n",
- "Zoonoses and Public Health 1\n",
- "genesis: Journal of Genetics 1\n",
- "mBio 1\n",
- "Name: Journal title, Length: 984, dtype: int64"
- ]
- },
- "execution_count": 83,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "titles.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 85,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "<class 'pandas.core.frame.DataFrame'>\n",
- "Index: 2127 entries, nan to PMID: 23846567 (Epub July 2013)\n",
- "Data columns (total 4 columns):\n",
- "Publisher 2127 non-null object\n",
- "Journal title 2126 non-null object\n",
- "Article title 2127 non-null object\n",
- "COST (£) charged to Wellcome (inc VAT when charged) 2127 non-null object\n",
- "dtypes: object(4)\n",
- "memory usage: 163.1+ KB\n"
- ]
- }
- ],
- "source": [
- "df.info()\n",
- "# Shows below that there's one null Journal title"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 86,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Journal title</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>count</th>\n",
- " <td>2127</td>\n",
- " <td>2126</td>\n",
- " <td>2127</td>\n",
- " <td>2127</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>unique</th>\n",
- " <td>299</td>\n",
- " <td>984</td>\n",
- " <td>2126</td>\n",
- " <td>1402</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>top</th>\n",
- " <td>Elsevier</td>\n",
- " <td>PLoS One</td>\n",
- " <td>Exclusive breastfeeding, diarrhoel morbidity a...</td>\n",
- " <td>£2040.00</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>freq</th>\n",
- " <td>387</td>\n",
- " <td>92</td>\n",
- " <td>2</td>\n",
- " <td>94</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Journal title \\\n",
- "count 2127 2126 \n",
- "unique 299 984 \n",
- "top Elsevier PLoS One \n",
- "freq 387 92 \n",
- "\n",
- " Article title \\\n",
- "count 2127 \n",
- "unique 2126 \n",
- "top Exclusive breastfeeding, diarrhoel morbidity a... \n",
- "freq 2 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "count 2127 \n",
- "unique 1402 \n",
- "top £2040.00 \n",
- "freq 94 "
- ]
- },
- "execution_count": 86,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.describe()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 87,
- "metadata": {},
- "outputs": [],
- "source": [
- "df_by_title = df.groupby('Journal title')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 88,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "<pandas.core.groupby.DataFrameGroupBy object at 0x113ab0a58>\n"
- ]
- }
- ],
- "source": [
- "print(df_by_title)"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 89,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead tr th {\n",
- " text-align: left;\n",
- " }\n",
- "\n",
- " .dataframe thead tr:last-of-type th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr>\n",
- " <th></th>\n",
- " <th colspan=\"4\" halign=\"left\">Article title</th>\n",
- " <th colspan=\"4\" halign=\"left\">COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " <th colspan=\"4\" halign=\"left\">Publisher</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th></th>\n",
- " <th>count</th>\n",
- " <th>unique</th>\n",
- " <th>top</th>\n",
- " <th>freq</th>\n",
- " <th>count</th>\n",
- " <th>unique</th>\n",
- " <th>top</th>\n",
- " <th>freq</th>\n",
- " <th>count</th>\n",
- " <th>unique</th>\n",
- " <th>top</th>\n",
- " <th>freq</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Journal title</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>ACS Chemical Biology</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>Chemical proteomic analysis reveals the drugab...</td>\n",
- " <td>1</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>£1267.76</td>\n",
- " <td>1</td>\n",
- " <td>5</td>\n",
- " <td>2</td>\n",
- " <td>American Chemical Society</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Chemical Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>Continuous online microdialysis using microflu...</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>£1186.80</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>American Chemical Society</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS NANO</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART...</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>£642.89</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>AMERICAN CHEMICAL SOCIETY</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Nano</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>Skin dendritic cell targeting via microneedle ...</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>£693.39</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>American Chemical Society Publications</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACTA F</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>Crystallization and preliminary crystallograph...</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>£754.90</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>International Union of Crystallography</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "</div>"
- ],
- "text/plain": [
- " Article title \\\n",
- " count unique \n",
- "Journal title \n",
- "ACS Chemical Biology 5 5 \n",
- "ACS Chemical Neuroscience 1 1 \n",
- "ACS NANO 1 1 \n",
- "ACS Nano 1 1 \n",
- "ACTA F 1 1 \n",
- "\n",
- " \\\n",
- " top \n",
- "Journal title \n",
- "ACS Chemical Biology Chemical proteomic analysis reveals the drugab... \n",
- "ACS Chemical Neuroscience Continuous online microdialysis using microflu... \n",
- "ACS NANO HYDROXY-TERMINATED CONJUGATED POLYMER NANOPART... \n",
- "ACS Nano Skin dendritic cell targeting via microneedle ... \n",
- "ACTA F Crystallization and preliminary crystallograph... \n",
- "\n",
- " \\\n",
- " freq \n",
- "Journal title \n",
- "ACS Chemical Biology 1 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \\\n",
- " count \n",
- "Journal title \n",
- "ACS Chemical Biology 5 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "\n",
- " Publisher \\\n",
- " unique top freq count unique \n",
- "Journal title \n",
- "ACS Chemical Biology 5 £1267.76 1 5 2 \n",
- "ACS Chemical Neuroscience 1 £1186.80 1 1 1 \n",
- "ACS NANO 1 £642.89 1 1 1 \n",
- "ACS Nano 1 £693.39 1 1 1 \n",
- "ACTA F 1 £754.90 1 1 1 \n",
- "\n",
- " \n",
- " top freq \n",
- "Journal title \n",
- "ACS Chemical Biology American Chemical Society 3 \n",
- "ACS Chemical Neuroscience American Chemical Society 1 \n",
- "ACS NANO AMERICAN CHEMICAL SOCIETY 1 \n",
- "ACS Nano American Chemical Society Publications 1 \n",
- "ACTA F International Union of Crystallography 1 "
- ]
- },
- "execution_count": 89,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df_by_title.describe().head()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 91,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "('Ageing & Society',\n",
- " Publisher Journal title \\\n",
- " PMID/PMCID \n",
- " NaN Cambridge University Press Ageing & Society \n",
- " \n",
- " Article title \\\n",
- " PMID/PMCID \n",
- " NaN Who cares? Implications of care-giving and -re... \n",
- " \n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- " PMID/PMCID \n",
- " NaN £1695.00 )"
- ]
- },
- "execution_count": 91,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "list(df_by_title)[30]"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 92,
- "metadata": {},
- "outputs": [],
- "source": [
- "# Step #1- List all of the journal names possible- field is 'Journal title'\n",
- "df_titlecount = df.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 95,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Journal title</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>ACS Chemical Biology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Chemical Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS NANO</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Nano</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACTA F</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AGE</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Behav</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Care</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Research and Therapy</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS UK</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ASN Neuro</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Academy of Nutrition and Dietetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D, Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D: Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section F: Structural Biology and Crystallization Communications</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica, Section D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallography D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Dermato Venereologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Diabetologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Opthalmologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Physiol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Addiction</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Advances in Experimental Medicine and Biology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age and Ageing</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Translational Psychiatry</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Cognitive Science</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Genetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Molecular Medicine</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neurosciences</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Parasitology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trop Med Int Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Animal Health & Production</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Medicine and International Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tuberculosis</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urban History</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urolithiasis</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vaccine</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vascular Pharmacology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Parasitology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Record</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virus Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vision Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Visual Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Zoonoses and Public Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>genesis: Journal of Genetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>mBio</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>984 rows × 3 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Article title \\\n",
- "Journal title \n",
- "ACS Chemical Biology 1 1 \n",
- "ACS Chemical Neuroscience 1 1 \n",
- "ACS NANO 1 1 \n",
- "ACS Nano 1 1 \n",
- "ACTA F 1 1 \n",
- "AGE 1 1 \n",
- "AIDS 1 1 \n",
- "AIDS Behav 1 1 \n",
- "AIDS Care 1 1 \n",
- "AIDS Journal 1 1 \n",
- "AIDS Research and Therapy 1 1 \n",
- "AIDS UK 1 1 \n",
- "ASN Neuro 1 1 \n",
- "Academy of Nutrition and Dietetics 1 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 1 1 \n",
- "Acta Crystallographica, Section D 1 1 \n",
- "Acta Crystallography D 1 1 \n",
- "Acta D 1 1 \n",
- "Acta Dermato Venereologica 1 1 \n",
- "Acta Diabetologica 1 1 \n",
- "Acta Neuropathol 1 1 \n",
- "Acta Neuropathologica 1 1 \n",
- "Acta Opthalmologica 1 1 \n",
- "Acta Physiol 1 1 \n",
- "Addiction 1 1 \n",
- "Advances in Experimental Medicine and Biology 1 1 \n",
- "Age 1 1 \n",
- "Age and Ageing 1 1 \n",
- "... ... ... \n",
- "Translational Psychiatry 1 1 \n",
- "Trends in Cognitive Science 1 1 \n",
- "Trends in Genetics 1 1 \n",
- "Trends in Microbiology 1 1 \n",
- "Trends in Molecular Medicine 1 1 \n",
- "Trends in Neuroscience 1 1 \n",
- "Trends in Neurosciences 1 1 \n",
- "Trends in Parasitology 1 1 \n",
- "Trials 1 1 \n",
- "Trials 1 1 \n",
- "Trop Med Int Health 1 1 \n",
- "Tropical Animal Health & Production 1 1 \n",
- "Tropical Medicine and International Health 1 1 \n",
- "Tuberculosis 1 1 \n",
- "Urban History 1 1 \n",
- "Urolithiasis 1 1 \n",
- "Vaccine 1 1 \n",
- "Vascular Pharmacology 1 1 \n",
- "Veterinary Microbiology 1 1 \n",
- "Veterinary Parasitology 1 1 \n",
- "Veterinary Record 1 1 \n",
- "Veterinary Research 1 1 \n",
- "Virology 1 1 \n",
- "Virology Journal 1 1 \n",
- "Virus Research 1 1 \n",
- "Vision Research 1 1 \n",
- "Visual Neuroscience 1 1 \n",
- "Zoonoses and Public Health 1 1 \n",
- "genesis: Journal of Genetics 1 1 \n",
- "mBio 1 1 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "Journal title \n",
- "ACS Chemical Biology 1 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "AGE 1 \n",
- "AIDS 1 \n",
- "AIDS Behav 1 \n",
- "AIDS Care 1 \n",
- "AIDS Journal 1 \n",
- "AIDS Research and Therapy 1 \n",
- "AIDS UK 1 \n",
- "ASN Neuro 1 \n",
- "Academy of Nutrition and Dietetics 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 1 \n",
- "Acta Crystallographica, Section D 1 \n",
- "Acta Crystallography D 1 \n",
- "Acta D 1 \n",
- "Acta Dermato Venereologica 1 \n",
- "Acta Diabetologica 1 \n",
- "Acta Neuropathol 1 \n",
- "Acta Neuropathologica 1 \n",
- "Acta Opthalmologica 1 \n",
- "Acta Physiol 1 \n",
- "Addiction 1 \n",
- "Advances in Experimental Medicine and Biology 1 \n",
- "Age 1 \n",
- "Age and Ageing 1 \n",
- "... ... \n",
- "Translational Psychiatry 1 \n",
- "Trends in Cognitive Science 1 \n",
- "Trends in Genetics 1 \n",
- "Trends in Microbiology 1 \n",
- "Trends in Molecular Medicine 1 \n",
- "Trends in Neuroscience 1 \n",
- "Trends in Neurosciences 1 \n",
- "Trends in Parasitology 1 \n",
- "Trials 1 \n",
- "Trials 1 \n",
- "Trop Med Int Health 1 \n",
- "Tropical Animal Health & Production 1 \n",
- "Tropical Medicine and International Health 1 \n",
- "Tuberculosis 1 \n",
- "Urban History 1 \n",
- "Urolithiasis 1 \n",
- "Vaccine 1 \n",
- "Vascular Pharmacology 1 \n",
- "Veterinary Microbiology 1 \n",
- "Veterinary Parasitology 1 \n",
- "Veterinary Record 1 \n",
- "Veterinary Research 1 \n",
- "Virology 1 \n",
- "Virology Journal 1 \n",
- "Virus Research 1 \n",
- "Vision Research 1 \n",
- "Visual Neuroscience 1 \n",
- "Zoonoses and Public Health 1 \n",
- "genesis: Journal of Genetics 1 \n",
- "mBio 1 \n",
- "\n",
- "[984 rows x 3 columns]"
- ]
- },
- "execution_count": 95,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df_titlecount.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 9,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "PMID/PMCID\n",
- "NaN psychological medicine\n",
- "PMC3679557 biomacromolecules\n",
- "23043264 PMC3506128 j med chem\n",
- "23438330 PMC3646402 j med chem\n",
- "23438216 PMC3601604 j org chem\n",
- "PMC3579457 journal of medicinal chemistry\n",
- "PMC3709265 journal of proteome research\n",
- "23057412 PMC3495574 mol pharm\n",
- "PMCID: PMC3780468 acs chemical biology\n",
- "PMCID: PMC3621575 acs chemical biology\n",
- "PMCID: PMC3739413 journal of chemical information and modeling\n",
- "PMCID: PMC3530961 journal of medicinal chemistry\n",
- "PMCID: PMC3624797 journal of medicinal chemistry\n",
- " PMC3413243 biochemistry\n",
- "PMC3694353 journal of medicinal chemistry\n",
- "PMC3572711 gastroenterology\n",
- "22610094 journal of biological chemistry\n",
- "PMCID: PMC3586974 journal of immunology\n",
- "23455506 PMCID: PMC3607399 journal of immunology\n",
- "PMID: 24015914 PMC3833349 acs chemical biology\n",
- ": PMC3805332 acs chemical biology\n",
- "NaN acs chemical biology\n",
- "PMCID:\\r\\n PMC3656742\\r\\n acs chemical neuroscience\n",
- "PMCID: 3584654 acs nano\n",
- "22971149 PMC3466778 american chemical society\n",
- "23072351 analytical chemistry\n",
- "PMC3477822 analytical chemistry\n",
- "PMC3530960 analytical chemistry\n",
- "23458425 PMC3630740 bioconjugate chemistry\n",
- "PMID: 20146481 journal of medicinal chemistry\n",
- " ... \n",
- "3575693 molecular microbiology\n",
- "PMID: 22188548 PMC3492912 obesity reviews\n",
- "PMID: 22764734 PMC3798095 obesity reviews\n",
- "PMID: 23703895 statistics in medicine\n",
- "PMCID: PMC3664106 stem cells\n",
- "PMID: 23649934 synapse\n",
- "PMC2955965 the european journal of neuroscience\n",
- "PMID: 19948006 PMC3551259 traffic\n",
- "PMID: 23305527 traffic\n",
- "PMCID: PMC3600532 zoonoses and public health\n",
- "PMC3440570 american journal of transplantation\n",
- "23670821 PMC3738939 angew chems int ed\n",
- "23640856 chembiochem\n",
- "PMID: 23918316 chemmedchem\n",
- "PMCID: PMC3728731 chemmedchem\n",
- "23495205685.88 PMC3743159 chemmedchem\n",
- "PMID:22997008 PMC3569869 protemics\n",
- "3708104 journal of small animal practice\n",
- "PMC3713766 aids\n",
- "PMC3819359 aids journal\n",
- "PMC3773237 aids uk\n",
- "PMC3815011 aids uk\n",
- "PMC3805356 jaids journal of acquired immune deficiency sy...\n",
- "Epub journal of acquired immune deficiency syndroms...\n",
- "PMC3707567 journal of aids\n",
- "2901593 circulation research\n",
- "3748854 aids\n",
- "3785148 pediatr infect dis j\n",
- "PMCID:\\r\\n PMC3647051\\r\\n aids\n",
- "PMID: 23846567 (Epub July 2013) journal of acquired immune deficiency syndromes\n",
- "Name: Journal title, Length: 2127, dtype: object \n",
- "\n"
- ]
- }
- ],
- "source": [
- "# df_titlecount.groupby('Journal title').count()\n",
- "print(df['Journal title'].str.lower(), '\\n')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 11,
- "metadata": {},
- "outputs": [],
- "source": [
- "df_lower = df['Journal title'].str.lower()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 12,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "PMID/PMCID\n",
- "NaN psychological medicine\n",
- "PMC3679557 biomacromolecules\n",
- "23043264 PMC3506128 j med chem\n",
- "23438330 PMC3646402 j med chem\n",
- "23438216 PMC3601604 j org chem\n",
- "PMC3579457 journal of medicinal chemistry\n",
- "PMC3709265 journal of proteome research\n",
- "23057412 PMC3495574 mol pharm\n",
- "PMCID: PMC3780468 acs chemical biology\n",
- "PMCID: PMC3621575 acs chemical biology\n",
- "PMCID: PMC3739413 journal of chemical information and modeling\n",
- "PMCID: PMC3530961 journal of medicinal chemistry\n",
- "PMCID: PMC3624797 journal of medicinal chemistry\n",
- " PMC3413243 biochemistry\n",
- "PMC3694353 journal of medicinal chemistry\n",
- "PMC3572711 gastroenterology\n",
- "22610094 journal of biological chemistry\n",
- "PMCID: PMC3586974 journal of immunology\n",
- "23455506 PMCID: PMC3607399 journal of immunology\n",
- "PMID: 24015914 PMC3833349 acs chemical biology\n",
- ": PMC3805332 acs chemical biology\n",
- "NaN acs chemical biology\n",
- "PMCID:\\r\\n PMC3656742\\r\\n acs chemical neuroscience\n",
- "PMCID: 3584654 acs nano\n",
- "22971149 PMC3466778 american chemical society\n",
- "23072351 analytical chemistry\n",
- "PMC3477822 analytical chemistry\n",
- "PMC3530960 analytical chemistry\n",
- "23458425 PMC3630740 bioconjugate chemistry\n",
- "PMID: 20146481 journal of medicinal chemistry\n",
- " ... \n",
- "3575693 molecular microbiology\n",
- "PMID: 22188548 PMC3492912 obesity reviews\n",
- "PMID: 22764734 PMC3798095 obesity reviews\n",
- "PMID: 23703895 statistics in medicine\n",
- "PMCID: PMC3664106 stem cells\n",
- "PMID: 23649934 synapse\n",
- "PMC2955965 the european journal of neuroscience\n",
- "PMID: 19948006 PMC3551259 traffic\n",
- "PMID: 23305527 traffic\n",
- "PMCID: PMC3600532 zoonoses and public health\n",
- "PMC3440570 american journal of transplantation\n",
- "23670821 PMC3738939 angew chems int ed\n",
- "23640856 chembiochem\n",
- "PMID: 23918316 chemmedchem\n",
- "PMCID: PMC3728731 chemmedchem\n",
- "23495205685.88 PMC3743159 chemmedchem\n",
- "PMID:22997008 PMC3569869 protemics\n",
- "3708104 journal of small animal practice\n",
- "PMC3713766 aids\n",
- "PMC3819359 aids journal\n",
- "PMC3773237 aids uk\n",
- "PMC3815011 aids uk\n",
- "PMC3805356 jaids journal of acquired immune deficiency sy...\n",
- "Epub journal of acquired immune deficiency syndroms...\n",
- "PMC3707567 journal of aids\n",
- "2901593 circulation research\n",
- "3748854 aids\n",
- "3785148 pediatr infect dis j\n",
- "PMCID:\\r\\n PMC3647051\\r\\n aids\n",
- "PMID: 23846567 (Epub July 2013) journal of acquired immune deficiency syndromes\n",
- "Name: Journal title, Length: 2127, dtype: object\n"
- ]
- }
- ],
- "source": [
- "print(df_lower)"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 17,
- "metadata": {},
- "outputs": [],
- "source": []
- },
- {
- "cell_type": "code",
- "execution_count": 18,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "PMID/PMCID\n",
- "NaN psychological medicine\n",
- "PMC3679557 biomacromolecules\n",
- "23043264 PMC3506128 j med chem\n",
- "23438330 PMC3646402 j med chem\n",
- "23438216 PMC3601604 j org chem\n",
- "PMC3579457 journal of medicinal chemistry\n",
- "PMC3709265 journal of proteome research\n",
- "23057412 PMC3495574 mol pharm\n",
- "PMCID: PMC3780468 acs chemical biology\n",
- "PMCID: PMC3621575 acs chemical biology\n",
- "PMCID: PMC3739413 journal of chemical information and modeling\n",
- "PMCID: PMC3530961 journal of medicinal chemistry\n",
- "PMCID: PMC3624797 journal of medicinal chemistry\n",
- " PMC3413243 biochemistry\n",
- "PMC3694353 journal of medicinal chemistry\n",
- "PMC3572711 gastroenterology\n",
- "22610094 journal of biological chemistry\n",
- "PMCID: PMC3586974 journal of immunology\n",
- "23455506 PMCID: PMC3607399 journal of immunology\n",
- "PMID: 24015914 PMC3833349 acs chemical biology\n",
- ": PMC3805332 acs chemical biology\n",
- "NaN acs chemical biology\n",
- "PMCID:\\r\\n PMC3656742\\r\\n acs chemical neuroscience\n",
- "PMCID: 3584654 acs nano\n",
- "22971149 PMC3466778 american chemical society\n",
- "23072351 analytical chemistry\n",
- "PMC3477822 analytical chemistry\n",
- "PMC3530960 analytical chemistry\n",
- "23458425 PMC3630740 bioconjugate chemistry\n",
- "PMID: 20146481 journal of medicinal chemistry\n",
- " ... \n",
- "3575693 molecular microbiology\n",
- "PMID: 22188548 PMC3492912 obesity reviews\n",
- "PMID: 22764734 PMC3798095 obesity reviews\n",
- "PMID: 23703895 statistics in medicine\n",
- "PMCID: PMC3664106 stem cells\n",
- "PMID: 23649934 synapse\n",
- "PMC2955965 the european journal of neuroscience\n",
- "PMID: 19948006 PMC3551259 traffic\n",
- "PMID: 23305527 traffic\n",
- "PMCID: PMC3600532 zoonoses and public health\n",
- "PMC3440570 american journal of transplantation\n",
- "23670821 PMC3738939 angew chems int ed\n",
- "23640856 chembiochem\n",
- "PMID: 23918316 chemmedchem\n",
- "PMCID: PMC3728731 chemmedchem\n",
- "23495205685.88 PMC3743159 chemmedchem\n",
- "PMID:22997008 PMC3569869 protemics\n",
- "3708104 journal of small animal practice\n",
- "PMC3713766 aids\n",
- "PMC3819359 aids journal\n",
- "PMC3773237 aids uk\n",
- "PMC3815011 aids uk\n",
- "PMC3805356 jaids journal of acquired immune deficiency sy...\n",
- "Epub journal of acquired immune deficiency syndroms...\n",
- "PMC3707567 journal of aids\n",
- "2901593 circulation research\n",
- "3748854 aids\n",
- "3785148 pediatr infect dis j\n",
- "PMCID:\\r\\n PMC3647051\\r\\n aids\n",
- "PMID: 23846567 (Epub July 2013) journal of acquired immune deficiency syndromes\n",
- "Name: Journal title, Length: 2127, dtype: object\n"
- ]
- }
- ],
- "source": [
- "\n",
- "print(df_lower)"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 21,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "<pandas.core.groupby.DataFrameGroupBy object at 0x11016be48>\n"
- ]
- }
- ],
- "source": [
- "print(df.groupby('Journal title'))"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 24,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "2126"
- ]
- },
- "execution_count": 24,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df['Journal title'].str.lower().count()\n",
- "# df.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 26,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Journal title</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>ACS Chemical Biology</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Chemical Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS NANO</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Nano</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACTA F</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AGE</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Behav</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Care</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Research and Therapy</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS UK</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ASN Neuro</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Academy of Nutrition and Dietetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D, Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D: Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section F: Structural Biology and Crystallization Communications</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica, Section D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallography D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Dermato Venereologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Diabetologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathologica</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Opthalmologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Physiol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Addiction</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Advances in Experimental Medicine and Biology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age and Ageing</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Translational Psychiatry</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Cognitive Science</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Genetics</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Molecular Medicine</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neurosciences</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Parasitology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trop Med Int Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Animal Health & Production</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Medicine and International Health</th>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tuberculosis</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urban History</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urolithiasis</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vaccine</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vascular Pharmacology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Parasitology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Record</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virus Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vision Research</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Visual Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Zoonoses and Public Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>genesis: Journal of Genetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>mBio</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>984 rows × 3 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Article title \\\n",
- "Journal title \n",
- "ACS Chemical Biology 5 5 \n",
- "ACS Chemical Neuroscience 1 1 \n",
- "ACS NANO 1 1 \n",
- "ACS Nano 1 1 \n",
- "ACTA F 1 1 \n",
- "AGE 1 1 \n",
- "AIDS 3 3 \n",
- "AIDS Behav 1 1 \n",
- "AIDS Care 2 2 \n",
- "AIDS Journal 1 1 \n",
- "AIDS Research and Therapy 1 1 \n",
- "AIDS UK 2 2 \n",
- "ASN Neuro 1 1 \n",
- "Academy of Nutrition and Dietetics 1 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 2 \n",
- "Acta Crystallographica, Section D 1 1 \n",
- "Acta Crystallography D 1 1 \n",
- "Acta D 1 1 \n",
- "Acta Dermato Venereologica 1 1 \n",
- "Acta Diabetologica 1 1 \n",
- "Acta Neuropathol 1 1 \n",
- "Acta Neuropathologica 3 3 \n",
- "Acta Opthalmologica 1 1 \n",
- "Acta Physiol 1 1 \n",
- "Addiction 2 2 \n",
- "Advances in Experimental Medicine and Biology 4 4 \n",
- "Age 1 1 \n",
- "Age and Ageing 1 1 \n",
- "... ... ... \n",
- "Translational Psychiatry 2 2 \n",
- "Trends in Cognitive Science 1 1 \n",
- "Trends in Genetics 2 2 \n",
- "Trends in Microbiology 1 1 \n",
- "Trends in Molecular Medicine 1 1 \n",
- "Trends in Neuroscience 1 1 \n",
- "Trends in Neurosciences 2 2 \n",
- "Trends in Parasitology 4 4 \n",
- "Trials 4 4 \n",
- "Trials 1 1 \n",
- "Trop Med Int Health 1 1 \n",
- "Tropical Animal Health & Production 1 1 \n",
- "Tropical Medicine and International Health 6 6 \n",
- "Tuberculosis 2 2 \n",
- "Urban History 1 1 \n",
- "Urolithiasis 1 1 \n",
- "Vaccine 5 5 \n",
- "Vascular Pharmacology 1 1 \n",
- "Veterinary Microbiology 1 1 \n",
- "Veterinary Parasitology 2 2 \n",
- "Veterinary Record 1 1 \n",
- "Veterinary Research 1 1 \n",
- "Virology 2 2 \n",
- "Virology Journal 1 1 \n",
- "Virus Research 1 1 \n",
- "Vision Research 2 2 \n",
- "Visual Neuroscience 1 1 \n",
- "Zoonoses and Public Health 1 1 \n",
- "genesis: Journal of Genetics 1 1 \n",
- "mBio 1 1 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "Journal title \n",
- "ACS Chemical Biology 5 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "AGE 1 \n",
- "AIDS 3 \n",
- "AIDS Behav 1 \n",
- "AIDS Care 2 \n",
- "AIDS Journal 1 \n",
- "AIDS Research and Therapy 1 \n",
- "AIDS UK 2 \n",
- "ASN Neuro 1 \n",
- "Academy of Nutrition and Dietetics 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 \n",
- "Acta Crystallographica, Section D 1 \n",
- "Acta Crystallography D 1 \n",
- "Acta D 1 \n",
- "Acta Dermato Venereologica 1 \n",
- "Acta Diabetologica 1 \n",
- "Acta Neuropathol 1 \n",
- "Acta Neuropathologica 3 \n",
- "Acta Opthalmologica 1 \n",
- "Acta Physiol 1 \n",
- "Addiction 2 \n",
- "Advances in Experimental Medicine and Biology 4 \n",
- "Age 1 \n",
- "Age and Ageing 1 \n",
- "... ... \n",
- "Translational Psychiatry 2 \n",
- "Trends in Cognitive Science 1 \n",
- "Trends in Genetics 2 \n",
- "Trends in Microbiology 1 \n",
- "Trends in Molecular Medicine 1 \n",
- "Trends in Neuroscience 1 \n",
- "Trends in Neurosciences 2 \n",
- "Trends in Parasitology 4 \n",
- "Trials 4 \n",
- "Trials 1 \n",
- "Trop Med Int Health 1 \n",
- "Tropical Animal Health & Production 1 \n",
- "Tropical Medicine and International Health 6 \n",
- "Tuberculosis 2 \n",
- "Urban History 1 \n",
- "Urolithiasis 1 \n",
- "Vaccine 5 \n",
- "Vascular Pharmacology 1 \n",
- "Veterinary Microbiology 1 \n",
- "Veterinary Parasitology 2 \n",
- "Veterinary Record 1 \n",
- "Veterinary Research 1 \n",
- "Virology 2 \n",
- "Virology Journal 1 \n",
- "Virus Research 1 \n",
- "Vision Research 2 \n",
- "Visual Neuroscience 1 \n",
- "Zoonoses and Public Health 1 \n",
- "genesis: Journal of Genetics 1 \n",
- "mBio 1 \n",
- "\n",
- "[984 rows x 3 columns]"
- ]
- },
- "execution_count": 26,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 29,
- "metadata": {},
- "outputs": [],
- "source": [
- "df_lower = df['Journal title'].str.lower()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 30,
- "metadata": {},
- "outputs": [
- {
- "ename": "KeyError",
- "evalue": "'Journal title'",
- "output_type": "error",
- "traceback": [
- "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
- "\u001b[0;31mKeyError\u001b[0m Traceback (most recent call last)",
- "\u001b[0;32m<ipython-input-30-8c4676e5bf2d>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf_lower\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgroupby\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'Journal title'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcount\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
- "\u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36mgroupby\u001b[0;34m(self, by, axis, level, as_index, sort, group_keys, squeeze, **kwargs)\u001b[0m\n\u001b[1;32m 5160\u001b[0m return groupby(self, by=by, axis=axis, level=level, as_index=as_index,\n\u001b[1;32m 5161\u001b[0m \u001b[0msort\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0msort\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mgroup_keys\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mgroup_keys\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msqueeze\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0msqueeze\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 5162\u001b[0;31m **kwargs)\n\u001b[0m\u001b[1;32m 5163\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 5164\u001b[0m def asfreq(self, freq, method=None, how=None, normalize=False,\n",
- "\u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/pandas/core/groupby.py\u001b[0m in \u001b[0;36mgroupby\u001b[0;34m(obj, by, **kwds)\u001b[0m\n\u001b[1;32m 1757\u001b[0m \u001b[0;32mraise\u001b[0m \u001b[0mTypeError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'invalid type: %s'\u001b[0m \u001b[0;34m%\u001b[0m \u001b[0mtype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mobj\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 1758\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1759\u001b[0;31m \u001b[0;32mreturn\u001b[0m \u001b[0mklass\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mby\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 1760\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 1761\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
- "\u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/pandas/core/groupby.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, obj, keys, axis, level, grouper, exclusions, selection, as_index, sort, group_keys, squeeze, **kwargs)\u001b[0m\n\u001b[1;32m 390\u001b[0m \u001b[0mlevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 391\u001b[0m \u001b[0msort\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0msort\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 392\u001b[0;31m mutated=self.mutated)\n\u001b[0m\u001b[1;32m 393\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 394\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mobj\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mobj\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
- "\u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/pandas/core/groupby.py\u001b[0m in \u001b[0;36m_get_grouper\u001b[0;34m(obj, key, axis, level, sort, mutated, validate)\u001b[0m\n\u001b[1;32m 2840\u001b[0m \u001b[0min_axis\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mgpr\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mFalse\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mgpr\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 2841\u001b[0m \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2842\u001b[0;31m \u001b[0;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mgpr\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 2843\u001b[0m \u001b[0;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mgpr\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mGrouper\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mgpr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mkey\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 2844\u001b[0m \u001b[0;31m# Add key to exclusions\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
- "\u001b[0;31mKeyError\u001b[0m: 'Journal title'"
- ]
- }
- ],
- "source": [
- "df_lower.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 31,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "0 True\n",
- "1 True\n",
- "2 False\n",
- "3 True\n",
- "4 False\n",
- "dtype: bool\n"
- ]
- }
- ],
- "source": [
- "# Dirty list\n",
- "money = pd.Series([400, 111, '$20', 57, 'Lots'])\n",
- "\n",
- "# Here's a lambda function that mirrors the is_a_digit function above.\n",
- "# Read this print statement carefully and compare to the previous one.\n",
- "print(money.apply(lambda x: str(x).isdigit()))"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 32,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "\n",
- "Applying filter() to each value in the series:\n",
- "0 400\n",
- "1 111\n",
- "2 20\n",
- "3 57\n",
- "4 \n",
- "dtype: object\n"
- ]
- }
- ],
- "source": [
- "print('\\nApplying filter() to each value in the series:')\n",
- "print(money.apply(lambda x: ''.join(list(filter(str.isdigit, str(x))))))"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 33,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Journal title</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>ACS Chemical Biology</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Chemical Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS NANO</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Nano</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACTA F</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AGE</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Behav</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Care</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Research and Therapy</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS UK</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ASN Neuro</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Academy of Nutrition and Dietetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D, Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D: Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section F: Structural Biology and Crystallization Communications</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica, Section D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallography D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Dermato Venereologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Diabetologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathologica</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Opthalmologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Physiol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Addiction</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Advances in Experimental Medicine and Biology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age and Ageing</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Translational Psychiatry</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Cognitive Science</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Genetics</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Molecular Medicine</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neurosciences</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Parasitology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trop Med Int Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Animal Health & Production</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Medicine and International Health</th>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tuberculosis</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urban History</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urolithiasis</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vaccine</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vascular Pharmacology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Parasitology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Record</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virus Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vision Research</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Visual Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Zoonoses and Public Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>genesis: Journal of Genetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>mBio</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>984 rows × 3 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Article title \\\n",
- "Journal title \n",
- "ACS Chemical Biology 5 5 \n",
- "ACS Chemical Neuroscience 1 1 \n",
- "ACS NANO 1 1 \n",
- "ACS Nano 1 1 \n",
- "ACTA F 1 1 \n",
- "AGE 1 1 \n",
- "AIDS 3 3 \n",
- "AIDS Behav 1 1 \n",
- "AIDS Care 2 2 \n",
- "AIDS Journal 1 1 \n",
- "AIDS Research and Therapy 1 1 \n",
- "AIDS UK 2 2 \n",
- "ASN Neuro 1 1 \n",
- "Academy of Nutrition and Dietetics 1 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 2 \n",
- "Acta Crystallographica, Section D 1 1 \n",
- "Acta Crystallography D 1 1 \n",
- "Acta D 1 1 \n",
- "Acta Dermato Venereologica 1 1 \n",
- "Acta Diabetologica 1 1 \n",
- "Acta Neuropathol 1 1 \n",
- "Acta Neuropathologica 3 3 \n",
- "Acta Opthalmologica 1 1 \n",
- "Acta Physiol 1 1 \n",
- "Addiction 2 2 \n",
- "Advances in Experimental Medicine and Biology 4 4 \n",
- "Age 1 1 \n",
- "Age and Ageing 1 1 \n",
- "... ... ... \n",
- "Translational Psychiatry 2 2 \n",
- "Trends in Cognitive Science 1 1 \n",
- "Trends in Genetics 2 2 \n",
- "Trends in Microbiology 1 1 \n",
- "Trends in Molecular Medicine 1 1 \n",
- "Trends in Neuroscience 1 1 \n",
- "Trends in Neurosciences 2 2 \n",
- "Trends in Parasitology 4 4 \n",
- "Trials 4 4 \n",
- "Trials 1 1 \n",
- "Trop Med Int Health 1 1 \n",
- "Tropical Animal Health & Production 1 1 \n",
- "Tropical Medicine and International Health 6 6 \n",
- "Tuberculosis 2 2 \n",
- "Urban History 1 1 \n",
- "Urolithiasis 1 1 \n",
- "Vaccine 5 5 \n",
- "Vascular Pharmacology 1 1 \n",
- "Veterinary Microbiology 1 1 \n",
- "Veterinary Parasitology 2 2 \n",
- "Veterinary Record 1 1 \n",
- "Veterinary Research 1 1 \n",
- "Virology 2 2 \n",
- "Virology Journal 1 1 \n",
- "Virus Research 1 1 \n",
- "Vision Research 2 2 \n",
- "Visual Neuroscience 1 1 \n",
- "Zoonoses and Public Health 1 1 \n",
- "genesis: Journal of Genetics 1 1 \n",
- "mBio 1 1 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "Journal title \n",
- "ACS Chemical Biology 5 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "AGE 1 \n",
- "AIDS 3 \n",
- "AIDS Behav 1 \n",
- "AIDS Care 2 \n",
- "AIDS Journal 1 \n",
- "AIDS Research and Therapy 1 \n",
- "AIDS UK 2 \n",
- "ASN Neuro 1 \n",
- "Academy of Nutrition and Dietetics 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 \n",
- "Acta Crystallographica, Section D 1 \n",
- "Acta Crystallography D 1 \n",
- "Acta D 1 \n",
- "Acta Dermato Venereologica 1 \n",
- "Acta Diabetologica 1 \n",
- "Acta Neuropathol 1 \n",
- "Acta Neuropathologica 3 \n",
- "Acta Opthalmologica 1 \n",
- "Acta Physiol 1 \n",
- "Addiction 2 \n",
- "Advances in Experimental Medicine and Biology 4 \n",
- "Age 1 \n",
- "Age and Ageing 1 \n",
- "... ... \n",
- "Translational Psychiatry 2 \n",
- "Trends in Cognitive Science 1 \n",
- "Trends in Genetics 2 \n",
- "Trends in Microbiology 1 \n",
- "Trends in Molecular Medicine 1 \n",
- "Trends in Neuroscience 1 \n",
- "Trends in Neurosciences 2 \n",
- "Trends in Parasitology 4 \n",
- "Trials 4 \n",
- "Trials 1 \n",
- "Trop Med Int Health 1 \n",
- "Tropical Animal Health & Production 1 \n",
- "Tropical Medicine and International Health 6 \n",
- "Tuberculosis 2 \n",
- "Urban History 1 \n",
- "Urolithiasis 1 \n",
- "Vaccine 5 \n",
- "Vascular Pharmacology 1 \n",
- "Veterinary Microbiology 1 \n",
- "Veterinary Parasitology 2 \n",
- "Veterinary Record 1 \n",
- "Veterinary Research 1 \n",
- "Virology 2 \n",
- "Virology Journal 1 \n",
- "Virus Research 1 \n",
- "Vision Research 2 \n",
- "Visual Neuroscience 1 \n",
- "Zoonoses and Public Health 1 \n",
- "genesis: Journal of Genetics 1 \n",
- "mBio 1 \n",
- "\n",
- "[984 rows x 3 columns]"
- ]
- },
- "execution_count": 33,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 37,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "2126"
- ]
- },
- "execution_count": 37,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df_lower.count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 40,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Journal title</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>ACS Chemical Biology</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Chemical Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS NANO</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Nano</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACTA F</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AGE</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Behav</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Care</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Research and Therapy</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS UK</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ASN Neuro</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Academy of Nutrition and Dietetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D, Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D: Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section F: Structural Biology and Crystallization Communications</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica, Section D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallography D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Dermato Venereologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Diabetologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathologica</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Opthalmologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Physiol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Addiction</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Advances in Experimental Medicine and Biology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age and Ageing</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Translational Psychiatry</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Cognitive Science</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Genetics</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Molecular Medicine</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neurosciences</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Parasitology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trop Med Int Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Animal Health & Production</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Medicine and International Health</th>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tuberculosis</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urban History</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urolithiasis</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vaccine</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vascular Pharmacology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Parasitology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Record</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virus Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vision Research</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Visual Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Zoonoses and Public Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>genesis: Journal of Genetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>mBio</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>984 rows × 3 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Article title \\\n",
- "Journal title \n",
- "ACS Chemical Biology 5 5 \n",
- "ACS Chemical Neuroscience 1 1 \n",
- "ACS NANO 1 1 \n",
- "ACS Nano 1 1 \n",
- "ACTA F 1 1 \n",
- "AGE 1 1 \n",
- "AIDS 3 3 \n",
- "AIDS Behav 1 1 \n",
- "AIDS Care 2 2 \n",
- "AIDS Journal 1 1 \n",
- "AIDS Research and Therapy 1 1 \n",
- "AIDS UK 2 2 \n",
- "ASN Neuro 1 1 \n",
- "Academy of Nutrition and Dietetics 1 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 2 \n",
- "Acta Crystallographica, Section D 1 1 \n",
- "Acta Crystallography D 1 1 \n",
- "Acta D 1 1 \n",
- "Acta Dermato Venereologica 1 1 \n",
- "Acta Diabetologica 1 1 \n",
- "Acta Neuropathol 1 1 \n",
- "Acta Neuropathologica 3 3 \n",
- "Acta Opthalmologica 1 1 \n",
- "Acta Physiol 1 1 \n",
- "Addiction 2 2 \n",
- "Advances in Experimental Medicine and Biology 4 4 \n",
- "Age 1 1 \n",
- "Age and Ageing 1 1 \n",
- "... ... ... \n",
- "Translational Psychiatry 2 2 \n",
- "Trends in Cognitive Science 1 1 \n",
- "Trends in Genetics 2 2 \n",
- "Trends in Microbiology 1 1 \n",
- "Trends in Molecular Medicine 1 1 \n",
- "Trends in Neuroscience 1 1 \n",
- "Trends in Neurosciences 2 2 \n",
- "Trends in Parasitology 4 4 \n",
- "Trials 4 4 \n",
- "Trials 1 1 \n",
- "Trop Med Int Health 1 1 \n",
- "Tropical Animal Health & Production 1 1 \n",
- "Tropical Medicine and International Health 6 6 \n",
- "Tuberculosis 2 2 \n",
- "Urban History 1 1 \n",
- "Urolithiasis 1 1 \n",
- "Vaccine 5 5 \n",
- "Vascular Pharmacology 1 1 \n",
- "Veterinary Microbiology 1 1 \n",
- "Veterinary Parasitology 2 2 \n",
- "Veterinary Record 1 1 \n",
- "Veterinary Research 1 1 \n",
- "Virology 2 2 \n",
- "Virology Journal 1 1 \n",
- "Virus Research 1 1 \n",
- "Vision Research 2 2 \n",
- "Visual Neuroscience 1 1 \n",
- "Zoonoses and Public Health 1 1 \n",
- "genesis: Journal of Genetics 1 1 \n",
- "mBio 1 1 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "Journal title \n",
- "ACS Chemical Biology 5 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "AGE 1 \n",
- "AIDS 3 \n",
- "AIDS Behav 1 \n",
- "AIDS Care 2 \n",
- "AIDS Journal 1 \n",
- "AIDS Research and Therapy 1 \n",
- "AIDS UK 2 \n",
- "ASN Neuro 1 \n",
- "Academy of Nutrition and Dietetics 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 \n",
- "Acta Crystallographica, Section D 1 \n",
- "Acta Crystallography D 1 \n",
- "Acta D 1 \n",
- "Acta Dermato Venereologica 1 \n",
- "Acta Diabetologica 1 \n",
- "Acta Neuropathol 1 \n",
- "Acta Neuropathologica 3 \n",
- "Acta Opthalmologica 1 \n",
- "Acta Physiol 1 \n",
- "Addiction 2 \n",
- "Advances in Experimental Medicine and Biology 4 \n",
- "Age 1 \n",
- "Age and Ageing 1 \n",
- "... ... \n",
- "Translational Psychiatry 2 \n",
- "Trends in Cognitive Science 1 \n",
- "Trends in Genetics 2 \n",
- "Trends in Microbiology 1 \n",
- "Trends in Molecular Medicine 1 \n",
- "Trends in Neuroscience 1 \n",
- "Trends in Neurosciences 2 \n",
- "Trends in Parasitology 4 \n",
- "Trials 4 \n",
- "Trials 1 \n",
- "Trop Med Int Health 1 \n",
- "Tropical Animal Health & Production 1 \n",
- "Tropical Medicine and International Health 6 \n",
- "Tuberculosis 2 \n",
- "Urban History 1 \n",
- "Urolithiasis 1 \n",
- "Vaccine 5 \n",
- "Vascular Pharmacology 1 \n",
- "Veterinary Microbiology 1 \n",
- "Veterinary Parasitology 2 \n",
- "Veterinary Record 1 \n",
- "Veterinary Research 1 \n",
- "Virology 2 \n",
- "Virology Journal 1 \n",
- "Virus Research 1 \n",
- "Vision Research 2 \n",
- "Visual Neuroscience 1 \n",
- "Zoonoses and Public Health 1 \n",
- "genesis: Journal of Genetics 1 \n",
- "mBio 1 \n",
- "\n",
- "[984 rows x 3 columns]"
- ]
- },
- "execution_count": 40,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "df.groupby('Journal title').count()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 46,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "PMID/PMCID\n",
- "NaN psychological medicine\n",
- "PMC3679557 biomacromolecules\n",
- "23043264 PMC3506128 j med chem\n",
- "23438330 PMC3646402 j med chem\n",
- "23438216 PMC3601604 j org chem\n",
- "PMC3579457 journal of medicinal chemistry\n",
- "PMC3709265 journal of proteome research\n",
- "23057412 PMC3495574 mol pharm\n",
- "PMCID: PMC3780468 acs chemical biology\n",
- "PMCID: PMC3621575 acs chemical biology\n",
- "PMCID: PMC3739413 journal of chemical information and modeling\n",
- "PMCID: PMC3530961 journal of medicinal chemistry\n",
- "PMCID: PMC3624797 journal of medicinal chemistry\n",
- " PMC3413243 biochemistry\n",
- "PMC3694353 journal of medicinal chemistry\n",
- "PMC3572711 gastroenterology\n",
- "22610094 journal of biological chemistry\n",
- "PMCID: PMC3586974 journal of immunology\n",
- "23455506 PMCID: PMC3607399 journal of immunology\n",
- "PMID: 24015914 PMC3833349 acs chemical biology\n",
- ": PMC3805332 acs chemical biology\n",
- "NaN acs chemical biology\n",
- "PMCID:\\r\\n PMC3656742\\r\\n acs chemical neuroscience\n",
- "PMCID: 3584654 acs nano\n",
- "22971149 PMC3466778 american chemical society\n",
- "23072351 analytical chemistry\n",
- "PMC3477822 analytical chemistry\n",
- "PMC3530960 analytical chemistry\n",
- "23458425 PMC3630740 bioconjugate chemistry\n",
- "PMID: 20146481 journal of medicinal chemistry\n",
- " ... \n",
- "3575693 molecular microbiology\n",
- "PMID: 22188548 PMC3492912 obesity reviews\n",
- "PMID: 22764734 PMC3798095 obesity reviews\n",
- "PMID: 23703895 statistics in medicine\n",
- "PMCID: PMC3664106 stem cells\n",
- "PMID: 23649934 synapse\n",
- "PMC2955965 the european journal of neuroscience\n",
- "PMID: 19948006 PMC3551259 traffic\n",
- "PMID: 23305527 traffic\n",
- "PMCID: PMC3600532 zoonoses and public health\n",
- "PMC3440570 american journal of transplantation\n",
- "23670821 PMC3738939 angew chems int ed\n",
- "23640856 chembiochem\n",
- "PMID: 23918316 chemmedchem\n",
- "PMCID: PMC3728731 chemmedchem\n",
- "23495205685.88 PMC3743159 chemmedchem\n",
- "PMID:22997008 PMC3569869 protemics\n",
- "3708104 journal of small animal practice\n",
- "PMC3713766 aids\n",
- "PMC3819359 aids journal\n",
- "PMC3773237 aids uk\n",
- "PMC3815011 aids uk\n",
- "PMC3805356 jaids journal of acquired immune deficiency sy...\n",
- "Epub journal of acquired immune deficiency syndroms...\n",
- "PMC3707567 journal of aids\n",
- "2901593 circulation research\n",
- "3748854 aids\n",
- "3785148 pediatr infect dis j\n",
- "PMCID:\\r\\n PMC3647051\\r\\n aids\n",
- "PMID: 23846567 (Epub July 2013) journal of acquired immune deficiency syndromes\n",
- "Name: Journal title, Length: 2127, dtype: object \n",
- "\n"
- ]
- },
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>Publisher</th>\n",
- " <th>Article title</th>\n",
- " <th>COST (£) charged to Wellcome (inc VAT when charged)</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Journal title</th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>ACS Chemical Biology</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Chemical Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS NANO</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACS Nano</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ACTA F</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AGE</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Behav</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Care</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS Research and Therapy</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>AIDS UK</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>ASN Neuro</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Academy of Nutrition and Dietetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D, Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section D: Biological Crystallography</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica Section F: Structural Biology and Crystallization Communications</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallographica, Section D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Crystallography D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta D</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Dermato Venereologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Diabetologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Neuropathologica</th>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Opthalmologica</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Acta Physiol</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Addiction</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Advances in Experimental Medicine and Biology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Age and Ageing</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Translational Psychiatry</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Cognitive Science</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Genetics</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Molecular Medicine</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Neurosciences</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trends in Parasitology</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trials</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Trop Med Int Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Animal Health & Production</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tropical Medicine and International Health</th>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Tuberculosis</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urban History</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Urolithiasis</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vaccine</th>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vascular Pharmacology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Microbiology</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Parasitology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Record</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Veterinary Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virology Journal</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Virus Research</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Vision Research</th>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " <td>2</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Visual Neuroscience</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Zoonoses and Public Health</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>genesis: Journal of Genetics</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>mBio</th>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " <td>1</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>984 rows × 3 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " Publisher Article title \\\n",
- "Journal title \n",
- "ACS Chemical Biology 5 5 \n",
- "ACS Chemical Neuroscience 1 1 \n",
- "ACS NANO 1 1 \n",
- "ACS Nano 1 1 \n",
- "ACTA F 1 1 \n",
- "AGE 1 1 \n",
- "AIDS 3 3 \n",
- "AIDS Behav 1 1 \n",
- "AIDS Care 2 2 \n",
- "AIDS Journal 1 1 \n",
- "AIDS Research and Therapy 1 1 \n",
- "AIDS UK 2 2 \n",
- "ASN Neuro 1 1 \n",
- "Academy of Nutrition and Dietetics 1 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 2 \n",
- "Acta Crystallographica, Section D 1 1 \n",
- "Acta Crystallography D 1 1 \n",
- "Acta D 1 1 \n",
- "Acta Dermato Venereologica 1 1 \n",
- "Acta Diabetologica 1 1 \n",
- "Acta Neuropathol 1 1 \n",
- "Acta Neuropathologica 3 3 \n",
- "Acta Opthalmologica 1 1 \n",
- "Acta Physiol 1 1 \n",
- "Addiction 2 2 \n",
- "Advances in Experimental Medicine and Biology 4 4 \n",
- "Age 1 1 \n",
- "Age and Ageing 1 1 \n",
- "... ... ... \n",
- "Translational Psychiatry 2 2 \n",
- "Trends in Cognitive Science 1 1 \n",
- "Trends in Genetics 2 2 \n",
- "Trends in Microbiology 1 1 \n",
- "Trends in Molecular Medicine 1 1 \n",
- "Trends in Neuroscience 1 1 \n",
- "Trends in Neurosciences 2 2 \n",
- "Trends in Parasitology 4 4 \n",
- "Trials 4 4 \n",
- "Trials 1 1 \n",
- "Trop Med Int Health 1 1 \n",
- "Tropical Animal Health & Production 1 1 \n",
- "Tropical Medicine and International Health 6 6 \n",
- "Tuberculosis 2 2 \n",
- "Urban History 1 1 \n",
- "Urolithiasis 1 1 \n",
- "Vaccine 5 5 \n",
- "Vascular Pharmacology 1 1 \n",
- "Veterinary Microbiology 1 1 \n",
- "Veterinary Parasitology 2 2 \n",
- "Veterinary Record 1 1 \n",
- "Veterinary Research 1 1 \n",
- "Virology 2 2 \n",
- "Virology Journal 1 1 \n",
- "Virus Research 1 1 \n",
- "Vision Research 2 2 \n",
- "Visual Neuroscience 1 1 \n",
- "Zoonoses and Public Health 1 1 \n",
- "genesis: Journal of Genetics 1 1 \n",
- "mBio 1 1 \n",
- "\n",
- " COST (£) charged to Wellcome (inc VAT when charged) \n",
- "Journal title \n",
- "ACS Chemical Biology 5 \n",
- "ACS Chemical Neuroscience 1 \n",
- "ACS NANO 1 \n",
- "ACS Nano 1 \n",
- "ACTA F 1 \n",
- "AGE 1 \n",
- "AIDS 3 \n",
- "AIDS Behav 1 \n",
- "AIDS Care 2 \n",
- "AIDS Journal 1 \n",
- "AIDS Research and Therapy 1 \n",
- "AIDS UK 2 \n",
- "ASN Neuro 1 \n",
- "Academy of Nutrition and Dietetics 1 \n",
- "Acta Crystallographica Section D, Biological C... 1 \n",
- "Acta Crystallographica Section D: Biological Cr... 1 \n",
- "Acta Crystallographica Section F: Structural Bi... 2 \n",
- "Acta Crystallographica, Section D 1 \n",
- "Acta Crystallography D 1 \n",
- "Acta D 1 \n",
- "Acta Dermato Venereologica 1 \n",
- "Acta Diabetologica 1 \n",
- "Acta Neuropathol 1 \n",
- "Acta Neuropathologica 3 \n",
- "Acta Opthalmologica 1 \n",
- "Acta Physiol 1 \n",
- "Addiction 2 \n",
- "Advances in Experimental Medicine and Biology 4 \n",
- "Age 1 \n",
- "Age and Ageing 1 \n",
- "... ... \n",
- "Translational Psychiatry 2 \n",
- "Trends in Cognitive Science 1 \n",
- "Trends in Genetics 2 \n",
- "Trends in Microbiology 1 \n",
- "Trends in Molecular Medicine 1 \n",
- "Trends in Neuroscience 1 \n",
- "Trends in Neurosciences 2 \n",
- "Trends in Parasitology 4 \n",
- "Trials 4 \n",
- "Trials 1 \n",
- "Trop Med Int Health 1 \n",
- "Tropical Animal Health & Production 1 \n",
- "Tropical Medicine and International Health 6 \n",
- "Tuberculosis 2 \n",
- "Urban History 1 \n",
- "Urolithiasis 1 \n",
- "Vaccine 5 \n",
- "Vascular Pharmacology 1 \n",
- "Veterinary Microbiology 1 \n",
- "Veterinary Parasitology 2 \n",
- "Veterinary Record 1 \n",
- "Veterinary Research 1 \n",
- "Virology 2 \n",
- "Virology Journal 1 \n",
- "Virus Research 1 \n",
- "Vision Research 2 \n",
- "Visual Neuroscience 1 \n",
- "Zoonoses and Public Health 1 \n",
- "genesis: Journal of Genetics 1 \n",
- "mBio 1 \n",
- "\n",
- "[984 rows x 3 columns]"
- ]
- },
- "execution_count": 46,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "print(df['Journal title'].str.lower(), '\\n')\n",
- "df.groupby('Journal title').count()\n",
- "# df_lower.count('Journal title')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 49,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "PMID/PMCID\n",
- "NaN psychological medicine\n",
- "PMC3679557 biomacromolecules\n",
- "23043264 PMC3506128 j med chem\n",
- "23438330 PMC3646402 j med chem\n",
- "23438216 PMC3601604 j org chem\n",
- "PMC3579457 journal of medicinal chemistry\n",
- "PMC3709265 journal of proteome research\n",
- "23057412 PMC3495574 mol pharm\n",
- "PMCID: PMC3780468 acs chemical biology\n",
- "PMCID: PMC3621575 acs chemical biology\n",
- "PMCID: PMC3739413 journal of chemical information and modeling\n",
- "PMCID: PMC3530961 journal of medicinal chemistry\n",
- "PMCID: PMC3624797 journal of medicinal chemistry\n",
- " PMC3413243 biochemistry\n",
- "PMC3694353 journal of medicinal chemistry\n",
- "PMC3572711 gastroenterology\n",
- "22610094 journal of biological chemistry\n",
- "PMCID: PMC3586974 journal of immunology\n",
- "23455506 PMCID: PMC3607399 journal of immunology\n",
- "PMID: 24015914 PMC3833349 acs chemical biology\n",
- ": PMC3805332 acs chemical biology\n",
- "NaN acs chemical biology\n",
- "PMCID:\\r\\n PMC3656742\\r\\n acs chemical neuroscience\n",
- "PMCID: 3584654 acs nano\n",
- "22971149 PMC3466778 american chemical society\n",
- "23072351 analytical chemistry\n",
- "PMC3477822 analytical chemistry\n",
- "PMC3530960 analytical chemistry\n",
- "23458425 PMC3630740 bioconjugate chemistry\n",
- "PMID: 20146481 journal of medicinal chemistry\n",
- " ... \n",
- "3575693 molecular microbiology\n",
- "PMID: 22188548 PMC3492912 obesity reviews\n",
- "PMID: 22764734 PMC3798095 obesity reviews\n",
- "PMID: 23703895 statistics in medicine\n",
- "PMCID: PMC3664106 stem cells\n",
- "PMID: 23649934 synapse\n",
- "PMC2955965 the european journal of neuroscience\n",
- "PMID: 19948006 PMC3551259 traffic\n",
- "PMID: 23305527 traffic\n",
- "PMCID: PMC3600532 zoonoses and public health\n",
- "PMC3440570 american journal of transplantation\n",
- "23670821 PMC3738939 angew chems int ed\n",
- "23640856 chembiochem\n",
- "PMID: 23918316 chemmedchem\n",
- "PMCID: PMC3728731 chemmedchem\n",
- "23495205685.88 PMC3743159 chemmedchem\n",
- "PMID:22997008 PMC3569869 protemics\n",
- "3708104 journal of small animal practice\n",
- "PMC3713766 aids\n",
- "PMC3819359 aids journal\n",
- "PMC3773237 aids uk\n",
- "PMC3815011 aids uk\n",
- "PMC3805356 jaids journal of acquired immune deficiency sy...\n",
- "Epub journal of acquired immune deficiency syndroms...\n",
- "PMC3707567 journal of aids\n",
- "2901593 circulation research\n",
- "3748854 aids\n",
- "3785148 pediatr infect dis j\n",
- "PMCID:\\r\\n PMC3647051\\r\\n aids\n",
- "PMID: 23846567 (Epub July 2013) journal of acquired immune deficiency syndromes\n",
- "Name: Journal title, Length: 2127, dtype: object \n",
- "\n"
- ]
- }
- ],
- "source": [
- "print(df['Journal title'].str.lower(), '\\n')\n",
- "# df.groupby('Journal title').sum()"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 50,
- "metadata": {},
- "outputs": [
- {
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "Filtering the whole series:\n"
- ]
- },
- {
- "ename": "TypeError",
- "evalue": "'StringMethods' object is not callable",
- "output_type": "error",
- "traceback": [
- "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
- "\u001b[0;31mTypeError\u001b[0m Traceback (most recent call last)",
- "\u001b[0;32m<ipython-input-50-ff0989edb773>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m 1\u001b[0m \u001b[0;31m# df['Journal title'].str.lower()\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 2\u001b[0m \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'Filtering the whole series:'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;32mlambda\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Journal title'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0misstring\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
- "\u001b[0;32m<ipython-input-50-ff0989edb773>\u001b[0m in \u001b[0;36m<lambda>\u001b[0;34m(x)\u001b[0m\n\u001b[1;32m 1\u001b[0m \u001b[0;31m# df['Journal title'].str.lower()\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 2\u001b[0m \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'Filtering the whole series:'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;32mlambda\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Journal title'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0misstring\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
- "\u001b[0;31mTypeError\u001b[0m: 'StringMethods' object is not callable"
- ]
- }
- ],
- "source": [
- "# df['Journal title'].str.lower()\n",
- "print('Filtering the whole series:')\n",
- "print(list(filter(lambda x: df['Journal title'].str(x).isstring(), df)))"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": null,
- "metadata": {},
- "outputs": [],
- "source": [
- "print(df['Journal title'].str.replace('@', ' at '),'\\n')"
- ]
- }
- ],
- "metadata": {
- "kernelspec": {
- "display_name": "Python 3",
- "language": "python",
- "name": "python3"
- },
- "language_info": {
- "codemirror_mode": {
- "name": "ipython",
- "version": 3
- },
- "file_extension": ".py",
- "mimetype": "text/x-python",
- "name": "python",
- "nbconvert_exporter": "python",
- "pygments_lexer": "ipython3",
- "version": "3.5.2"
- }
- },
- "nbformat": 4,
- "nbformat_minor": 2
- }
Add Comment
Please, Sign In to add comment