{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "#szekelyland workbook - extrapolating from romanian values using mortality statistics from INSSE\n", "import pandas as pd, numpy as np" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df=pd.read_csv('trexportPivot_POP206C.csv')\n", "de=pd.read_csv('trexportPivot_POP206E.csv')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Index([u'Sexe', u' Grupe de varsta ',\n", " u' Macroregiuni regiuni de dezvoltare si judete', u' Ani',\n", " u' UM: Numar persoane', u' Valoare'],\n", " dtype='object')" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "de.columns" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [], "source": [ "df=df.drop(u' UM: Numar persoane',axis=1).set_index([u' Ani',u'Clasificarea internationala a maladiilor - Revizia a X a 1994',u' Macroregiuni regiuni de dezvoltare si judete'])\n", "de=de.drop(u' UM: Numar persoane',axis=1).set_index([u' Ani',u'Sexe',u' Grupe de varsta ',u' Macroregiuni regiuni de dezvoltare si judete'])" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | \n", " | \n", " | \n", " | Valoare | \n", "
---|---|---|---|---|
Ani | \n", "Sexe | \n", "Grupe de varsta | \n", "Macroregiuni regiuni de dezvoltare si judete | \n", "\n", " |
Anul 1990 | \n", "Total | \n", "Total | \n", "TOTAL | \n", "247086 | \n", "
Anul 1991 | \n", "Total | \n", "Total | \n", "TOTAL | \n", "251760 | \n", "
Anul 1992 | \n", "Total | \n", "Total | \n", "TOTAL | \n", "263855 | \n", "
Anul 1993 | \n", "Total | \n", "Total | \n", "TOTAL | \n", "263323 | \n", "
Anul 1994 | \n", "Total | \n", "Total | \n", "TOTAL | \n", "266101 | \n", "