{ "metadata": { "name": "artpaut" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "heading", "level": 2, "metadata": {}, "source": [ "Art\u00edculos por autor para cada Grupo" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Para obtener las claves de las hojas de c\u00e1lculo de Google, visita la [p\u00e1gina de b\u00fasqueda de Indicadores](http://gfif.udea.edu.co/gssis/sql_query/search.html): (Seleccione indicador, ponga `*` en la caja de `\"select\"`, pulse el bot\u00f3n de b\u00fasqueda y abra el link HTML)." ] }, { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "def read_google_cvs(gss_url=\"http://spreadsheets.google.com\",\\\n", " gss_format=\"csv\",\\\n", " gss_key=\"0AuLa_xuSIEvxdERYSGVQWDBTX1NCN19QMXVpb0lhWXc\",\\\n", " gss_sheet=0,\\\n", " gss_query=\"select B,D,E,F,I where (H contains 'GFIF') order by D desc\",\\\n", " gss_keep_default_na=False\n", " ):\n", " import urllib\n", " import pandas as pd\n", " \"\"\"\n", " read a google spreadsheet in cvs format and return a pandas DataFrame object.\n", " ....\n", " gss_keep_default_na: (False) Blank values are filled with NaN\n", " \"\"\"\n", " issn_url=\"%s/tq?tqx=out:%s&tq=%s&key=%s&gid=%s\" %(gss_url,\\\n", " gss_format,\\\n", " gss_query,\\\n", " gss_key,\\\n", " str(gss_sheet))\n", "\n", " gfile=urllib.urlopen(issn_url)\n", " return pd.read_csv(gfile,keep_default_na=gss_keep_default_na)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", " | Grupo | \n", "Articulos | \n", "Autores | \n", "Articulos/(autores grupo) | \n", "
---|---|---|---|---|
0 | \n", "GMC: Grupo de Materia Condensada | \n", "43 | \n", "1 | \n", "43 | \n", "
1 | \n", "GES: Estado S\u00f3lido | \n", "21 | \n", "6 | \n", "3.5 | \n", "
2 | \n", "GOF: Grupo \u00d3ptica y Fot\u00f3nica | \n", "9 | \n", "3 | \n", "3 | \n", "
3 | \n", "GFIF: Grupo de Fenomenolog\u00eda de Interacciones ... | \n", "13 | \n", "5 | \n", "2.6 | \n", "
4 | \n", "MS: Magnetismo y Simulaci\u00f3n | \n", "6 | \n", "3 | \n", "2 | \n", "
5 | \n", "GFAM: Grupo de F\u00edsica At\u00f3mica y Molecular | \n", "8 | \n", "4 | \n", "2 | \n", "
6 | \n", "FACOM: F\u00edsica y Astrof\u00edsica Computacional | \n", "3 | \n", "2 | \n", "1.5 | \n", "
7 | \n", "GES: Estado S\u00f3lido; GMC: Grupo de Materia Cond... | \n", "2 | \n", "2 | \n", "1 | \n", "