Skip to content

Instantly share code, notes, and snippets.

@answerquest

answerquest/ArticlesListing.csv

Last active May 27, 2018 14:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save answerquest/752719c74d24f945722d495e6c6d6ae7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save answerquest/752719c74d24f945722d495e6c6d6ae7 to your computer and use it in GitHub Desktop.
Download ZIP
transactional scrape.ipynb
Raw
ArticlesListing.csv
article-type authors citations link cross-ref citations issue link online pub date pages pdf link references link subject title views volume
[{'role': '(President)', 'degree': 'M.D.', 'name': 'Kenneth V. Everts', 'authorURL': 'https://tandfonline.com/author/Everts%2C+Kenneth+V'}] https://tandfonline.com/doi/abs/10.1177/036215377100100101 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100101 02 Jan 2018 4 https://tandfonline.com/doi/pdf/10.1177/036215377100100101 The President's Page The President's Page 2 1
[{'name': 'Warren D. Cheney', 'authorURL': 'https://tandfonline.com/author/Cheney%2C+Warren+D'}] https://tandfonline.com/doi/abs/10.1177/036215377100100102 1 1 https://tandfonline.com/doi/abs/10.1177/036215377100100102 02 Jan 2018 5 https://tandfonline.com/doi/pdf/10.1177/036215377100100102 Introducing the Transactional Analysis Journal Introducing the Transactional Analysis Journal 4 1
Article [{'degree': 'M.D.', 'name': 'Eric Berne', 'authorURL': 'https://tandfonline.com/author/Berne%2C+Eric'}] 27 1 https://tandfonline.com/doi/abs/10.1177/036215377100100103 02 Jan 2018 6-13 https://tandfonline.com/doi/pdf/10.1177/036215377100100103 Section I: Feature Article Away from a Theory of the Impact of Interpersonal Interaction on Non-Verbal Participation 13 1
Article [{'degree': 'M.A., M.A.', 'name': 'Warren D. Cheney', 'authorURL': 'https://tandfonline.com/author/Cheney%2C+Warren+D'}] 8 1 https://tandfonline.com/doi/abs/10.1177/036215377100100104 02 Jan 2018 14-22 https://tandfonline.com/doi/pdf/10.1177/036215377100100104 Section II: Eric Berne Memorial Eric Berne: Biographical Sketch 6 1
Article [{'degree': 'B.A., B.A.', 'name': 'Robert M. Cranmer', 'authorURL': 'https://tandfonline.com/author/Cranmer%2C+Robert+M'}] 1 1 https://tandfonline.com/doi/abs/10.1177/036215377100100105 02 Jan 2018 23-29 https://tandfonline.com/doi/pdf/10.1177/036215377100100105 Section II: Eric Berne Memorial Eric Berne: Annotated Bibliography 2 1
0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100106 02 Jan 2018 30-33 https://tandfonline.com/doi/pdf/10.1177/036215377100100106 Section II: Eric Berne Memorial Eric Berne — Portfolio of Pictures 3 1
Article [{'degree': 'M.D.', 'name': 'John M. Dusay', 'authorURL': 'https://tandfonline.com/author/Dusay%2C+John+M'}] 3 1 https://tandfonline.com/doi/abs/10.1177/036215377100100107 02 Jan 2018 34-44 https://tandfonline.com/doi/pdf/10.1177/036215377100100107 https://tandfonline.com/doi/ref/10.1177/036215377100100107 Section II: Evaluative Article Eric Berne's Studies of Intuition 1949–1962 14 1
Article [{'degree': 'Ph.D.', 'name': 'Claude M. Steiner', 'authorURL': 'https://tandfonline.com/author/Steiner%2C+Claude+M'}] 2 1 https://tandfonline.com/doi/abs/10.1177/036215377100100108 02 Jan 2018 46-48 https://tandfonline.com/doi/pdf/10.1177/036215377100100108 Section II: Evaluative Article A Little Boy's Dream 8 1
Article [{'degree': 'MD.', 'name': 'Franklin H. Ernst Jr.', 'authorURL': 'https://tandfonline.com/author/Ernst%2C+Franklin+H+Jr'}] 4 1 https://tandfonline.com/doi/abs/10.1177/036215377100100109 02 Jan 2018 49-58 https://tandfonline.com/doi/pdf/10.1177/036215377100100109 https://tandfonline.com/doi/ref/10.1177/036215377100100109 Section II: Evaluative Article The Diagrammed Parent Eric Berne's Most Significant Contribution 4 1
Article [{'degree': 'M.D.', 'name': 'Thomas A. Harris', 'authorURL': 'https://tandfonline.com/author/Harris%2C+Thomas+A'}] https://tandfonline.com/doi/abs/10.1177/036215377100100110 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100110 02 Jan 2018 59-60 https://tandfonline.com/doi/pdf/10.1177/036215377100100110 Section II: Salutes to Eric Berne A Tribute to Doctor Eric Berne 3 1
Article [{'degree': 'M.S.W.', 'name': 'Joseph P. Concannon', 'authorURL': 'https://tandfonline.com/author/Concannon%2C+Joseph+P'}] https://tandfonline.com/doi/abs/10.1177/036215377100100111 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100111 02 Jan 2018 60-61 https://tandfonline.com/doi/pdf/10.1177/036215377100100111 Section II: Salutes to Eric Berne My Introduction to Eric Berne 1 1
Article [{'degree': 'Ph.D.', 'name': 'David Kupfer', 'authorURL': 'https://tandfonline.com/author/Kupfer%2C+David'}] https://tandfonline.com/doi/abs/10.1177/036215377100100112 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100112 02 Jan 2018 62 https://tandfonline.com/doi/pdf/10.1177/036215377100100112 Section II: Salutes to Eric Berne In the Beginning … 2 1
Article [{'degree': 'M.S.W.', 'name': 'Jules A. Levaggi', 'authorURL': 'https://tandfonline.com/author/Levaggi%2C+Jules+A'}, {'degree': 'M.A.', 'name': 'Viola Litt Callaghan', 'authorURL': 'https://tandfonline.com/author/Callaghan%2C+Viola+Litt'}, {'degree': 'M.D.', 'name': 'Charles Berger', 'authorURL': 'https://tandfonline.com/author/Berger%2C+Charles'}] 1 1 https://tandfonline.com/doi/abs/10.1177/036215377100100113 02 Jan 2018 64-70 https://tandfonline.com/doi/pdf/10.1177/036215377100100113 Section II: Salutes to Eric Berne A Living Euhemerus Never Dies 2 1
Article [{'degree': 'B.A.', 'name': 'Aaron Wolfe Schiff', 'authorURL': 'https://tandfonline.com/author/Schiff%2C+Aaron+Wolfe'}, {'degree': 'M.S.S.W.', 'name': 'Jacqui Lee Schiff', 'authorURL': 'https://tandfonline.com/author/Lee+Schiff%2C+Jacqui'}] 74 1 https://tandfonline.com/doi/abs/10.1177/036215377100100114 02 Jan 2018 71-78 https://tandfonline.com/doi/pdf/10.1177/036215377100100114 Section III: Scientific Paper Passivity 45 1
Article [{'degree': 'M.D.', 'name': 'Stephen Karpman', 'authorURL': 'https://tandfonline.com/author/Karpman%2C+Stephen'}] 30 1 https://tandfonline.com/doi/abs/10.1177/036215377100100115 02 Jan 2018 79-87 https://tandfonline.com/doi/pdf/10.1177/036215377100100115 https://tandfonline.com/doi/ref/10.1177/036215377100100115 Section III: Scientific Paper Options 26 1
Article [{'degree': 'Ed.D.', 'name': 'Muriel M. James', 'authorURL': 'https://tandfonline.com/author/James%2C+Muriel+M'}] 4 1 https://tandfonline.com/doi/abs/10.1177/036215377100100116 02 Jan 2018 88-94 https://tandfonline.com/doi/pdf/10.1177/036215377100100116 https://tandfonline.com/doi/ref/10.1177/036215377100100116 Section III: Scientific Paper Curing Impotency with Transactional Analysis 2 1
Article [{'degree': 'M.D.', 'name': 'Solon D. Samuels', 'authorURL': 'https://tandfonline.com/author/Samuels%2C+Solon+D'}] 3 1 https://tandfonline.com/doi/abs/10.1177/036215377100100117 02 Jan 2018 95-99 https://tandfonline.com/doi/pdf/10.1177/036215377100100117 Section III: Scientific Paper Games Therapists Play 8 1
Article [{'name': 'Polly Parker', 'authorURL': 'https://tandfonline.com/author/Parker%2C+Polly'}] 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100118 02 Jan 2018 100-104 https://tandfonline.com/doi/pdf/10.1177/036215377100100118 Section III: Scientific Paper 1970 Summer Conference Proceedings: Part II 1 1
Article https://tandfonline.com/doi/abs/10.1177/036215377100100119 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100119 02 Jan 2018 105 https://tandfonline.com/doi/pdf/10.1177/036215377100100119 Section IV: The ITAA ITAA Personalities in the News 1 1
Article https://tandfonline.com/doi/abs/10.1177/036215377100100120 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100120 02 Jan 2018 106 https://tandfonline.com/doi/pdf/10.1177/036215377100100120 Section IV: The ITAA News of the Affiliates 0 1
Article [{'name': 'Arthur Rissman', 'authorURL': 'https://tandfonline.com/author/Rissman%2C+Arthur'}] https://tandfonline.com/doi/abs/10.1177/036215377100100121 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100121 02 Jan 2018 107 https://tandfonline.com/doi/pdf/10.1177/036215377100100121 Section V: Department Brief Communications 1 1
Article [{'degree': 'M.D.', 'name': 'Roberto Kertesz', 'authorURL': 'https://tandfonline.com/author/Kertesz%2C+Roberto'}] https://tandfonline.com/doi/abs/10.1177/036215377100100122 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100122 02 Jan 2018 108 https://tandfonline.com/doi/pdf/10.1177/036215377100100122 Section V: Department Resemblance between the Alcoholic and the Obesity Games 2 1
book review [{'name': 'Helen Colton', 'authorURL': 'https://tandfonline.com/author/Colton%2C+Helen'}] https://tandfonline.com/doi/abs/10.1177/036215377100100123 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100123 02 Jan 2018 108-109 https://tandfonline.com/doi/pdf/10.1177/036215377100100123 Book Review Book Review: Please Touch 2 1
Article https://tandfonline.com/doi/abs/10.1177/036215377100100124 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100124 02 Jan 2018 109-110 https://tandfonline.com/doi/pdf/10.1177/036215377100100124 Section V: Department Transactional Pubs 0 1
Article 0 1 https://tandfonline.com/doi/abs/10.1177/036215377100100125 02 Jan 2018 111-115 https://tandfonline.com/doi/pdf/10.1177/036215377100100125 Section V: Department Authors 0 1
Article [{'degree': 'M.D.', 'name': 'Ken Everts', 'authorURL': 'https://tandfonline.com/author/Everts%2C+Ken'}] https://tandfonline.com/doi/abs/10.1177/036215377100100201 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100201 28 Dec 2017 4 https://tandfonline.com/doi/pdf/10.1177/036215377100100201 The President's Page The President's Page 0 1
editorial https://tandfonline.com/doi/abs/10.1177/036215377100100202 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100202 28 Dec 2017 5 https://tandfonline.com/doi/pdf/10.1177/036215377100100202 Editorial Policy of the TAJ Editorial Policy of the TAJ 1 1
Article [{'name': 'Polly Parker', 'authorURL': 'https://tandfonline.com/author/Parker%2C+Polly'}] https://tandfonline.com/doi/abs/10.1177/036215377100100203 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100203 28 Dec 2017 6-7 https://tandfonline.com/doi/pdf/10.1177/036215377100100203 Section I: David Kupfer Memorial David Kupfer, 1910–1971 1 1
Article https://tandfonline.com/doi/abs/10.1177/036215377100100204 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100204 28 Dec 2017 8-9 https://tandfonline.com/doi/pdf/10.1177/036215377100100204 https://tandfonline.com/doi/ref/10.1177/036215377100100204 Section I: David Kupfer Memorial A Tribute to David Kupfer 0 1
Article [{'degree': 'Ph.D.', 'name': 'David Kupfer', 'authorURL': 'https://tandfonline.com/author/Kupfer%2C+David'}, {'degree': 'Ph.D.', 'name': 'Morris Haimowitz', 'authorURL': 'https://tandfonline.com/author/Haimowitz%2C+Morris'}] 19 2 https://tandfonline.com/doi/abs/10.1177/036215377100100205 28 Dec 2017 10-16 https://tandfonline.com/doi/pdf/10.1177/036215377100100205 Section II: Feature Article Therapeutic Interventions Part I. Rubberbands Now 13 1
Article [{'name': 'Samuel N. Park Jr.', 'authorURL': 'https://tandfonline.com/author/Park%2C+Samuel+N+Jr'}] https://tandfonline.com/doi/abs/10.1177/036215377100100206 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100206 28 Dec 2017 17-18 https://tandfonline.com/doi/pdf/10.1177/036215377100100206 Section III: Paper Sir Lancelot or the Beautiful Wife Game 2 1
Article [{'degree': 'M.D.', 'name': 'Martin G. Groder', 'authorURL': 'https://tandfonline.com/author/Groder%2C+Martin+G'}] https://tandfonline.com/doi/abs/10.1177/036215377100100207 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100207 28 Dec 2017 19-20 https://tandfonline.com/doi/pdf/10.1177/036215377100100207 Section III: Paper Kiud 2 1
Article [{'name': 'Hedges Capers', 'authorURL': 'https://tandfonline.com/author/Capers%2C+Hedges'}] https://tandfonline.com/doi/abs/10.1177/036215377100100208 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100208 28 Dec 2017 21 https://tandfonline.com/doi/pdf/10.1177/036215377100100208 Section III: Paper No Place for Critical Parent 2 1
Article [{'name': 'Bob Mott', 'authorURL': 'https://tandfonline.com/author/Mott%2C+Bob'}] https://tandfonline.com/doi/abs/10.1177/036215377100100209 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100209 28 Dec 2017 21-22 https://tandfonline.com/doi/pdf/10.1177/036215377100100209 Section III: Paper “Let down” a Variation of “Kick Me” 2 1
Article [{'name': 'Hedges Capers', 'authorURL': 'https://tandfonline.com/author/Capers%2C+Hedges'}, {'name': 'Glen Holland', 'authorURL': 'https://tandfonline.com/author/Holland%2C+Glen'}] https://tandfonline.com/doi/abs/10.1177/036215377100100210 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100210 28 Dec 2017 22-23 https://tandfonline.com/doi/pdf/10.1177/036215377100100210 Section III: Paper Zapped by Getting Better – “Sorry, Too Late” (NIGYSOB) 1 1
Article [{'degree': 'Ph. D.', 'name': 'Natalie Haimowitz', 'authorURL': 'https://tandfonline.com/author/Haimowitz%2C+Natalie'}] 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100211 28 Dec 2017 23-28 https://tandfonline.com/doi/pdf/10.1177/036215377100100211 Section III: Paper Fairytale Scripts in TA Therapists the Powerful, Adapted Child of the Therapist 11 1
Article [{'name': 'Richard H. Lee', 'authorURL': 'https://tandfonline.com/author/Lee%2C+Richard+H'}] 2 2 https://tandfonline.com/doi/abs/10.1177/036215377100100212 28 Dec 2017 28-31 https://tandfonline.com/doi/pdf/10.1177/036215377100100212 Section III: Paper The Psychotherapist as Rescuer 9 1
Article [{'degree': 'M.D.', 'name': 'Franklin H. Ernst Jr.', 'authorURL': 'https://tandfonline.com/author/Ernst%2C+Franklin+H+Jr'}] https://tandfonline.com/doi/abs/10.1177/036215377100100213 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100213 28 Dec 2017 32 https://tandfonline.com/doi/pdf/10.1177/036215377100100213 Section IV: The ITAA TA Collector's Corner 1 1
Article 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100214 28 Dec 2017 32-34 https://tandfonline.com/doi/pdf/10.1177/036215377100100214 Section IV: The ITAA News of Affiliates 0 1
https://tandfonline.com/doi/abs/10.1177/036215377100100215 0 2 https://tandfonline.com/doi/abs/10.1177/036215377100100215 28 Dec 2017 35 https://tandfonline.com/doi/pdf/10.1177/036215377100100215 Errata Errata 0 1
Article [{'role': '(President)', 'degree': 'M.D.', 'name': 'Ken V. Everts', 'authorURL': 'https://tandfonline.com/author/Everts%2C+Ken+V'}] https://tandfonline.com/doi/abs/10.1177/036215377100100301 0 3 https://tandfonline.com/doi/abs/10.1177/036215377100100301 28 Dec 2017 4 https://tandfonline.com/doi/pdf/10.1177/036215377100100301 The President's Page The President's Page 0 1
Article [{'role': '(Executive Secretary)', 'name': 'Donald C. Westlake', 'authorURL': 'https://tandfonline.com/author/Westlake%2C+Donald+C'}] https://tandfonline.com/doi/abs/10.1177/036215377100100302 0 3 https://tandfonline.com/doi/abs/10.1177/036215377100100302 28 Dec 2017 5 https://tandfonline.com/doi/pdf/10.1177/036215377100100302 Executive Secretary's Report Executive Secretary's Report 0 1
https://tandfonline.com/doi/abs/10.1177/036215377100100303 0 3 https://tandfonline.com/doi/abs/10.1177/036215377100100303 28 Dec 2017 6 https://tandfonline.com/doi/pdf/10.1177/036215377100100303 The Annual Eric Berne Memorial Scientific Award The Annual Eric Berne Memorial Scientific Award 1 1
editorial https://tandfonline.com/doi/abs/10.1177/036215377100100304 0 3 https://tandfonline.com/doi/abs/10.1177/036215377100100304 28 Dec 2017 7-8 https://tandfonline.com/doi/pdf/10.1177/036215377100100304 Editorial Editorial 1 1
Article [{'degree': 'M. D.', 'name': 'Claude M. Steiner', 'authorURL': 'https://tandfonline.com/author/Steiner%2C+Claude+M'}] 22 3 https://tandfonline.com/doi/abs/10.1177/036215377100100305 28 Dec 2017 9-15 https://tandfonline.com/doi/pdf/10.1177/036215377100100305 https://tandfonline.com/doi/ref/10.1177/036215377100100305 Section I: Feature Article The Stroke Economy 17 1
Article [{'name': 'Hogie Wyckoff', 'authorURL': 'https://tandfonline.com/author/Wyckoff%2C+Hogie'}] 5 3 https://tandfonline.com/doi/abs/10.1177/036215377100100306 28 Dec 2017 16-20 https://tandfonline.com/doi/pdf/10.1177/036215377100100306 https://tandfonline.com/doi/ref/10.1177/036215377100100306 Section II: Papers The Stroke Economy in Women's Scripts 6 1
Article [{'degree': 'M.D.', 'name': 'John M. Dusay', 'authorURL': 'https://tandfonline.com/author/Dusay%2C+John+M'}] https://tandfonline.com/doi/abs/10.1177/036215377100100307 1 3 https://tandfonline.com/doi/abs/10.1177/036215377100100307 28 Dec 2017 21-22 https://tandfonline.com/doi/pdf/10.1177/036215377100100307 https://tandfonline.com/doi/ref/10.1177/036215377100100307 Section II: Papers Big Mama 4 1
Article [{'degree': 'M.D.', 'name': 'Solon D. Samuels', 'authorURL': 'https://tandfonline.com/author/Samuels%2C+Solon+D'}] https://tandfonline.com/doi/abs/10.1177/036215377100100308 3 3 https://tandfonline.com/doi/abs/10.1177/036215377100100308 28 Dec 2017 23-24 https://tandfonline.com/doi/pdf/10.1177/036215377100100308 Section II: Papers Stroke Strategy: I. The Basis of Therapy 7 1
Article [{'name': 'Helen Colton', 'authorURL': 'https://tandfonline.com/author/Colton%2C+Helen'}] https://tandfonline.com/doi/abs/10.1177/036215377100100309 0 3 https://tandfonline.com/doi/abs/10.1177/036215377100100309 28 Dec 2017 25-26 https://tandfonline.com/doi/pdf/10.1177/036215377100100309 Section II: Papers “You Should Only Choke on Your Stroke, Knock on Wood” 2 1
Article [{'degree': 'M.S.W.', 'name': 'Fanita English', 'authorURL': 'https://tandfonline.com/author/English%2C+Fanita'}] https://tandfonline.com/doi/abs/10.1177/036215377100100310 2 3 https://tandfonline.com/doi/abs/10.1177/036215377100100310 28 Dec 2017 27-28 https://tandfonline.com/doi/pdf/10.1177/036215377100100310 Section II: Papers Strokes in the Credit Bank for David Kupper 3 1
Display the source blob
Display the rendered blob
Raw
transactional scrape.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"from bs4 import BeautifulSoup\n",
"from collections import OrderedDict\n",
"import csv\n",
"\n",
"import requests\n",
"from requests.exceptions import RequestException\n",
"from contextlib import closing\n",
"import pandas as pd\n",
"import os"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# rough work, skip to next heading"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"url = 'https://tandfonline.com/toc/rtaj20/1/1'"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"r = requests.get(url, allow_redirects=True)\n",
"soup = BeautifulSoup( r.content, 'lxml')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"a = soup.select_one('.tocContent')\n",
"print(str(len(a)))"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"scrolled": true
},
"outputs": [],
"source": [
"for child in a.children:\n",
" print(child.name)\n",
" #if child.find('.tocHeading'):\n",
" #print(child.find('.tocHeading'))"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"a = soup.select_one('.tocHeading')\n",
"print(a)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"a = a.next_sibling\n",
"a"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"b = a.select('.subj-group')\n",
"b.name"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"a.name"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# downloading the issue pages"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"def downloadPage(url,name):\n",
"\tif os.path.exists(name) :\n",
"\t\tprint('skipping '+name + ' as its already been downloaded.')\n",
"\t\treturn\n",
"\tprint('downloading '+url)\n",
"\tr = requests.get(url, allow_redirects=True)\n",
"\tif r.status_code == 404 or len(r.content) < 1000 :\n",
"\t\tprint(url + ' not found, skipping')\n",
"\t\treturn\n",
"\twith open(name, 'wb') as f:\n",
"\t\tf.write(r.content)\n",
"\tprint( 'Created '+name )\n"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"issuesFolder = 'issues/'"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"skipping issues/1_1.html as its already been downloaded.\n",
"skipping issues/1_2.html as its already been downloaded.\n",
"skipping issues/1_3.html as its already been downloaded.\n",
"skipping issues/1_4.html as its already been downloaded.\n",
"skipping issues/2_1.html as its already been downloaded.\n",
"skipping issues/2_2.html as its already been downloaded.\n",
"skipping issues/2_3.html as its already been downloaded.\n",
"skipping issues/2_4.html as its already been downloaded.\n",
"skipping issues/3_1.html as its already been downloaded.\n",
"skipping issues/3_2.html as its already been downloaded.\n",
"skipping issues/3_3.html as its already been downloaded.\n",
"skipping issues/3_4.html as its already been downloaded.\n",
"skipping issues/4_1.html as its already been downloaded.\n",
"skipping issues/4_2.html as its already been downloaded.\n",
"skipping issues/4_3.html as its already been downloaded.\n",
"skipping issues/4_4.html as its already been downloaded.\n",
"skipping issues/5_1.html as its already been downloaded.\n",
"skipping issues/5_2.html as its already been downloaded.\n",
"skipping issues/5_3.html as its already been downloaded.\n",
"skipping issues/5_4.html as its already been downloaded.\n",
"skipping issues/6_1.html as its already been downloaded.\n",
"skipping issues/6_2.html as its already been downloaded.\n",
"skipping issues/6_3.html as its already been downloaded.\n",
"skipping issues/6_4.html as its already been downloaded.\n",
"skipping issues/7_1.html as its already been downloaded.\n",
"skipping issues/7_2.html as its already been downloaded.\n",
"skipping issues/7_3.html as its already been downloaded.\n",
"skipping issues/7_4.html as its already been downloaded.\n",
"skipping issues/8_1.html as its already been downloaded.\n",
"skipping issues/8_2.html as its already been downloaded.\n",
"skipping issues/8_3.html as its already been downloaded.\n",
"skipping issues/8_4.html as its already been downloaded.\n",
"skipping issues/9_1.html as its already been downloaded.\n",
"skipping issues/9_2.html as its already been downloaded.\n",
"skipping issues/9_3.html as its already been downloaded.\n",
"skipping issues/9_4.html as its already been downloaded.\n",
"skipping issues/10_1.html as its already been downloaded.\n",
"skipping issues/10_2.html as its already been downloaded.\n",
"skipping issues/10_3.html as its already been downloaded.\n",
"skipping issues/10_4.html as its already been downloaded.\n",
"skipping issues/11_1.html as its already been downloaded.\n",
"skipping issues/11_2.html as its already been downloaded.\n",
"skipping issues/11_3.html as its already been downloaded.\n",
"skipping issues/11_4.html as its already been downloaded.\n",
"skipping issues/12_1.html as its already been downloaded.\n",
"skipping issues/12_2.html as its already been downloaded.\n",
"skipping issues/12_3.html as its already been downloaded.\n",
"skipping issues/12_4.html as its already been downloaded.\n",
"skipping issues/13_1.html as its already been downloaded.\n",
"skipping issues/13_2.html as its already been downloaded.\n",
"skipping issues/13_3.html as its already been downloaded.\n",
"skipping issues/13_4.html as its already been downloaded.\n",
"skipping issues/14_1.html as its already been downloaded.\n",
"skipping issues/14_2.html as its already been downloaded.\n",
"skipping issues/14_3.html as its already been downloaded.\n",
"skipping issues/14_4.html as its already been downloaded.\n",
"skipping issues/15_1.html as its already been downloaded.\n",
"skipping issues/15_2.html as its already been downloaded.\n",
"skipping issues/15_3.html as its already been downloaded.\n",
"skipping issues/15_4.html as its already been downloaded.\n",
"skipping issues/16_1.html as its already been downloaded.\n",
"skipping issues/16_2.html as its already been downloaded.\n",
"skipping issues/16_3.html as its already been downloaded.\n",
"skipping issues/16_4.html as its already been downloaded.\n",
"skipping issues/17_1.html as its already been downloaded.\n",
"skipping issues/17_2.html as its already been downloaded.\n",
"skipping issues/17_3.html as its already been downloaded.\n",
"skipping issues/17_4.html as its already been downloaded.\n",
"skipping issues/18_1.html as its already been downloaded.\n",
"skipping issues/18_2.html as its already been downloaded.\n",
"skipping issues/18_3.html as its already been downloaded.\n",
"skipping issues/18_4.html as its already been downloaded.\n",
"skipping issues/19_1.html as its already been downloaded.\n",
"skipping issues/19_2.html as its already been downloaded.\n",
"skipping issues/19_3.html as its already been downloaded.\n",
"skipping issues/19_4.html as its already been downloaded.\n",
"skipping issues/20_1.html as its already been downloaded.\n",
"skipping issues/20_2.html as its already been downloaded.\n",
"skipping issues/20_3.html as its already been downloaded.\n",
"skipping issues/20_4.html as its already been downloaded.\n",
"skipping issues/21_1.html as its already been downloaded.\n",
"skipping issues/21_2.html as its already been downloaded.\n",
"skipping issues/21_3.html as its already been downloaded.\n",
"skipping issues/21_4.html as its already been downloaded.\n",
"skipping issues/22_1.html as its already been downloaded.\n",
"skipping issues/22_2.html as its already been downloaded.\n",
"skipping issues/22_3.html as its already been downloaded.\n",
"skipping issues/22_4.html as its already been downloaded.\n",
"skipping issues/23_1.html as its already been downloaded.\n",
"skipping issues/23_2.html as its already been downloaded.\n",
"skipping issues/23_3.html as its already been downloaded.\n",
"skipping issues/23_4.html as its already been downloaded.\n",
"skipping issues/24_1.html as its already been downloaded.\n",
"skipping issues/24_2.html as its already been downloaded.\n",
"skipping issues/24_3.html as its already been downloaded.\n",
"skipping issues/24_4.html as its already been downloaded.\n",
"skipping issues/25_1.html as its already been downloaded.\n",
"skipping issues/25_2.html as its already been downloaded.\n",
"skipping issues/25_3.html as its already been downloaded.\n",
"skipping issues/25_4.html as its already been downloaded.\n",
"skipping issues/26_1.html as its already been downloaded.\n",
"skipping issues/26_2.html as its already been downloaded.\n",
"skipping issues/26_3.html as its already been downloaded.\n",
"skipping issues/26_4.html as its already been downloaded.\n",
"skipping issues/27_1.html as its already been downloaded.\n",
"skipping issues/27_2.html as its already been downloaded.\n",
"skipping issues/27_3.html as its already been downloaded.\n",
"skipping issues/27_4.html as its already been downloaded.\n",
"skipping issues/28_1.html as its already been downloaded.\n",
"skipping issues/28_2.html as its already been downloaded.\n",
"skipping issues/28_3.html as its already been downloaded.\n",
"skipping issues/28_4.html as its already been downloaded.\n",
"skipping issues/29_1.html as its already been downloaded.\n",
"skipping issues/29_2.html as its already been downloaded.\n",
"skipping issues/29_3.html as its already been downloaded.\n",
"skipping issues/29_4.html as its already been downloaded.\n",
"skipping issues/30_1.html as its already been downloaded.\n",
"skipping issues/30_2.html as its already been downloaded.\n",
"skipping issues/30_3.html as its already been downloaded.\n",
"skipping issues/30_4.html as its already been downloaded.\n",
"skipping issues/31_1.html as its already been downloaded.\n",
"skipping issues/31_2.html as its already been downloaded.\n",
"skipping issues/31_3.html as its already been downloaded.\n",
"skipping issues/31_4.html as its already been downloaded.\n",
"skipping issues/32_1.html as its already been downloaded.\n",
"skipping issues/32_2.html as its already been downloaded.\n",
"skipping issues/32_3.html as its already been downloaded.\n",
"skipping issues/32_4.html as its already been downloaded.\n",
"skipping issues/33_1.html as its already been downloaded.\n",
"skipping issues/33_2.html as its already been downloaded.\n",
"skipping issues/33_3.html as its already been downloaded.\n",
"skipping issues/33_4.html as its already been downloaded.\n",
"skipping issues/34_1.html as its already been downloaded.\n",
"skipping issues/34_2.html as its already been downloaded.\n",
"skipping issues/34_3.html as its already been downloaded.\n",
"skipping issues/34_4.html as its already been downloaded.\n",
"skipping issues/35_1.html as its already been downloaded.\n",
"skipping issues/35_2.html as its already been downloaded.\n",
"skipping issues/35_3.html as its already been downloaded.\n",
"skipping issues/35_4.html as its already been downloaded.\n",
"skipping issues/36_1.html as its already been downloaded.\n",
"skipping issues/36_2.html as its already been downloaded.\n",
"skipping issues/36_3.html as its already been downloaded.\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"skipping issues/36_4.html as its already been downloaded.\n",
"skipping issues/37_1.html as its already been downloaded.\n",
"skipping issues/37_2.html as its already been downloaded.\n",
"skipping issues/37_3.html as its already been downloaded.\n",
"skipping issues/37_4.html as its already been downloaded.\n",
"skipping issues/38_1.html as its already been downloaded.\n",
"skipping issues/38_2.html as its already been downloaded.\n",
"skipping issues/38_3.html as its already been downloaded.\n",
"skipping issues/38_4.html as its already been downloaded.\n",
"skipping issues/39_1.html as its already been downloaded.\n",
"skipping issues/39_2.html as its already been downloaded.\n",
"skipping issues/39_3.html as its already been downloaded.\n",
"skipping issues/39_4.html as its already been downloaded.\n",
"skipping issues/40_1.html as its already been downloaded.\n",
"skipping issues/40_2.html as its already been downloaded.\n",
"skipping issues/40_3.html as its already been downloaded.\n",
"downloading https://tandfonline.com/toc/rtaj20/40/4\n",
"https://tandfonline.com/toc/rtaj20/40/4 not found, skipping\n",
"skipping issues/41_1.html as its already been downloaded.\n",
"skipping issues/41_2.html as its already been downloaded.\n",
"skipping issues/41_3.html as its already been downloaded.\n",
"skipping issues/41_4.html as its already been downloaded.\n",
"skipping issues/42_1.html as its already been downloaded.\n",
"skipping issues/42_2.html as its already been downloaded.\n",
"skipping issues/42_3.html as its already been downloaded.\n",
"skipping issues/42_4.html as its already been downloaded.\n",
"skipping issues/43_1.html as its already been downloaded.\n",
"skipping issues/43_2.html as its already been downloaded.\n",
"skipping issues/43_3.html as its already been downloaded.\n",
"skipping issues/43_4.html as its already been downloaded.\n",
"skipping issues/44_1.html as its already been downloaded.\n",
"skipping issues/44_2.html as its already been downloaded.\n",
"skipping issues/44_3.html as its already been downloaded.\n",
"skipping issues/44_4.html as its already been downloaded.\n",
"skipping issues/45_1.html as its already been downloaded.\n",
"skipping issues/45_2.html as its already been downloaded.\n",
"skipping issues/45_3.html as its already been downloaded.\n",
"skipping issues/45_4.html as its already been downloaded.\n",
"skipping issues/46_1.html as its already been downloaded.\n",
"skipping issues/46_2.html as its already been downloaded.\n",
"skipping issues/46_3.html as its already been downloaded.\n",
"skipping issues/46_4.html as its already been downloaded.\n",
"skipping issues/47_1.html as its already been downloaded.\n",
"skipping issues/47_2.html as its already been downloaded.\n",
"skipping issues/47_3.html as its already been downloaded.\n",
"skipping issues/47_4.html as its already been downloaded.\n",
"skipping issues/48_1.html as its already been downloaded.\n",
"skipping issues/48_2.html as its already been downloaded.\n",
"skipping issues/48_3.html as its already been downloaded.\n",
"downloading https://tandfonline.com/toc/rtaj20/48/4\n",
"https://tandfonline.com/toc/rtaj20/48/4 not found, skipping\n"
]
}
],
"source": [
"for volume in range(1,49):\n",
" for issue in range(1,5):\n",
" url = 'https://tandfonline.com/toc/rtaj20/'+str(volume)+'/'+str(issue)\n",
" name = issuesFolder + str(volume)+'_'+str(issue)+'.html'\n",
" downloadPage(url,name)\n",
" "
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### it seems there was a combined issue for 40_3 and 40_4\n",
"Naming it as 40_3.html ."
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"skipping issues/40_3.html as its already been downloaded.\n"
]
}
],
"source": [
"url = 'https://tandfonline.com/toc/rtaj20/40/3-4'\n",
"name = issuesFolder + '40_3.html'\n",
"downloadPage(url,name)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Creating issue-level listing"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"opening issues/1_1.html\n",
"opening issues/1_2.html\n",
"opening issues/1_3.html\n",
"opening issues/1_4.html\n",
"opening issues/2_1.html\n",
"opening issues/2_2.html\n",
"opening issues/2_3.html\n",
"opening issues/2_4.html\n",
"opening issues/3_1.html\n",
"opening issues/3_2.html\n",
"opening issues/3_3.html\n",
"opening issues/3_4.html\n",
"opening issues/4_1.html\n",
"opening issues/4_2.html\n",
"opening issues/4_3.html\n",
"opening issues/4_4.html\n",
"opening issues/5_1.html\n",
"opening issues/5_2.html\n",
"opening issues/5_3.html\n",
"opening issues/5_4.html\n",
"opening issues/6_1.html\n",
"opening issues/6_2.html\n",
"opening issues/6_3.html\n",
"opening issues/6_4.html\n",
"opening issues/7_1.html\n",
"opening issues/7_2.html\n",
"opening issues/7_3.html\n",
"opening issues/7_4.html\n",
"opening issues/8_1.html\n",
"opening issues/8_2.html\n",
"opening issues/8_3.html\n",
"opening issues/8_4.html\n",
"opening issues/9_1.html\n",
"opening issues/9_2.html\n",
"opening issues/9_3.html\n",
"opening issues/9_4.html\n",
"opening issues/10_1.html\n",
"opening issues/10_2.html\n",
"opening issues/10_3.html\n",
"opening issues/10_4.html\n",
"opening issues/11_1.html\n",
"opening issues/11_2.html\n",
"opening issues/11_3.html\n",
"opening issues/11_4.html\n",
"opening issues/12_1.html\n",
"opening issues/12_2.html\n",
"opening issues/12_3.html\n",
"opening issues/12_4.html\n",
"opening issues/13_1.html\n",
"opening issues/13_2.html\n",
"opening issues/13_3.html\n",
"opening issues/13_4.html\n",
"opening issues/14_1.html\n",
"opening issues/14_2.html\n",
"opening issues/14_3.html\n",
"opening issues/14_4.html\n",
"opening issues/15_1.html\n",
"opening issues/15_2.html\n",
"opening issues/15_3.html\n",
"opening issues/15_4.html\n",
"opening issues/16_1.html\n",
"opening issues/16_2.html\n",
"opening issues/16_3.html\n",
"opening issues/16_4.html\n",
"opening issues/17_1.html\n",
"opening issues/17_2.html\n",
"opening issues/17_3.html\n",
"opening issues/17_4.html\n",
"opening issues/18_1.html\n",
"opening issues/18_2.html\n",
"opening issues/18_3.html\n",
"opening issues/18_4.html\n",
"opening issues/19_1.html\n",
"opening issues/19_2.html\n",
"opening issues/19_3.html\n",
"opening issues/19_4.html\n",
"opening issues/20_1.html\n",
"opening issues/20_2.html\n",
"opening issues/20_3.html\n",
"opening issues/20_4.html\n",
"opening issues/21_1.html\n",
"opening issues/21_2.html\n",
"opening issues/21_3.html\n",
"opening issues/21_4.html\n",
"opening issues/22_1.html\n",
"opening issues/22_2.html\n",
"opening issues/22_3.html\n",
"opening issues/22_4.html\n",
"opening issues/23_1.html\n",
"opening issues/23_2.html\n",
"opening issues/23_3.html\n",
"opening issues/23_4.html\n",
"opening issues/24_1.html\n",
"opening issues/24_2.html\n",
"opening issues/24_3.html\n",
"opening issues/24_4.html\n",
"opening issues/25_1.html\n",
"opening issues/25_2.html\n",
"opening issues/25_3.html\n",
"opening issues/25_4.html\n",
"opening issues/26_1.html\n",
"opening issues/26_2.html\n",
"opening issues/26_3.html\n",
"opening issues/26_4.html\n",
"opening issues/27_1.html\n",
"opening issues/27_2.html\n",
"opening issues/27_3.html\n",
"opening issues/27_4.html\n",
"opening issues/28_1.html\n",
"opening issues/28_2.html\n",
"opening issues/28_3.html\n",
"opening issues/28_4.html\n",
"opening issues/29_1.html\n",
"opening issues/29_2.html\n",
"opening issues/29_3.html\n",
"opening issues/29_4.html\n",
"opening issues/30_1.html\n",
"opening issues/30_2.html\n",
"opening issues/30_3.html\n",
"opening issues/30_4.html\n",
"opening issues/31_1.html\n",
"opening issues/31_2.html\n",
"opening issues/31_3.html\n",
"opening issues/31_4.html\n",
"opening issues/32_1.html\n",
"opening issues/32_2.html\n",
"opening issues/32_3.html\n",
"opening issues/32_4.html\n",
"opening issues/33_1.html\n",
"opening issues/33_2.html\n",
"opening issues/33_3.html\n",
"opening issues/33_4.html\n",
"opening issues/34_1.html\n",
"opening issues/34_2.html\n",
"opening issues/34_3.html\n",
"opening issues/34_4.html\n",
"opening issues/35_1.html\n",
"opening issues/35_2.html\n",
"opening issues/35_3.html\n",
"opening issues/35_4.html\n",
"opening issues/36_1.html\n",
"opening issues/36_2.html\n",
"opening issues/36_3.html\n",
"opening issues/36_4.html\n",
"opening issues/37_1.html\n",
"opening issues/37_2.html\n",
"opening issues/37_3.html\n",
"opening issues/37_4.html\n",
"opening issues/38_1.html\n",
"opening issues/38_2.html\n",
"opening issues/38_3.html\n",
"opening issues/38_4.html\n",
"opening issues/39_1.html\n",
"opening issues/39_2.html\n",
"opening issues/39_3.html\n",
"opening issues/39_4.html\n",
"opening issues/40_1.html\n",
"opening issues/40_2.html\n",
"opening issues/40_3.html\n",
"issues/40_4.html not found\n",
"opening issues/41_1.html\n",
"opening issues/41_2.html\n",
"opening issues/41_3.html\n",
"opening issues/41_4.html\n",
"opening issues/42_1.html\n",
"opening issues/42_2.html\n",
"opening issues/42_3.html\n",
"opening issues/42_4.html\n",
"opening issues/43_1.html\n",
"opening issues/43_2.html\n",
"opening issues/43_3.html\n",
"opening issues/43_4.html\n",
"opening issues/44_1.html\n",
"opening issues/44_2.html\n",
"opening issues/44_3.html\n",
"opening issues/44_4.html\n",
"opening issues/45_1.html\n",
"opening issues/45_2.html\n",
"opening issues/45_3.html\n",
"opening issues/45_4.html\n",
"opening issues/46_1.html\n",
"opening issues/46_2.html\n",
"opening issues/46_3.html\n",
"opening issues/46_4.html\n",
"opening issues/47_1.html\n",
"opening issues/47_2.html\n",
"opening issues/47_3.html\n",
"opening issues/47_4.html\n",
"opening issues/48_1.html\n",
"opening issues/48_2.html\n",
"opening issues/48_3.html\n",
"issues/48_4.html not found\n"
]
}
],
"source": [
"# initiating\n",
"collector = []\n",
"authorsCollector = []\n",
"currentSubject = ''\n",
"counter = 0\n",
"siteURL = 'https://tandfonline.com'\n",
"\n",
"for volume in range(1,49):\n",
" for issue in range(1,5):\n",
" filename = issuesFolder + str(volume) + '_' + str(issue) + '.html'\n",
" if not os.path.exists(filename):\n",
" print(filename,'not found')\n",
" continue\n",
" print('opening',filename)\n",
" with open(filename, 'rb') as f:\n",
" soup = BeautifulSoup( f , 'lxml')\n",
" \n",
" # get the year\n",
" volYear = soup.select_one('a.expander.open').span.find_next_sibling('span').get_text().strip()\n",
" \n",
" # start work on the repeating units\n",
" holder = soup.select_one('.tocContent')\n",
" for item in holder.children:\n",
" if item.name is None:\n",
" continue\n",
" row = {}\n",
" row['year'] = volYear\n",
" row['volume'] = volume\n",
" row['issue'] = issue\n",
" if item.name == 'div':\n",
" currentSubject = item.select_one('.subj-group').text\n",
" continue\n",
" row['subject'] = currentSubject\n",
" if item.name != 'table':\n",
" print('warning: in {}, child item is neither div nor table.'.format(filename))\n",
" continue\n",
" # come children gather around\n",
" if item.select_one('.article-type'):\n",
" row['article-type'] = item.select_one('.article-type').get_text().strip()\n",
" \n",
" titleHolder = item.select_one('.art_title.linkable')\n",
" row['title'] = titleHolder.select_one('.hlFld-Title').get_text().strip()\n",
" row['link'] = siteURL + titleHolder.a.get('href')\n",
" \n",
" # store the doi number\n",
" row['doi'] = row['link'][32:]\n",
" \n",
" authorsHolder = item.select_one('.articleEntryAuthorsLinks')\n",
" if authorsHolder is not None:\n",
" authorsDict = []\n",
" spans = authorsHolder.find_all('span')\n",
" authRow = {}\n",
" for authItem in spans:\n",
" if authItem.select_one('a') is not None:\n",
" if len(authRow):\n",
" authorsDict.append(authRow)\n",
" authRow = {}\n",
" authRow['name'] = authItem.a.text\n",
" authRow['authorURL'] = siteURL + authItem.a.get('href')\n",
"\n",
" if authItem.get(\"class\") is not None:\n",
" if 'NLM_degrees' in authItem.get(\"class\"):\n",
" authRow['degree'] = authItem.text\n",
" if 'role' in authItem.get(\"class\"):\n",
" authRow['role'] = authItem.text.strip()\n",
" authorsDict.append(authRow); # last one\n",
" row['authors'] = authorsDict\n",
" \n",
" if item.select_one('.tocPageRange'):\n",
" row['pages'] = item.select_one('.tocPageRange').get_text().replace('Pages:','').replace('Page:','').strip()\n",
" \n",
" if item.select_one('.tocEPubDate'):\n",
" row['online pub date'] = item.select_one('.tocEPubDate').get_text().replace('Published online:','').strip()\n",
" \n",
" if item.select_one('a.ref.references'):\n",
" row['references link'] = siteURL + item.select_one('a.ref.references').get('href')\n",
" \n",
" if item.select_one('a.pdf'):\n",
" row['pdf link'] = siteURL + item.select_one('a.pdf').get('href')\n",
" \n",
" if item.find('a',text='Citation'):\n",
" row['citations link'] = siteURL + item.find('a',text='Citation').get('href')\n",
" \n",
" if item.find('a',text='Abstract'):\n",
" row['abstract'] = siteURL + item.find('a',text='Abstract').get('href')\n",
" \n",
" # scores\n",
" scoreBoard = item.select_one('.altmetric-score').find_all('li')\n",
" row['views'] = scoreBoard[0].span.get_text()\n",
" row['cross-ref citations'] = scoreBoard[1].span.get_text()\n",
" # print(scoreBoard[2])\n",
" #print(scoreBoard[2].span)\n",
" # row['altmetric'] = scoreBoard[2].span.get_text()\n",
" # looks like this value might be getting populated after the html loads. Leave it for now.\n",
" \n",
" collector.append(row)\n",
" counter += 1\n",
" #if counter >= 100: break\n",
" #if counter >= 100: break\n",
" #if counter >= 100: break"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [],
"source": [
"### limiting loop to 50 during testing, will remove limit for full"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"2826\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>abstract</th>\n",
" <th>article-type</th>\n",
" <th>authors</th>\n",
" <th>citations link</th>\n",
" <th>cross-ref citations</th>\n",
" <th>doi</th>\n",
" <th>issue</th>\n",
" <th>link</th>\n",
" <th>online pub date</th>\n",
" <th>pages</th>\n",
" <th>pdf link</th>\n",
" <th>references link</th>\n",
" <th>subject</th>\n",
" <th>title</th>\n",
" <th>views</th>\n",
" <th>volume</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[{'role': '(President)', 'degree': 'M.D.', 'na...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100101</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>4</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>The President's Page</td>\n",
" <td>The President's Page</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[{'name': 'Warren D. Cheney', 'authorURL': 'ht...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>1</td>\n",
" <td>10.1177/036215377100100102</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>5</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Introducing the Transactional Analysis Journal</td>\n",
" <td>Introducing the Transactional Analysis Journal</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.D.', 'name': 'Eric Berne', 'aut...</td>\n",
" <td>NaN</td>\n",
" <td>27</td>\n",
" <td>10.1177/036215377100100103</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>6-13</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section I: Feature Article</td>\n",
" <td>Away from a Theory of the Impact of Interperso...</td>\n",
" <td>13</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.A., M.A.', 'name': 'Warren D. C...</td>\n",
" <td>NaN</td>\n",
" <td>8</td>\n",
" <td>10.1177/036215377100100104</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>14-22</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Eric Berne Memorial</td>\n",
" <td>Eric Berne: Biographical Sketch</td>\n",
" <td>6</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'B.A., B.A.', 'name': 'Robert M. C...</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>10.1177/036215377100100105</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>23-29</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Eric Berne Memorial</td>\n",
" <td>Eric Berne: Annotated Bibliography</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100106</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>30-33</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Eric Berne Memorial</td>\n",
" <td>Eric Berne — Portfolio of Pictures</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.D.', 'name': 'John M. Dusay', '...</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>10.1177/036215377100100107</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>34-44</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1177/036215...</td>\n",
" <td>Section II: Evaluative Article</td>\n",
" <td>Eric Berne's Studies of Intuition 1949–1962</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'Ph.D.', 'name': 'Claude M. Steine...</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>10.1177/036215377100100108</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>46-48</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Evaluative Article</td>\n",
" <td>A Little Boy's Dream</td>\n",
" <td>8</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'MD.', 'name': 'Franklin H. Ernst ...</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>10.1177/036215377100100109</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>49-58</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1177/036215...</td>\n",
" <td>Section II: Evaluative Article</td>\n",
" <td>The Diagrammed Parent Eric Berne's Most Signif...</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.D.', 'name': 'Thomas A. Harris'...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100110</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>59-60</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Salutes to Eric Berne</td>\n",
" <td>A Tribute to Doctor Eric Berne</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.S.W.', 'name': 'Joseph P. Conca...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100111</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>60-61</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Salutes to Eric Berne</td>\n",
" <td>My Introduction to Eric Berne</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'Ph.D.', 'name': 'David Kupfer', '...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100112</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>62</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Salutes to Eric Berne</td>\n",
" <td>In the Beginning …</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.S.W.', 'name': 'Jules A. Levagg...</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>10.1177/036215377100100113</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>64-70</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Salutes to Eric Berne</td>\n",
" <td>A Living Euhemerus Never Dies</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'B.A.', 'name': 'Aaron Wolfe Schif...</td>\n",
" <td>NaN</td>\n",
" <td>74</td>\n",
" <td>10.1177/036215377100100114</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>71-78</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section III: Scientific Paper</td>\n",
" <td>Passivity</td>\n",
" <td>45</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.D.', 'name': 'Stephen Karpman',...</td>\n",
" <td>NaN</td>\n",
" <td>30</td>\n",
" <td>10.1177/036215377100100115</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>79-87</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1177/036215...</td>\n",
" <td>Section III: Scientific Paper</td>\n",
" <td>Options</td>\n",
" <td>26</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'Ed.D.', 'name': 'Muriel M. James'...</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>10.1177/036215377100100116</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>88-94</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1177/036215...</td>\n",
" <td>Section III: Scientific Paper</td>\n",
" <td>Curing Impotency with Transactional Analysis</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.D.', 'name': 'Solon D. Samuels'...</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>10.1177/036215377100100117</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>95-99</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section III: Scientific Paper</td>\n",
" <td>Games Therapists Play</td>\n",
" <td>8</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Polly Parker', 'authorURL': 'https:...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100118</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>100-104</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section III: Scientific Paper</td>\n",
" <td>1970 Summer Conference Proceedings: Part II</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>NaN</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100119</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>105</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section IV: The ITAA</td>\n",
" <td>ITAA Personalities in the News</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>NaN</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100120</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>106</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section IV: The ITAA</td>\n",
" <td>News of the Affiliates</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Arthur Rissman', 'authorURL': 'http...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100121</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>107</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section V: Department</td>\n",
" <td>Brief Communications</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.D.', 'name': 'Roberto Kertesz',...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100122</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>108</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section V: Department</td>\n",
" <td>Resemblance between the Alcoholic and the Obes...</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>NaN</td>\n",
" <td>book review</td>\n",
" <td>[{'name': 'Helen Colton', 'authorURL': 'https:...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100123</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>108-109</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Book Review</td>\n",
" <td>Book Review: Please Touch</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>NaN</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100124</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>109-110</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section V: Department</td>\n",
" <td>Transactional Pubs</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100125</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>02 Jan 2018</td>\n",
" <td>111-115</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section V: Department</td>\n",
" <td>Authors</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'M.D.', 'name': 'Ken Everts', 'aut...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100201</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>28 Dec 2017</td>\n",
" <td>4</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>The President's Page</td>\n",
" <td>The President's Page</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>NaN</td>\n",
" <td>editorial</td>\n",
" <td>NaN</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100202</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>28 Dec 2017</td>\n",
" <td>5</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Editorial Policy of the TAJ</td>\n",
" <td>Editorial Policy of the TAJ</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Polly Parker', 'authorURL': 'https:...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100203</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>28 Dec 2017</td>\n",
" <td>6-7</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section I: David Kupfer Memorial</td>\n",
" <td>David Kupfer, 1910–1971</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>NaN</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>0</td>\n",
" <td>10.1177/036215377100100204</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>28 Dec 2017</td>\n",
" <td>8-9</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1177/036215...</td>\n",
" <td>Section I: David Kupfer Memorial</td>\n",
" <td>A Tribute to David Kupfer</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>NaN</td>\n",
" <td>Article</td>\n",
" <td>[{'degree': 'Ph.D.', 'name': 'David Kupfer', '...</td>\n",
" <td>NaN</td>\n",
" <td>19</td>\n",
" <td>10.1177/036215377100100205</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>28 Dec 2017</td>\n",
" <td>10-16</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Section II: Feature Article</td>\n",
" <td>Therapeutic Interventions Part I. Rubberbands Now</td>\n",
" <td>13</td>\n",
" <td>1</td>\n",
" <td>1971</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2796</th>\n",
" <td>NaN</td>\n",
" <td>editorial</td>\n",
" <td>[{'name': 'Brad McLean', 'authorURL': 'https:/...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1177/0362153717725532</td>\n",
" <td>4</td>\n",
" <td>https://tandfonline.com/doi/full/10.1177/03621...</td>\n",
" <td>28 Dec 2017</td>\n",
" <td>227-228</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1177/036215...</td>\n",
" <td>Editorial</td>\n",
" <td>Letters From the Coeditors</td>\n",
" <td>7</td>\n",
" <td>47</td>\n",
" <td>2017</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2797</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1177/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Suzanne Johnson', 'authorURL': 'htt...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1177/0362153717725533</td>\n",
" <td>4</td>\n",
" <td>https://tandfonline.com/doi/full/10.1177/03621...</td>\n",
" <td>28 Dec 2017</td>\n",
" <td>308-320</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1177/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1177/036215...</td>\n",
" <td>Articles</td>\n",
" <td>The Trouble With Gender</td>\n",
" <td>52</td>\n",
" <td>47</td>\n",
" <td>2017</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2798</th>\n",
" <td>NaN</td>\n",
" <td>editorial</td>\n",
" <td>[{'name': 'William F. Cornell', 'authorURL': '...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397959</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>27 Nov 2017</td>\n",
" <td>1-3</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Editorial</td>\n",
" <td>Letter From the Coeditor: Challenging Our Fram...</td>\n",
" <td>246</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2799</th>\n",
" <td>NaN</td>\n",
" <td>editorial</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397960</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>17 Nov 2017</td>\n",
" <td>4-6</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Editorials</td>\n",
" <td>Introducing a New Coeditor and New Editorial B...</td>\n",
" <td>141</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2800</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Giles Barrow', 'authorURL': 'https:...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1391681</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>16 Nov 2017</td>\n",
" <td>7-17</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>A Body of Knowledge: Somatic and Environmental...</td>\n",
" <td>156</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2801</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Edward T. Novak', 'authorURL': 'htt...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397962</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>20 Nov 2017</td>\n",
" <td>18-32</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>A Model of Informed Physical Contact in Psycho...</td>\n",
" <td>164</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2802</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Mark Widdowson', 'authorURL': 'http...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397965</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>23 Nov 2017</td>\n",
" <td>33-42</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>The Importance of Research in Transactional An...</td>\n",
" <td>136</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2803</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Dmitri I. Shustov', 'authorURL': 'h...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397970</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>20 Nov 2017</td>\n",
" <td>43-58</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Games Abstainers Play</td>\n",
" <td>243</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2804</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Tony White', 'authorURL': 'https://...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397972</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>17 Nov 2017</td>\n",
" <td>59-72</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>The Seven Suicide Decisions: Reassessing the G...</td>\n",
" <td>346</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2805</th>\n",
" <td>NaN</td>\n",
" <td>book review</td>\n",
" <td>[{'name': 'William F. Cornell', 'authorURL': '...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397974</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>27 Nov 2017</td>\n",
" <td>73-76</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Book Review</td>\n",
" <td>Understanding and Treating Chronic Shame: A Re...</td>\n",
" <td>144</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2806</th>\n",
" <td>NaN</td>\n",
" <td>book review</td>\n",
" <td>[{'name': 'Edward T. Novak', 'authorURL': 'htt...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1397975</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>20 Nov 2017</td>\n",
" <td>77-79</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Book Review</td>\n",
" <td>Unrepressed Unconscious, Implicit Memory, and ...</td>\n",
" <td>76</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2807</th>\n",
" <td>NaN</td>\n",
" <td>letter</td>\n",
" <td>[{'name': 'Fanita English', 'authorURL': 'http...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1399676</td>\n",
" <td>1</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>24 Nov 2017</td>\n",
" <td>80</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Letter to the Editor</td>\n",
" <td>Letter to the Coeditors</td>\n",
" <td>81</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2808</th>\n",
" <td>NaN</td>\n",
" <td>editorial</td>\n",
" <td>[{'name': 'William F. Cornell', 'authorURL': '...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1442687</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>23 Feb 2018</td>\n",
" <td>81-84</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Editorial</td>\n",
" <td>Letter From the Coeditors</td>\n",
" <td>198</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2809</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Françoise Sironi', 'authorURL': 'ht...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1429273</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>21 Feb 2018</td>\n",
" <td>85-96</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Clinical Geopolitical Psychology: A New Approa...</td>\n",
" <td>75</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2810</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'William F. Cornell', 'authorURL': '...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1431460</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>97-110</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>If it is Not for All, it is Not for Us: Reflec...</td>\n",
" <td>230</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2811</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Karen Minikin', 'authorURL': 'https...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1429287</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>111-125</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Radical Relational Psychiatry: Toward a Democr...</td>\n",
" <td>196</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2812</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Leonard P. Campos', 'authorURL': 'h...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1429290</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>126-138</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Meeting the Challenges of a Vengeful World wit...</td>\n",
" <td>101</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2813</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Maria Teresa Tosi', 'authorURL': 'h...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1429295</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>139-151</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Personal Identity and Moral Discourse in Psych...</td>\n",
" <td>151</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2814</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Nicoleta Gheorghe', 'authorURL': 'h...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1429301</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>152-165</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>When the Outside Strikes a Chord Inside: The R...</td>\n",
" <td>108</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2815</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Susanna Ligabue', 'authorURL': 'htt...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1429308</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>166-180</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Forced Migration and Refugees: Trauma Experien...</td>\n",
" <td>93</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2816</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Ioana Cupsa', 'authorURL': 'https:/...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1431467</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>181-191</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Culture Shock and Identity</td>\n",
" <td>239</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2817</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Marion Umney', 'authorURL': 'https:...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1429314</td>\n",
" <td>2</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>15 Feb 2018</td>\n",
" <td>192-205</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Using Relationship to Explore the Development ...</td>\n",
" <td>183</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2818</th>\n",
" <td>NaN</td>\n",
" <td>editorial</td>\n",
" <td>[{'name': 'Diana Deaconu', 'authorURL': 'https...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471287</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>18 May 2018</td>\n",
" <td>207-208</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>NaN</td>\n",
" <td>Editorial</td>\n",
" <td>Letter from the Coeditor</td>\n",
" <td>20</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2819</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Anna Emanuela Tangolo', 'authorURL'...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471288</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>18 May 2018</td>\n",
" <td>209-223</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>A Contemporary Perspective on Transactional An...</td>\n",
" <td>33</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2820</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Ray Little', 'authorURL': 'https://...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471290</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>16 May 2018</td>\n",
" <td>224-241</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>The Management of Erotic/Sexual Countertransfe...</td>\n",
" <td>55</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2821</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Tatjana Gjurković', 'authorURL': 'h...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471291</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>18 May 2018</td>\n",
" <td>242-257</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Treatment Stages in Working with Children: An ...</td>\n",
" <td>179</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2822</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Pete King', 'authorURL': 'https://t...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471292</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>18 May 2018</td>\n",
" <td>258-271</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Transactional Analysis and the Ludic Third (TA...</td>\n",
" <td>62</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2823</th>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>[{'name': 'Giorgio Piccinino', 'authorURL': 'h...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471293</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>18 May 2018</td>\n",
" <td>272-285</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Article</td>\n",
" <td>Reflections on Physis, Happiness, and Human Mo...</td>\n",
" <td>39</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2824</th>\n",
" <td>NaN</td>\n",
" <td>book review</td>\n",
" <td>[{'name': 'Marianna Ackerman', 'authorURL': 'h...</td>\n",
" <td>https://tandfonline.com/doi/abs/10.1080/036215...</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471294</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>18 May 2018</td>\n",
" <td>286-287</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Book Review</td>\n",
" <td>Ghosts in the Consulting Room: Echoes of Traum...</td>\n",
" <td>10</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2825</th>\n",
" <td>NaN</td>\n",
" <td>book review</td>\n",
" <td>[{'name': 'Edward T. Novak', 'authorURL': 'htt...</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>/10.1080/03621537.2018.1471295</td>\n",
" <td>3</td>\n",
" <td>https://tandfonline.com/doi/full/10.1080/03621...</td>\n",
" <td>18 May 2018</td>\n",
" <td>288-290</td>\n",
" <td>https://tandfonline.com/doi/pdf/10.1080/036215...</td>\n",
" <td>https://tandfonline.com/doi/ref/10.1080/036215...</td>\n",
" <td>Book Review</td>\n",
" <td>Trauma-Sensitive Mindfulness: Practices for Sa...</td>\n",
" <td>12</td>\n",
" <td>48</td>\n",
" <td>2018</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>2826 rows × 17 columns</p>\n",
"</div>"
],
"text/plain": [
" abstract article-type \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN Article \n",
"3 NaN Article \n",
"4 NaN Article \n",
"5 NaN NaN \n",
"6 NaN Article \n",
"7 NaN Article \n",
"8 NaN Article \n",
"9 NaN Article \n",
"10 NaN Article \n",
"11 NaN Article \n",
"12 NaN Article \n",
"13 NaN Article \n",
"14 NaN Article \n",
"15 NaN Article \n",
"16 NaN Article \n",
"17 NaN Article \n",
"18 NaN Article \n",
"19 NaN Article \n",
"20 NaN Article \n",
"21 NaN Article \n",
"22 NaN book review \n",
"23 NaN Article \n",
"24 NaN Article \n",
"25 NaN Article \n",
"26 NaN editorial \n",
"27 NaN Article \n",
"28 NaN Article \n",
"29 NaN Article \n",
"... ... ... \n",
"2796 NaN editorial \n",
"2797 https://tandfonline.com/doi/abs/10.1177/036215... Article \n",
"2798 NaN editorial \n",
"2799 NaN editorial \n",
"2800 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2801 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2802 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2803 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2804 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2805 NaN book review \n",
"2806 NaN book review \n",
"2807 NaN letter \n",
"2808 NaN editorial \n",
"2809 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2810 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2811 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2812 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2813 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2814 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2815 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2816 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2817 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2818 NaN editorial \n",
"2819 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2820 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2821 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2822 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2823 https://tandfonline.com/doi/abs/10.1080/036215... Article \n",
"2824 NaN book review \n",
"2825 NaN book review \n",
"\n",
" authors \\\n",
"0 [{'role': '(President)', 'degree': 'M.D.', 'na... \n",
"1 [{'name': 'Warren D. Cheney', 'authorURL': 'ht... \n",
"2 [{'degree': 'M.D.', 'name': 'Eric Berne', 'aut... \n",
"3 [{'degree': 'M.A., M.A.', 'name': 'Warren D. C... \n",
"4 [{'degree': 'B.A., B.A.', 'name': 'Robert M. C... \n",
"5 NaN \n",
"6 [{'degree': 'M.D.', 'name': 'John M. Dusay', '... \n",
"7 [{'degree': 'Ph.D.', 'name': 'Claude M. Steine... \n",
"8 [{'degree': 'MD.', 'name': 'Franklin H. Ernst ... \n",
"9 [{'degree': 'M.D.', 'name': 'Thomas A. Harris'... \n",
"10 [{'degree': 'M.S.W.', 'name': 'Joseph P. Conca... \n",
"11 [{'degree': 'Ph.D.', 'name': 'David Kupfer', '... \n",
"12 [{'degree': 'M.S.W.', 'name': 'Jules A. Levagg... \n",
"13 [{'degree': 'B.A.', 'name': 'Aaron Wolfe Schif... \n",
"14 [{'degree': 'M.D.', 'name': 'Stephen Karpman',... \n",
"15 [{'degree': 'Ed.D.', 'name': 'Muriel M. James'... \n",
"16 [{'degree': 'M.D.', 'name': 'Solon D. Samuels'... \n",
"17 [{'name': 'Polly Parker', 'authorURL': 'https:... \n",
"18 NaN \n",
"19 NaN \n",
"20 [{'name': 'Arthur Rissman', 'authorURL': 'http... \n",
"21 [{'degree': 'M.D.', 'name': 'Roberto Kertesz',... \n",
"22 [{'name': 'Helen Colton', 'authorURL': 'https:... \n",
"23 NaN \n",
"24 NaN \n",
"25 [{'degree': 'M.D.', 'name': 'Ken Everts', 'aut... \n",
"26 NaN \n",
"27 [{'name': 'Polly Parker', 'authorURL': 'https:... \n",
"28 NaN \n",
"29 [{'degree': 'Ph.D.', 'name': 'David Kupfer', '... \n",
"... ... \n",
"2796 [{'name': 'Brad McLean', 'authorURL': 'https:/... \n",
"2797 [{'name': 'Suzanne Johnson', 'authorURL': 'htt... \n",
"2798 [{'name': 'William F. Cornell', 'authorURL': '... \n",
"2799 NaN \n",
"2800 [{'name': 'Giles Barrow', 'authorURL': 'https:... \n",
"2801 [{'name': 'Edward T. Novak', 'authorURL': 'htt... \n",
"2802 [{'name': 'Mark Widdowson', 'authorURL': 'http... \n",
"2803 [{'name': 'Dmitri I. Shustov', 'authorURL': 'h... \n",
"2804 [{'name': 'Tony White', 'authorURL': 'https://... \n",
"2805 [{'name': 'William F. Cornell', 'authorURL': '... \n",
"2806 [{'name': 'Edward T. Novak', 'authorURL': 'htt... \n",
"2807 [{'name': 'Fanita English', 'authorURL': 'http... \n",
"2808 [{'name': 'William F. Cornell', 'authorURL': '... \n",
"2809 [{'name': 'Françoise Sironi', 'authorURL': 'ht... \n",
"2810 [{'name': 'William F. Cornell', 'authorURL': '... \n",
"2811 [{'name': 'Karen Minikin', 'authorURL': 'https... \n",
"2812 [{'name': 'Leonard P. Campos', 'authorURL': 'h... \n",
"2813 [{'name': 'Maria Teresa Tosi', 'authorURL': 'h... \n",
"2814 [{'name': 'Nicoleta Gheorghe', 'authorURL': 'h... \n",
"2815 [{'name': 'Susanna Ligabue', 'authorURL': 'htt... \n",
"2816 [{'name': 'Ioana Cupsa', 'authorURL': 'https:/... \n",
"2817 [{'name': 'Marion Umney', 'authorURL': 'https:... \n",
"2818 [{'name': 'Diana Deaconu', 'authorURL': 'https... \n",
"2819 [{'name': 'Anna Emanuela Tangolo', 'authorURL'... \n",
"2820 [{'name': 'Ray Little', 'authorURL': 'https://... \n",
"2821 [{'name': 'Tatjana Gjurković', 'authorURL': 'h... \n",
"2822 [{'name': 'Pete King', 'authorURL': 'https://t... \n",
"2823 [{'name': 'Giorgio Piccinino', 'authorURL': 'h... \n",
"2824 [{'name': 'Marianna Ackerman', 'authorURL': 'h... \n",
"2825 [{'name': 'Edward T. Novak', 'authorURL': 'htt... \n",
"\n",
" citations link cross-ref citations \\\n",
"0 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"1 https://tandfonline.com/doi/abs/10.1177/036215... 1 \n",
"2 NaN 27 \n",
"3 NaN 8 \n",
"4 NaN 1 \n",
"5 NaN 0 \n",
"6 NaN 3 \n",
"7 NaN 2 \n",
"8 NaN 4 \n",
"9 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"10 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"11 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"12 NaN 1 \n",
"13 NaN 74 \n",
"14 NaN 30 \n",
"15 NaN 4 \n",
"16 NaN 3 \n",
"17 NaN 0 \n",
"18 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"19 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"20 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"21 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"22 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"23 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"24 NaN 0 \n",
"25 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"26 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"27 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"28 https://tandfonline.com/doi/abs/10.1177/036215... 0 \n",
"29 NaN 19 \n",
"... ... ... \n",
"2796 NaN 0 \n",
"2797 NaN 0 \n",
"2798 NaN 0 \n",
"2799 NaN 0 \n",
"2800 NaN 0 \n",
"2801 NaN 0 \n",
"2802 NaN 0 \n",
"2803 NaN 0 \n",
"2804 NaN 0 \n",
"2805 NaN 0 \n",
"2806 NaN 0 \n",
"2807 https://tandfonline.com/doi/abs/10.1080/036215... 0 \n",
"2808 NaN 0 \n",
"2809 NaN 0 \n",
"2810 NaN 0 \n",
"2811 NaN 0 \n",
"2812 NaN 0 \n",
"2813 NaN 0 \n",
"2814 NaN 0 \n",
"2815 NaN 0 \n",
"2816 NaN 0 \n",
"2817 NaN 0 \n",
"2818 https://tandfonline.com/doi/abs/10.1080/036215... 0 \n",
"2819 NaN 0 \n",
"2820 NaN 0 \n",
"2821 NaN 0 \n",
"2822 NaN 0 \n",
"2823 NaN 0 \n",
"2824 https://tandfonline.com/doi/abs/10.1080/036215... 0 \n",
"2825 NaN 0 \n",
"\n",
" doi issue \\\n",
"0 10.1177/036215377100100101 1 \n",
"1 10.1177/036215377100100102 1 \n",
"2 10.1177/036215377100100103 1 \n",
"3 10.1177/036215377100100104 1 \n",
"4 10.1177/036215377100100105 1 \n",
"5 10.1177/036215377100100106 1 \n",
"6 10.1177/036215377100100107 1 \n",
"7 10.1177/036215377100100108 1 \n",
"8 10.1177/036215377100100109 1 \n",
"9 10.1177/036215377100100110 1 \n",
"10 10.1177/036215377100100111 1 \n",
"11 10.1177/036215377100100112 1 \n",
"12 10.1177/036215377100100113 1 \n",
"13 10.1177/036215377100100114 1 \n",
"14 10.1177/036215377100100115 1 \n",
"15 10.1177/036215377100100116 1 \n",
"16 10.1177/036215377100100117 1 \n",
"17 10.1177/036215377100100118 1 \n",
"18 10.1177/036215377100100119 1 \n",
"19 10.1177/036215377100100120 1 \n",
"20 10.1177/036215377100100121 1 \n",
"21 10.1177/036215377100100122 1 \n",
"22 10.1177/036215377100100123 1 \n",
"23 10.1177/036215377100100124 1 \n",
"24 10.1177/036215377100100125 1 \n",
"25 10.1177/036215377100100201 2 \n",
"26 10.1177/036215377100100202 2 \n",
"27 10.1177/036215377100100203 2 \n",
"28 10.1177/036215377100100204 2 \n",
"29 10.1177/036215377100100205 2 \n",
"... ... ... \n",
"2796 /10.1177/0362153717725532 4 \n",
"2797 /10.1177/0362153717725533 4 \n",
"2798 /10.1080/03621537.2018.1397959 1 \n",
"2799 /10.1080/03621537.2018.1397960 1 \n",
"2800 /10.1080/03621537.2018.1391681 1 \n",
"2801 /10.1080/03621537.2018.1397962 1 \n",
"2802 /10.1080/03621537.2018.1397965 1 \n",
"2803 /10.1080/03621537.2018.1397970 1 \n",
"2804 /10.1080/03621537.2018.1397972 1 \n",
"2805 /10.1080/03621537.2018.1397974 1 \n",
"2806 /10.1080/03621537.2018.1397975 1 \n",
"2807 /10.1080/03621537.2018.1399676 1 \n",
"2808 /10.1080/03621537.2018.1442687 2 \n",
"2809 /10.1080/03621537.2018.1429273 2 \n",
"2810 /10.1080/03621537.2018.1431460 2 \n",
"2811 /10.1080/03621537.2018.1429287 2 \n",
"2812 /10.1080/03621537.2018.1429290 2 \n",
"2813 /10.1080/03621537.2018.1429295 2 \n",
"2814 /10.1080/03621537.2018.1429301 2 \n",
"2815 /10.1080/03621537.2018.1429308 2 \n",
"2816 /10.1080/03621537.2018.1431467 2 \n",
"2817 /10.1080/03621537.2018.1429314 2 \n",
"2818 /10.1080/03621537.2018.1471287 3 \n",
"2819 /10.1080/03621537.2018.1471288 3 \n",
"2820 /10.1080/03621537.2018.1471290 3 \n",
"2821 /10.1080/03621537.2018.1471291 3 \n",
"2822 /10.1080/03621537.2018.1471292 3 \n",
"2823 /10.1080/03621537.2018.1471293 3 \n",
"2824 /10.1080/03621537.2018.1471294 3 \n",
"2825 /10.1080/03621537.2018.1471295 3 \n",
"\n",
" link online pub date \\\n",
"0 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"1 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"2 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"3 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"4 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"5 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"6 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"7 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"8 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"9 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"10 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"11 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"12 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"13 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"14 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"15 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"16 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"17 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"18 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"19 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"20 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"21 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"22 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"23 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"24 https://tandfonline.com/doi/abs/10.1177/036215... 02 Jan 2018 \n",
"25 https://tandfonline.com/doi/abs/10.1177/036215... 28 Dec 2017 \n",
"26 https://tandfonline.com/doi/abs/10.1177/036215... 28 Dec 2017 \n",
"27 https://tandfonline.com/doi/abs/10.1177/036215... 28 Dec 2017 \n",
"28 https://tandfonline.com/doi/abs/10.1177/036215... 28 Dec 2017 \n",
"29 https://tandfonline.com/doi/abs/10.1177/036215... 28 Dec 2017 \n",
"... ... ... \n",
"2796 https://tandfonline.com/doi/full/10.1177/03621... 28 Dec 2017 \n",
"2797 https://tandfonline.com/doi/full/10.1177/03621... 28 Dec 2017 \n",
"2798 https://tandfonline.com/doi/full/10.1080/03621... 27 Nov 2017 \n",
"2799 https://tandfonline.com/doi/full/10.1080/03621... 17 Nov 2017 \n",
"2800 https://tandfonline.com/doi/full/10.1080/03621... 16 Nov 2017 \n",
"2801 https://tandfonline.com/doi/full/10.1080/03621... 20 Nov 2017 \n",
"2802 https://tandfonline.com/doi/full/10.1080/03621... 23 Nov 2017 \n",
"2803 https://tandfonline.com/doi/full/10.1080/03621... 20 Nov 2017 \n",
"2804 https://tandfonline.com/doi/full/10.1080/03621... 17 Nov 2017 \n",
"2805 https://tandfonline.com/doi/full/10.1080/03621... 27 Nov 2017 \n",
"2806 https://tandfonline.com/doi/full/10.1080/03621... 20 Nov 2017 \n",
"2807 https://tandfonline.com/doi/full/10.1080/03621... 24 Nov 2017 \n",
"2808 https://tandfonline.com/doi/full/10.1080/03621... 23 Feb 2018 \n",
"2809 https://tandfonline.com/doi/full/10.1080/03621... 21 Feb 2018 \n",
"2810 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2811 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2812 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2813 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2814 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2815 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2816 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2817 https://tandfonline.com/doi/full/10.1080/03621... 15 Feb 2018 \n",
"2818 https://tandfonline.com/doi/full/10.1080/03621... 18 May 2018 \n",
"2819 https://tandfonline.com/doi/full/10.1080/03621... 18 May 2018 \n",
"2820 https://tandfonline.com/doi/full/10.1080/03621... 16 May 2018 \n",
"2821 https://tandfonline.com/doi/full/10.1080/03621... 18 May 2018 \n",
"2822 https://tandfonline.com/doi/full/10.1080/03621... 18 May 2018 \n",
"2823 https://tandfonline.com/doi/full/10.1080/03621... 18 May 2018 \n",
"2824 https://tandfonline.com/doi/full/10.1080/03621... 18 May 2018 \n",
"2825 https://tandfonline.com/doi/full/10.1080/03621... 18 May 2018 \n",
"\n",
" pages pdf link \\\n",
"0 4 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"1 5 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"2 6-13 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"3 14-22 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"4 23-29 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"5 30-33 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"6 34-44 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"7 46-48 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"8 49-58 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"9 59-60 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"10 60-61 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"11 62 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"12 64-70 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"13 71-78 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"14 79-87 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"15 88-94 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"16 95-99 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"17 100-104 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"18 105 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"19 106 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"20 107 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"21 108 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"22 108-109 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"23 109-110 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"24 111-115 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"25 4 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"26 5 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"27 6-7 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"28 8-9 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"29 10-16 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"... ... ... \n",
"2796 227-228 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"2797 308-320 https://tandfonline.com/doi/pdf/10.1177/036215... \n",
"2798 1-3 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2799 4-6 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2800 7-17 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2801 18-32 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2802 33-42 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2803 43-58 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2804 59-72 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2805 73-76 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2806 77-79 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2807 80 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2808 81-84 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2809 85-96 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2810 97-110 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2811 111-125 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2812 126-138 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2813 139-151 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2814 152-165 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2815 166-180 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2816 181-191 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2817 192-205 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2818 207-208 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2819 209-223 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2820 224-241 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2821 242-257 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2822 258-271 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2823 272-285 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2824 286-287 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"2825 288-290 https://tandfonline.com/doi/pdf/10.1080/036215... \n",
"\n",
" references link \\\n",
"0 NaN \n",
"1 NaN \n",
"2 NaN \n",
"3 NaN \n",
"4 NaN \n",
"5 NaN \n",
"6 https://tandfonline.com/doi/ref/10.1177/036215... \n",
"7 NaN \n",
"8 https://tandfonline.com/doi/ref/10.1177/036215... \n",
"9 NaN \n",
"10 NaN \n",
"11 NaN \n",
"12 NaN \n",
"13 NaN \n",
"14 https://tandfonline.com/doi/ref/10.1177/036215... \n",
"15 https://tandfonline.com/doi/ref/10.1177/036215... \n",
"16 NaN \n",
"17 NaN \n",
"18 NaN \n",
"19 NaN \n",
"20 NaN \n",
"21 NaN \n",
"22 NaN \n",
"23 NaN \n",
"24 NaN \n",
"25 NaN \n",
"26 NaN \n",
"27 NaN \n",
"28 https://tandfonline.com/doi/ref/10.1177/036215... \n",
"29 NaN \n",
"... ... \n",
"2796 https://tandfonline.com/doi/ref/10.1177/036215... \n",
"2797 https://tandfonline.com/doi/ref/10.1177/036215... \n",
"2798 NaN \n",
"2799 NaN \n",
"2800 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2801 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2802 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2803 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2804 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2805 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2806 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2807 NaN \n",
"2808 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2809 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2810 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2811 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2812 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2813 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2814 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2815 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2816 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2817 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2818 NaN \n",
"2819 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2820 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2821 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2822 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2823 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2824 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"2825 https://tandfonline.com/doi/ref/10.1080/036215... \n",
"\n",
" subject \\\n",
"0 The President's Page \n",
"1 Introducing the Transactional Analysis Journal \n",
"2 Section I: Feature Article \n",
"3 Section II: Eric Berne Memorial \n",
"4 Section II: Eric Berne Memorial \n",
"5 Section II: Eric Berne Memorial \n",
"6 Section II: Evaluative Article \n",
"7 Section II: Evaluative Article \n",
"8 Section II: Evaluative Article \n",
"9 Section II: Salutes to Eric Berne \n",
"10 Section II: Salutes to Eric Berne \n",
"11 Section II: Salutes to Eric Berne \n",
"12 Section II: Salutes to Eric Berne \n",
"13 Section III: Scientific Paper \n",
"14 Section III: Scientific Paper \n",
"15 Section III: Scientific Paper \n",
"16 Section III: Scientific Paper \n",
"17 Section III: Scientific Paper \n",
"18 Section IV: The ITAA \n",
"19 Section IV: The ITAA \n",
"20 Section V: Department \n",
"21 Section V: Department \n",
"22 Book Review \n",
"23 Section V: Department \n",
"24 Section V: Department \n",
"25 The President's Page \n",
"26 Editorial Policy of the TAJ \n",
"27 Section I: David Kupfer Memorial \n",
"28 Section I: David Kupfer Memorial \n",
"29 Section II: Feature Article \n",
"... ... \n",
"2796 Editorial \n",
"2797 Articles \n",
"2798 Editorial \n",
"2799 Editorials \n",
"2800 Article \n",
"2801 Article \n",
"2802 Article \n",
"2803 Article \n",
"2804 Article \n",
"2805 Book Review \n",
"2806 Book Review \n",
"2807 Letter to the Editor \n",
"2808 Editorial \n",
"2809 Article \n",
"2810 Article \n",
"2811 Article \n",
"2812 Article \n",
"2813 Article \n",
"2814 Article \n",
"2815 Article \n",
"2816 Article \n",
"2817 Article \n",
"2818 Editorial \n",
"2819 Article \n",
"2820 Article \n",
"2821 Article \n",
"2822 Article \n",
"2823 Article \n",
"2824 Book Review \n",
"2825 Book Review \n",
"\n",
" title views volume year \n",
"0 The President's Page 2 1 1971 \n",
"1 Introducing the Transactional Analysis Journal 4 1 1971 \n",
"2 Away from a Theory of the Impact of Interperso... 13 1 1971 \n",
"3 Eric Berne: Biographical Sketch 6 1 1971 \n",
"4 Eric Berne: Annotated Bibliography 2 1 1971 \n",
"5 Eric Berne — Portfolio of Pictures 3 1 1971 \n",
"6 Eric Berne's Studies of Intuition 1949–1962 14 1 1971 \n",
"7 A Little Boy's Dream 8 1 1971 \n",
"8 The Diagrammed Parent Eric Berne's Most Signif... 4 1 1971 \n",
"9 A Tribute to Doctor Eric Berne 3 1 1971 \n",
"10 My Introduction to Eric Berne 1 1 1971 \n",
"11 In the Beginning … 2 1 1971 \n",
"12 A Living Euhemerus Never Dies 2 1 1971 \n",
"13 Passivity 45 1 1971 \n",
"14 Options 26 1 1971 \n",
"15 Curing Impotency with Transactional Analysis 2 1 1971 \n",
"16 Games Therapists Play 8 1 1971 \n",
"17 1970 Summer Conference Proceedings: Part II 1 1 1971 \n",
"18 ITAA Personalities in the News 1 1 1971 \n",
"19 News of the Affiliates 0 1 1971 \n",
"20 Brief Communications 1 1 1971 \n",
"21 Resemblance between the Alcoholic and the Obes... 2 1 1971 \n",
"22 Book Review: Please Touch 2 1 1971 \n",
"23 Transactional Pubs 0 1 1971 \n",
"24 Authors 0 1 1971 \n",
"25 The President's Page 0 1 1971 \n",
"26 Editorial Policy of the TAJ 1 1 1971 \n",
"27 David Kupfer, 1910–1971 1 1 1971 \n",
"28 A Tribute to David Kupfer 0 1 1971 \n",
"29 Therapeutic Interventions Part I. Rubberbands Now 13 1 1971 \n",
"... ... ... ... ... \n",
"2796 Letters From the Coeditors 7 47 2017 \n",
"2797 The Trouble With Gender 52 47 2017 \n",
"2798 Letter From the Coeditor: Challenging Our Fram... 246 48 2018 \n",
"2799 Introducing a New Coeditor and New Editorial B... 141 48 2018 \n",
"2800 A Body of Knowledge: Somatic and Environmental... 156 48 2018 \n",
"2801 A Model of Informed Physical Contact in Psycho... 164 48 2018 \n",
"2802 The Importance of Research in Transactional An... 136 48 2018 \n",
"2803 Games Abstainers Play 243 48 2018 \n",
"2804 The Seven Suicide Decisions: Reassessing the G... 346 48 2018 \n",
"2805 Understanding and Treating Chronic Shame: A Re... 144 48 2018 \n",
"2806 Unrepressed Unconscious, Implicit Memory, and ... 76 48 2018 \n",
"2807 Letter to the Coeditors 81 48 2018 \n",
"2808 Letter From the Coeditors 198 48 2018 \n",
"2809 Clinical Geopolitical Psychology: A New Approa... 75 48 2018 \n",
"2810 If it is Not for All, it is Not for Us: Reflec... 230 48 2018 \n",
"2811 Radical Relational Psychiatry: Toward a Democr... 196 48 2018 \n",
"2812 Meeting the Challenges of a Vengeful World wit... 101 48 2018 \n",
"2813 Personal Identity and Moral Discourse in Psych... 151 48 2018 \n",
"2814 When the Outside Strikes a Chord Inside: The R... 108 48 2018 \n",
"2815 Forced Migration and Refugees: Trauma Experien... 93 48 2018 \n",
"2816 Culture Shock and Identity 239 48 2018 \n",
"2817 Using Relationship to Explore the Development ... 183 48 2018 \n",
"2818 Letter from the Coeditor 20 48 2018 \n",
"2819 A Contemporary Perspective on Transactional An... 33 48 2018 \n",
"2820 The Management of Erotic/Sexual Countertransfe... 55 48 2018 \n",
"2821 Treatment Stages in Working with Children: An ... 179 48 2018 \n",
"2822 Transactional Analysis and the Ludic Third (TA... 62 48 2018 \n",
"2823 Reflections on Physis, Happiness, and Human Mo... 39 48 2018 \n",
"2824 Ghosts in the Consulting Room: Echoes of Traum... 10 48 2018 \n",
"2825 Trauma-Sensitive Mindfulness: Practices for Sa... 12 48 2018 \n",
"\n",
"[2826 rows x 17 columns]"
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = pd.DataFrame(collector)\n",
"print(len(df))\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {},
"outputs": [],
"source": [
"df.to_csv('ArticlesListing.csv', index=False, quoting=csv.QUOTE_NONNUMERIC)\n",
" "
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"58"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(row['link'])"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'https://tandfonline.com/doi/abs/10.1177/036215377100100120'"
]
},
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"row['link']"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"32"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len('https://tandfonline.com/doi/abs/')"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'10.1177/036215377100100120'"
]
},
"execution_count": 28,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"row['link'][32:]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# author specific"
]
},
{
"cell_type": "code",
"execution_count": 50,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"[{'name': 'Jacqui Schiff', 'authorURL': 'https://tandfonline.com/author/Schiff%2C+Jacqui'}, {'name': 'Judith L. Erb', 'authorURL': 'https://tandfonline.com/author/Erb%2C+Judith+L'}, {'name': 'Kenneth Warner', 'authorURL': 'https://tandfonline.com/author/Warner%2C+Kenneth'}, {'name': 'Shea Schiff', 'authorURL': 'https://tandfonline.com/author/Schiff%2C+Shea'}, {'name': 'David Kline', 'authorURL': 'https://tandfonline.com/author/Kline%2C+David'}, {'name': 'Dee Bowman', 'authorURL': 'https://tandfonline.com/author/Bowman%2C+Dee'}]\n",
"[{'name': 'Richard G. Erskine', 'authorURL': 'https://tandfonline.com/author/Erskine%2C+Richard+G'}, {'name': 'Barbara Clark', 'authorURL': 'https://tandfonline.com/author/Clark%2C+Barbara'}, {'name': 'Kenneth R. Evans', 'authorURL': 'https://tandfonline.com/author/Evans%2C+Kenneth+R'}, {'name': 'Carl Goldberg', 'authorURL': 'https://tandfonline.com/author/Goldberg%2C+Carl'}, {'name': 'Hanna Hyams', 'authorURL': 'https://tandfonline.com/author/Hyams%2C+Hanna'}, {'name': 'Samuel James', 'authorURL': 'https://tandfonline.com/author/James%2C+Samuel'}, {'name': \"Marye O'Reilly-Knapp\", 'authorURL': 'https://tandfonline.com/author/O%27Reilly-Knapp%2C+Marye'}]\n",
"[{'name': 'James R. Allen', 'authorURL': 'https://tandfonline.com/author/Allen%2C+James+R'}, {'name': 'Barbara Allen', 'authorURL': 'https://tandfonline.com/author/Allen%2C+Barbara'}, {'name': 'Graham Barnes', 'authorURL': 'https://tandfonline.com/author/Barnes%2C+Graham'}, {'name': 'Barbara Hibner', 'authorURL': 'https://tandfonline.com/author/Hibner%2C+Barbara'}, {'name': 'Rosa Krausz', 'authorURL': 'https://tandfonline.com/author/Krausz%2C+Rosa'}, {'name': 'Carlo Moiso', 'authorURL': 'https://tandfonline.com/author/Moiso%2C+Carlo'}, {'name': 'Carlos Welch', 'authorURL': 'https://tandfonline.com/author/Welch%2C+Carlos'}, {'name': 'Saroj Welch', 'authorURL': 'https://tandfonline.com/author/Welch%2C+Saroj'}]\n",
"[{'name': 'Richard G. Erskine', 'authorURL': 'https://tandfonline.com/author/Erskine%2C+Richard+G'}, {'name': 'Helena Hargaden', 'authorURL': 'https://tandfonline.com/author/Hargaden%2C+Helena'}, {'name': 'Lynne Jacobs', 'authorURL': 'https://tandfonline.com/author/Jacobs%2C+Lynne'}, {'name': 'Ray Little', 'authorURL': 'https://tandfonline.com/author/Little%2C+Ray'}, {'name': \"Marye O'Reilly-Knapp\", 'authorURL': 'https://tandfonline.com/author/O%27Reilly-Knapp%2C+Marye'}, {'name': 'Charlotte Sills', 'authorURL': 'https://tandfonline.com/author/Sills%2C+Charlotte'}, {'name': 'Thomas Weil', 'authorURL': 'https://tandfonline.com/author/Weil%2C+Thomas'}, {'name': 'Gary Yontef', 'authorURL': 'https://tandfonline.com/author/Yontef%2C+Gary'}]\n",
"[{'name': 'Claude Steiner', 'authorURL': 'https://tandfonline.com/author/Steiner%2C+Claude'}, {'name': 'Leonard Campos', 'authorURL': 'https://tandfonline.com/author/Campos%2C+Leonard'}, {'name': 'Pearl Drego', 'authorURL': 'https://tandfonline.com/author/Drego%2C+Pearl'}, {'name': 'Vann Joines', 'authorURL': 'https://tandfonline.com/author/Joines%2C+Vann'}, {'name': 'Susanna Ligabue', 'authorURL': 'https://tandfonline.com/author/Ligabue%2C+Susanna'}, {'name': 'Gloria Noriega', 'authorURL': 'https://tandfonline.com/author/Noriega%2C+Gloria'}, {'name': 'Denton Roberts', 'authorURL': 'https://tandfonline.com/author/Roberts%2C+Denton'}, {'name': 'Emilio Said', 'authorURL': 'https://tandfonline.com/author/Said%2C+Emilio'}]\n",
"[{'name': 'Maria Teresa Tosi', 'authorURL': 'https://tandfonline.com/author/Tosi%2C+Maria+Teresa'}, {'name': 'Evita Cassoni', 'authorURL': 'https://tandfonline.com/author/Cassoni%2C+Evita'}, {'name': 'Giorgio Cavallero', 'authorURL': 'https://tandfonline.com/author/Cavallero%2C+Giorgio'}, {'name': 'Carlo Moiso', 'authorURL': 'https://tandfonline.com/author/Moiso%2C+Carlo'}, {'name': 'Michele Novellino', 'authorURL': 'https://tandfonline.com/author/Novellino%2C+Michele'}, {'name': 'Laura Quagliotti', 'authorURL': 'https://tandfonline.com/author/Quagliotti%2C+Laura'}, {'name': 'Silvie Rossi', 'authorURL': 'https://tandfonline.com/author/Rossi%2C+Silvie'}, {'name': 'Pio Scilligo', 'authorURL': 'https://tandfonline.com/author/Scilligo%2C+Pio'}]\n",
"3030\n"
]
}
],
"source": [
"authorsCollector = []\n",
"\n",
"for artRow in collector:\n",
" if len(artRow.get('authors',[])) > 0:\n",
" authorsDict = artRow.get('authors')\n",
" if len(authorsDict) > 5:\n",
" print(authorsDict)\n",
" for oneAuth in authorsDict:\n",
" row = {}\n",
" row.update(oneAuth)\n",
" row['doi'] = artRow['doi']\n",
" authorsCollector.append(row)\n",
"print(len(authorsCollector))"
]
},
{
"cell_type": "code",
"execution_count": 41,
"metadata": {},
"outputs": [],
"source": [
"adf = pd.DataFrame(authorsCollector)"
]
},
{
"cell_type": "code",
"execution_count": 43,
"metadata": {
"scrolled": true
},
"outputs": [],
"source": [
"## do a left merge/join to bring in titles of their works"
]
},
{
"cell_type": "code",
"execution_count": 54,
"metadata": {
"scrolled": true
},
"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>authorURL</th>\n",
" <th>degree</th>\n",
" <th>name</th>\n",
" <th>year</th>\n",
" <th>title</th>\n",
" <th>doi</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>102</th>\n",
" <td>https://tandfonline.com/author/Miller%2C+A+Bar...</td>\n",
" <td>R.N.</td>\n",
" <td>A. Barbara Miller</td>\n",
" <td>1972</td>\n",
" <td>Turn — Over</td>\n",
" <td>10.1177/036215377200200308</td>\n",
" </tr>\n",
" <tr>\n",
" <th>469</th>\n",
" <td>https://tandfonline.com/author/Barchiesi%2C+A</td>\n",
" <td>MD</td>\n",
" <td>A. Barchiesi</td>\n",
" <td>1976</td>\n",
" <td>Exhibitionism and Ego States: A Phenomenologic...</td>\n",
" <td>10.1177/036215377600600323</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1615</th>\n",
" <td>https://tandfonline.com/author/Elliott%2C+A+J</td>\n",
" <td>NaN</td>\n",
" <td>A. J. Elliott</td>\n",
" <td>1992</td>\n",
" <td>The Dance of Relationship</td>\n",
" <td>10.1177/036215379202200106</td>\n",
" </tr>\n",
" <tr>\n",
" <th>990</th>\n",
" <td>https://tandfonline.com/author/McLellan%2C+A+T...</td>\n",
" <td>NaN</td>\n",
" <td>A. Thomas McLellan</td>\n",
" <td>1981</td>\n",
" <td>The Parenting Function of Therapeutic Communit...</td>\n",
" <td>10.1177/036215378101100308</td>\n",
" </tr>\n",
" <tr>\n",
" <th>605</th>\n",
" <td>https://tandfonline.com/author/France%2C+A+Wil...</td>\n",
" <td>NaN</td>\n",
" <td>A. William France</td>\n",
" <td>1977</td>\n",
" <td>Redefining and Paraphrasing</td>\n",
" <td>10.1177/036215377700700409</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1428</th>\n",
" <td>https://tandfonline.com/author/Elliott%2C+AJ</td>\n",
" <td>NaN</td>\n",
" <td>A.J. Elliott</td>\n",
" <td>1988</td>\n",
" <td>A Treatment Program for the Child Referred by ...</td>\n",
" <td>10.1177/036215378801800208</td>\n",
" </tr>\n",
" <tr>\n",
" <th>771</th>\n",
" <td>https://tandfonline.com/author/Lederer%2C+Aaron</td>\n",
" <td>NaN</td>\n",
" <td>Aaron Lederer</td>\n",
" <td>1979</td>\n",
" <td>The Redecision Movie</td>\n",
" <td>10.1177/036215377900900212</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1885</th>\n",
" <td>https://tandfonline.com/author/Lederer%2C+Aaron</td>\n",
" <td>NaN</td>\n",
" <td>Aaron Lederer</td>\n",
" <td>1996</td>\n",
" <td>The Unwanted Child</td>\n",
" <td>10.1177/036215379602600205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1912</th>\n",
" <td>https://tandfonline.com/author/Lederer%2C+Aaron</td>\n",
" <td>NaN</td>\n",
" <td>Aaron Lederer</td>\n",
" <td>1996</td>\n",
" <td>Script and Counterscript: An Israeli Experience</td>\n",
" <td>10.1177/036215379602600309</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1995</th>\n",
" <td>https://tandfonline.com/author/Lederer%2C+Aaron</td>\n",
" <td>NaN</td>\n",
" <td>Aaron Lederer</td>\n",
" <td>1997</td>\n",
" <td>The Unwanted Child's Narcissistic Defense</td>\n",
" <td>10.1177/036215379702700405</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2063</th>\n",
" <td>https://tandfonline.com/author/Lederer%2C+Aaron</td>\n",
" <td>NaN</td>\n",
" <td>Aaron Lederer</td>\n",
" <td>1998</td>\n",
" <td>The Unwanted Child's Narcissistic Defense Revi...</td>\n",
" <td>10.1177/036215379802800409</td>\n",
" </tr>\n",
" <tr>\n",
" <th>332</th>\n",
" <td>https://tandfonline.com/author/Schiff%2C+Aaron</td>\n",
" <td>B.A., Eric Schiff</td>\n",
" <td>Aaron Schiff</td>\n",
" <td>1975</td>\n",
" <td>Frames of Reference</td>\n",
" <td>10.1177/036215377500500320</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>https://tandfonline.com/author/Schiff%2C+Aaron...</td>\n",
" <td>B.A.</td>\n",
" <td>Aaron Wolfe Schiff</td>\n",
" <td>1971</td>\n",
" <td>Passivity</td>\n",
" <td>10.1177/036215377100100114</td>\n",
" </tr>\n",
" <tr>\n",
" <th>264</th>\n",
" <td>https://tandfonline.com/author/Schiff%2C+Aaron...</td>\n",
" <td>B.A.</td>\n",
" <td>Aaron Wolfe Schiff</td>\n",
" <td>1975</td>\n",
" <td>1974 Eric Berne Memorial Scientific Award Lecture</td>\n",
" <td>10.1177/036215377500500117</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1765</th>\n",
" <td>https://tandfonline.com/author/Wagner%2C+Abe</td>\n",
" <td>NaN</td>\n",
" <td>Abe Wagner</td>\n",
" <td>1994</td>\n",
" <td>Blue Ego States for Effective Communication</td>\n",
" <td>10.1177/036215379402400408</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1799</th>\n",
" <td>https://tandfonline.com/author/Wagner%2C+Abe</td>\n",
" <td>NaN</td>\n",
" <td>Abe Wagner</td>\n",
" <td>1995</td>\n",
" <td>My TA History</td>\n",
" <td>10.1177/036215379502500123</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1166</th>\n",
" <td>https://tandfonline.com/author/Magalhaes%2C+Abel</td>\n",
" <td>NaN</td>\n",
" <td>Abel Magalhaes</td>\n",
" <td>1983</td>\n",
" <td>Death Scripts</td>\n",
" <td>10.1177/036215378301300411</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1529</th>\n",
" <td>https://tandfonline.com/author/Choy%2C+Acey</td>\n",
" <td>NaN</td>\n",
" <td>Acey Choy</td>\n",
" <td>1990</td>\n",
" <td>The Winner's Triangle</td>\n",
" <td>10.1177/036215379002000105</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1911</th>\n",
" <td>https://tandfonline.com/author/Stickley%2C+Adr...</td>\n",
" <td>NaN</td>\n",
" <td>Adrian S. G. Stickley</td>\n",
" <td>1996</td>\n",
" <td>Validation of a Driver Checklist for Team Desi...</td>\n",
" <td>10.1177/036215379602600308</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2083</th>\n",
" <td>https://tandfonline.com/author/Dunn%2C+Adriana...</td>\n",
" <td>NaN</td>\n",
" <td>Adriana Balaguer Dunn</td>\n",
" <td>1999</td>\n",
" <td>Viewing the Transactional Dimensions of Spirit...</td>\n",
" <td>10.1177/036215379902900205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2530</th>\n",
" <td>https://tandfonline.com/author/Lee%2C+Adrienne</td>\n",
" <td>NaN</td>\n",
" <td>Adrienne Lee</td>\n",
" <td>2008</td>\n",
" <td>The Power is in Our Process</td>\n",
" <td>10.1177/036215370803800106</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2827</th>\n",
" <td>https://tandfonline.com/author/Lee%2C+Adrienne</td>\n",
" <td>NaN</td>\n",
" <td>Adrienne Lee</td>\n",
" <td>2014</td>\n",
" <td>The Development of a Process Group</td>\n",
" <td>/10.1177/0362153714527424</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2356</th>\n",
" <td>https://tandfonline.com/author/le+Guernic%2C+A...</td>\n",
" <td>NaN</td>\n",
" <td>Agnès Le Guernic</td>\n",
" <td>2004</td>\n",
" <td>Fairy Tales and Psychological Life Plans</td>\n",
" <td>10.1177/036215370403400305</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1673</th>\n",
" <td>https://tandfonline.com/author/Cardon%2C+Alain</td>\n",
" <td>NaN</td>\n",
" <td>Alain Cardon</td>\n",
" <td>1993</td>\n",
" <td>Organizational Holistics</td>\n",
" <td>10.1177/036215379302300203</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2053</th>\n",
" <td>https://tandfonline.com/author/Crespelle%2C+Alain</td>\n",
" <td>NaN</td>\n",
" <td>Alain Crespelle</td>\n",
" <td>1998</td>\n",
" <td>Self, Role, and Personhood: Differences and In...</td>\n",
" <td>10.1177/036215379802800309</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1369</th>\n",
" <td>https://tandfonline.com/author/Jacobs%2C+Alan</td>\n",
" <td>NaN</td>\n",
" <td>Alan Jacobs</td>\n",
" <td>1987</td>\n",
" <td>Autocratic Power</td>\n",
" <td>10.1177/036215378701700303</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1379</th>\n",
" <td>https://tandfonline.com/author/Jacobs%2C+Alan</td>\n",
" <td>NaN</td>\n",
" <td>Alan Jacobs</td>\n",
" <td>1987</td>\n",
" <td>Book Review: Toward Social Sanity and Human Su...</td>\n",
" <td>10.1177/036215378701700312</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1563</th>\n",
" <td>https://tandfonline.com/author/Jacobs%2C+Alan</td>\n",
" <td>NaN</td>\n",
" <td>Alan Jacobs</td>\n",
" <td>1990</td>\n",
" <td>Nationalism</td>\n",
" <td>10.1177/036215379002000403</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1572</th>\n",
" <td>https://tandfonline.com/author/Jacobs%2C+Alan</td>\n",
" <td>NaN</td>\n",
" <td>Alan Jacobs</td>\n",
" <td>1991</td>\n",
" <td>Aspects of Survival: Triumph over Death and On...</td>\n",
" <td>10.1177/036215379102100102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1603</th>\n",
" <td>https://tandfonline.com/author/Jacobs%2C+Alan</td>\n",
" <td>NaN</td>\n",
" <td>Alan Jacobs</td>\n",
" <td>1991</td>\n",
" <td>Autocracy: Groups, Organizations, Nations, and...</td>\n",
" <td>10.1177/036215379102100402</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>594</th>\n",
" <td>https://tandfonline.com/author/Sowder%2C+Willi...</td>\n",
" <td>NaN</td>\n",
" <td>William F. Sowder</td>\n",
" <td>1977</td>\n",
" <td>Experimentation in Transactional Analysis</td>\n",
" <td>10.1177/036215377700700329</td>\n",
" </tr>\n",
" <tr>\n",
" <th>106</th>\n",
" <td>https://tandfonline.com/author/Holloway%2C+Wil...</td>\n",
" <td>M.D.</td>\n",
" <td>William H. Holloway</td>\n",
" <td>1972</td>\n",
" <td>The Crazy Child in the Parent</td>\n",
" <td>10.1177/036215377200200311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>203</th>\n",
" <td>https://tandfonline.com/author/Holloway%2C+Wil...</td>\n",
" <td>M.D.</td>\n",
" <td>William H. Holloway</td>\n",
" <td>1974</td>\n",
" <td>Beyond Permission</td>\n",
" <td>10.1177/036215377400400205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>370</th>\n",
" <td>https://tandfonline.com/author/Holloway%2C+Wil...</td>\n",
" <td>M.D.</td>\n",
" <td>William H. Holloway</td>\n",
" <td>1976</td>\n",
" <td>The President's Page</td>\n",
" <td>10.1177/036215377600600101</td>\n",
" </tr>\n",
" <tr>\n",
" <th>394</th>\n",
" <td>https://tandfonline.com/author/Holloway%2C+Wil...</td>\n",
" <td>M.D.</td>\n",
" <td>William H. Holloway</td>\n",
" <td>1976</td>\n",
" <td>President's Page</td>\n",
" <td>10.1177/036215377600600201</td>\n",
" </tr>\n",
" <tr>\n",
" <th>428</th>\n",
" <td>https://tandfonline.com/author/Holloway%2C+Wil...</td>\n",
" <td>M.D.</td>\n",
" <td>William H. Holloway</td>\n",
" <td>1976</td>\n",
" <td>ITAA Historical Note</td>\n",
" <td>10.1177/036215377600600231</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1002</th>\n",
" <td>https://tandfonline.com/author/Holloway%2C+Wil...</td>\n",
" <td>NaN</td>\n",
" <td>William H. Holloway</td>\n",
" <td>1981</td>\n",
" <td>A New Look at Mental Disorders: DSMIII</td>\n",
" <td>10.1177/036215378101100317</td>\n",
" </tr>\n",
" <tr>\n",
" <th>194</th>\n",
" <td>https://tandfonline.com/author/Thweatt%2C+Will...</td>\n",
" <td>Ph.D.</td>\n",
" <td>William H. Thweatt</td>\n",
" <td>1974</td>\n",
" <td>Integrating Transactional Analysis with a Univ...</td>\n",
" <td>10.1177/036215377400400109</td>\n",
" </tr>\n",
" <tr>\n",
" <th>867</th>\n",
" <td>https://tandfonline.com/author/Thweatt%2C+Will...</td>\n",
" <td>NaN</td>\n",
" <td>William H. Thweatt</td>\n",
" <td>1980</td>\n",
" <td>Effective Permission-Giving and Representation...</td>\n",
" <td>10.1177/036215378001000116</td>\n",
" </tr>\n",
" <tr>\n",
" <th>888</th>\n",
" <td>https://tandfonline.com/author/Holloway%2C+Wil...</td>\n",
" <td>NaN</td>\n",
" <td>William Holloway</td>\n",
" <td>1980</td>\n",
" <td>Cure, a Lure</td>\n",
" <td>10.1177/036215378001000214</td>\n",
" </tr>\n",
" <tr>\n",
" <th>835</th>\n",
" <td>https://tandfonline.com/author/Kenney%2C+Willi...</td>\n",
" <td>NaN</td>\n",
" <td>William J. Kenney</td>\n",
" <td>1979</td>\n",
" <td>Naturally Occurring Teacher Ego State Behaviors</td>\n",
" <td>10.1177/036215377900900416</td>\n",
" </tr>\n",
" <tr>\n",
" <th>919</th>\n",
" <td>https://tandfonline.com/author/Kenney%2C+Willi...</td>\n",
" <td>NaN</td>\n",
" <td>William J. Kenney</td>\n",
" <td>1980</td>\n",
" <td>A TA Model of School Consultation: An Empirica...</td>\n",
" <td>10.1177/036215378001000319</td>\n",
" </tr>\n",
" <tr>\n",
" <th>991</th>\n",
" <td>https://tandfonline.com/author/Kenney%2C+Willi...</td>\n",
" <td>NaN</td>\n",
" <td>William J. Kenney</td>\n",
" <td>1981</td>\n",
" <td>Generalization of Ego State Behavior Change</td>\n",
" <td>10.1177/036215378101100309</td>\n",
" </tr>\n",
" <tr>\n",
" <th>995</th>\n",
" <td>https://tandfonline.com/author/Kenney%2C+Willi...</td>\n",
" <td>NaN</td>\n",
" <td>William J. Kenney</td>\n",
" <td>1981</td>\n",
" <td>Problem-Student Effects on Teacher Ego State B...</td>\n",
" <td>10.1177/036215378101100312</td>\n",
" </tr>\n",
" <tr>\n",
" <th>638</th>\n",
" <td>https://tandfonline.com/author/O%27Connor%2C+W...</td>\n",
" <td>NaN</td>\n",
" <td>William J. O'Connor</td>\n",
" <td>1978</td>\n",
" <td>Bridging the Gap: Treatment in vivo “If You Wa...</td>\n",
" <td>10.1177/036215377800800111</td>\n",
" </tr>\n",
" <tr>\n",
" <th>843</th>\n",
" <td>https://tandfonline.com/author/Kir-Stimon%2C+W...</td>\n",
" <td>NaN</td>\n",
" <td>William Kir-Stimon</td>\n",
" <td>1979</td>\n",
" <td>Cinderella and the Frog: An American Myth</td>\n",
" <td>10.1177/036215377900900421</td>\n",
" </tr>\n",
" <tr>\n",
" <th>659</th>\n",
" <td>https://tandfonline.com/author/Davis%2C+William+L</td>\n",
" <td>NaN</td>\n",
" <td>William L. Davis</td>\n",
" <td>1978</td>\n",
" <td>Beyond Magic Thinking</td>\n",
" <td>10.1177/036215377800800209</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1000</th>\n",
" <td>https://tandfonline.com/author/Moran%2C+William+L</td>\n",
" <td>NaN</td>\n",
" <td>William L. Moran</td>\n",
" <td>1981</td>\n",
" <td>Influence of Group Psychotherapy a Thirty Year...</td>\n",
" <td>10.1177/036215378101100316</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1315</th>\n",
" <td>https://tandfonline.com/author/Moran%2C+William+L</td>\n",
" <td>NaN</td>\n",
" <td>William L. Moran</td>\n",
" <td>1986</td>\n",
" <td>Influence of Group Psychotherapy: A Thirty-Eig...</td>\n",
" <td>10.1177/036215378601600210</td>\n",
" </tr>\n",
" <tr>\n",
" <th>450</th>\n",
" <td>https://tandfonline.com/author/Mundy%2C+William+L</td>\n",
" <td>MD</td>\n",
" <td>William L. Mundy</td>\n",
" <td>1976</td>\n",
" <td>Hypoglycemia—A Popular Wooden Leg</td>\n",
" <td>10.1177/036215377600600304</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1749</th>\n",
" <td>https://tandfonline.com/author/Mundy%2C+William+L</td>\n",
" <td>NaN</td>\n",
" <td>William L. Mundy</td>\n",
" <td>1994</td>\n",
" <td>“You Know.” Or Do You?</td>\n",
" <td>10.1177/036215379402400310</td>\n",
" </tr>\n",
" <tr>\n",
" <th>100</th>\n",
" <td>https://tandfonline.com/author/Mundy%2C+Willia...</td>\n",
" <td>M.D.</td>\n",
" <td>William Lowe Mundy</td>\n",
" <td>1972</td>\n",
" <td>Physical Exam and Script Decision — One Hour</td>\n",
" <td>10.1177/036215377200200306</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1326</th>\n",
" <td>https://tandfonline.com/author/Ruud%2C+William</td>\n",
" <td>NaN</td>\n",
" <td>William Ruud</td>\n",
" <td>1986</td>\n",
" <td>Quality Circles: Will Transactional Analysis I...</td>\n",
" <td>10.1177/036215378601600307</td>\n",
" </tr>\n",
" <tr>\n",
" <th>309</th>\n",
" <td>https://tandfonline.com/author/Thweatt%2C+William</td>\n",
" <td>Ph.D.</td>\n",
" <td>William Thweatt</td>\n",
" <td>1975</td>\n",
" <td>“My High School Counselor Said I Should Be a F...</td>\n",
" <td>10.1177/036215377500500304</td>\n",
" </tr>\n",
" <tr>\n",
" <th>811</th>\n",
" <td>https://tandfonline.com/author/Firman%2C+Win</td>\n",
" <td>NaN</td>\n",
" <td>Win Firman</td>\n",
" <td>1979</td>\n",
" <td>TAB (TA Buzz Words) — The Vocabulary Slimmer</td>\n",
" <td>10.1177/036215377900900325</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2412</th>\n",
" <td>https://tandfonline.com/author/Harano%2C+Yoshi...</td>\n",
" <td>NaN</td>\n",
" <td>Yoshikazu Harano</td>\n",
" <td>2005</td>\n",
" <td>Role Lettering Therapy: A New Transactional An...</td>\n",
" <td>10.1177/036215370503500305</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1947</th>\n",
" <td>https://tandfonline.com/author/Retief%2C+Yvonne</td>\n",
" <td>NaN</td>\n",
" <td>Yvonne Retief</td>\n",
" <td>1997</td>\n",
" <td>Conscious Empowerment Therapy: A Model for Cou...</td>\n",
" <td>10.1177/036215379702700110</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2830</th>\n",
" <td>https://tandfonline.com/author/Mellacqua%2C+Ze...</td>\n",
" <td>NaN</td>\n",
" <td>Zefiro Mellacqua</td>\n",
" <td>2014</td>\n",
" <td>Beyond Symbiosis</td>\n",
" <td>/10.1177/0362153714529410</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2930</th>\n",
" <td>https://tandfonline.com/author/Mellacqua%2C+Ze...</td>\n",
" <td>NaN</td>\n",
" <td>Zefiro Mellacqua</td>\n",
" <td>2016</td>\n",
" <td>When Spirit Comes to Mind</td>\n",
" <td>/10.1177/0362153716636640</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1992</th>\n",
" <td>https://tandfonline.com/author/Cuiran%2C+Zhang</td>\n",
" <td>NaN</td>\n",
" <td>Zhang Cuiran</td>\n",
" <td>1997</td>\n",
" <td>A Comparative Study of Chinese and American Hi...</td>\n",
" <td>10.1177/036215379702700403</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3030 rows × 6 columns</p>\n",
"</div>"
],
"text/plain": [
" authorURL degree \\\n",
"102 https://tandfonline.com/author/Miller%2C+A+Bar... R.N. \n",
"469 https://tandfonline.com/author/Barchiesi%2C+A MD \n",
"1615 https://tandfonline.com/author/Elliott%2C+A+J NaN \n",
"990 https://tandfonline.com/author/McLellan%2C+A+T... NaN \n",
"605 https://tandfonline.com/author/France%2C+A+Wil... NaN \n",
"1428 https://tandfonline.com/author/Elliott%2C+AJ NaN \n",
"771 https://tandfonline.com/author/Lederer%2C+Aaron NaN \n",
"1885 https://tandfonline.com/author/Lederer%2C+Aaron NaN \n",
"1912 https://tandfonline.com/author/Lederer%2C+Aaron NaN \n",
"1995 https://tandfonline.com/author/Lederer%2C+Aaron NaN \n",
"2063 https://tandfonline.com/author/Lederer%2C+Aaron NaN \n",
"332 https://tandfonline.com/author/Schiff%2C+Aaron B.A., Eric Schiff \n",
"14 https://tandfonline.com/author/Schiff%2C+Aaron... B.A. \n",
"264 https://tandfonline.com/author/Schiff%2C+Aaron... B.A. \n",
"1765 https://tandfonline.com/author/Wagner%2C+Abe NaN \n",
"1799 https://tandfonline.com/author/Wagner%2C+Abe NaN \n",
"1166 https://tandfonline.com/author/Magalhaes%2C+Abel NaN \n",
"1529 https://tandfonline.com/author/Choy%2C+Acey NaN \n",
"1911 https://tandfonline.com/author/Stickley%2C+Adr... NaN \n",
"2083 https://tandfonline.com/author/Dunn%2C+Adriana... NaN \n",
"2530 https://tandfonline.com/author/Lee%2C+Adrienne NaN \n",
"2827 https://tandfonline.com/author/Lee%2C+Adrienne NaN \n",
"2356 https://tandfonline.com/author/le+Guernic%2C+A... NaN \n",
"1673 https://tandfonline.com/author/Cardon%2C+Alain NaN \n",
"2053 https://tandfonline.com/author/Crespelle%2C+Alain NaN \n",
"1369 https://tandfonline.com/author/Jacobs%2C+Alan NaN \n",
"1379 https://tandfonline.com/author/Jacobs%2C+Alan NaN \n",
"1563 https://tandfonline.com/author/Jacobs%2C+Alan NaN \n",
"1572 https://tandfonline.com/author/Jacobs%2C+Alan NaN \n",
"1603 https://tandfonline.com/author/Jacobs%2C+Alan NaN \n",
"... ... ... \n",
"594 https://tandfonline.com/author/Sowder%2C+Willi... NaN \n",
"106 https://tandfonline.com/author/Holloway%2C+Wil... M.D. \n",
"203 https://tandfonline.com/author/Holloway%2C+Wil... M.D. \n",
"370 https://tandfonline.com/author/Holloway%2C+Wil... M.D. \n",
"394 https://tandfonline.com/author/Holloway%2C+Wil... M.D. \n",
"428 https://tandfonline.com/author/Holloway%2C+Wil... M.D. \n",
"1002 https://tandfonline.com/author/Holloway%2C+Wil... NaN \n",
"194 https://tandfonline.com/author/Thweatt%2C+Will... Ph.D. \n",
"867 https://tandfonline.com/author/Thweatt%2C+Will... NaN \n",
"888 https://tandfonline.com/author/Holloway%2C+Wil... NaN \n",
"835 https://tandfonline.com/author/Kenney%2C+Willi... NaN \n",
"919 https://tandfonline.com/author/Kenney%2C+Willi... NaN \n",
"991 https://tandfonline.com/author/Kenney%2C+Willi... NaN \n",
"995 https://tandfonline.com/author/Kenney%2C+Willi... NaN \n",
"638 https://tandfonline.com/author/O%27Connor%2C+W... NaN \n",
"843 https://tandfonline.com/author/Kir-Stimon%2C+W... NaN \n",
"659 https://tandfonline.com/author/Davis%2C+William+L NaN \n",
"1000 https://tandfonline.com/author/Moran%2C+William+L NaN \n",
"1315 https://tandfonline.com/author/Moran%2C+William+L NaN \n",
"450 https://tandfonline.com/author/Mundy%2C+William+L MD \n",
"1749 https://tandfonline.com/author/Mundy%2C+William+L NaN \n",
"100 https://tandfonline.com/author/Mundy%2C+Willia... M.D. \n",
"1326 https://tandfonline.com/author/Ruud%2C+William NaN \n",
"309 https://tandfonline.com/author/Thweatt%2C+William Ph.D. \n",
"811 https://tandfonline.com/author/Firman%2C+Win NaN \n",
"2412 https://tandfonline.com/author/Harano%2C+Yoshi... NaN \n",
"1947 https://tandfonline.com/author/Retief%2C+Yvonne NaN \n",
"2830 https://tandfonline.com/author/Mellacqua%2C+Ze... NaN \n",
"2930 https://tandfonline.com/author/Mellacqua%2C+Ze... NaN \n",
"1992 https://tandfonline.com/author/Cuiran%2C+Zhang NaN \n",
"\n",
" name year \\\n",
"102 A. Barbara Miller 1972 \n",
"469 A. Barchiesi 1976 \n",
"1615 A. J. Elliott 1992 \n",
"990 A. Thomas McLellan 1981 \n",
"605 A. William France 1977 \n",
"1428 A.J. Elliott 1988 \n",
"771 Aaron Lederer 1979 \n",
"1885 Aaron Lederer 1996 \n",
"1912 Aaron Lederer 1996 \n",
"1995 Aaron Lederer 1997 \n",
"2063 Aaron Lederer 1998 \n",
"332 Aaron Schiff 1975 \n",
"14 Aaron Wolfe Schiff 1971 \n",
"264 Aaron Wolfe Schiff 1975 \n",
"1765 Abe Wagner 1994 \n",
"1799 Abe Wagner 1995 \n",
"1166 Abel Magalhaes 1983 \n",
"1529 Acey Choy 1990 \n",
"1911 Adrian S. G. Stickley 1996 \n",
"2083 Adriana Balaguer Dunn 1999 \n",
"2530 Adrienne Lee 2008 \n",
"2827 Adrienne Lee 2014 \n",
"2356 Agnès Le Guernic 2004 \n",
"1673 Alain Cardon 1993 \n",
"2053 Alain Crespelle 1998 \n",
"1369 Alan Jacobs 1987 \n",
"1379 Alan Jacobs 1987 \n",
"1563 Alan Jacobs 1990 \n",
"1572 Alan Jacobs 1991 \n",
"1603 Alan Jacobs 1991 \n",
"... ... ... \n",
"594 William F. Sowder 1977 \n",
"106 William H. Holloway 1972 \n",
"203 William H. Holloway 1974 \n",
"370 William H. Holloway 1976 \n",
"394 William H. Holloway 1976 \n",
"428 William H. Holloway 1976 \n",
"1002 William H. Holloway 1981 \n",
"194 William H. Thweatt 1974 \n",
"867 William H. Thweatt 1980 \n",
"888 William Holloway 1980 \n",
"835 William J. Kenney 1979 \n",
"919 William J. Kenney 1980 \n",
"991 William J. Kenney 1981 \n",
"995 William J. Kenney 1981 \n",
"638 William J. O'Connor 1978 \n",
"843 William Kir-Stimon 1979 \n",
"659 William L. Davis 1978 \n",
"1000 William L. Moran 1981 \n",
"1315 William L. Moran 1986 \n",
"450 William L. Mundy 1976 \n",
"1749 William L. Mundy 1994 \n",
"100 William Lowe Mundy 1972 \n",
"1326 William Ruud 1986 \n",
"309 William Thweatt 1975 \n",
"811 Win Firman 1979 \n",
"2412 Yoshikazu Harano 2005 \n",
"1947 Yvonne Retief 1997 \n",
"2830 Zefiro Mellacqua 2014 \n",
"2930 Zefiro Mellacqua 2016 \n",
"1992 Zhang Cuiran 1997 \n",
"\n",
" title \\\n",
"102 Turn — Over \n",
"469 Exhibitionism and Ego States: A Phenomenologic... \n",
"1615 The Dance of Relationship \n",
"990 The Parenting Function of Therapeutic Communit... \n",
"605 Redefining and Paraphrasing \n",
"1428 A Treatment Program for the Child Referred by ... \n",
"771 The Redecision Movie \n",
"1885 The Unwanted Child \n",
"1912 Script and Counterscript: An Israeli Experience \n",
"1995 The Unwanted Child's Narcissistic Defense \n",
"2063 The Unwanted Child's Narcissistic Defense Revi... \n",
"332 Frames of Reference \n",
"14 Passivity \n",
"264 1974 Eric Berne Memorial Scientific Award Lecture \n",
"1765 Blue Ego States for Effective Communication \n",
"1799 My TA History \n",
"1166 Death Scripts \n",
"1529 The Winner's Triangle \n",
"1911 Validation of a Driver Checklist for Team Desi... \n",
"2083 Viewing the Transactional Dimensions of Spirit... \n",
"2530 The Power is in Our Process \n",
"2827 The Development of a Process Group \n",
"2356 Fairy Tales and Psychological Life Plans \n",
"1673 Organizational Holistics \n",
"2053 Self, Role, and Personhood: Differences and In... \n",
"1369 Autocratic Power \n",
"1379 Book Review: Toward Social Sanity and Human Su... \n",
"1563 Nationalism \n",
"1572 Aspects of Survival: Triumph over Death and On... \n",
"1603 Autocracy: Groups, Organizations, Nations, and... \n",
"... ... \n",
"594 Experimentation in Transactional Analysis \n",
"106 The Crazy Child in the Parent \n",
"203 Beyond Permission \n",
"370 The President's Page \n",
"394 President's Page \n",
"428 ITAA Historical Note \n",
"1002 A New Look at Mental Disorders: DSMIII \n",
"194 Integrating Transactional Analysis with a Univ... \n",
"867 Effective Permission-Giving and Representation... \n",
"888 Cure, a Lure \n",
"835 Naturally Occurring Teacher Ego State Behaviors \n",
"919 A TA Model of School Consultation: An Empirica... \n",
"991 Generalization of Ego State Behavior Change \n",
"995 Problem-Student Effects on Teacher Ego State B... \n",
"638 Bridging the Gap: Treatment in vivo “If You Wa... \n",
"843 Cinderella and the Frog: An American Myth \n",
"659 Beyond Magic Thinking \n",
"1000 Influence of Group Psychotherapy a Thirty Year... \n",
"1315 Influence of Group Psychotherapy: A Thirty-Eig... \n",
"450 Hypoglycemia—A Popular Wooden Leg \n",
"1749 “You Know.” Or Do You? \n",
"100 Physical Exam and Script Decision — One Hour \n",
"1326 Quality Circles: Will Transactional Analysis I... \n",
"309 “My High School Counselor Said I Should Be a F... \n",
"811 TAB (TA Buzz Words) — The Vocabulary Slimmer \n",
"2412 Role Lettering Therapy: A New Transactional An... \n",
"1947 Conscious Empowerment Therapy: A Model for Cou... \n",
"2830 Beyond Symbiosis \n",
"2930 When Spirit Comes to Mind \n",
"1992 A Comparative Study of Chinese and American Hi... \n",
"\n",
" doi \n",
"102 10.1177/036215377200200308 \n",
"469 10.1177/036215377600600323 \n",
"1615 10.1177/036215379202200106 \n",
"990 10.1177/036215378101100308 \n",
"605 10.1177/036215377700700409 \n",
"1428 10.1177/036215378801800208 \n",
"771 10.1177/036215377900900212 \n",
"1885 10.1177/036215379602600205 \n",
"1912 10.1177/036215379602600309 \n",
"1995 10.1177/036215379702700405 \n",
"2063 10.1177/036215379802800409 \n",
"332 10.1177/036215377500500320 \n",
"14 10.1177/036215377100100114 \n",
"264 10.1177/036215377500500117 \n",
"1765 10.1177/036215379402400408 \n",
"1799 10.1177/036215379502500123 \n",
"1166 10.1177/036215378301300411 \n",
"1529 10.1177/036215379002000105 \n",
"1911 10.1177/036215379602600308 \n",
"2083 10.1177/036215379902900205 \n",
"2530 10.1177/036215370803800106 \n",
"2827 /10.1177/0362153714527424 \n",
"2356 10.1177/036215370403400305 \n",
"1673 10.1177/036215379302300203 \n",
"2053 10.1177/036215379802800309 \n",
"1369 10.1177/036215378701700303 \n",
"1379 10.1177/036215378701700312 \n",
"1563 10.1177/036215379002000403 \n",
"1572 10.1177/036215379102100102 \n",
"1603 10.1177/036215379102100402 \n",
"... ... \n",
"594 10.1177/036215377700700329 \n",
"106 10.1177/036215377200200311 \n",
"203 10.1177/036215377400400205 \n",
"370 10.1177/036215377600600101 \n",
"394 10.1177/036215377600600201 \n",
"428 10.1177/036215377600600231 \n",
"1002 10.1177/036215378101100317 \n",
"194 10.1177/036215377400400109 \n",
"867 10.1177/036215378001000116 \n",
"888 10.1177/036215378001000214 \n",
"835 10.1177/036215377900900416 \n",
"919 10.1177/036215378001000319 \n",
"991 10.1177/036215378101100309 \n",
"995 10.1177/036215378101100312 \n",
"638 10.1177/036215377800800111 \n",
"843 10.1177/036215377900900421 \n",
"659 10.1177/036215377800800209 \n",
"1000 10.1177/036215378101100316 \n",
"1315 10.1177/036215378601600210 \n",
"450 10.1177/036215377600600304 \n",
"1749 10.1177/036215379402400310 \n",
"100 10.1177/036215377200200306 \n",
"1326 10.1177/036215378601600307 \n",
"309 10.1177/036215377500500304 \n",
"811 10.1177/036215377900900325 \n",
"2412 10.1177/036215370503500305 \n",
"1947 10.1177/036215379702700110 \n",
"2830 /10.1177/0362153714529410 \n",
"2930 /10.1177/0362153716636640 \n",
"1992 10.1177/036215379702700403 \n",
"\n",
"[3030 rows x 6 columns]"
]
},
"execution_count": 54,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# https://michaeljsanders.com/2017/04/17/python-vlookup.html\n",
"merged_df = adf.merge(df, how='left', on='doi')[['authorURL','degree','name','year','title','doi']].sort_values(by=['name','year','doi'])\n",
"merged_df"
]
},
{
"cell_type": "code",
"execution_count": 55,
"metadata": {},
"outputs": [],
"source": [
"merged_df.to_csv('AuthorsListing.csv', index=False, quoting=csv.QUOTE_NONNUMERIC)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"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
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment