Skip to content

Instantly share code, notes, and snippets.

@zuphilip

zuphilip/BWL-Benchmarking.ipynb

Created July 5, 2018 20:23
Show Gist options
  • Save zuphilip/712f4de051df872f8ef33a111348c030 to your computer and use it in GitHub Desktop.
Save zuphilip/712f4de051df872f8ef33a111348c030 to your computer and use it in GitHub Desktop.
Download ZIP
BWL Benchmarking counting UTD24 and FT50 publications for a list of persons
Display the source blob
Display the rendered blob
Raw
BWL-Benchmarking.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"!pip install crossrefapi -q"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'Testing BWL Benchmarking/ (; mailto:Philipp Zumstein (Mannheim University Library)) BasedOn: CrossrefAPI/1.3.0'"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from crossref.restful import Works, Journals, Etiquette\n",
"my_etiquette = Etiquette('Testing BWL Benchmarking', '', '', 'Philipp Zumstein (Mannheim University Library)')\n",
"str(my_etiquette)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Liste mit ISSNs von allen relevanten Zeitschriften\n",
"\n",
"Die Liste umfasst alle 51 Zeitschriften aus UTD24 sowie FT50. Stand 2018-05"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Beim INFORMS Journal on Computing anstatt der ISSN 1091-9856 die eISSN 1526-5528 verwenden!"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"issnUT24FT50 = [\n",
" '0001-4273', '0363-7425', '0001-4826', '0361-3682', '0001-8392', \n",
" '0002-8282', '0823-9150', '0012-9682', '1042-2587', '0017-8012', \n",
" '0018-7267', '0090-4848', '1047-7047', '0165-4101', '0021-8456', \n",
" '0021-9010', '0167-4544', '0883-9026', '1057-7408', '0093-5301', \n",
" '0022-1082', '0022-1090', '0304-405X', '0047-2506', '0149-2063', \n",
" '0742-1222', '0022-2380', '0022-2429', '0022-2437', '0272-6963', \n",
" '0022-3808', '0092-0703', '0025-1909', '1523-4614', '0732-2399', \n",
" '0276-7783', '0030-364X', '1047-7039', '0170-8406', '0749-5978', \n",
" '1059-1478', '0033-5533', '0048-7333', '1380-6653', '0034-6527', \n",
" '1572-3097', '0893-9454', '1532-9194', '1932-4391', '0143-2095', \n",
" '1526-5528'\n",
"]\n",
"issnTestList = ['0022-2461']"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"onlyFT45 = ['1558-9080', '0008-1256', '0162-1459', '0741-6261']\n",
"\n",
"issnListOld = [\n",
" '0001-4273', '1943-4529', '0363-7425', '0361-3682', '0001-8392', \n",
" '0002-8282', '2162-8564', '0823-9150', '0012-9682', '0017-8012',\n",
" '0090-4848', '1526-5536', '0165-4101', '0021-8456', '0021-9010',\n",
" '1573-0697', '0883-9026', '1057-7408', '0093-5301', '1540-6261',\n",
" '0022-1090', '0304-405x', '1478-6990', '0022-2380', '0022-2429',\n",
" '0022-2437', '0272-6963', '0022-3808', '0162-1459', '1526-5528',\n",
" '0025-1909', '1526-5498', '1526-548X', '0276-7783', '0030-364X',\n",
" '1047-7039', '0170-8406', '0749-5978', '1059-1478', '0033-5533',\n",
" '0741-6261', '1380-6653', '0893-9454', '1532-9194', '0143-2095',\n",
" '0001-4826'\n",
" ]"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {},
"outputs": [],
"source": [
"#issnList = issnTestList\n",
"issnList = issnUT24FT50\n",
"#issnList = onlyFT45"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Academy of Management Journal | Academy of Management\n",
"129 articles in 2017\n",
"95 articles in 2016\n",
"79 articles in 2015\n",
"79\n",
"[114, 96, 80, 70, 70, 59, 57, 56, 49, 48, 44, 40, 40, 38, 38, 38, 36, 35, 35, 32, 32, 32, 29, 28, 28, 27, 26, 26, 26, 25, 24, 24, 23, 22, 21, 20, 20, 20, 20, 19, 19, 19, 19, 18, 18, 18, 18, 17, 17, 17, 16, 16, 16, 15, 15, 15, 15, 15, 14, 13, 13, 13, 13, 13, 12, 12, 11, 11, 11, 10, 10, 9, 9, 9, 9, 8, 8, 4, 1]\n",
"Academy of Management Review | Academy of Management\n",
"55 articles in 2017\n",
"45 articles in 2016\n",
"41 articles in 2015\n",
"41\n",
"[90, 59, 57, 48, 47, 46, 38, 34, 34, 33, 31, 31, 30, 27, 27, 25, 22, 21, 19, 16, 16, 16, 14, 13, 13, 9, 9, 6, 6, 6, 5, 3, 3, 3, 2, 2, 2, 2, 1, 1, 0]\n",
"The Accounting Review | American Accounting Association\n",
"114 articles in 2015\n",
"98 articles in 2017\n",
"91 articles in 2016\n",
"114\n",
"[41, 30, 29, 25, 23, 20, 19, 19, 18, 17, 17, 17, 17, 16, 14, 14, 13, 13, 13, 12, 12, 11, 11, 11, 10, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 7, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Accounting Organizations and Society | Elsevier \n",
"54 articles in 2015\n",
"49 articles in 2016\n",
"48 articles in 2017\n",
"54\n",
"[73, 20, 18, 17, 16, 13, 12, 12, 12, 11, 11, 11, 9, 9, 9, 8, 7, 7, 7, 7, 6, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Administrative Science Quarterly | SAGE Publications\n",
"54 articles in 2017\n",
"51 articles in 2016\n",
"40 articles in 2015\n",
"40\n",
"[45, 43, 38, 31, 29, 29, 26, 25, 22, 18, 18, 17, 17, 16, 12, 11, 10, 10, 9, 8, 5, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"The American Economic Review | American Economic Association\n",
"287 articles in 2016\n",
"286 articles in 2017\n",
"272 articles in 2015\n",
"272\n",
"[319, 204, 156, 109, 72, 63, 60, 60, 56, 55, 53, 52, 48, 47, 46, 43, 43, 42, 42, 40, 39, 38, 37, 36, 34, 33, 31, 31, 30, 30, 29, 28, 26, 26, 26, 26, 26, 25, 24, 24, 23, 22, 21, 21, 21, 21, 20, 20, 20, 20, 20, 19, 19, 19, 18, 18, 18, 18, 18, 18, 18, 18, 17, 17, 17, 17, 16, 16, 16, 16, 16, 16, 15, 15, 15, 15, 15, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 13, 13, 13, 12, 12, 12, 12, 12, 12, 12, 12, 11, 11, 11, 11, 11, 11, 10, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Contemporary Accounting Research | Wiley (Blackwell Publishing)\n",
"96 articles in 2017\n",
"91 articles in 2015\n",
"59 articles in 2016\n",
"91\n",
"[53, 36, 25, 24, 19, 14, 14, 12, 11, 11, 10, 10, 9, 9, 8, 8, 8, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Econometrica | The Econometric Society\n",
"92 articles in 2015\n",
"89 articles in 2017\n",
"83 articles in 2016\n",
"92\n",
"[86, 48, 38, 37, 32, 27, 25, 25, 24, 22, 22, 20, 19, 19, 18, 18, 15, 14, 13, 12, 11, 11, 11, 10, 10, 10, 9, 9, 9, 9, 9, 9, 8, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 2, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Entrepreneurship Theory and Practice | SAGE Publications\n",
"59 articles in 2017\n",
"59 articles in 2015\n",
"45 articles in 2016\n",
"59\n",
"[136, 77, 39, 31, 19, 19, 19, 17, 15, 15, 15, 15, 14, 13, 12, 12, 11, 11, 10, 10, 10, 9, 9, 8, 8, 8, 7, 7, 7, 6, 6, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 3, 3, 3, 3, 3, 2, 2, 2, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Human Relations | SAGE Publications\n",
"111 articles in 2016\n",
"100 articles in 2015\n",
"76 articles in 2017\n",
"100\n",
"[35, 32, 31, 28, 23, 23, 21, 21, 19, 19, 18, 17, 16, 16, 14, 14, 13, 13, 13, 13, 13, 13, 13, 12, 11, 11, 11, 11, 11, 11, 10, 10, 10, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 7, 6, 6, 5, 5, 5, 4, 4, 4, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Human Resource Management | Wiley (John Wiley & Sons)\n",
"103 articles in 2015\n",
"76 articles in 2017\n",
"55 articles in 2016\n",
"103\n",
"[31, 31, 24, 23, 23, 18, 18, 17, 17, 16, 16, 16, 15, 15, 15, 15, 14, 14, 13, 12, 12, 12, 11, 11, 10, 10, 10, 10, 10, 9, 9, 8, 8, 8, 8, 8, 7, 6, 6, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Information Systems Research | Institute for Operations Research and the Management Sciences\n",
"65 articles in 2016\n",
"60 articles in 2017\n",
"55 articles in 2015\n",
"55\n",
"[30, 26, 23, 22, 18, 18, 17, 16, 14, 13, 12, 12, 12, 11, 10, 10, 10, 9, 9, 8, 8, 7, 7, 7, 6, 6, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Accounting and Economics | Elsevier \n",
"57 articles in 2016\n",
"50 articles in 2017\n",
"45 articles in 2015\n",
"45\n",
"[53, 46, 32, 30, 28, 24, 23, 21, 15, 14, 14, 12, 12, 11, 11, 11, 11, 10, 10, 10, 9, 7, 6, 6, 5, 5, 5, 5, 4, 4, 3, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Accounting Research | Wiley (Blackwell Publishing)\n",
"47 articles in 2017\n",
"47 articles in 2016\n",
"38 articles in 2015\n",
"38\n",
"[90, 43, 31, 27, 25, 23, 21, 20, 20, 17, 16, 14, 12, 12, 11, 10, 9, 8, 8, 7, 5, 5, 5, 4, 4, 3, 2, 2, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0]\n",
"Journal of Applied Psychology | American Psychological Association\n",
"147 articles in 2017\n",
"136 articles in 2015\n",
"127 articles in 2016\n",
"136\n",
"[93, 55, 55, 54, 49, 49, 46, 46, 41, 38, 38, 38, 38, 37, 36, 35, 33, 32, 31, 28, 27, 27, 25, 25, 25, 24, 23, 23, 22, 22, 21, 21, 21, 21, 20, 19, 19, 19, 19, 18, 18, 18, 18, 18, 18, 18, 17, 17, 16, 16, 16, 16, 15, 15, 14, 14, 14, 13, 13, 13, 13, 13, 13, 12, 12, 12, 12, 12, 12, 11, 10, 10, 10, 10, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 5, 5, 5, 4, 4, 4, 3, 3, 3, 3, 2, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Business Ethics | Springer-Verlag\n",
"479 articles in 2015\n",
"412 articles in 2016\n",
"357 articles in 2017\n",
"479\n",
"[73, 39, 36, 31, 30, 26, 22, 22, 21, 21, 20, 19, 18, 18, 18, 18, 17, 16, 16, 15, 15, 15, 14, 14, 14, 14, 14, 14, 14, 13, 13, 13, 13, 12, 12, 12, 12, 12, 12, 12, 11, 11, 11, 11, 11, 11, 11, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Business Venturing | Elsevier \n",
"55 articles in 2015\n",
"51 articles in 2017\n",
"42 articles in 2016\n",
"55\n",
"[118, 105, 87, 74, 55, 45, 44, 43, 36, 33, 29, 27, 26, 25, 25, 24, 24, 22, 21, 20, 20, 20, 18, 17, 16, 15, 15, 14, 14, 14, 13, 13, 13, 13, 12, 11, 10, 10, 10, 9, 8, 7, 6, 5, 5, 5, 5, 1, 0, 0, 0, 0, 0, 0, 0]\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"Journal of Consumer Psychology | Wiley (John Wiley & Sons)\n",
"79 articles in 2017\n",
"65 articles in 2016\n",
"63 articles in 2015\n",
"63\n",
"[66, 55, 53, 53, 52, 43, 43, 41, 31, 25, 21, 21, 16, 10, 10, 9, 9, 9, 9, 8, 8, 7, 7, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Consumer Research | Oxford University Press\n",
"129 articles in 2017\n",
"93 articles in 2016\n",
"80 articles in 2015\n",
"80\n",
"[73, 64, 38, 36, 36, 32, 31, 26, 24, 21, 20, 20, 18, 16, 16, 16, 16, 16, 15, 15, 15, 14, 14, 14, 14, 13, 13, 13, 12, 12, 12, 12, 11, 10, 10, 9, 8, 8, 8, 7, 7, 6, 6, 6, 6, 6, 4, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"The Journal of Finance | Wiley (Blackwell Publishing)\n",
"142 articles in 2016\n",
"111 articles in 2017\n",
"111 articles in 2015\n",
"111\n",
"[81, 62, 58, 51, 49, 45, 44, 43, 42, 42, 41, 38, 38, 37, 36, 34, 31, 31, 31, 29, 28, 28, 27, 26, 24, 24, 23, 23, 21, 20, 20, 18, 18, 18, 17, 17, 17, 17, 16, 16, 16, 15, 14, 14, 14, 14, 13, 13, 13, 13, 13, 12, 12, 12, 12, 11, 11, 10, 9, 8, 8, 7, 7, 7, 6, 6, 5, 5, 4, 4, 3, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Financial and Quantitative Analysis | Cambridge University Press\n",
"104 articles in 2017\n",
"80 articles in 2016\n",
"61 articles in 2015\n",
"61\n",
"[47, 27, 21, 20, 17, 16, 14, 13, 13, 13, 12, 12, 12, 12, 10, 10, 9, 8, 8, 8, 8, 7, 7, 7, 7, 7, 6, 5, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Financial Economics | Elsevier \n",
"137 articles in 2017\n",
"135 articles in 2016\n",
"134 articles in 2015\n",
"134\n",
"[365, 117, 83, 73, 61, 56, 54, 54, 53, 49, 47, 46, 45, 43, 42, 40, 39, 38, 38, 38, 37, 35, 35, 34, 33, 33, 32, 30, 29, 28, 27, 27, 27, 27, 27, 26, 25, 25, 24, 24, 24, 23, 22, 21, 21, 20, 20, 20, 19, 18, 18, 17, 17, 16, 16, 16, 15, 15, 15, 14, 14, 13, 13, 13, 13, 13, 13, 13, 12, 12, 12, 12, 11, 11, 11, 11, 11, 10, 10, 10, 10, 9, 9, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 3, 2, 2, 2, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of International Business Studies | Springer Nature\n",
"82 articles in 2017\n",
"60 articles in 2016\n",
"54 articles in 2015\n",
"54\n",
"[115, 102, 61, 50, 37, 31, 27, 27, 26, 26, 24, 20, 20, 18, 17, 17, 17, 17, 15, 14, 13, 13, 12, 12, 11, 11, 10, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 7, 7, 7, 6, 6, 6, 6, 5, 4, 4, 2, 1, 1, 0, 0, 0, 0]\n",
"Journal of Management | SAGE Publications\n",
"157 articles in 2016\n",
"79 articles in 2015\n",
"78 articles in 2017\n",
"79\n",
"[74, 69, 52, 42, 41, 32, 30, 23, 21, 19, 18, 16, 13, 13, 13, 13, 12, 11, 11, 10, 10, 9, 9, 9, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0]\n",
"Journal of Management Information Systems | Informa UK (Taylor & Francis)\n",
"56 articles in 2015\n",
"46 articles in 2017\n",
"46 articles in 2016\n",
"56\n",
"[23, 23, 22, 20, 19, 18, 16, 16, 15, 15, 12, 12, 11, 11, 10, 9, 9, 9, 9, 9, 9, 8, 7, 7, 7, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 3, 3, 3, 3, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Management Studies | Wiley (Blackwell Publishing)\n",
"83 articles in 2017\n",
"71 articles in 2016\n",
"60 articles in 2015\n",
"60\n",
"[41, 30, 29, 29, 28, 27, 27, 23, 21, 20, 20, 19, 19, 19, 19, 17, 17, 16, 16, 15, 13, 12, 11, 11, 11, 11, 11, 10, 10, 8, 8, 8, 8, 8, 7, 7, 6, 5, 4, 4, 3, 3, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Marketing | American Marketing Association\n",
"49 articles in 2017\n",
"44 articles in 2016\n",
"40 articles in 2015\n",
"40\n",
"[71, 48, 48, 45, 41, 35, 27, 25, 24, 23, 20, 20, 19, 19, 18, 18, 18, 17, 17, 16, 16, 14, 14, 14, 13, 13, 12, 8, 7, 7, 6, 6, 5, 3, 3, 1, 1, 0, 0, 0]\n",
"Journal of Marketing Research | American Marketing Association\n",
"68 articles in 2016\n",
"65 articles in 2017\n",
"59 articles in 2015\n",
"59\n",
"[60, 47, 45, 40, 40, 32, 27, 26, 23, 20, 20, 19, 19, 18, 17, 17, 17, 16, 14, 13, 13, 12, 12, 11, 10, 10, 10, 10, 10, 9, 9, 9, 8, 8, 7, 7, 7, 6, 6, 6, 6, 5, 5, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 2, 2, 2, 1, 1, 0]\n",
"Journal of Operations Management | Elsevier \n",
"65 articles in 2015\n",
"62 articles in 2016\n",
"25 articles in 2017\n",
"65\n",
"[106, 67, 63, 57, 53, 50, 47, 43, 39, 33, 30, 27, 26, 23, 19, 18, 18, 18, 18, 15, 13, 12, 12, 12, 12, 12, 11, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 6, 5, 5, 5, 4, 3, 2, 2, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of Political Economy | The University of Chicago Press\n",
"96 articles in 2017\n",
"59 articles in 2016\n",
"51 articles in 2015\n",
"51\n",
"[34, 28, 28, 23, 21, 21, 20, 19, 18, 17, 16, 15, 14, 13, 13, 12, 12, 12, 12, 11, 10, 10, 9, 7, 7, 7, 6, 6, 5, 5, 4, 2, 2, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Journal of the Academy of Marketing Science | Springer-Verlag\n",
"64 articles in 2017\n",
"47 articles in 2015\n",
"39 articles in 2016\n",
"47\n",
"[297, 94, 42, 36, 31, 30, 29, 21, 19, 17, 15, 15, 14, 14, 14, 14, 13, 13, 11, 11, 9, 9, 9, 8, 7, 7, 6, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 2, 2, 1, 1, 0, 0, 0, 0]\n",
"Management Science | Institute for Operations Research and the Management Sciences\n",
"370 articles in 2017\n",
"205 articles in 2015\n",
"202 articles in 2016\n",
"205\n",
"[85, 79, 60, 47, 40, 40, 38, 33, 30, 29, 29, 27, 27, 27, 27, 25, 25, 25, 24, 24, 23, 23, 23, 22, 21, 20, 19, 19, 19, 18, 17, 17, 17, 16, 16, 16, 16, 16, 15, 15, 15, 15, 15, 15, 15, 14, 14, 14, 14, 14, 14, 14, 13, 13, 13, 13, 13, 12, 12, 12, 12, 11, 11, 11, 11, 11, 11, 11, 10, 10, 10, 10, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Manufacturing & Service Operations Management | Institute for Operations Research and the Management Sciences\n",
"52 articles in 2015\n",
"48 articles in 2017\n",
"45 articles in 2016\n",
"52\n",
"[25, 15, 15, 15, 14, 12, 12, 12, 11, 11, 10, 8, 8, 7, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 5, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 2, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Marketing Science | Institute for Operations Research and the Management Sciences\n",
"74 articles in 2015\n",
"63 articles in 2017\n",
"59 articles in 2016\n",
"74\n",
"[43, 27, 23, 22, 20, 18, 18, 16, 15, 15, 13, 13, 11, 11, 11, 10, 9, 9, 9, 9, 8, 8, 7, 7, 7, 7, 6, 6, 6, 6, 5, 5, 5, 4, 4, 4, 3, 3, 3, 3, 3, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"MIS Quarterly | MIS Quarterly\n",
"65 articles in 2017\n",
"55 articles in 2016\n",
"47 articles in 2015\n",
"47\n",
"[123, 67, 56, 37, 36, 34, 25, 25, 24, 23, 20, 16, 13, 12, 12, 11, 10, 10, 10, 10, 9, 9, 9, 8, 8, 8, 8, 8, 7, 5, 4, 4, 3, 3, 3, 2, 2, 2, 2, 2, 1, 0, 0, 0, 0, 0, 0]\n",
"Operations Research | Institute for Operations Research and the Management Sciences\n",
"113 articles in 2016\n",
"108 articles in 2015\n",
"107 articles in 2017\n",
"108\n",
"[28, 27, 23, 20, 17, 17, 17, 16, 16, 16, 14, 14, 13, 13, 13, 13, 12, 12, 12, 11, 11, 11, 11, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Organization Science | Institute for Operations Research and the Management Sciences\n",
"112 articles in 2015\n",
"76 articles in 2016\n",
"62 articles in 2017\n",
"112\n",
"[55, 45, 37, 32, 31, 30, 29, 27, 26, 23, 20, 17, 17, 17, 17, 16, 16, 16, 16, 15, 15, 15, 15, 13, 13, 13, 12, 12, 12, 12, 12, 11, 11, 11, 11, 11, 11, 11, 11, 11, 10, 10, 10, 10, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 5, 5, 5, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Organization Studies | SAGE Publications\n",
"117 articles in 2017\n",
"113 articles in 2016\n",
"102 articles in 2015\n",
"102\n",
"[67, 51, 35, 24, 23, 22, 21, 21, 19, 19, 18, 18, 16, 16, 16, 15, 15, 15, 14, 14, 12, 12, 12, 12, 11, 11, 11, 10, 10, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 4, 4, 4, 4, 3, 3, 3, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"Organizational Behavior and Human Decision Processes | Elsevier \n",
"74 articles in 2015\n",
"55 articles in 2016\n",
"46 articles in 2017\n",
"74\n",
"[41, 29, 25, 21, 17, 15, 15, 14, 14, 12, 11, 11, 11, 10, 10, 10, 10, 10, 9, 9, 9, 8, 8, 8, 8, 8, 7, 7, 7, 7, 6, 6, 6, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Production and Operations Management | Wiley (Blackwell Publishing)\n",
"191 articles in 2016\n",
"182 articles in 2015\n",
"171 articles in 2017\n",
"182\n",
"[31, 23, 23, 14, 13, 13, 13, 12, 12, 12, 12, 12, 11, 11, 10, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"The Quarterly Journal of Economics | Oxford University Press\n",
"63 articles in 2016\n",
"59 articles in 2015\n",
"51 articles in 2017\n",
"59\n",
"[71, 64, 48, 44, 43, 39, 36, 31, 29, 27, 26, 24, 24, 24, 23, 22, 22, 19, 19, 19, 18, 18, 18, 18, 16, 15, 13, 9, 9, 9, 7, 7, 7, 7, 5, 5, 5, 5, 5, 4, 4, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Research Policy | Elsevier \n",
"170 articles in 2016\n",
"155 articles in 2015\n",
"149 articles in 2017\n",
"155\n",
"[67, 65, 57, 53, 42, 42, 41, 41, 38, 36, 35, 34, 34, 33, 33, 33, 29, 29, 28, 25, 25, 24, 24, 24, 23, 23, 22, 22, 21, 21, 21, 21, 20, 20, 20, 19, 19, 19, 18, 18, 18, 18, 17, 17, 17, 16, 16, 16, 16, 16, 16, 15, 15, 15, 14, 14, 14, 14, 13, 13, 13, 13, 13, 13, 12, 12, 12, 12, 11, 11, 11, 11, 11, 11, 10, 10, 10, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Review of Accounting Studies | Springer-Verlag\n",
"51 articles in 2017\n",
"37 articles in 2016\n",
"30 articles in 2015\n",
"30\n",
"[19, 14, 12, 12, 10, 10, 7, 6, 6, 5, 5, 4, 4, 3, 3, 3, 2, 2, 2, 2, 2, 1, 1, 1, 1, 0, 0, 0, 0, 0]\n",
"The Review of Economic Studies | Oxford University Press\n",
"79 articles in 2017\n",
"64 articles in 2016\n",
"56 articles in 2015\n",
"56\n",
"[74, 45, 41, 24, 22, 22, 22, 20, 19, 18, 17, 17, 16, 16, 14, 14, 12, 12, 12, 12, 11, 11, 10, 10, 9, 9, 9, 8, 8, 7, 7, 7, 7, 6, 6, 5, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 2, 2, 2, 2, 1, 1, 1, 1, 0, 0]\n",
"Review of Finance | Oxford University Press\n",
"70 articles in 2016\n",
"70 articles in 2015\n",
"66 articles in 2017\n",
"70\n",
"[32, 9, 9, 8, 8, 8, 8, 7, 7, 7, 6, 6, 6, 6, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Review of Financial Studies | Oxford University Press\n",
"149 articles in 2017\n",
"143 articles in 2016\n",
"132 articles in 2015\n",
"132\n",
"[114, 66, 41, 38, 31, 23, 22, 22, 21, 19, 18, 18, 18, 17, 16, 16, 15, 15, 15, 15, 15, 13, 13, 13, 12, 12, 12, 11, 11, 11, 11, 11, 11, 11, 10, 9, 8, 8, 8, 8, 7, 7, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"Strategic Entrepreneurship Journal | Wiley (John Wiley & Sons)\n",
"44 articles in 2017\n",
"33 articles in 2016\n",
"24 articles in 2015\n",
"24\n",
"[68, 53, 53, 31, 30, 27, 18, 14, 11, 11, 10, 10, 9, 7, 5, 4, 4, 3, 3, 3, 0, 0, 0, 0]\n",
"Strategic Management Journal | Wiley (John Wiley & Sons)\n",
"179 articles in 2016\n",
"130 articles in 2017\n",
"121 articles in 2015\n",
"121\n",
"[104, 49, 40, 36, 33, 33, 31, 27, 25, 24, 23, 23, 20, 19, 18, 18, 18, 17, 17, 17, 17, 17, 15, 15, 14, 14, 14, 13, 13, 13, 13, 13, 13, 13, 12, 12, 11, 11, 11, 11, 11, 11, 11, 11, 10, 10, 10, 10, 10, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 6, 6, 6, 6, 6, 6, 5, 5, 5, 5, 5, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"INFORMS Journal on Computing | Institute for Operations Research and the Management Sciences\n",
"54 articles in 2016\n",
"54 articles in 2015\n",
"49 articles in 2017\n",
"54\n",
"[71, 12, 10, 9, 9, 9, 9, 7, 7, 7, 7, 6, 6, 6, 5, 5, 5, 5, 4, 4, 4, 4, 4, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\n",
"49 von 51\n"
]
}
],
"source": [
"k = 0\n",
"details = []\n",
"inCrossref = {}\n",
"for issn in issnList:\n",
" journal = Journals(etiquette=my_etiquette).journal(issn)\n",
" details.append(journal)\n",
" if journal:\n",
" inCrossref[issn] = True\n",
" print(journal['title'], \" | \", journal['publisher'])\n",
" k = k+1\n",
" if (journal['breakdowns'] and journal['breakdowns']['dois-by-issued-year']):\n",
" dois = journal['breakdowns']['dois-by-issued-year']\n",
" for doi in dois:\n",
" if doi[0]==2017:\n",
" print(doi[1], \"articles in 2017\")\n",
" if doi[0]==2016:\n",
" print(doi[1], \"articles in 2016\")\n",
" if doi[0]==2015:\n",
" print(doi[1], \"articles in 2015\")\n",
" \n",
" ncites = []\n",
" works = Journals(etiquette=my_etiquette).works(issn).filter(from_pub_date=2015).filter(until_pub_date=2015)\n",
" #print(works.url)\n",
" for article in works:\n",
" if (article['is-referenced-by-count']):\n",
" ncites.append(article['is-referenced-by-count'])\n",
" else:\n",
" ncites.append(0)\n",
" print(len(ncites))\n",
" print(sorted(ncites, reverse=True)) \n",
" else:\n",
" inCrossref[issn] = False \n",
" \n",
"print(k, \" von \", len(issnList))\n",
"#print(details)"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"0017-8012\n",
"1532-9194\n"
]
}
],
"source": [
"for issn in issnList:\n",
" if (not(inCrossref[issn])):\n",
" print(issn)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Problemfälle\n",
"\n",
"* Harvard Business Review 0017-8012 (keine DOIs)\n",
"* MIT Sloan Management Review 1532-9194 (keine DOIs)\n",
"* ~~Journal of Finance (Datumsfilter funktioniert nicht)~~"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Personenliste\n",
"\n",
"Eine Liste von Personenen einer oder auch mehreren Institutionen ist vorgegeben. Für jede Person wird getrennt der Nachname wie der Vorname gespeichert."
]
},
{
"cell_type": "raw",
"metadata": {},
"source": [
"Prof. Christian Homburg, Universität Mannheim\n",
"Prof. Holger Daske, Universität Mannheim\n",
"Prof. Matthias Blonski, Goethe-Universität Frankfurt\n",
"Prof. Alexander Hillert, Goethe Universität Frankfurt\n",
"Associate Prof. Kristine De Valck, HEC Paris\n",
"Prof. Augustin Landier, HEC Paris\n",
"Prof. Nikolaus Franke, WU Wien\n",
"Prof. Nadia Abou Nabout, WU Wien\n",
"Prof. Dietmar Grichnik, St. Gallen\n",
"Prof. Gerald Häubl, St. Gallen"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {},
"outputs": [],
"source": [
"authorList = [{'lastName': 'Homburg', 'firstName': 'Christian'},\n",
" {'lastName': 'Daske', 'firstName': 'Holger'},\n",
" {'lastName': 'Blonski', 'firstName': 'Matthias'},\n",
" {'lastName': 'Hillert', 'firstName': 'Alexander'},\n",
" {'lastName': 'De Valck', 'firstName': 'Kristine'},\n",
" {'lastName': 'Landier', 'firstName': 'Augustin'},\n",
" {'lastName': 'Franke', 'firstName': 'Nikolaus'},\n",
" {'lastName': 'Nabout', 'firstName': 'Nadia Abou'},\n",
" {'lastName': 'Abou Nabout', 'firstName': 'Nadia'},\n",
" {'lastName': 'Grichnik', 'firstName': 'Dietmar'},\n",
" {'lastName': 'Häubl', 'firstName': 'Gerald'}\n",
" ]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Anzahl Publikationen in diesen Zeitschriften\n",
"\n",
"Für jede ISSN und jede Personen in den oben definierten Listen werden die Anzahl Publikationen gezählt. Die erste Berechnung gibt die Detailinformationen zurück und die folgende Berechnung gibt diese dann aggregiert heraus."
]
},
{
"cell_type": "code",
"execution_count": 33,
"metadata": {
"scrolled": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"\"Homburg\",\"Christian\",\"0361-3682\",\"10.1016/j.aos.2012.07.001\",\"Performance-measurement system design and functional strategic decision influence: The role of performance-measure properties\",\"2012\",\"Accounting, Organizations and Society\",\"Martin Artz + Christian Homburg + Thomas Rajab + \",\"24\"\n",
"\"Homburg\",\"Christian\",\"0093-5301\",\"10.1086/659874\",\"Psychological Distance and the Dual Role of Price\",\"2011\",\"Journal of Consumer Research\",\"Torsten Bornemann + Christian Homburg + \",\"47\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.72.4.29\",\"Satisfaction, Complaint, and the Stock Value Gap\",\"2008\",\"Journal of Marketing\",\"Xueming Luo + Christian Homburg + \",\"47\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.09.0486\",\"Customer Uncertainty Following Downsizing: The Effects of Extent of Downsizing and Open Communication\",\"2012\",\"Journal of Marketing\",\"Christian Homburg + Martin Klarmann + Sabine Staritz + \",\"8\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.2307/1251976\",\"Retaliatory Behavior to New Product Entry\",\"1999\",\"Journal of Marketing\",\"Sabine Kuester + Christian Homburg + Thomas S. Robertson + \",\"66\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.14.0398\",\"Motivating Sales Reps for Innovation Selling in Different Cultures\",\"2016\",\"Journal of Marketing\",\"Sebastian Hohenberg + Christian Homburg + \",\"12\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.12.0179\",\"Firm Value Creation Through Major Channel Expansions: Evidence from an Event Study in the United States, Germany, and China\",\"2014\",\"Journal of Marketing\",\"Christian Homburg + Josef Vollmayr + Alexander Hahn + \",\"32\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.12.0529\",\"Looking Beyond the Horizon: How to Approach the Customers' Customers in Business-to-Business Markets\",\"2014\",\"Journal of Marketing\",\"Christian Homburg + Halina Wilczek + Alexander Hahn + \",\"22\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.12.0089\",\"Corporate Social Responsibility in Business-to-Business Markets: How Organizational Customers Account for Supplier Corporate Social Responsibility Engagement\",\"2013\",\"Journal of Marketing\",\"Christian Homburg + Marcel Stierl + Torsten Bornemann + \",\"72\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.73.5.70\",\"Managing Dynamics in a Customer Portfolio\",\"2009\",\"Journal of Marketing\",\"Christian Homburg + Viviana V Steiner + Dirk Totzek + \",\"39\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.14.0199\",\"New Product Design: Concept, Measurement, and Consequences\",\"2015\",\"Journal of Marketing\",\"Christian Homburg + Martin Schwemmle + Christina Kuehnl + \",\"45\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.69.3.95.66367\",\"How Organizational Complaint Handling Drives Customer Loyalty: An Analysis of the Mechanistic and the Organic Approach\",\"2005\",\"Journal of Marketing\",\"Christian Homburg + Andreas Fürst + \",\"191\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.2307/1251741\",\"Marketing Organization: An Integrative Framework of Dimensions and Determinants\",\"1998\",\"Journal of Marketing\",\"John P. Workman + Christian Homburg + Kjell Gruner + \",\"136\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.73.4.64\",\"Implementing the Marketing Concept at the Employee–Customer Interface: The Role of Customer Need Knowledge\",\"2009\",\"Journal of Marketing\",\"Christian Homburg + Jan Wieseke + Torsten Bornemann + \",\"145\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.11.0251\",\"How to Organize Pricing? Vertical Delegation and Horizontal Dispersion of Pricing Authority\",\"2012\",\"Journal of Marketing\",\"Christian Homburg + Ove Jensen + Alexander Hahn + \",\"23\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.69.1.95.55510\",\"A Marketing Perspective on Mergers and Acquisitions: How Marketing Integration Affects Postmerger Performance\",\"2005\",\"Journal of Marketing\",\"Christian Homburg + Matthias Bucerius + \",\"75\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.70.3.21\",\"The Role of Cognition and Affect in the Formation of Customer Satisfaction: A Dynamic Perspective\",\"2006\",\"Journal of Marketing\",\"Christian Homburg + Nicole Koschate + Wayne D Hoyer + \",\"163\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.71.3.18\",\"Responsiveness to Customers and Competitors:The Role of Affective and Cognitive Organizational Systems\",\"2007\",\"Journal of Marketing\",\"Christian Homburg + Marko Grozdanovic + Martin Klarmann + \",\"92\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jm.09.0487\",\"Marketing Performance Measurement Systems: Does Comprehensiveness Really Improve Performance?\",\"2012\",\"Journal of Marketing\",\"Christian Homburg + Martin Artz + Jan Wieseke + \",\"46\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.75.2.55\",\"When Should the Customer Really Be King? On the Optimum Level of Salesperson Customer Orientation in Sales Encounters\",\"2011\",\"Journal of Marketing\",\"Christian Homburg + Michael Müller + Martin Klarmann + \",\"143\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.73.2.38\",\"Social Identity and the Service–Profit Chain\",\"2009\",\"Journal of Marketing\",\"Christian Homburg + Jan Wieseke + Wayne D Hoyer + \",\"236\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.72.5.110\",\"Customer Prioritization: Does It Pay Off, and How Should It Be Implemented?\",\"2008\",\"Journal of Marketing\",\"Christian Homburg + Mathias Droll + Dirk Totzek + \",\"109\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.69.2.84.60760\",\"Do Satisfied Customers Really Pay More? A Study of the Relationship Between Customer Satisfaction and Willingness to Pay\",\"2005\",\"Journal of Marketing\",\"Christian Homburg + Nicole Koschate + Wayne D. Hoyer + \",\"330\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.66.4.86.18511\",\"Service Orientation of a Retailer’s Business Strategy: Dimensions, Antecedents, and Performance Outcomes\",\"2002\",\"Journal of Marketing\",\"Christian Homburg + Wayne D. Hoyer + Martin Fassnacht + \",\"199\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.71.2.133\",\"Neglected Outcomes of Customer Satisfaction\",\"2007\",\"Journal of Marketing\",\"Xueming Luo + Christian Homburg + \",\"164\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.65.1.29.18136\",\"Buyer-Supplier Relationships and Customer Firm Costs\",\"2001\",\"Journal of Marketing\",\"Joseph P. Cannon + Christian Homburg + \",\"361\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.66.2.38.18471\",\"A Configurational Perspective on Key Account Management\",\"2002\",\"Journal of Marketing\",\"Christian Homburg + John P. Workman + Ove Jensen + \",\"201\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.71.3.124\",\"The Thought Worlds of Marketing and Sales: Which Differences Make a Difference?\",\"2007\",\"Journal of Marketing\",\"Christian Homburg + Ove Jensen + \",\"153\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.2307/1251942\",\"Marketing's Influence within the Firm\",\"1999\",\"Journal of Marketing\",\"Christian Homburg + John P. Workman + Harley Krohmer + \",\"225\"\n",
"\"Homburg\",\"Christian\",\"0022-2429\",\"10.1509/jmkg.72.2.133\",\"Configurations of Marketing and Sales: A Taxonomy\",\"2008\",\"Journal of Marketing\",\"Christian Homburg + Ove Jensen + Harley Krohmer + \",\"105\"\n",
"\"Homburg\",\"Christian\",\"0022-2437\",\"10.2307/3172803\",\"Cross-Validation and Information Criteria in Causal Modeling\",\"1991\",\"Journal of Marketing Research\",\"Christian Homburg + \",\"21\"\n",
"\"Homburg\",\"Christian\",\"0022-2437\",\"10.1509/jmkr.47.6.1041\",\"Customer Satisfaction, Analyst Stock Recommendations, and Firm Value\",\"2010\",\"Journal of Marketing Research\",\"Xueming Luo + Christian Homburg + Jan Wieseke + \",\"62\"\n",
"\"Homburg\",\"Christian\",\"0022-2437\",\"10.1509/jmr.09.0174\",\"What Drives Key Informant Accuracy?\",\"2012\",\"Journal of Marketing Research\",\"Christian Homburg + Martin Klarmann + Martin Reimann + Oliver Schilke + \",\"62\"\n",
"\"Homburg\",\"Christian\",\"0022-2437\",\"10.1509/jmr.11.0350\",\"The Role of Chief Marketing Officers for Venture Capital Funding: Endowing New Ventures with Marketing Legitimacy\",\"2014\",\"Journal of Marketing Research\",\"Christian Homburg + Alexander Hahn + Torsten Bornemann + Philipp Sandner + \",\"14\"\n",
"\"Homburg\",\"Christian\",\"0022-2437\",\"10.1509/jmr.11.0448\",\"Measuring and Managing Consumer Sentiment in an Online Community Environment\",\"2015\",\"Journal of Marketing Research\",\"Christian Homburg + Laura Ehm + Martin Artz + \",\"20\"\n",
"\"Homburg\",\"Christian\",\"0022-2437\",\"10.1509/jmkr.37.4.449.18786\",\"A Multiple-Layer Model of Market-Oriented Organizational Culture: Measurement Issues and Performance Outcomes\",\"2000\",\"Journal of Marketing Research\",\"Christian Homburg + Christian Pflesser + \",\"487\"\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-010-0233-2\",\"When salespeople develop negative headquarters stereotypes: performance effects and managerial remedies\",\"2010\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Jan Wieseke + Bryan A. Lukas + Sven Mikolon + \",\"5\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1177/0092070303031003008\",\"Reflections on Research in Marketing and Reviewing for Scholarly Journals Invited Essays by JAMS 2000-2003 Outstanding Reviewer Award Recipients: Introduction to Special Section\",\"2003\",\"Journal of the Academy of Marketing Science\",\"Rajesh K. Chandy + Christian Homburg + Debbie MacInnis + Scott B. MacKenzie + Cheryl Nakata + Amy L. Ostrom + A. Parasuraman + Jagdip Singh + Daniel C. Smith + Shirley Taylor + Glenn B. Voss + Robert B. Woodruff + \",\"1\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-006-0009-x\",\"See no evil, hear no evil, speak no evil: a study of defensive organizational behavior towards customer complaints\",\"2007\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Andreas Fürst + \",\"51\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-007-0031-7\",\"How to get lost customers back?\",\"2007\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Wayne D. Hoyer + Ruth Maria Stock + \",\"42\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-007-0055-z\",\"Understanding the adoption of new brands through salespeople: a multilevel framework\",\"2007\",\"Journal of the Academy of Marketing Science\",\"Jan Wieseke + Christian Homburg + Nick Lee + \",\"33\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-011-0290-1\",\"Incentivizing CEOs to build customer- and employee-firm relations for higher customer satisfaction and firm value\",\"2011\",\"Journal of the Academy of Marketing Science\",\"Xueming Luo + Jan Wieseke + Christian Homburg + \",\"21\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-009-0134-4\",\"Preannouncing pioneering versus follower products: what should the message be?\",\"2009\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Torsten Bornemann + Dirk Totzek + \",\"19\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-009-0157-x\",\"Social influence on salespeople’s adoption of sales technology: a multilevel analysis\",\"2009\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Jan Wieseke + Christina Kuehnl + \",\"41\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-011-0299-5\",\"Incumbents’ defense strategies: a comparison of deterrence and shakeout strategy based on evolutionary game theory\",\"2012\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Andreas Fürst + Thomas Ehrmann + Eugen Scheinker + \",\"6\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-009-0174-9\",\"A customer perspective on product eliminations: how the removal of products affects customers and business relationships\",\"2009\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Andreas Fürst + Jana-Kristin Prigge + \",\"12\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1177/0092070303031003018\",\"Publishing Processes in the Academic Marketing Discipline in the United States: A German Perspective\",\"2003\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + \",\"18\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-009-0172-y\",\"On the importance of complaint handling design: a multi-level analysis of the impact in specific complaint situations\",\"2009\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Andreas Fürst + Nicole Koschate + \",\"17\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-013-0347-4\",\"Delusive perception—antecedents and consequences of salespeople’s misperception of customer commitment\",\"2013\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Torsten Bornemann + Max Kretzer + \",\"1\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-011-0264-3\",\"Ensuring international competitiveness: a configurative approach to foreign marketing subsidiaries\",\"2011\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Andreas Fürst + Christina Kuehnl + \",\"8\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1177/0092070302238599\",\"Intraorganizational Determinants of Key Account Management Effectiveness\",\"2003\",\"Journal of the Academy of Marketing Science\",\"John P. Workman + Christian Homburg + Ove Jensen + \",\"128\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-013-0334-9\",\"Firm-hosted online brand communities and new product success\",\"2013\",\"Journal of the Academy of Marketing Science\",\"Richard L. Gruner + Christian Homburg + Bryan A. Lukas + \",\"42\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-015-0460-7\",\"Customer experience management: toward implementing an evolving marketing concept\",\"2015\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Danijel Jozić + Christina Kuehnl + \",\"36\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1177/0092070303261415\",\"The Link Between Salespeople’s Job Satisfaction and Customer Satisfaction in a Business-to-Business Context: A Dyadic Analysis\",\"2004\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Ruth M. Stock + \",\"178\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-010-0220-7\",\"When does salespeople’s customer orientation lead to customer loyalty? The differential effects of relational and functional customer orientation\",\"2010\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Michael Müller + Martin Klarmann + \",\"60\"\n",
"\"Homburg\",\"Christian\",\"0092-0703\",\"10.1007/s11747-014-0416-3\",\"The loss of the marketing department’s influence: is it really happening? And why worry?\",\"2014\",\"Journal of the Academy of Marketing Science\",\"Christian Homburg + Arnd Vomberg + Margit Enke + Philipp H. Grimm + \",\"45\"\n",
"\"Homburg\",\"Christian\",\"0143-2095\",\"10.1002/(sici)1097-0266(199904)20:4<339::aid-smj29>3.3.co;2-k\",\"Strategic consensus and performance: the role of strategy type and market‐related dynamism\",\"1999\",\"Strategic Management Journal\",\"Christian Homburg + Harley Krohmer + John P. Workman. Jr + \",\"3\"\n",
"\"Homburg\",\"Christian\",\"0143-2095\",\"10.1002/(sici)1097-0266(199904)20:4<339::aid-smj29>3.0.co;2-t\",\"Strategic consensus and performance: the role of strategy type and market-related dynamism\",\"1999\",\"Strategic Management Journal\",\"Christian Homburg + Harley Krohmer + John P. Workman. Jr + \",\"84\"\n",
"\"Homburg\",\"Christian\",\"0143-2095\",\"10.1002/smj.2328\",\"Talented people and strong brands: The contribution of human capital and brand equity to firm value\",\"2014\",\"Strategic Management Journal\",\"Arnd Vomberg + Christian Homburg + Torsten Bornemann + \",\"30\"\n",
"\"Homburg\",\"Christian\",\"0143-2095\",\"10.1002/smj.520\",\"Is speed of integration really a success factor of mergers and acquisitions? An analysis of the role of internal and external relatedness\",\"2006\",\"Strategic Management Journal\",\"Christian Homburg + Matthias Bucerius + \",\"115\"\n",
"\"Daske\",\"Holger\",\"0021-8456\",\"10.1111/1475-679x.12029\",\"Mandatory Disclosure, Voluntary Disclosure, and Stock Market Liquidity: Evidence from the EU Bank Stress Tests\",\"2013\",\"Journal of Accounting Research\",\"JANNIS BISCHOF + HOLGER DASKE + \",\"13\"\n",
"\"Daske\",\"Holger\",\"0021-8456\",\"10.1111/j.1475-679x.2008.00306.x\",\"Mandatory IFRS Reporting around the World: Early Evidence on the Economic Consequences\",\"2008\",\"Journal of Accounting Research\",\"HOLGER DASKE + LUZI HAIL + CHRISTIAN LEUZ + RODRIGO VERDI + \",\"107\"\n",
"\"Daske\",\"Holger\",\"0021-8456\",\"10.1111/1475-679x.12005\",\"Adopting a Label: Heterogeneity in the Economic Consequences Around IAS/IFRS Adoptions\",\"2013\",\"Journal of Accounting Research\",\"HOLGER DASKE + LUZI HAIL + CHRISTIAN LEUZ + RODRIGO VERDI + \",\"158\"\n",
"\"Hillert\",\"Alexander\",\"0304-405X\",\"10.1016/j.jfineco.2015.08.009\",\"Stock repurchases and liquidity\",\"2016\",\"Journal of Financial Economics\",\"Alexander Hillert + Ernst Maug + Stefan Obernberger + \",\"2\"\n",
"\"Hillert\",\"Alexander\",\"1572-3097\",\"10.1093/rof/rfv060\",\"Alphabetic Bias, Investor Recognition, and Trading Behavior\",\"2015\",\"Review of Finance\",\"Heiko Jacobs + Alexander Hillert + \",\"3\"\n",
"\"Hillert\",\"Alexander\",\"0893-9454\",\"10.1093/rfs/hhu061\",\"Media Makes Momentum\",\"2014\",\"Review of Financial Studies\",\"Alexander Hillert + Heiko Jacobs + Sebastian Müller + \",\"25\"\n",
"\"De Valck\",\"Kristine\",\"0022-2429\",\"10.1509/jmkg.74.2.71\",\"Networked Narratives: Understanding Word-of-Mouth Marketing in Online Communities\",\"2010\",\"Journal of Marketing\",\"Robert V Kozinets + Kristine de Valck + Andrea C Wojnicki + Sarah J.S Wilner + \",\"586\"\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"\"De Valck\",\"Kristine\",\"0022-2437\",\"10.1509/jmr.14.0380\",\"The Effect of Electronic Word of Mouth on Sales: A Meta-Analytic Review of Platform, Product, and Metric Factors\",\"2016\",\"Journal of Marketing Research\",\"Ana Babić Rosario + Francesca Sotgiu + Kristine De Valck + Tammo H.A. Bijmolt + \",\"64\"\n",
"\"Landier\",\"Augustin\",\"0002-8282\",\"10.1257/aer.99.2.454\",\"Financial Risk Management: When Does Independence Fail?\",\"2009\",\"American Economic Review\",\"Augustin Landier + David Sraer + David Thesmar + \",\"5\"\n",
"\"Landier\",\"Augustin\",\"0022-1082\",\"10.1111/jofi.12062\",\"Do Hedge Funds Manipulate Stock Prices?\",\"2013\",\"The Journal of Finance\",\"ITZHAK BEN-DAVID + FRANCESCO FRANZONI + AUGUSTIN LANDIER + RABIH MOUSSAWI + \",\"19\"\n",
"\"Landier\",\"Augustin\",\"0022-1082\",\"10.1111/jofi.12250\",\"The WACC Fallacy: The Real Effects of Using a Unique Discount Rate\",\"2015\",\"The Journal of Finance\",\"PHILIPP KRÜGER + AUGUSTIN LANDIER + DAVID THESMAR + \",\"14\"\n",
"\"Landier\",\"Augustin\",\"0304-405X\",\"10.1016/j.jfineco.2017.03.001\",\"Banking integration and house price co-movement\",\"2017\",\"Journal of Financial Economics\",\"Augustin Landier + David Sraer + David Thesmar + \",\"2\"\n",
"\"Landier\",\"Augustin\",\"0304-405X\",\"10.1016/j.jfineco.2014.11.006\",\"Vulnerable banks\",\"2015\",\"Journal of Financial Economics\",\"Robin Greenwood + Augustin Landier + David Thesmar + \",\"46\"\n",
"\"Landier\",\"Augustin\",\"0033-5533\",\"10.1162/qjec.2008.123.1.49\",\"Why Has CEO Pay Increased So Much?*\",\"2008\",\"Quarterly Journal of Economics\",\"Xavier Gabaix + Augustin Landier + \",\"427\"\n",
"\"Landier\",\"Augustin\",\"0034-6527\",\"10.1093/restud/rdw033\",\"Taxing the Rich\",\"2016\",\"The Review of Economic Studies\",\"Augustin Landier + Guillaume Plantin + \",\"0\"\n",
"\"Landier\",\"Augustin\",\"0034-6527\",\"10.1111/j.1467-937x.2009.00544.x\",\"Optimal Dissent in Organizations\",\"2009\",\"Review of Economic Studies\",\"AUGUSTIN LANDIER + DAVID SRAER + DAVID THESMAR + \",\"24\"\n",
"\"Landier\",\"Augustin\",\"1572-3097\",\"10.1093/rof/rfs020\",\"Bottom-Up Corporate Governance\",\"2012\",\"Review of Finance\",\"Augustin Landier + Julien Sauvagnat + David Sraer + David Thesmar + \",\"18\"\n",
"\"Landier\",\"Augustin\",\"0893-9454\",\"10.1093/rfs/hhn117\",\"A Multiplicative Model of Optimal CEO Incentives in Market Equilibrium\",\"2008\",\"Review of Financial Studies\",\"Alex Edmans + Xavier Gabaix + Augustin Landier + \",\"118\"\n",
"\"Landier\",\"Augustin\",\"0893-9454\",\"10.1093/rfs/hhn065\",\"Financial Contracting with Optimistic Entrepreneurs\",\"2008\",\"Review of Financial Studies\",\"Augustin Landier + David Thesmar + \",\"93\"\n",
"\"Landier\",\"Augustin\",\"0893-9454\",\"10.1093/rfs/hhm042\",\"Trade-offs in Staying Close: Corporate Decision Making and Geographic Dispersion\",\"2007\",\"Review of Financial Studies\",\"Augustin Landier + Vinay B. Nair + Julie Wulf + \",\"70\"\n",
"\"Franke\",\"Nikolaus\",\"1042-2587\",\"10.1111/j.1540-6520.2008.00236.x\",\"Venture Capitalists' Evaluations of Start-Up Teams: Trade-Offs, Knock-Out Criteria, and the Impact of VC Experience\",\"2008\",\"Entrepreneurship Theory and Practice\",\"Nikolaus Franke + Marc Gruber + Dietmar Harhoff + Joachim Henkel + \",\"75\"\n",
"\"Franke\",\"Nikolaus\",\"1047-7047\",\"10.1287/isre.2016.0649\",\"Intellectual Property Norms in Online Communities: How User-Organized Intellectual Property Regulation Supports Innovation\",\"2016\",\"Information Systems Research\",\"Julia Bauer + Nikolaus Franke + Philipp Tuertscher + \",\"2\"\n",
"\"Franke\",\"Nikolaus\",\"0883-9026\",\"10.1016/j.jbusvent.2005.07.001\",\"What you are is what you like—similarity biases in venture capitalists' evaluations of start-up teams\",\"2006\",\"Journal of Business Venturing\",\"Nikolaus Franke + Marc Gruber + Dietmar Harhoff + Joachim Henkel + \",\"105\"\n",
"\"Franke\",\"Nikolaus\",\"0883-9026\",\"10.1016/j.jbusvent.2016.03.003\",\"See Paris and… found a business? The impact of cross-cultural experience on opportunity recognition capabilities\",\"2016\",\"Journal of Business Venturing\",\"Peter Vandor + Nikolaus Franke + \",\"10\"\n",
"\"Franke\",\"Nikolaus\",\"0742-1222\",\"10.1080/07421222.2018.1440763\",\"Social Product-Customization Systems: Peer Input, Conformity, and Consumers’ Evaluation of Customized Products\",\"2018\",\"Journal of Management Information Systems\",\"Tobias Schlager + Christian Hildebrand + Gerald Häubl + Nikolaus Franke + Andreas Herrmann + \",\"0\"\n",
"\"Franke\",\"Nikolaus\",\"0022-2429\",\"10.1509/jmkg.73.5.103\",\"Testing the Value of Customization: When Do Customers Really Prefer Products Tailored to Their Preferences?\",\"2009\",\"Journal of Marketing\",\"Nikolaus Franke + Peter Keinz + Christoph J Steger + \",\"186\"\n",
"\"Franke\",\"Nikolaus\",\"0025-1909\",\"10.1287/mnsc.2013.1805\",\"Integrating Problem Solvers from Analogous Markets in New Product Ideation\",\"2014\",\"Management Science\",\"Nikolaus Franke + Marion K. Poetz + Martin Schreier + \",\"24\"\n",
"\"Franke\",\"Nikolaus\",\"0025-1909\",\"10.1287/mnsc.1090.1077\",\"The “I Designed It Myself” Effect in Mass Customization\",\"2010\",\"Management Science\",\"Nikolaus Franke + Martin Schreier + Ulrike Kaiser + \",\"214\"\n",
"\"Franke\",\"Nikolaus\",\"1047-7039\",\"10.1287/orsc.1120.0794\",\"“Does This Sound Like a Fair Deal?”: Antecedents and Consequences of Fairness Expectations in the Individual’s Decision to Participate in Firm Innovation\",\"2013\",\"Organization Science\",\"Nikolaus Franke + Peter Keinz + Katharina Klausberger + \",\"40\"\n",
"\"Franke\",\"Nikolaus\",\"0048-7333\",\"10.1016/j.respol.2009.07.005\",\"“Pyramiding: Efficient search for rare subjects”\",\"2009\",\"Research Policy\",\"Eric von Hippel + Nikolaus Franke + Reinhard Prügl + \",\"36\"\n",
"\"Franke\",\"Nikolaus\",\"0048-7333\",\"10.1016/j.respol.2016.04.012\",\"The frequency of end-user innovation: A re-estimation of extant findings\",\"2016\",\"Research Policy\",\"Nikolaus Franke + Florian Schirg + Kathrin Reinsberger + \",\"2\"\n",
"\"Franke\",\"Nikolaus\",\"0048-7333\",\"10.1016/s0048-7333(03)00049-0\",\"Satisfying heterogeneous user needs via innovation toolkits: the case of Apache security software\",\"2003\",\"Research Policy\",\"Nikolaus Franke + Eric von Hippel + \",\"238\"\n",
"\"Franke\",\"Nikolaus\",\"0048-7333\",\"10.1016/s0048-7333(02)00006-9\",\"How communities support innovative activities: an exploration of assistance and sharing among end-users\",\"2003\",\"Research Policy\",\"Nikolaus Franke + Sonali Shah + \",\"500\"\n",
"\"Abou Nabout\",\"Nadia\",\"0732-2399\",\"10.1287/mksc.1120.0735\",\"Practice Prize Paper—PROSAD: A Bidding Decision Support System for Profit Optimizing Search Engine Advertising\",\"2013\",\"Marketing Science\",\"Bernd Skiera + Nadia Abou Nabout + \",\"18\"\n",
"\"Grichnik\",\"Dietmar\",\"1042-2587\",\"10.1111/j.1540-6520.2011.00481.x\",\"Emotions and Opportunities: The Interplay of Opportunity Evaluation, Fear, Joy, and Anger as Antecedent of Entrepreneurial Exploitation\",\"2011\",\"Entrepreneurship Theory and Practice\",\"Isabell M. Welpe + Matthias Spörrle + Dietmar Grichnik + Theresa Michl + David B. Audretsch + \",\"76\"\n",
"\"Grichnik\",\"Dietmar\",\"0883-9026\",\"10.1016/j.jbusvent.2008.10.007\",\"Should entrepreneurs plan or just storm the castle? A meta-analysis on contextual factors impacting the business planning–performance relationship in small firms\",\"2010\",\"Journal of Business Venturing\",\"Jan Brinckmann + Dietmar Grichnik + Diana Kapsa + \",\"156\"\n",
"\"Grichnik\",\"Dietmar\",\"0883-9026\",\"10.1016/j.jbusvent.2013.02.006\",\"Beyond environmental scarcity: Human and social capital as driving forces of bootstrapping activities\",\"2014\",\"Journal of Business Venturing\",\"Dietmar Grichnik + Jan Brinckmann + Luv Singh + Sophie Manigart + \",\"21\"\n",
"\"Grichnik\",\"Dietmar\",\"0048-7333\",\"10.1016/j.respol.2013.03.001\",\"Entrepreneurial talent and venture performance: A meta-analytic investigation of SMEs\",\"2013\",\"Research Policy\",\"Katrin Mayer-Haug + Stuart Read + Jan Brinckmann + Nicholas Dew + Dietmar Grichnik + \",\"30\"\n",
"\"Häubl\",\"Gerald\",\"1047-7047\",\"10.1287/isre.1120.0455\",\"When Social Media Can Be Bad for You: Community Feedback Stifles Consumer Creativity and Reduces Satisfaction with Self-Designed Products\",\"2013\",\"Information Systems Research\",\"Christian Hildebrand + Gerald Häubl + Andreas Herrmann + Jan R. Landwehr + \",\"36\"\n",
"\"Häubl\",\"Gerald\",\"1057-7408\",\"10.1016/j.jcps.2014.09.003\",\"The preference-signaling effect of search\",\"2015\",\"Journal of Consumer Psychology\",\"Xin Ge + Neil Brigden + Gerald Häubl + \",\"2\"\n",
"\"Häubl\",\"Gerald\",\"1057-7408\",\"10.1207/153276603768344861\",\"Information Availability and Consumer Preference: Can Online Retailers Benefit From Providing Access to Competitor Price Information?\",\"2003\",\"Journal of Consumer Psychology\",\"Valerie Trifts + Gerald Häubl + \",\"11\"\n",
"\"Häubl\",\"Gerald\",\"1057-7408\",\"10.1207/153276603768344807\",\"Preference Construction and Persistence in Digital Marketplaces: The Role of Electronic Recommendation Agents\",\"2003\",\"Journal of Consumer Psychology\",\"Gerald Häubl + Kyle B. Murray + \",\"20\"\n",
"\"Häubl\",\"Gerald\",\"1057-7408\",\"10.1207/s15327663jcp13-1&2_13\",\"Information Availability and Consumer Preference: Can Online Retailers Benefit From Providing Access to Competitor Price Information?\",\"2003\",\"Journal of Consumer Psychology\",\"Valerie Trifts + Gerald Häubl + \",\"6\"\n",
"\"Häubl\",\"Gerald\",\"1057-7408\",\"10.1207/s15327663jcp13-1&2_07\",\"Preference Construction and Persistence in Digital Marketplaces: The Role of Electronic Recommendation Agents\",\"2003\",\"Journal of Consumer Psychology\",\"Gerald Häubl + Kyle B. Murray + \",\"38\"\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"\"Häubl\",\"Gerald\",\"0093-5301\",\"10.1086/661937\",\"What to Say When: Influencing Consumer Choice by Delaying the Presentation of Favorable Information\",\"2012\",\"Journal of Consumer Research\",\"Xin Ge + Gerald Häubl + Terry Elrod + \",\"9\"\n",
"\"Häubl\",\"Gerald\",\"0093-5301\",\"10.1086/669165\",\"Self-Identity and Consumer Behavior Dissociative versus Associative Responses to Social Identity Threat: The Role of Consumer Self-Construal Self-Affirmation through the Choice of Highly Aesthetic Products It's Not Me, It's You: How Gift Giving Creates Giver Identity Threat as a Function of Social Closeness Identifiable but Not Identical: Combining Social Identity and Uniqueness Motives in Choice The Signature Effect: Signing Influences Consumption-Related Behavior by Priming Self-Identity An Interpretive Frame Model of Identity-Dependent Learning: The Moderating Role of Content-State Association\",\"2013\",\"Journal of Consumer Research\",\"Jennifer Escalas + Katherine White + Claudia Townsend + Morgan K. Ward + Cindy Chan + Keri L. Kettle + Kathryn R. Mercurio + Jennifer J. Argo + Jaideep Sengupta + Sanjay Sood + Susan M. Broniarczyk + Jonah Berger + Leaf Van Boven + Gerald Häubl + Mark R. Forehand + \",\"5\"\n",
"\"Häubl\",\"Gerald\",\"0093-5301\",\"10.1093/jcr/ucw037\",\"Repayment Concentration and Consumer Motivation to Get Out of Debt\",\"2016\",\"Journal of Consumer Research\",\"Keri L. Kettle + Remi Trudel + Simon J. Blanchard + Gerald Häubl + \",\"3\"\n",
"\"Häubl\",\"Gerald\",\"0093-5301\",\"10.1086/513048\",\"Explaining Cognitive Lock-In: The Role of Skill-Based Habits of Use in Consumer Choice\",\"2007\",\"Journal of Consumer Research\",\"Kyle B. Murray + Gerald Häubl + \",\"75\"\n",
"\"Häubl\",\"Gerald\",\"0093-5301\",\"10.1093/jcr/ucy056\",\"Bidding Frenzy: Speed of Competitor Reaction and Willingness to Pay in Auctions\",\"2018\",\"Journal of Consumer Research\",\"Gerald Häubl + Peter T L Popkowski Leszczyc + \",\"0\"\n",
"\"Häubl\",\"Gerald\",\"0093-5301\",\"10.1086/659753\",\"The Signature Effect: Signing Influences Consumption-Related Behavior by Priming Self-Identity\",\"2011\",\"Journal of Consumer Research\",\"Keri L. Kettle + Gerald Häubl + \",\"28\"\n",
"\"Häubl\",\"Gerald\",\"0742-1222\",\"10.1080/07421222.2018.1440763\",\"Social Product-Customization Systems: Peer Input, Conformity, and Consumers’ Evaluation of Customized Products\",\"2018\",\"Journal of Management Information Systems\",\"Tobias Schlager + Christian Hildebrand + Gerald Häubl + Nikolaus Franke + Andreas Herrmann + \",\"0\"\n",
"\"Häubl\",\"Gerald\",\"0022-2429\",\"10.1509/jmkg.74.4.110\",\"To Bundle or Not to Bundle: Determinants of the Profitability of Multi-Item Auctions\",\"2010\",\"Journal of Marketing\",\"Peter T.L Popkowski Leszczyc + Gerald Häubl + \",\"18\"\n",
"\"Häubl\",\"Gerald\",\"0022-2429\",\"10.1509/jm.15.0396\",\"Gamified Information Presentation and Consumer Adoption of Product Innovations\",\"2017\",\"Journal of Marketing\",\"Jessica Müller-Stewens + Tobias Schlager + Gerald Häubl + Andreas Herrmann + \",\"3\"\n",
"\"Häubl\",\"Gerald\",\"0022-2437\",\"10.1509/jmr.13.0437\",\"Product Customization via Starting Solutions\",\"2014\",\"Journal of Marketing Research\",\"Christian Hildebrand + Gerald Häubl + Andreas Herrmann + \",\"12\"\n",
"\"Häubl\",\"Gerald\",\"0022-2437\",\"10.1509/jmr.09.0481\",\"Searching in Choice Mode: Consumer Decision Processes in Product Search with Recommendations\",\"2012\",\"Journal of Marketing Research\",\"Benedict G.C Dellaert + Gerald Häubl + \",\"24\"\n",
"\"Häubl\",\"Gerald\",\"0022-2437\",\"10.1509/jmkr.48.2.403\",\"Self-Regulatory Strength and Consumers' Relinquishment of Decision Control: When Less Effortful Decisions Are More Resource Depleting\",\"2011\",\"Journal of Marketing Research\",\"Murat Usta + Gerald Häubl + \",\"14\"\n",
"\"Häubl\",\"Gerald\",\"0732-2399\",\"10.1287/mksc.1100.0577\",\"Optimal Reverse-Pricing Mechanisms\",\"2010\",\"Marketing Science\",\"Martin Spann + Robert Zeithammer + Gerald Häubl + \",\"15\"\n",
"\"Häubl\",\"Gerald\",\"0732-2399\",\"10.1287/mksc.1090.0525\",\"Tunnel Vision: Local Behavioral Influences on Consumer Decisions in Product Search\",\"2010\",\"Marketing Science\",\"Gerald Häubl + Benedict G. C. Dellaert + Bas Donkers + \",\"13\"\n",
"\"Häubl\",\"Gerald\",\"0732-2399\",\"10.1287/mksc.2014.0883\",\"Erratum to “Optimal Reverse-Pricing Mechanisms” by Martin Spann, Robert Zeithammer, and Gerald Häubl\",\"2015\",\"Marketing Science\",\"Martin Spann + Robert Zeithammer + Gerald Häubl + \",\"1\"\n",
"\"Häubl\",\"Gerald\",\"0732-2399\",\"10.1287/mksc.19.1.4.15178\",\"Consumer Decision Making in Online Shopping Environments: The Effects of Interactive Decision Aids\",\"2000\",\"Marketing Science\",\"Gerald Häubl + Valerie Trifts + \",\"516\"\n",
"DONE\n"
]
}
],
"source": [
"import time\n",
"\n",
"for findAuthor in authorList:\n",
" citationCount = 0\n",
" #print(findAuthor)\n",
" #time.sleep(10)\n",
" for issn in issnList:\n",
" if (inCrossref[issn]):\n",
" k = 0\n",
" works = Journals(etiquette=my_etiquette).works(issn).query(author=findAuthor['lastName'])\n",
" for article in works:\n",
" authorStatement = ''\n",
" for au in article['author']:\n",
" if ('given' in au):\n",
" authorStatement += au['given']+' '\n",
" else:\n",
" authorStatement += '<no-given-name> '\n",
" if ('family' in au):\n",
" authorStatement += au['family']+' + '\n",
" else:\n",
" authorStatement += '<no-family-name> + '\n",
" # TODO delete last two letters if not null\n",
" \n",
" # very rare, but title can be missing in crossref\n",
" # e.g. http://api.crossref.org/works/10.1023/a:1006054912880\n",
" if ('title' not in article):\n",
" article['title'] = ['<no-title>']\n",
" date = str(article['issued']['date-parts'][0][0])\n",
" for au in article['author']:\n",
" # Here we filter institutional authors out and assure that\n",
" # we have family and given name part. TODO: not too restrictive?\n",
" #print(au)\n",
" if ('family' in au and 'given' in au):\n",
" if (au['family'].lower()==findAuthor['lastName'].lower() and (au['given'].lower() in findAuthor['firstName'].lower())):\n",
" k = k+1\n",
" citationCount = citationCount + article['is-referenced-by-count']\n",
" output = [ findAuthor['lastName'], findAuthor['firstName'], issn, article['DOI'], article['title'][0], date, article['container-title'][0], authorStatement, str(article['is-referenced-by-count']) ]\n",
" print('\"'+'\",\"'.join(output)+'\"')\n",
" # Save it back to the findAuthor object\n",
" findAuthor[issn] = k\n",
" findAuthor['citationCount'] = citationCount\n",
"\n",
"print(\"DONE\")\n",
"#print(\"\\n\")\n",
"#print(authorList)\n"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Homburg Christian 60 5173\n",
"Daske Holger 3 278\n",
"Blonski Matthias 0 0\n",
"Hillert Alexander 3 30\n",
"De Valck Kristine 2 650\n",
"Landier Augustin 12 836\n",
"Franke Nikolaus 13 1432\n",
"Nabout Nadia Abou 0 0\n",
"Abou Nabout Nadia 1 18\n",
"Grichnik Dietmar 4 283\n",
"Häubl Gerald 22 849\n"
]
}
],
"source": [
"for author in authorList:\n",
" sum = 0\n",
" for prop in author:\n",
" if (prop!=\"lastName\" and prop!=\"firstName\" and prop!=\"citationCount\"):\n",
" sum = sum+author[prop]\n",
" print(author['lastName'], author['firstName'], sum, author['citationCount'])"
]
}
],
"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.6.4"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment