Skip to content

Instantly share code, notes, and snippets.

@restrepo

restrepo/InformeSostebilidad.ipynb

Last active August 29, 2015 13:55
Show Gist options
  • Save restrepo/8694834 to your computer and use it in GitHub Desktop.
Save restrepo/8694834 to your computer and use it in GitHub Desktop.
Download ZIP
InformeSostebilidad.ipynb
Display the source blob
Display the rendered blob
Raw
informe.pdf
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Raw
informe.tex
\documentclass{article}
\usepackage[utf8]{inputenc}
\usepackage[colorlinks = true]{hyperref}
\usepackage[spanish]{babel}
\usepackage{textcomp}
\renewcommand{\rmdefault}{phv}
\renewcommand{\sfdefault}{pag}
\renewcommand{\ttdefault}{pcr}
\usepackage{amsmath}
\usepackage{amssymb}
\usepackage{graphicx}
\usepackage{xcolor}
\usepackage{booktabs}
\setlength{\oddsidemargin}{-0.5cm}
\setlength{\evensidemargin}{-0.5cm}
\setlength{\topmargin}{-1cm}
\setlength{\textheight}{21.5cm}
\setlength{\textwidth}{18cm}
\pagestyle{empty}
\title{Informe estrategía de Sostenibilidad GFIF 2013\footnote{
Generado automáticamente con Ipython:
\url{http://nbviewer.ipython.org/urls/gist.github.com/rescolo/8694834/raw/InformeSostebilidad.ipynb},
a partir de los Indicadores del Instituto de Física: \url{http://fisica.udea.edu.co/fisica}
}}
\author{Grupo de Fenomenología de Interacciones Fundamentales}
\begin{document}
\maketitle
\section*{Artículos: 2013 2014 }
Factor de Impacto (FI) promedio: 5.2134
\begin{enumerate}
\item Klasen M., Yaguna C. E, Ruiz-Alvarez J. D, Restrepo D., Zapata O., ``Scalar dark matter and fermion coannihilations in the radiative seesaw model'', Journal of Cosmology and Astroparticle Physics, 2013(2013)044, DOI: \href{http://dx.doi.org/10.1088/1475-7516/2013/04/044}{10.1088/1475-7516/2013/04/044}, FI: 6.036,
\item Florez A., Restrepo D., Velasquez M., Zapata O., ``Baryonic violation of R parity from anomalous U (1) H'', Physical Review D, 87(2013)095010, DOI: \href{http://dx.doi.org/10.1103/PhysRevD.87.095010}{10.1103/PhysRevD.87.095010}, FI: 4.691,
\item Ponce W. A, Gómez J. D, Benavides R. H, ``Five texture zeros and CP violation for the standard model quark mass matrices'', Physical Review D, 87(2013)053016, DOI: \href{http://dx.doi.org/10.1103/PhysRevD.87.053016}{10.1103/PhysRevD.87.053016}, FI: 4.691,
\item Sierra, D Aristizabal, Restrepo, D, Spinner, S, ``LSP sneutrino novel decays'', Journal of High Energy Physics, 2013(2013)046, DOI: \href{http://dx.doi.org/10.1007/JHEP05(2013)046}{10.1007/JHEP05(2013)046}, FI: 5.618,
\item Restrepo D., Zapata O., Yaguna C. E, ``Models with radiative neutrino masses and viable dark matter candidates'', Journal of High Energy Physics, 2013(2013)011, DOI: \href{http://dx.doi.org/10.1007/JHEP11(2013)011}{10.1007/JHEP11(2013)011}, FI: 5.618,
\item Sheng F. C., Nardi E., ``Spontaneous Breaking of Flavor Symmetry Avoids the Strong CP Problem'', Physical Review Letters, 111(2013)061601, DOI: \href{http://dx.doi.org/10.1103/PhysRevLett.111.061601}{10.1103/PhysRevLett.111.061601}, FI: 7.943,
\item Sheng Fong C., Gonzalez-Garcia, M. C, Nardi E., Peinado E., ``New ways to TeV scale leptogenesis'', Journal of High Energy Physics, 1308(2013)104, DOI: \href{http://dx.doi.org/10.1007/JHEP08(2013)104}{10.1007/JHEP08(2013)104}, FI: 5.618,
\item Cardenas, H, Restrepo, D, Rodriguez, J-Alexis, ``The role of charged Higgs boson decays in the determination of tan-like parameters'', Journal of Physics G-Nuclear and Particle Physics, 40(2013)095004, DOI: \href{http://dx.doi.org/10.1088/0954-3899/40/9/095004}{10.1088/0954-3899/40/9/095004}, FI: 5.326,
\item Klasen M., Yaguna C. E, Ruiz-Alvarez J. D, ``Electroweak corrections to the direct detection cross section of inert Higgs dark matter'', Physical Review D, 87(2013)075025, DOI: \href{http://dx.doi.org/10.1103/PhysRevD.87.075025}{10.1103/PhysRevD.87.075025}, FI: 4.691,
\item Romano A. Enea, ``Conditions for low-redshift positive apparent acceleration in smooth inhomogeneous models'', General Relativity and Gravitation, 45(2013)1515-1530, DOI: \href{http://dx.doi.org/10.1007/s10714-013-1541-x}{10.1007/s10714-013-1541-x}, FI: 1.902,
\end{enumerate}
\textbf{Compromiso:} 14 artículos con FI promedio de 3.7445.
\section*{Proyectos activos: 2013 2014 }
\begin{enumerate}
\item ``Fenomenología de modelos supersimétricos con ruptura de paridad R y violación de número leptónico.'', IP: Diego Alejandro Restrepo Quintero, inicia: 2012-01-01, finaliza: 2014-01-01, tipo: Mediana Cuantía,
\item ``Testing the Standar Cosmological Model Studyng the effects of not gaussianity and large scale inhomogenities'', IP: Antonio Enea Romano, inicia: 2012-01-26, finaliza: 2013-07-26, tipo: Profesores Recién Vinculados,
\item ``Materia oscura de gravitinos y masas de neutrinos en modelos con violación trilineal y bilineal inducida de paridad R'', IP: Óscar Alberto Zapata Noreña, inicia: 2012-11-09, finaliza: 2014-05-09, tipo: Profesores Recién Vinculados,
\item ``Implicaciones de modelos supersimétricos con violación de paridad R en las fronteras de física de partículas y cosmología'', IP: Diego Restrepo, inicia: 2013-02-14, finaliza: 2015-02-14, tipo: Colciencias, \textbf{Recursos externos: \$340,726,155.00}
\item ``Estrategia para la Sostenibilidad GFIF 2013-2014'', IP: Diego Restrepo, inicia: 2013-03-06, finaliza: 2015-03-06, tipo: Sostenibilidad,
\item ``Cosmological effects of local inhomogeneities'', IP: Anotnio Enea Romano, inicia: 2013-10-01, finaliza: 2016-10-01, tipo: SUI 2013,
\item ``Masas y mezclas de neutrinos en modelos 3-N-1 (N=3,4)'', IP: William Ponce, inicia: 2014-01-01, finaliza: 2016-01-01, tipo: Convocatoria Ciencias Exactas,
\item ``Implicaciones de modelos tipo seesaw radiativo en las fronteras de la física de partículas y la cosmología'', IP: Óscar Alberto Zapata Noreña, inicia: 2014-01-01, finaliza: 2017-01-01, tipo: Convocatoria Ciencias Exactas,
\end{enumerate}
\textbf{Compromiso}: \$138,600,000 en recursos externos nacionales
\section*{Estudiantes graduados: 2013 2014 }
\begin{tabular}{|l|r|l|l|}\hline
\toprule
ESTUDIANTE & AÑO & ASESOR & PROGRAMA \\\hline
\midrule
Mauricio Velásquez López & 2013 & Diego Restrepo Q. & Doctorado \\
Alexander Gallego Cadavid & 2013 & Antonio Enea Romano & Maestría \\
Johana Alexandra Herrera Ruales & 2013 & William Ponce G. & Maestría \\
Camilo Andrés Salazar González & 2013 & Diego Restrepo & Pregrado \\
Dilia Maria Portillo & 2013 & Diego Restrepo & Pregrado \\
Cristian David Ruiz Carvajal & 2013 & William Antonio Ponce Gutierrez & Pregrado \\\hline
\bottomrule
\end{tabular}
\section*{Estudiantes nuevos: 2013 2014 }
\begin{tabular}{|l|r|l|l|}\hline
\toprule
ESTUDIANTE & AÑO & ASESOR & PROGRAMA \\\hline
\midrule
Longas Bedoya Robinson & 2014 & Oscar Zapata & Doctorado \\
Rivera Romero Andres Felipe & 2014 & Diego Restrepo Q. & Doctorado \\
Marta Liliana Sánchez Peláez & 2013 & Diego Restrepo Q. & Doctorado \\
Gillermo Alberto Palacios Cárdenas & 2013 & Diego Restrepo Q. & Doctorado \\
Cesar Augusto Arias Chica & 2013 & Antonio Enea Romano & Doctorado \\
Salazar Camilo Andrés & 2014 & Willam Ponce & Maestría \\
Dilia Portillo Quintero & 2013 & Oscar Zapata & Maestría \\\hline
\bottomrule
\end{tabular}
\smallskip
\textbf{Compromiso:} Formar 2 estudiantes de Doctorado
\section*{Pasantías internacionales en 2013 2014 }
\hspace{-2.2cm}\begin{tabular}{|l|l|l|l|l|l|}\hline
\toprule
Nombre & Institución & Salida & Regreso & Proyecto & Rec. externos \\\hline
\midrule
Mauricio Velásquez López & IFIC CSIC-Universidad de Valencia & 2013-01-24 & 2013-03-28 & IN1614CE & \\
Antonio Enea Romano & The University of Szczecin & 2013-06-24 & 2013-06-29 & Sostenibilidad GFIF & \\
Antonio Enea Romano & Universidad de Mcgill, Montreal & 2013-08-19 & 2013-08-22 & Sostenibilidad GFIF & \\
Diego Restrepo & IFIC CSIC-Universidad de Valencia & 2013-09-02 & 2013-09-27 & IN3055CE & \\
Diego Restrepo & LNF-INFN Frascati & 2013-09-30 & 2013-10-10 & IN1614CE & \\
Diego Restrepo & Universidad de Liege & 2013-10-14 & 2013-11-08 & IN624CE & \\
Diego Restrepo & Technische Universität München, TUM & 2013-11-04 & 2013-11-05 & & \\
Oscar Zapata & Technische Universität München, TUM & 2013-11-04 & 2014-04-04 & Postdoc DAAD & \textdollar 19.000.000 \\
Diego Restrepo & Univsidad de Münster & 2013-11-11 & 2013-11-15 & & \\\hline
\bottomrule
\end{tabular}
\textbf{Compromiso:} \$15,400,000 en recursos externos internacionales
\section*{Conclusiones}
A la fecha se ha ejecutado el 100\% del presupuesto desembolsado, y se ha cumplido la casi totalidad de los compromisos.
\vspace{2cm}
$\overline{\text{Diego A. Restrepo Q.}}$
Coordinador GFIF
\end{document}
Display the source blob
Display the rendered blob
Raw
InformeSostebilidad.ipynb
{
"metadata": {
"name": ""
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "heading",
"level": 1,
"metadata": {},
"source": [
"Informe de Estrategia de Sostenibilidad"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Configure los datos del informe"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"config_inf={'DEBUG':False} #Development mode\n",
"config_inf['Years']=[2013,2014]\n",
"config_inf['Grupo']=['GFIF','Grupo de Fenomenolog\u00eda de Interacciones Fundamentales']\n",
"config_inf['Coordinador']='Diego A. Restrepo Q.'\n",
"config_inf['LaTeX File']='informe.tex'\n",
"config_inf['Proyectos Externos']=['Colciencias']\n",
"config_inf['Conclusiones']=r'''\n",
"A la fecha se ha ejecutado el 100\\% del presupuesto desembolsado, y se ha cumplido la casi totalidad de los compromisos.\n",
"'''"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Compromisos"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"compromisos={'Art\u00edculos':[14,3.7445]}\n",
"compromisos['Estudiantes']={'Doctorado':2,'Maestr\u00eda':0,u'Pregrado':0}\n",
"recursos=154000000\n",
"\n",
"compromisos['Financiaci\u00f3n']={'Internos':recursos*0.9,'Externos':recursos*0.1}"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Funci\u00f3n de b\u00fasqueda"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Para obtener las claves de las hojas de c\u00e1lculo de Google: `gss_key`, 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",
" \"\"\"\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)\n",
"\n",
"def catutf8(fileutf8):\n",
" \"\"\"\n",
" Print UTF-8 file.\n",
" \"\"\"\n",
" fo=open(fileutf8,'r')\n",
" a=fo.read()\n",
" a=a.decode('utf8')\n",
" fo.close()\n",
" print a\n",
" \n",
"def simplify_authors(authors):\n",
" import re\n",
" authlist=''\n",
" for i in [re.sub(',(\\s[A-Z])[a-z]+','\\\\1.',j) for j in authors.split(';')]:\n",
" authlist=authlist+','+i\n",
" \n",
" return re.sub('^,(.*),\\s$','\\\\1',authlist)\n",
"\n",
"def fixtable(table):\n",
" formatold=re.sub('\\\\\\\\begin{tabular}{(.*)}','\\\\1',[row for row in table.split('\\n') if row.find('\\\\begin{tabular}') > -1 ][0])\n",
" if formatold.find('|')==-1:\n",
" formatnew='|'+'|'.join(formatold)+'|'\n",
" return re.sub('(\\n\\\\\\\\[a-z]+rule)','\\\\hline\\\\1',re.sub('(\\\\\\\\begin{tabular})({.*})','\\\\1{'+formatnew+'}',table))\n",
" else:\n",
" return table"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 3
},
{
"cell_type": "heading",
"level": 2,
"metadata": {},
"source": [
"Prepare `pandas` DataFrames"
]
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Art\u00edculos"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df=read_google_cvs(gss_key='0AjqGPI5Q_Ez6dDA3ajhtYVVDOWdBckVhWm1MSFRET1E',gss_query=\"select *\")\n",
"df.columns"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 4,
"text": [
"Index([u'Marca temporal', u'Nombre de usuario', u'A\u00f1o', u'Tipo', u'Autor(es)', u'Revista', u'Vol.', u'p\u00e1g.', u'ISSN', u'Art\u00edculo', u'Impreso', u'PDF', u'Grupo', u'DOI', u'Tipo.1', u'R\u00f3tulo', u'Autores de la UdeA', u'Clasificaci\u00f3n Colciencias', u'Factor de Impacto'], dtype=object)"
]
}
],
"prompt_number": 4
},
{
"cell_type": "heading",
"level": 4,
"metadata": {},
"source": [
"Seleccione los art\u00edculos publicados de un Grupo:"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Publicados:"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"publicadas=df[df['ISSN']!='0000-0000']\n",
"publicadas=publicadas.reset_index(drop=True)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 5
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Grupo:"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"publicadas=publicadas[publicadas['Grupo'].str.contains(config_inf['Grupo'][0])].reset_index(drop=True)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 6
},
{
"cell_type": "heading",
"level": 4,
"metadata": {},
"source": [
"Filtre p\u00fablicadas a partir de los a\u00f1os solicitados"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import re\n",
"publicadas1=publicadas[publicadas['A\u00f1o']>=config_inf['Years'][0]].reset_index(drop=True)\n",
"#Fix pag. info from the last part: e.g '[-1]', of the doi information\n",
"pages=[re.sub('(^[a-zA-Z].*)','',re.sub('^10.','',i).split('/')[-1].split(')')[-1].split('.')[-1]) for i in publicadas1['DOI']]\n",
"for i in range(len(pages)):\n",
" if pages[i]:\n",
" publicadas1['p\u00e1g.'][i]=pages[i]\n",
" \n",
"publicadas1[['Autor(es)','Art\u00edculo','Revista','Vol.','p\u00e1g.','A\u00f1o','DOI','Factor de Impacto']]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Autor(es)</th>\n",
" <th>Art\u00edculo</th>\n",
" <th>Revista</th>\n",
" <th>Vol.</th>\n",
" <th>p\u00e1g.</th>\n",
" <th>A\u00f1o</th>\n",
" <th>DOI</th>\n",
" <th>Factor de Impacto</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> Klasen, Michael; Yaguna, Carlos E; Ruiz-Alvare...</td>\n",
" <td> Scalar dark matter and fermion coannihilations...</td>\n",
" <td> Journal of Cosmology and Astroparticle Physics</td>\n",
" <td> 2013</td>\n",
" <td> 044</td>\n",
" <td> 2013</td>\n",
" <td> 10.1088/1475-7516/2013/04/044</td>\n",
" <td> 6.036</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> Florez, Andres; Restrepo, Diego; Velasquez, Ma...</td>\n",
" <td> Baryonic violation of R parity from anomalous ...</td>\n",
" <td> Physical Review D</td>\n",
" <td> 87</td>\n",
" <td> 095010</td>\n",
" <td> 2013</td>\n",
" <td> 10.1103/PhysRevD.87.095010</td>\n",
" <td> 4.691</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> Ponce, William A; G\u00f3mez, John D; Benavides, Ri...</td>\n",
" <td> Five texture zeros and CP violation for the st...</td>\n",
" <td> Physical Review D</td>\n",
" <td> 87</td>\n",
" <td> 053016</td>\n",
" <td> 2013</td>\n",
" <td> 10.1103/PhysRevD.87.053016</td>\n",
" <td> 4.691</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> Sierra, D Aristizabal; Restrepo, D; Spinner, S; </td>\n",
" <td> LSP sneutrino novel decays</td>\n",
" <td> Journal of High Energy Physics</td>\n",
" <td> 2013</td>\n",
" <td> 046</td>\n",
" <td> 2013</td>\n",
" <td> 10.1007/JHEP05(2013)046</td>\n",
" <td> 5.618</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> Restrepo, Diego; Zapata, Oscar; Yaguna, Carlos...</td>\n",
" <td> Models with radiative neutrino masses and viab...</td>\n",
" <td> Journal of High Energy Physics</td>\n",
" <td> 2013</td>\n",
" <td> 011</td>\n",
" <td> 2013</td>\n",
" <td> 10.1007/JHEP11(2013)011</td>\n",
" <td> 5.618</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> Sheng, Fong, Chee; Nardi, Enrico; </td>\n",
" <td> Spontaneous Breaking of Flavor Symmetry Avoids...</td>\n",
" <td> Physical Review Letters</td>\n",
" <td> 111</td>\n",
" <td> 061601</td>\n",
" <td> 2013</td>\n",
" <td> 10.1103/PhysRevLett.111.061601</td>\n",
" <td> 7.943</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> Sheng Fong, Chee; Gonzalez-Garcia, M. C; Nardi...</td>\n",
" <td> New ways to TeV scale leptogenesis</td>\n",
" <td> Journal of High Energy Physics</td>\n",
" <td> 1308</td>\n",
" <td> 104</td>\n",
" <td> 2013</td>\n",
" <td> 10.1007/JHEP08(2013)104</td>\n",
" <td> 5.618</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td> Cardenas, H; Restrepo, D; Rodriguez, J-Alexis; </td>\n",
" <td> The role of charged Higgs boson decays in the ...</td>\n",
" <td> Journal of Physics G-Nuclear and Particle Physics</td>\n",
" <td> 40</td>\n",
" <td> 095004</td>\n",
" <td> 2013</td>\n",
" <td> 10.1088/0954-3899/40/9/095004</td>\n",
" <td> 5.326</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td> Klasen, Michael; Yaguna, Carlos E; Ruiz-Alvare...</td>\n",
" <td> Electroweak corrections to the direct detectio...</td>\n",
" <td> Physical Review D</td>\n",
" <td> 87</td>\n",
" <td> 075025</td>\n",
" <td> 2013</td>\n",
" <td> 10.1103/PhysRevD.87.075025</td>\n",
" <td> 4.691</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td> Romano, Antonio Enea; </td>\n",
" <td> Conditions for low-redshift positive apparent ...</td>\n",
" <td> General Relativity and Gravitation</td>\n",
" <td> 45</td>\n",
" <td> 1515-1530</td>\n",
" <td> 2013</td>\n",
" <td> 10.1007/s10714-013-1541-x</td>\n",
" <td> 1.902</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 7,
"text": [
" Autor(es) \\\n",
"0 Klasen, Michael; Yaguna, Carlos E; Ruiz-Alvare... \n",
"1 Florez, Andres; Restrepo, Diego; Velasquez, Ma... \n",
"2 Ponce, William A; G\u00f3mez, John D; Benavides, Ri... \n",
"3 Sierra, D Aristizabal; Restrepo, D; Spinner, S; \n",
"4 Restrepo, Diego; Zapata, Oscar; Yaguna, Carlos... \n",
"5 Sheng, Fong, Chee; Nardi, Enrico; \n",
"6 Sheng Fong, Chee; Gonzalez-Garcia, M. C; Nardi... \n",
"7 Cardenas, H; Restrepo, D; Rodriguez, J-Alexis; \n",
"8 Klasen, Michael; Yaguna, Carlos E; Ruiz-Alvare... \n",
"9 Romano, Antonio Enea; \n",
"\n",
" Art\u00edculo \\\n",
"0 Scalar dark matter and fermion coannihilations... \n",
"1 Baryonic violation of R parity from anomalous ... \n",
"2 Five texture zeros and CP violation for the st... \n",
"3 LSP sneutrino novel decays \n",
"4 Models with radiative neutrino masses and viab... \n",
"5 Spontaneous Breaking of Flavor Symmetry Avoids... \n",
"6 New ways to TeV scale leptogenesis \n",
"7 The role of charged Higgs boson decays in the ... \n",
"8 Electroweak corrections to the direct detectio... \n",
"9 Conditions for low-redshift positive apparent ... \n",
"\n",
" Revista Vol. p\u00e1g. A\u00f1o \\\n",
"0 Journal of Cosmology and Astroparticle Physics 2013 044 2013 \n",
"1 Physical Review D 87 095010 2013 \n",
"2 Physical Review D 87 053016 2013 \n",
"3 Journal of High Energy Physics 2013 046 2013 \n",
"4 Journal of High Energy Physics 2013 011 2013 \n",
"5 Physical Review Letters 111 061601 2013 \n",
"6 Journal of High Energy Physics 1308 104 2013 \n",
"7 Journal of Physics G-Nuclear and Particle Physics 40 095004 2013 \n",
"8 Physical Review D 87 075025 2013 \n",
"9 General Relativity and Gravitation 45 1515-1530 2013 \n",
"\n",
" DOI Factor de Impacto \n",
"0 10.1088/1475-7516/2013/04/044 6.036 \n",
"1 10.1103/PhysRevD.87.095010 4.691 \n",
"2 10.1103/PhysRevD.87.053016 4.691 \n",
"3 10.1007/JHEP05(2013)046 5.618 \n",
"4 10.1007/JHEP11(2013)011 5.618 \n",
"5 10.1103/PhysRevLett.111.061601 7.943 \n",
"6 10.1007/JHEP08(2013)104 5.618 \n",
"7 10.1088/0954-3899/40/9/095004 5.326 \n",
"8 10.1103/PhysRevD.87.075025 4.691 \n",
"9 10.1007/s10714-013-1541-x 1.902 "
]
}
],
"prompt_number": 7
},
{
"cell_type": "heading",
"level": 4,
"metadata": {},
"source": [
"Factor de Impacto promedio de los art\u00edculos p\u00fablicados:"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"publicadas1['Factor de Impacto']=publicadas1['Factor de Impacto'].str.replace('null','0')\n",
"fi_mean=publicadas1[['Factor de Impacto']].astype(float).mean()[0]\n",
"print '%g' %fi_mean"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"5.2134\n"
]
}
],
"prompt_number": 8
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Proyectos activos"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfpr=read_google_cvs(gss_key=\"0AjqGPI5Q_Ez6dFE1S2pWQkZJdFkycWFvNXdaMDhkWFE\",gss_query=\"select *\",gss_sheet=0)\n",
"dfpr=dfpr[dfpr['Grupo'].str.contains(config_inf['Grupo'][0])].reset_index(drop=True)\n",
"dfpr['Fecha de Finalizaci\u00f3n']=dfpr['Fecha de Finalizaci\u00f3n'].str.replace('null','')\n",
"dfpr['Rec. Externos']=''\n",
"for i in range(len(dfpr)):\n",
" for proyext in config_inf['Proyectos Externos']:\n",
" if dfpr['Tipo'][i].find(proyext)>-1:\n",
" dfpr['Rec. Externos'][i]=dfpr['Recursos Frescos'][i]\n",
" \n",
"dfpr=dfpr[pd.DatetimeIndex(dfpr['Fecha de Finalizaci\u00f3n']).year>=config_inf['Years'][0]].sort('Fecha de Inicio').reset_index(drop=True)\n",
"dfpr=dfpr[['T\u00edtulo','Investigador Principal','Fecha de Inicio','Fecha de Finalizaci\u00f3n','Tipo','Rec. Externos']]\n",
"dfpr"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>T\u00edtulo</th>\n",
" <th>Investigador Principal</th>\n",
" <th>Fecha de Inicio</th>\n",
" <th>Fecha de Finalizaci\u00f3n</th>\n",
" <th>Tipo</th>\n",
" <th>Rec. Externos</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> Fenomenolog\u00eda de modelos supersim\u00e9tricos con r...</td>\n",
" <td> Diego Alejandro Restrepo Quintero</td>\n",
" <td> 2012-01-01</td>\n",
" <td> 2014-01-01</td>\n",
" <td> Mediana Cuant\u00eda</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> Testing the Standar Cosmological Model Studyng...</td>\n",
" <td> Antonio Enea Romano</td>\n",
" <td> 2012-01-26</td>\n",
" <td> 2013-07-26</td>\n",
" <td> Profesores Reci\u00e9n Vinculados</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> Materia oscura de gravitinos y masas de neutri...</td>\n",
" <td> \u00d3scar Alberto Zapata Nore\u00f1a</td>\n",
" <td> 2012-11-09</td>\n",
" <td> 2014-05-09</td>\n",
" <td> Profesores Reci\u00e9n Vinculados</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> Implicaciones de modelos supersim\u00e9tricos con v...</td>\n",
" <td> Diego Restrepo</td>\n",
" <td> 2013-02-14</td>\n",
" <td> 2015-02-14</td>\n",
" <td> Colciencias</td>\n",
" <td> $340,726,155.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> Estrategia para la Sostenibilidad GFIF 2013-2014</td>\n",
" <td> Diego Restrepo</td>\n",
" <td> 2013-03-06</td>\n",
" <td> 2015-03-06</td>\n",
" <td> Sostenibilidad</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> Cosmological effects of local inhomogeneities</td>\n",
" <td> Anotnio Enea Romano</td>\n",
" <td> 2013-10-01</td>\n",
" <td> 2016-10-01</td>\n",
" <td> SUI 2013</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> Masas y mezclas de neutrinos en modelos 3-N-1 ...</td>\n",
" <td> William Ponce</td>\n",
" <td> 2014-01-01</td>\n",
" <td> 2016-01-01</td>\n",
" <td> Convocatoria Ciencias Exactas</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td> Implicaciones de modelos tipo seesaw radiativo...</td>\n",
" <td> \u00d3scar Alberto Zapata Nore\u00f1a</td>\n",
" <td> 2014-01-01</td>\n",
" <td> 2017-01-01</td>\n",
" <td> Convocatoria Ciencias Exactas</td>\n",
" <td> </td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 9,
"text": [
" T\u00edtulo \\\n",
"0 Fenomenolog\u00eda de modelos supersim\u00e9tricos con r... \n",
"1 Testing the Standar Cosmological Model Studyng... \n",
"2 Materia oscura de gravitinos y masas de neutri... \n",
"3 Implicaciones de modelos supersim\u00e9tricos con v... \n",
"4 Estrategia para la Sostenibilidad GFIF 2013-2014 \n",
"5 Cosmological effects of local inhomogeneities \n",
"6 Masas y mezclas de neutrinos en modelos 3-N-1 ... \n",
"7 Implicaciones de modelos tipo seesaw radiativo... \n",
"\n",
" Investigador Principal Fecha de Inicio Fecha de Finalizaci\u00f3n \\\n",
"0 Diego Alejandro Restrepo Quintero 2012-01-01 2014-01-01 \n",
"1 Antonio Enea Romano 2012-01-26 2013-07-26 \n",
"2 \u00d3scar Alberto Zapata Nore\u00f1a 2012-11-09 2014-05-09 \n",
"3 Diego Restrepo 2013-02-14 2015-02-14 \n",
"4 Diego Restrepo 2013-03-06 2015-03-06 \n",
"5 Anotnio Enea Romano 2013-10-01 2016-10-01 \n",
"6 William Ponce 2014-01-01 2016-01-01 \n",
"7 \u00d3scar Alberto Zapata Nore\u00f1a 2014-01-01 2017-01-01 \n",
"\n",
" Tipo Rec. Externos \n",
"0 Mediana Cuant\u00eda \n",
"1 Profesores Reci\u00e9n Vinculados \n",
"2 Profesores Reci\u00e9n Vinculados \n",
"3 Colciencias $340,726,155.00 \n",
"4 Sostenibilidad \n",
"5 SUI 2013 \n",
"6 Convocatoria Ciencias Exactas \n",
"7 Convocatoria Ciencias Exactas "
]
}
],
"prompt_number": 9
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfpr=dfpr[pd.DatetimeIndex(dfpr['Fecha de Finalizaci\u00f3n']).year>=config_inf['Years'][0]]"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 10
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Estudiantes"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfd=read_google_cvs(gss_key=\"0AuLa_xuSIEvxdERYSGVQWDBTX1NCN19QMXVpb0lhWXc\",gss_query=\"select *\",gss_sheet=2)\n",
"dfd['PROGRAMA']='Doctorado'"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfm=read_google_cvs(gss_key=\"0AuLa_xuSIEvxdERYSGVQWDBTX1NCN19QMXVpb0lhWXc\",gss_query=\"select *\",gss_sheet=1)\n",
"dfm['PROGRAMA']='Maestr\u00eda'"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 12
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfp=read_google_cvs(gss_key=\"0AuLa_xuSIEvxdERYSGVQWDBTX1NCN19QMXVpb0lhWXc\",gss_query=\"select *\",gss_sheet=0)\n",
"dfp['PROGRAMA']='Pregrado'"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 13
},
{
"cell_type": "heading",
"level": 4,
"metadata": {},
"source": [
"Join into a single data frame"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfe=dfd.append(dfm)\n",
"dfe=dfe.append(dfp)\n",
"dfe=dfe[dfe['GRUPO'].str.contains(config_inf['Grupo'][0])]\n",
"dfe.columns"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 14,
"text": [
"Index([u'ASESOR', u'Becado de', u'Beneficios que recibe', u'CORREO', u'C\u00e9dula', u'Distinci\u00f3n', u'Doble titulaci\u00f3n', u'ESTANTE', u'ESTUDIANTE', u'Estado', u'Estado Laboral', u'Fecha de graduaci\u00f3n', u'Fecha de ingreso', u'Fecha de sustentaci\u00f3n', u'GRUPO', u'INSTITUTO', u'Materias matriculas semestre 2011-1', u'NOMBRE TESIS', u'No.TESIS', u'PROGRAMA', u'Pasant\u00eda', u'Proyecto ID', u'SIGNATURA', u'Situaci\u00f3n'], dtype=object)"
]
}
],
"prompt_number": 14
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfe['A\u00f1o de ingreso']=dfe['Fecha de ingreso'].replace('','0').replace('null','0').str.replace('-1','').str.replace('-2','').astype('int')\n",
"dfe['A\u00f1o de graduaci\u00f3n']=dfe['Fecha de graduaci\u00f3n'].replace('','0').replace('null','0').str.replace('-1','').str.replace('-2','').astype('int').values\n",
"#dfe['A\u00f1o de graduaci\u00f3n'].values"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 15
},
{
"cell_type": "heading",
"level": 4,
"metadata": {},
"source": [
"Working DataFrames"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfei=dfe[dfe['A\u00f1o de ingreso']>=config_inf['Years'][0]].reset_index(drop=True)\n",
"dfeg=dfe[dfe['A\u00f1o de graduaci\u00f3n']>=config_inf['Years'][0]].reset_index(drop=True)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 16
},
{
"cell_type": "heading",
"level": 5,
"metadata": {},
"source": [
"Nuevos"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfei['A\u00d1O']=dfei['A\u00f1o de ingreso']\n",
"dfei[['ESTUDIANTE','A\u00d1O','GRUPO','ASESOR','PROGRAMA']]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>ESTUDIANTE</th>\n",
" <th>A\u00d1O</th>\n",
" <th>GRUPO</th>\n",
" <th>ASESOR</th>\n",
" <th>PROGRAMA</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> Longas Bedoya Robinson</td>\n",
" <td> 2014</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Oscar Zapata</td>\n",
" <td> Doctorado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> Rivera Romero Andres Felipe</td>\n",
" <td> 2014</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Diego Restrepo Q.</td>\n",
" <td> Doctorado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> Marta Liliana S\u00e1nchez Pel\u00e1ez</td>\n",
" <td> 2013</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Diego Restrepo Q.</td>\n",
" <td> Doctorado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> Gillermo Alberto Palacios C\u00e1rdenas</td>\n",
" <td> 2013</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Diego Restrepo Q.</td>\n",
" <td> Doctorado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> Cesar Augusto Arias Chica</td>\n",
" <td> 2013</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Antonio Enea Romano</td>\n",
" <td> Doctorado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> Salazar Camilo Andr\u00e9s</td>\n",
" <td> 2014</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Willam Ponce</td>\n",
" <td> Maestr\u00eda</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> Dilia Portillo Quintero</td>\n",
" <td> 2013</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Oscar Zapata</td>\n",
" <td> Maestr\u00eda</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 17,
"text": [
" ESTUDIANTE A\u00d1O GRUPO ASESOR PROGRAMA\n",
"0 Longas Bedoya Robinson 2014 GFIF: Fenomenolog\u00eda Oscar Zapata Doctorado\n",
"1 Rivera Romero Andres Felipe 2014 GFIF: Fenomenolog\u00eda Diego Restrepo Q. Doctorado\n",
"2 Marta Liliana S\u00e1nchez Pel\u00e1ez 2013 GFIF: Fenomenolog\u00eda Diego Restrepo Q. Doctorado\n",
"3 Gillermo Alberto Palacios C\u00e1rdenas 2013 GFIF: Fenomenolog\u00eda Diego Restrepo Q. Doctorado\n",
"4 Cesar Augusto Arias Chica 2013 GFIF: Fenomenolog\u00eda Antonio Enea Romano Doctorado\n",
"5 Salazar Camilo Andr\u00e9s 2014 GFIF: Fenomenolog\u00eda Willam Ponce Maestr\u00eda\n",
"6 Dilia Portillo Quintero 2013 GFIF: Fenomenolog\u00eda Oscar Zapata Maestr\u00eda"
]
}
],
"prompt_number": 17
},
{
"cell_type": "heading",
"level": 5,
"metadata": {},
"source": [
"Graduados"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfeg['A\u00d1O']=dfeg['A\u00f1o de graduaci\u00f3n']\n",
"dfeg[['ESTUDIANTE','A\u00d1O','GRUPO','ASESOR','PROGRAMA']].reset_index(drop=True)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>ESTUDIANTE</th>\n",
" <th>A\u00d1O</th>\n",
" <th>GRUPO</th>\n",
" <th>ASESOR</th>\n",
" <th>PROGRAMA</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> Mauricio Vel\u00e1squez L\u00f3pez</td>\n",
" <td> 2013</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Diego Restrepo Q.</td>\n",
" <td> Doctorado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> Alexander Gallego Cadavid</td>\n",
" <td> 2013</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> Antonio Enea Romano</td>\n",
" <td> Maestr\u00eda</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> Johana Alexandra Herrera Ruales </td>\n",
" <td> 2013</td>\n",
" <td> GFIF: Fenomenolog\u00eda</td>\n",
" <td> William Ponce G.</td>\n",
" <td> Maestr\u00eda</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> Camilo Andr\u00e9s Salazar Gonz\u00e1lez</td>\n",
" <td> 2013</td>\n",
" <td> GFIF</td>\n",
" <td> Diego Restrepo</td>\n",
" <td> Pregrado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> Dilia Maria Portillo</td>\n",
" <td> 2013</td>\n",
" <td> GFIF</td>\n",
" <td> Diego Restrepo</td>\n",
" <td> Pregrado</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> Cristian David Ruiz Carvajal</td>\n",
" <td> 2013</td>\n",
" <td> GFIF</td>\n",
" <td> William Antonio Ponce Gutierrez</td>\n",
" <td> Pregrado</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 18,
"text": [
" ESTUDIANTE A\u00d1O GRUPO \\\n",
"0 Mauricio Vel\u00e1squez L\u00f3pez 2013 GFIF: Fenomenolog\u00eda \n",
"1 Alexander Gallego Cadavid 2013 GFIF: Fenomenolog\u00eda \n",
"2 Johana Alexandra Herrera Ruales 2013 GFIF: Fenomenolog\u00eda \n",
"3 Camilo Andr\u00e9s Salazar Gonz\u00e1lez 2013 GFIF \n",
"4 Dilia Maria Portillo 2013 GFIF \n",
"5 Cristian David Ruiz Carvajal 2013 GFIF \n",
"\n",
" ASESOR PROGRAMA \n",
"0 Diego Restrepo Q. Doctorado \n",
"1 Antonio Enea Romano Maestr\u00eda \n",
"2 William Ponce G. Maestr\u00eda \n",
"3 Diego Restrepo Pregrado \n",
"4 Diego Restrepo Pregrado \n",
"5 William Antonio Ponce Gutierrez Pregrado "
]
}
],
"prompt_number": 18
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Pasant\u00edas"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfpa=read_google_cvs(gss_key=\"0AjqGPI5Q_Ez6dEJoNF91YjYwOENmNHZPTWZuTmsyTGc\",gss_query=\"select *\",gss_sheet=0)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 19
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Remove spurios space from column names"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfpa.columns=[i.strip() for i in dfpa.columns]\n",
"dfpa.columns"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 20,
"text": [
"Index([u'Timestamp', u'Nombre', u'Instituto', u'Pa\u00eds', u'Fecha salida', u'Fecha regreso', u'Grupo', u'Proyecto ID', u'Monto', u'T\u00edtulo Seminario'], dtype=object)"
]
}
],
"prompt_number": 20
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfpa=dfpa[dfpa['Grupo'].str.contains(config_inf['Grupo'][0])]\n",
"dfpat=dfpa[pd.DatetimeIndex(dfpa['Fecha salida']).year>=config_inf['Years'][0]]\n",
"dfpat=dfpat.reset_index(drop=True)\n",
"dfpas=dfpat[['Nombre','Instituto','Fecha salida','Fecha regreso','Proyecto ID','Monto']]\n",
"dfpas.columns=['Nombre','Instituci\u00f3n','Salida','Regreso','Proyecto','Rec. externos']\n",
"dfpas=dfpas.sort(columns='Salida').reset_index(drop=True)\n",
"#Avoid accidental math mode errors\n",
"dfpas['Rec. externos']=dfpas['Rec. externos'].str.replace('$',r'\\textdollar ')\n",
"dfpas"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Nombre</th>\n",
" <th>Instituci\u00f3n</th>\n",
" <th>Salida</th>\n",
" <th>Regreso</th>\n",
" <th>Proyecto</th>\n",
" <th>Rec. externos</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> Mauricio Vel\u00e1squez L\u00f3pez</td>\n",
" <td> IFIC CSIC-Universidad de Valencia</td>\n",
" <td> 2013-01-24</td>\n",
" <td> 2013-03-28</td>\n",
" <td> IN1614CE</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> Antonio Enea Romano</td>\n",
" <td> The University of Szczecin</td>\n",
" <td> 2013-06-24</td>\n",
" <td> 2013-06-29</td>\n",
" <td> Sostenibilidad GFIF</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> Antonio Enea Romano</td>\n",
" <td> Universidad de Mcgill, Montreal</td>\n",
" <td> 2013-08-19</td>\n",
" <td> 2013-08-22</td>\n",
" <td> Sostenibilidad GFIF</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> Diego Restrepo</td>\n",
" <td> IFIC CSIC-Universidad de Valencia</td>\n",
" <td> 2013-09-02</td>\n",
" <td> 2013-09-27</td>\n",
" <td> IN3055CE</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> Diego Restrepo</td>\n",
" <td> LNF-INFN Frascati</td>\n",
" <td> 2013-09-30</td>\n",
" <td> 2013-10-10</td>\n",
" <td> IN1614CE</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> Diego Restrepo</td>\n",
" <td> Universidad de Liege</td>\n",
" <td> 2013-10-14</td>\n",
" <td> 2013-11-08</td>\n",
" <td> IN624CE</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> Diego Restrepo</td>\n",
" <td> Technische Universit\u00e4t M\u00fcnchen, TUM</td>\n",
" <td> 2013-11-04</td>\n",
" <td> 2013-11-05</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td> Oscar Zapata</td>\n",
" <td> Technische Universit\u00e4t M\u00fcnchen, TUM</td>\n",
" <td> 2013-11-04</td>\n",
" <td> 2014-04-04</td>\n",
" <td> Postdoc DAAD</td>\n",
" <td> \\textdollar 19.000.000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td> Diego Restrepo</td>\n",
" <td> Univsidad de M\u00fcnster</td>\n",
" <td> 2013-11-11</td>\n",
" <td> 2013-11-15</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 21,
"text": [
" Nombre Instituci\u00f3n Salida \\\n",
"0 Mauricio Vel\u00e1squez L\u00f3pez IFIC CSIC-Universidad de Valencia 2013-01-24 \n",
"1 Antonio Enea Romano The University of Szczecin 2013-06-24 \n",
"2 Antonio Enea Romano Universidad de Mcgill, Montreal 2013-08-19 \n",
"3 Diego Restrepo IFIC CSIC-Universidad de Valencia 2013-09-02 \n",
"4 Diego Restrepo LNF-INFN Frascati 2013-09-30 \n",
"5 Diego Restrepo Universidad de Liege 2013-10-14 \n",
"6 Diego Restrepo Technische Universit\u00e4t M\u00fcnchen, TUM 2013-11-04 \n",
"7 Oscar Zapata Technische Universit\u00e4t M\u00fcnchen, TUM 2013-11-04 \n",
"8 Diego Restrepo Univsidad de M\u00fcnster 2013-11-11 \n",
"\n",
" Regreso Proyecto Rec. externos \n",
"0 2013-03-28 IN1614CE \n",
"1 2013-06-29 Sostenibilidad GFIF \n",
"2 2013-08-22 Sostenibilidad GFIF \n",
"3 2013-09-27 IN3055CE \n",
"4 2013-10-10 IN1614CE \n",
"5 2013-11-08 IN624CE \n",
"6 2013-11-05 \n",
"7 2014-04-04 Postdoc DAAD \\textdollar 19.000.000 \n",
"8 2013-11-15 "
]
}
],
"prompt_number": 21
},
{
"cell_type": "heading",
"level": 2,
"metadata": {},
"source": [
"ALmacene informaci\u00f3n en un archivo $\\LaTeX$"
]
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"`Cell -> Run All Bellow`: from here, to update $\\LaTeX$ file"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import locale\n",
"locale.setlocale(locale.LC_ALL, 'en_US')\n",
"latexfile=config_inf['LaTeX File']\n",
"f=open(latexfile,'w')\n",
"f.write(r'''\\documentclass{article}\n",
"\\usepackage[utf8]{inputenc}\n",
"\\usepackage[colorlinks = true]{hyperref}\n",
"\\usepackage[spanish]{babel}\n",
"\\usepackage{textcomp}\n",
"\\renewcommand{\\rmdefault}{phv}\n",
"\\renewcommand{\\sfdefault}{pag}\n",
"\\renewcommand{\\ttdefault}{pcr}\n",
"\\usepackage{amsmath}\n",
"\\usepackage{amssymb}\n",
"\\usepackage{graphicx}\n",
"\\usepackage{xcolor}\n",
"\\usepackage{booktabs}\n",
"\\setlength{\\oddsidemargin}{-0.5cm}\n",
"\\setlength{\\evensidemargin}{-0.5cm}\n",
"\\setlength{\\topmargin}{-1cm}\n",
"\\setlength{\\textheight}{21.5cm}\n",
"\\setlength{\\textwidth}{18cm}\n",
"\\pagestyle{empty}\n",
"\\title{Informe estrateg\u00eda de Sostenibilidad %s %s\\footnote{\n",
"Generado autom\u00e1ticamente con Ipython:\n",
"\\url{http://nbviewer.ipython.org/urls/gist.github.com/rescolo/8694834/raw/InformeSostebilidad.ipynb},\n",
"a partir de los Indicadores del Instituto de F\u00edsica: \\url{http://fisica.udea.edu.co/fisica}\n",
"}}\n",
"\\author{%s}\n",
"\\begin{document}\n",
"\\maketitle\n",
"''' %(config_inf['Grupo'][0],config_inf['Years'][0],config_inf['Grupo'][1]))\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 22
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Art\u00edculos"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\section*{Art\u00edculos: %s }\n",
"''' %' '.join([str(i) for i in config_inf['Years']]))\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 23
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"pb=publicadas1\n",
"pb.columns"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 24,
"text": [
"Index([u'Marca temporal', u'Nombre de usuario', u'A\u00f1o', u'Tipo', u'Autor(es)', u'Revista', u'Vol.', u'p\u00e1g.', u'ISSN', u'Art\u00edculo', u'Impreso', u'PDF', u'Grupo', u'DOI', u'Tipo.1', u'R\u00f3tulo', u'Autores de la UdeA', u'Clasificaci\u00f3n Colciencias', u'Factor de Impacto'], dtype=object)"
]
}
],
"prompt_number": 24
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open(latexfile,'a')\n",
"f.write(\n",
"r'''Factor de Impacto (FI) promedio: %g\n",
"\\begin{enumerate}\n",
"''' %fi_mean)\n",
"\n",
"for i in range(pb.shape[0]):\n",
" title = re.sub(r\"\\$.*?\\$\",\"\",pb['Art\u00edculo'][i]) # better remove all math expressions\n",
" title = re.sub(r\"[^a-zA-Z0-9\\(\\)\\-\\+\\s]\", \"\", title) #remove non standard characters\n",
" f.write(r\"\"\"\\item %s, ``%s'', %s, %s(%s)%s, DOI: \\href{http://dx.doi.org/%s}{%s}, FI: %s,\n",
"\"\"\" %(simplify_authors(pb['Autor(es)'][i]),title,pb['Revista'][i],pb['Vol.'][i],pb['A\u00f1o'][i],pb['p\u00e1g.'][i],pb['DOI'][i],pb['DOI'][i],pb['Factor de Impacto'][i])) \n",
"\n",
"f.write(r'''\n",
"\\end{enumerate}\n",
"\\textbf{Compromiso:} %g art\u00edculos con FI promedio de %g.\n",
"''' %(compromisos['Art\u00edculos'][0],compromisos['Art\u00edculos'][1]))\n",
"\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 25
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Proyectos activos"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\section*{Proyectos activos: %s }\n",
"''' %' '.join([str(i) for i in config_inf['Years']]))\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 26
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\begin{enumerate}\n",
"''')\n",
"\n",
"for i in range(len(dfpr)): \n",
" f.write(r\"\"\"\\item ``%s'', IP: %s, inicia: %s, finaliza: %s, tipo: %s, \"\"\" \n",
" %(dfpr['T\u00edtulo'][i],dfpr['Investigador Principal'][i],dfpr['Fecha de Inicio'][i],dfpr['Fecha de Finalizaci\u00f3n'][i], dfpr['Tipo'][i]))\n",
" if dfpr['Rec. Externos'][i]: \n",
" f.write(r\"\"\"\\textbf{Recursos externos: %s}\"\"\" %dfpr['Rec. Externos'][i].replace(r'$',r'\\$'))\n",
" f.write(\"\\n\")\n",
" \n",
"f.write(r'''\n",
"\\end{enumerate}\n",
"\\textbf{Compromiso}: \\$%s en recursos externos nacionales\n",
"''' %locale.format(\"%d\",compromisos['Financiaci\u00f3n']['Internos'] , grouping=True))\n",
"\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 27
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Estudiantes"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\section*{Estudiantes graduados: %s }\n",
"''' %' '.join([str(i) for i in config_inf['Years']]))\n",
"f.close()\n",
"\n",
"if len(dfeg)>0:\n",
" f=open(latexfile,'a')\n",
" f.write(fixtable(dfeg[['ESTUDIANTE','A\u00d1O','ASESOR','PROGRAMA']].reset_index(drop=True).to_latex(index=False)).encode(\"utf8\"))\n",
" f.close()\n",
"\n",
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\section*{Estudiantes nuevos: %s }\n",
"''' %' '.join([str(i) for i in config_inf['Years']]))\n",
"f.close()\n",
"\n",
"if len(dfei)>0:\n",
" f=open(latexfile,'a')\n",
" f.write(fixtable(dfei[['ESTUDIANTE','A\u00d1O','ASESOR','PROGRAMA']].reset_index(drop=True).to_latex(index=False)).encode(\"utf8\"))\n",
" f.write(r'''\n",
"\n",
" \\smallskip\n",
"\n",
" \\textbf{Compromiso:} ''')\n",
" for i in ['Doctorado','Maestr\u00eda', 'Pregrado']:\n",
" if compromisos['Estudiantes'][i]>0:\n",
" f.write(r'''Formar %g estudiantes de %s\n",
" ''' %(compromisos['Estudiantes'][i],i))\n",
" \n",
" f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 28
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Pasant\u00edas"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\section*{Pasant\u00edas internacionales en %s }\n",
"''' %' '.join([str(i) for i in config_inf['Years']]))\n",
"f.close()\n",
"\n",
"if len(dfpas)>0:\n",
" f=open(latexfile,'a')\n",
" f.write(r'\\hspace{-2.2cm}')\n",
" f.write(fixtable(dfpas.to_latex(index=False)).encode(\"utf8\"))\n",
" f.close()\n",
"\n",
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\textbf{Compromiso:} \\$%s en recursos externos internacionales\n",
"''' %locale.format(\"%d\",compromisos['Financiaci\u00f3n']['Externos'] , grouping=True))\n",
"f.close()\n"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 29
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Conclusiones"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\section*{Conclusiones}\n",
"%s\n",
"''' %config_inf['Conclusiones'])\n",
"f.write(r'''\n",
"\n",
"\\vspace{2cm}\n",
"\n",
"$\\overline{\\text{%s}}$\n",
"\n",
"Coordinador %s\n",
"''' %(config_inf['Coordinador'],config_inf['Grupo'][0]))\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 30
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Closing"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"\n",
"f=open(latexfile,'a')\n",
"f.write(r'''\n",
"\\end{document}\n",
"''') \n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 31
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 31
},
{
"cell_type": "heading",
"level": 4,
"metadata": {},
"source": [
"Check $\\LaTeX$ output"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"catutf8(latexfile)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\\documentclass{article}\n",
"\\usepackage[utf8]{inputenc}\n",
"\\usepackage[colorlinks = true]{hyperref}\n",
"\\usepackage[spanish]{babel}\n",
"\\usepackage{textcomp}\n",
"\\renewcommand{\\rmdefault}{phv}\n",
"\\renewcommand{\\sfdefault}{pag}\n",
"\\renewcommand{\\ttdefault}{pcr}\n",
"\\usepackage{amsmath}\n",
"\\usepackage{amssymb}\n",
"\\usepackage{graphicx}\n",
"\\usepackage{xcolor}\n",
"\\usepackage{booktabs}\n",
"\\setlength{\\oddsidemargin}{-0.5cm}\n",
"\\setlength{\\evensidemargin}{-0.5cm}\n",
"\\setlength{\\topmargin}{-1cm}\n",
"\\setlength{\\textheight}{21.5cm}\n",
"\\setlength{\\textwidth}{18cm}\n",
"\\pagestyle{empty}\n",
"\\title{Informe estrateg\u00eda de Sostenibilidad GFIF 2013\\footnote{\n",
"Generado autom\u00e1ticamente con Ipython:\n",
"\\url{http://nbviewer.ipython.org/urls/gist.github.com/rescolo/8694834/raw/InformeSostebilidad.ipynb},\n",
"a partir de los Indicadores del Instituto de F\u00edsica: \\url{http://fisica.udea.edu.co/fisica}\n",
"}}\n",
"\\author{Grupo de Fenomenolog\u00eda de Interacciones Fundamentales}\n",
"\\begin{document}\n",
"\\maketitle\n",
"\n",
"\\section*{Art\u00edculos: 2013 2014 }\n",
"Factor de Impacto (FI) promedio: 5.2134\n",
"\\begin{enumerate}\n",
"\\item Klasen M., Yaguna C. E, Ruiz-Alvarez J. D, Restrepo D., Zapata O., ``Scalar dark matter and fermion coannihilations in the radiative seesaw model'', Journal of Cosmology and Astroparticle Physics, 2013(2013)044, DOI: \\href{http://dx.doi.org/10.1088/1475-7516/2013/04/044}{10.1088/1475-7516/2013/04/044}, FI: 6.036,\n",
"\\item Florez A., Restrepo D., Velasquez M., Zapata O., ``Baryonic violation of R parity from anomalous U (1) H'', Physical Review D, 87(2013)095010, DOI: \\href{http://dx.doi.org/10.1103/PhysRevD.87.095010}{10.1103/PhysRevD.87.095010}, FI: 4.691,\n",
"\\item Ponce W. A, G\u00f3mez J. D, Benavides R. H, ``Five texture zeros and CP violation for the standard model quark mass matrices'', Physical Review D, 87(2013)053016, DOI: \\href{http://dx.doi.org/10.1103/PhysRevD.87.053016}{10.1103/PhysRevD.87.053016}, FI: 4.691,\n",
"\\item Sierra, D Aristizabal, Restrepo, D, Spinner, S, ``LSP sneutrino novel decays'', Journal of High Energy Physics, 2013(2013)046, DOI: \\href{http://dx.doi.org/10.1007/JHEP05(2013)046}{10.1007/JHEP05(2013)046}, FI: 5.618,\n",
"\\item Restrepo D., Zapata O., Yaguna C. E, ``Models with radiative neutrino masses and viable dark matter candidates'', Journal of High Energy Physics, 2013(2013)011, DOI: \\href{http://dx.doi.org/10.1007/JHEP11(2013)011}{10.1007/JHEP11(2013)011}, FI: 5.618,\n",
"\\item Sheng F. C., Nardi E., ``Spontaneous Breaking of Flavor Symmetry Avoids the Strong CP Problem'', Physical Review Letters, 111(2013)061601, DOI: \\href{http://dx.doi.org/10.1103/PhysRevLett.111.061601}{10.1103/PhysRevLett.111.061601}, FI: 7.943,\n",
"\\item Sheng Fong C., Gonzalez-Garcia, M. C, Nardi E., Peinado E., ``New ways to TeV scale leptogenesis'', Journal of High Energy Physics, 1308(2013)104, DOI: \\href{http://dx.doi.org/10.1007/JHEP08(2013)104}{10.1007/JHEP08(2013)104}, FI: 5.618,\n",
"\\item Cardenas, H, Restrepo, D, Rodriguez, J-Alexis, ``The role of charged Higgs boson decays in the determination of tan-like parameters'', Journal of Physics G-Nuclear and Particle Physics, 40(2013)095004, DOI: \\href{http://dx.doi.org/10.1088/0954-3899/40/9/095004}{10.1088/0954-3899/40/9/095004}, FI: 5.326,\n",
"\\item Klasen M., Yaguna C. E, Ruiz-Alvarez J. D, ``Electroweak corrections to the direct detection cross section of inert Higgs dark matter'', Physical Review D, 87(2013)075025, DOI: \\href{http://dx.doi.org/10.1103/PhysRevD.87.075025}{10.1103/PhysRevD.87.075025}, FI: 4.691,\n",
"\\item Romano A. Enea, ``Conditions for low-redshift positive apparent acceleration in smooth inhomogeneous models'', General Relativity and Gravitation, 45(2013)1515-1530, DOI: \\href{http://dx.doi.org/10.1007/s10714-013-1541-x}{10.1007/s10714-013-1541-x}, FI: 1.902,\n",
"\n",
"\\end{enumerate}\n",
"\\textbf{Compromiso:} 14 art\u00edculos con FI promedio de 3.7445.\n",
"\n",
"\\section*{Proyectos activos: 2013 2014 }\n",
"\n",
"\\begin{enumerate}\n",
"\\item ``Fenomenolog\u00eda de modelos supersim\u00e9tricos con ruptura de paridad R y violaci\u00f3n de n\u00famero lept\u00f3nico.'', IP: Diego Alejandro Restrepo Quintero, inicia: 2012-01-01, finaliza: 2014-01-01, tipo: Mediana Cuant\u00eda, \n",
"\\item ``Testing the Standar Cosmological Model Studyng the effects of not gaussianity and large scale inhomogenities'', IP: Antonio Enea Romano, inicia: 2012-01-26, finaliza: 2013-07-26, tipo: Profesores Reci\u00e9n Vinculados, \n",
"\\item ``Materia oscura de gravitinos y masas de neutrinos en modelos con violaci\u00f3n trilineal y bilineal inducida de paridad R'', IP: \u00d3scar Alberto Zapata Nore\u00f1a, inicia: 2012-11-09, finaliza: 2014-05-09, tipo: Profesores Reci\u00e9n Vinculados, \n",
"\\item ``Implicaciones de modelos supersim\u00e9tricos con violaci\u00f3n de paridad R en las fronteras de f\u00edsica de part\u00edculas y cosmolog\u00eda'', IP: Diego Restrepo, inicia: 2013-02-14, finaliza: 2015-02-14, tipo: Colciencias, \\textbf{Recursos externos: \\$340,726,155.00}\n",
"\\item ``Estrategia para la Sostenibilidad GFIF 2013-2014'', IP: Diego Restrepo, inicia: 2013-03-06, finaliza: 2015-03-06, tipo: Sostenibilidad, \n",
"\\item ``Cosmological effects of local inhomogeneities'', IP: Anotnio Enea Romano, inicia: 2013-10-01, finaliza: 2016-10-01, tipo: SUI 2013, \n",
"\\item ``Masas y mezclas de neutrinos en modelos 3-N-1 (N=3,4)'', IP: William Ponce, inicia: 2014-01-01, finaliza: 2016-01-01, tipo: Convocatoria Ciencias Exactas, \n",
"\\item ``Implicaciones de modelos tipo seesaw radiativo en las fronteras de la f\u00edsica de part\u00edculas y la cosmolog\u00eda'', IP: \u00d3scar Alberto Zapata Nore\u00f1a, inicia: 2014-01-01, finaliza: 2017-01-01, tipo: Convocatoria Ciencias Exactas, \n",
"\n",
"\\end{enumerate}\n",
"\\textbf{Compromiso}: \\$138,600,000 en recursos externos nacionales\n",
"\n",
"\\section*{Estudiantes graduados: 2013 2014 }\n",
"\\begin{tabular}{|l|r|l|l|}\\hline\n",
"\\toprule\n",
" ESTUDIANTE & A\u00d1O & ASESOR & PROGRAMA \\\\\\hline\n",
"\\midrule\n",
" Mauricio Vel\u00e1squez L\u00f3pez & 2013 & Diego Restrepo Q. & Doctorado \\\\\n",
" Alexander Gallego Cadavid & 2013 & Antonio Enea Romano & Maestr\u00eda \\\\\n",
" Johana Alexandra Herrera Ruales & 2013 & William Ponce G. & Maestr\u00eda \\\\\n",
" Camilo Andr\u00e9s Salazar Gonz\u00e1lez & 2013 & Diego Restrepo & Pregrado \\\\\n",
" Dilia Maria Portillo & 2013 & Diego Restrepo & Pregrado \\\\\n",
" Cristian David Ruiz Carvajal & 2013 & William Antonio Ponce Gutierrez & Pregrado \\\\\\hline\n",
"\\bottomrule\n",
"\\end{tabular}\n",
"\n",
"\\section*{Estudiantes nuevos: 2013 2014 }\n",
"\\begin{tabular}{|l|r|l|l|}\\hline\n",
"\\toprule\n",
" ESTUDIANTE & A\u00d1O & ASESOR & PROGRAMA \\\\\\hline\n",
"\\midrule\n",
" Longas Bedoya Robinson & 2014 & Oscar Zapata & Doctorado \\\\\n",
" Rivera Romero Andres Felipe & 2014 & Diego Restrepo Q. & Doctorado \\\\\n",
" Marta Liliana S\u00e1nchez Pel\u00e1ez & 2013 & Diego Restrepo Q. & Doctorado \\\\\n",
" Gillermo Alberto Palacios C\u00e1rdenas & 2013 & Diego Restrepo Q. & Doctorado \\\\\n",
" Cesar Augusto Arias Chica & 2013 & Antonio Enea Romano & Doctorado \\\\\n",
" Salazar Camilo Andr\u00e9s & 2014 & Willam Ponce & Maestr\u00eda \\\\\n",
" Dilia Portillo Quintero & 2013 & Oscar Zapata & Maestr\u00eda \\\\\\hline\n",
"\\bottomrule\n",
"\\end{tabular}\n",
"\n",
"\n",
" \\smallskip\n",
"\n",
" \\textbf{Compromiso:} Formar 2 estudiantes de Doctorado\n",
" \n",
"\\section*{Pasant\u00edas internacionales en 2013 2014 }\n",
"\\hspace{-2.2cm}\\begin{tabular}{|l|l|l|l|l|l|}\\hline\n",
"\\toprule\n",
" Nombre & Instituci\u00f3n & Salida & Regreso & Proyecto & Rec. externos \\\\\\hline\n",
"\\midrule\n",
" Mauricio Vel\u00e1squez L\u00f3pez & IFIC CSIC-Universidad de Valencia & 2013-01-24 & 2013-03-28 & IN1614CE & \\\\\n",
" Antonio Enea Romano & The University of Szczecin & 2013-06-24 & 2013-06-29 & Sostenibilidad GFIF & \\\\\n",
" Antonio Enea Romano & Universidad de Mcgill, Montreal & 2013-08-19 & 2013-08-22 & Sostenibilidad GFIF & \\\\\n",
" Diego Restrepo & IFIC CSIC-Universidad de Valencia & 2013-09-02 & 2013-09-27 & IN3055CE & \\\\\n",
" Diego Restrepo & LNF-INFN Frascati & 2013-09-30 & 2013-10-10 & IN1614CE & \\\\\n",
" Diego Restrepo & Universidad de Liege & 2013-10-14 & 2013-11-08 & IN624CE & \\\\\n",
" Diego Restrepo & Technische Universit\u00e4t M\u00fcnchen, TUM & 2013-11-04 & 2013-11-05 & & \\\\\n",
" Oscar Zapata & Technische Universit\u00e4t M\u00fcnchen, TUM & 2013-11-04 & 2014-04-04 & Postdoc DAAD & \\textdollar 19.000.000 \\\\\n",
" Diego Restrepo & Univsidad de M\u00fcnster & 2013-11-11 & 2013-11-15 & & \\\\\\hline\n",
"\\bottomrule\n",
"\\end{tabular}\n",
"\n",
"\\textbf{Compromiso:} \\$15,400,000 en recursos externos internacionales\n",
"\n",
"\\section*{Conclusiones}\n",
"\n",
"A la fecha se ha ejecutado el 100\\% del presupuesto desembolsado, y se ha cumplido la casi totalidad de los compromisos.\n",
"\n",
"\n",
"\n",
"\\vspace{2cm}\n",
"\n",
"$\\overline{\\text{Diego A. Restrepo Q.}}$\n",
"\n",
"Coordinador GFIF\n",
"\n",
"\\end{document}\n",
"\n"
]
}
],
"prompt_number": 32
},
{
"cell_type": "heading",
"level": 4,
"metadata": {},
"source": [
"Compile $\\LaTeX$ file to PDF"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"f=open('FLAGS','w')\n",
"f.write(latexfile)\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 33
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Generate PDF with the LaTeX from http://gfif.udea.edu.co:2700 (based on https://raw.github.com/aslushnikov/latex-online/master/util/laton)"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"%%bash\n",
"if [ ! $(which curl) ];then\n",
" echo 'ERROR: curl is required in order to generate the PDF output'\n",
" exit 1\n",
"fi\n",
"\n",
"target=$(cat FLAGS)\n",
"host=gfif.udea.edu.co:2700\n",
"base=$(basename $target)\n",
"pdfFileName=${base%.*}.pdf\n",
"tarball=informe.tar.bz2\n",
"tar -cj $target > $tarball\n",
"\n",
"outputFile=pdfFileName\n",
"curl -F file=@$tarball \"$host/data?target=$target\" > $pdfFileName 2> /dev/null\n",
"\n",
"if [ $(file $pdfFileName|grep \"PDF document\"|wc -l) -gt 0 ]\n",
" then\n",
" echo Success! $pdfFileName is written\n",
"\n",
" else\n",
" echo Errors during compiling TeX document\n",
" exit 1\n",
"fi"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"Success! informe.pdf is written\n"
]
}
],
"prompt_number": 34
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Output files ( [SRC](files/informe.tex), [PDF](files/informe.pdf) )"
]
},
{
"cell_type": "heading",
"level": 5,
"metadata": {},
"source": [
"Old way: push and pull gist repository and send final url to gfif:2700"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"COMMIT=False\n",
"if config_inf['DEBUG']: COMMIT=False\n",
"\n",
"f=open('FLAGS','w')\n",
"if COMMIT:\n",
" f.write('COMMIT')\n",
"else:\n",
" f.write('')\n",
"f.close()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 35
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"%%bash\n",
"commitbol=$(cat FLAGS)\n",
"echo $commitbol\n",
"if [ \"$commitbol\" ];then\n",
" outdir=info_sostenibilidad\n",
" if [ ! -d $outdir ]; then\n",
" git clone git@github.com:f46aa3f23118ed8fa154.git\n",
" mv f46aa3f23118ed8fa154 $outdir\n",
" fi\n",
" cd info_sostenibilidad/ \n",
" git commit -a -m 'Python generated changes'\n",
" git push origin master\n",
"fi"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n"
]
}
],
"prompt_number": 36
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"http://gfif.udea.edu.co:2700/compile?url=https://gist.github.com/rescolo/f46aa3f23118ed8fa154/raw/informe.tex"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Version 2013-01-29 14:48 at [WriteLaTeX](https://www.writelatex.com/680323tktmwj#/1443936/)"
]
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment