{ "cells": [ { "cell_type": "code", "execution_count": 239, "metadata": { "ExecuteTime": { "end_time": "2019-03-07T02:56:32.521682Z", "start_time": "2019-03-07T02:56:26.288106Z" } }, "outputs": [], "source": [ "import pandas as pd, numpy as np, json, os" ] }, { "cell_type": "code", "execution_count": 240, "metadata": {}, "outputs": [], "source": [ "# os.chdir('E:/Onedrive - Lancaster University/datarepo/influence/ro')\n", "os.chdir('C:/users/csala/Onedrive - Lancaster University/datarepo/influence/ro')" ] }, { "cell_type": "code", "execution_count": 241, "metadata": {}, "outputs": [], "source": [ "nmembers=json.loads(open('data/nmembers.json','r').read())" ] }, { "cell_type": "code", "execution_count": 242, "metadata": {}, "outputs": [], "source": [ "img=json.loads(open('data/img.json','r').read())" ] }, { "cell_type": "code", "execution_count": 243, "metadata": {}, "outputs": [], "source": [ "deaths=json.loads(open('data/deaths.json','r').read())" ] }, { "cell_type": "code", "execution_count": 244, "metadata": {}, "outputs": [], "source": [ "# os.chdir('E:/Skydrive/Github/influence/ro')\n", "os.chdir('C:/users/csala/Onedrive/Github/influence/ro')" ] }, { "cell_type": "code", "execution_count": 245, "metadata": {}, "outputs": [], "source": [ "legs={'2016':['2016-12-21','2019-07-01'],\n", "'2012':['2012-12-20','2016-12-20'],\n", "'2008':['2008-12-19','2012-12-19'],\n", "'2004':['2004-12-19','2008-12-13'],\n", "'2000':['2000-12-15','2004-11-30'],\n", "'1996':['1996-11-27','2000-11-30'],\n", "'1992':['1992-10-28','1996-11-22'],\n", "'1990':['1990-06-19','1992-10-16']}" ] }, { "cell_type": "code", "execution_count": 246, "metadata": {}, "outputs": [], "source": [ "import altair as alt" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Members" ] }, { "cell_type": "code", "execution_count": 247, "metadata": {}, "outputs": [], "source": [ "szen=['🔼 Szenátus','🔽 Képviselőház']\n", "szen2=['Senat','Camera Deputaților']" ] }, { "cell_type": "code", "execution_count": 248, "metadata": {}, "outputs": [], "source": [ "istart=legs['1990'][0]\n", "iend=legs['2016'][1]" ] }, { "cell_type": "code", "execution_count": 249, "metadata": {}, "outputs": [], "source": [ "ro_months={'ian.':'Jan',\n", " ' ia ':' Jan ',\n", " 'feb.':'Feb',\n", " 'mar.':'Mar',\n", " 'apr.':'Apr',\n", " 'mai':'May',\n", " 'iun.':'Jun',\n", " ' iu ':' Jun ',\n", " 'iul.':'Jul',\n", " 'aug.':'Aug',\n", " 'sep.':'Sep',\n", " 'oct.':'Oct',\n", " 'noi.':'Nov',\n", " 'dec.':'Dec',\n", " 'ianuarie':'Jan',\n", " 'februarie':'Feb',\n", " 'martie':'Mar',\n", " 'aprilie':'Apr',\n", " 'mai':'May',\n", " 'iunie':'Jun',\n", " 'iulie':'Jul',\n", " 'august':'Aug',\n", " 'septembrie':'Sep',\n", " 'octombrie':'Oct',\n", " 'noiembrie':'Nov',\n", " 'decembrie':'Dec'}\n", "def date_ro(d,s=True):\n", " if 'prezent' in d:\n", " t=pd.to_datetime(legs['2016'][1])\n", " else:\n", " ds=d.split(' ')\n", " x=ds[1].replace('0201','2001').replace('0092','1992')\n", " t=pd.to_datetime(ro_months[ds[0].strip()]+' '+x)\n", " if s: return str(t)[:10]\n", " else: return t" ] }, { "cell_type": "code", "execution_count": 250, "metadata": {}, "outputs": [], "source": [ "def replace_all(text, dic):\n", " for i in dic:\n", " text = text.replace(i, dic[i])\n", " return text" ] }, { "cell_type": "code", "execution_count": 251, "metadata": {}, "outputs": [], "source": [ "m=nmembers['Antonescu George Crin Laurentiu | 1959-09-21']\n", "data=[]\n", "for p in m['Parties']:\n", " start=pd.to_datetime(p['start'])\n", " end=pd.to_datetime(p['end']) \n", " d={}\n", " d['Name']=m['Name']['full']\n", " d['Csoportok']=p['party']\n", " d['Típus']='Párt'\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", " d=dict(d)\n", " d['Csoportok']=p['judet']\n", " d['Típus']='Megye'\n", " data.append(d)\n", "for p in m['Countries']:\n", " start=pd.to_datetime(p['start'])\n", " end=pd.to_datetime(p['end']) \n", " d={}\n", " d['Name']=m['Name']['full']\n", " d['Csoportok']=p['country']\n", " d['Típus']='Ország'\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", "for p in m['Groups']:\n", " start=pd.to_datetime(p['start'])\n", " end=pd.to_datetime(p['end']) \n", " d={}\n", " d['Name']=m['Name']['full']\n", " d['Csoportok']=p['group'].replace('Comisia pentru','').replace('Comisia','').strip().capitalize()\n", " d['Típus']='Bizottság'\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", "for pi,p in enumerate(m['Link']):\n", " start=pd.to_datetime(legs[p[-10:-6]][0])\n", " end=pd.to_datetime(legs[p[-10:-6]][1]) \n", " d={}\n", " d['Name']=m['Name']['full']\n", " d['Típus']='Kamara'\n", " kamara=m['Camera'][pi]\n", " pres=''\n", " if '#' in kamara:\n", " pres='#'+kamara.split('#')[1]+'#'\n", " if ('din ') in kamara:\n", " b=dict(d)\n", " b['Csoportok']=szen2[int(p[-1])-1]\n", " b['start']=start\n", " start=max(start,date_ro(kamara[kamara.find('din ')+4:].strip(),False))\n", " b['end']=start\n", " b['duration']=pd.to_timedelta(end-start).days\n", " data.append(b)\n", " if ('până în ') in kamara:\n", " b=dict(d)\n", " b['Csoportok']=szen2[int(p[-1])-1]\n", " b['end']=end\n", " end=min(end,date_ro(kamara[kamara.find('până în ')+8:].strip(),False))\n", " b['start']=end\n", " b['duration']=pd.to_timedelta(end-start).days\n", " data.append(b)\n", " d['Csoportok']=pres+szen2[int(p[-1])-1]\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", "ef=pd.DataFrame(data)\n", "eord=ef.groupby('Típus').sum()\n", "eord['duration']=[1,60,30,4,50]\n", "eord.columns=['order']\n", "ef=ef.set_index('Típus').join(eord).reset_index()" ] }, { "cell_type": "code", "execution_count": 252, "metadata": {}, "outputs": [ { "data": { "application/vnd.vegalite.v3+json": { "$schema": "https://vega.github.io/schema/vega-lite/v3.3.0.json", "config": { "mark": { "tooltip": null }, "view": { "height": 300, "width": 400 } }, "data": { "name": "data-13b163f6587657af30e50b4f3ace1274" }, "datasets": { "data-13b163f6587657af30e50b4f3ace1274": [ { "Csoportok": "#pres##bp#1", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 212, "end": "2014-09-01T00:00:00", "order": 1, "start": "2014-02-01T00:00:00" }, { "Csoportok": "#pres##bp#1", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 153, "end": "2014-02-01T00:00:00", "order": 1, "start": "2013-09-01T00:00:00" }, { "Csoportok": "#pres##bp#1", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 212, "end": "2013-09-01T00:00:00", "order": 1, "start": "2013-02-01T00:00:00" }, { "Csoportok": "#pres##bp#1", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 43, "end": "2013-02-01T00:00:00", "order": 1, "start": "2012-12-20T00:00:00" }, { "Csoportok": "Politică externă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 1025, "end": "2016-12-20T00:00:00", "order": 1, "start": "2014-03-01T00:00:00" }, { "Csoportok": "#pres##spec# comună a camerei deputaţilor şi senatului pentru elaborarea propunerii legislative de revizuire a constituţiei româniei", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 801, "end": "2015-03-01T00:00:00", "order": 1, "start": "2012-12-20T00:00:00" }, { "Csoportok": "Învăţământ, ştiinţă, tineret şi sport", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 1486, "end": "1996-11-22T00:00:00", "order": 1, "start": "1992-10-28T00:00:00" }, { "Csoportok": "Politică externă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 316, "end": "2008-12-13T00:00:00", "order": 1, "start": "2008-02-01T00:00:00" }, { "Csoportok": "Cultură, arte, mijloace de informare în masă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 1, "start": "2004-12-17T00:00:00" }, { "Csoportok": "Politică externă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 776, "end": "2007-02-01T00:00:00", "order": 1, "start": "2004-12-17T00:00:00" }, { "Csoportok": "#pres##anch# comună de anchetă ca urmare a propunerii de suspendare din funcţie a preşedintelui româniei", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 1, "start": "2004-12-17T00:00:00" }, { "Csoportok": "Învăţământ, ştiinţă, tineret şi sport", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 1446, "end": "2004-11-30T00:00:00", "order": 1, "start": "2000-12-15T00:00:00" }, { "Csoportok": "#pres##bp#1", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 62, "end": "2012-09-01T00:00:00", "order": 1, "start": "2012-07-01T00:00:00" }, { "Csoportok": "#vp##bp#1", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 212, "end": "2009-09-01T00:00:00", "order": 1, "start": "2009-02-01T00:00:00" }, { "Csoportok": "#vp##bp#1", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 44, "end": "2009-02-01T00:00:00", "order": 1, "start": "2008-12-19T00:00:00" }, { "Csoportok": "Politică externă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 1461, "end": "2012-12-19T00:00:00", "order": 1, "start": "2008-12-19T00:00:00" }, { "Csoportok": "Permanentă a camerei deputaţilor şi senatului privind statutul deputaţilor şi al senatorilor, organizarea şi funcţionarea şedinţelor comune ale camerei deputaţilor şi senatulu", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 164, "end": "2009-06-01T00:00:00", "order": 1, "start": "2008-12-19T00:00:00" }, { "Csoportok": "Politică externă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Bizottság", "duration": 1464, "end": "2000-11-30T00:00:00", "order": 1, "start": "1996-11-27T00:00:00" }, { "Csoportok": "Senat", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 436, "end": "2016-12-20T00:00:00", "order": 60, "start": "2014-03-01T00:00:00" }, { "Csoportok": "#PRES#Senat", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 436, "end": "2014-03-01T00:00:00", "order": 60, "start": "2012-12-20T00:00:00" }, { "Csoportok": "Camera Deputaților", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 1486, "end": "1996-11-22T00:00:00", "order": 60, "start": "1992-10-28T00:00:00" }, { "Csoportok": "Camera Deputaților", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 1455, "end": "2008-12-13T00:00:00", "order": 60, "start": "2004-12-19T00:00:00" }, { "Csoportok": "Camera Deputaților", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 1446, "end": "2004-11-30T00:00:00", "order": 60, "start": "2000-12-15T00:00:00" }, { "Csoportok": "Senat", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 171, "end": "2012-07-01T00:00:00", "order": 60, "start": "2008-12-19T00:00:00" }, { "Csoportok": "#PRES#Senat", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 171, "end": "2012-12-19T00:00:00", "order": 60, "start": "2012-07-01T00:00:00" }, { "Csoportok": "Camera Deputaților", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Kamara", "duration": 1464, "end": "2000-11-30T00:00:00", "order": 60, "start": "1996-11-27T00:00:00" }, { "Csoportok": "TELEORMAN", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1461, "end": "2016-12-20T00:00:00", "order": 30, "start": "2012-12-20T00:00:00" }, { "Csoportok": "TELEORMAN", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1461, "end": "2016-12-20T00:00:00", "order": 30, "start": "2012-12-20T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 246, "end": "1993-07-01T00:00:00", "order": 30, "start": "1992-10-28T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 608, "end": "1995-03-01T00:00:00", "order": 30, "start": "1993-07-01T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 632, "end": "1996-11-22T00:00:00", "order": 30, "start": "1995-03-01T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 638, "end": "1995-03-01T00:00:00", "order": 30, "start": "1993-06-01T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 632, "end": "1996-11-22T00:00:00", "order": 30, "start": "1995-03-01T00:00:00" }, { "Csoportok": "BUCUREŞTI", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 30, "start": "2004-12-17T00:00:00" }, { "Csoportok": "BUCUREŞTI", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 30, "start": "2004-12-17T00:00:00" }, { "Csoportok": "BUCUREŞTI", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1199, "end": "2008-12-13T00:00:00", "order": 30, "start": "2005-09-01T00:00:00" }, { "Csoportok": "TELEORMAN", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1446, "end": "2004-11-30T00:00:00", "order": 30, "start": "2000-12-15T00:00:00" }, { "Csoportok": "TELEORMAN", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1446, "end": "2004-11-30T00:00:00", "order": 30, "start": "2000-12-15T00:00:00" }, { "Csoportok": "TELEORMAN", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 821, "end": "2004-11-30T00:00:00", "order": 30, "start": "2002-09-01T00:00:00" }, { "Csoportok": "BUCUREŞTI", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1461, "end": "2012-12-19T00:00:00", "order": 30, "start": "2008-12-19T00:00:00" }, { "Csoportok": "BUCUREŞTI", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1461, "end": "2012-12-19T00:00:00", "order": 30, "start": "2008-12-19T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1464, "end": "2000-11-30T00:00:00", "order": 30, "start": "1996-11-27T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 1464, "end": "2000-11-30T00:00:00", "order": 30, "start": "1996-11-27T00:00:00" }, { "Csoportok": "TULCEA", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Megye", "duration": 278, "end": "1997-09-01T00:00:00", "order": 30, "start": "1996-11-27T00:00:00" }, { "Csoportok": "Grupul parlamentar de prietenie cu Republica Franceză - Senat", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 4, "start": "2004-12-17T00:00:00" }, { "Csoportok": "Grupul parlamentar de prietenie cu Republica Franceză - Adunarea Naţională", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 4, "start": "2004-12-17T00:00:00" }, { "Csoportok": "#SECR#Grupul parlamentar de prietenie cu Republica Slovacă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 1446, "end": "2004-11-30T00:00:00", "order": 4, "start": "2000-12-15T00:00:00" }, { "Csoportok": "Grupul parlamentar de prietenie cu Republica Malta", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 1024, "end": "2012-12-19T00:00:00", "order": 4, "start": "2010-03-01T00:00:00" }, { "Csoportok": "Grupul parlamentar de prietenie cu Republica Africa de Sud", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 1024, "end": "2012-12-19T00:00:00", "order": 4, "start": "2010-03-01T00:00:00" }, { "Csoportok": "#PRES#Grupul parlamentar de prietenie cu Federaţia Rusă", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 485, "end": "1998-06-01T00:00:00", "order": 4, "start": "1997-02-01T00:00:00" }, { "Csoportok": "Grupul parlamentar de prietenie cu Republica Italiană", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 1398, "end": "2000-11-30T00:00:00", "order": 4, "start": "1997-02-01T00:00:00" }, { "Csoportok": "#PRES#Grupul parlamentar de prietenie cu Malaezia", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Ország", "duration": 913, "end": "2000-11-30T00:00:00", "order": 4, "start": "1998-06-01T00:00:00" }, { "Csoportok": "PNL", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1461, "end": "2016-12-20T00:00:00", "order": 50, "start": "2012-12-20T00:00:00" }, { "Csoportok": "#GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1461, "end": "2016-12-20T00:00:00", "order": 50, "start": "2012-12-20T00:00:00" }, { "Csoportok": "PAC", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 246, "end": "1993-07-01T00:00:00", "order": 50, "start": "1992-10-28T00:00:00" }, { "Csoportok": "PL'93", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 608, "end": "1995-03-01T00:00:00", "order": 50, "start": "1993-07-01T00:00:00" }, { "Csoportok": "Independent", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 632, "end": "1996-11-22T00:00:00", "order": 50, "start": "1995-03-01T00:00:00" }, { "Csoportok": "#GRUP#Grupul parlamentaral Partidului Liberal 1993 si al Partidului Aliantei Civice", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 638, "end": "1995-03-01T00:00:00", "order": 50, "start": "1993-06-01T00:00:00" }, { "Csoportok": "#GRUP#Grupul parlamentart neafiliat", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 632, "end": "1996-11-22T00:00:00", "order": 50, "start": "1995-03-01T00:00:00" }, { "Csoportok": "PNL", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 50, "start": "2004-12-17T00:00:00" }, { "Csoportok": "#GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1457, "end": "2008-12-13T00:00:00", "order": 50, "start": "2004-12-17T00:00:00" }, { "Csoportok": "#PRES##GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1199, "end": "2008-12-13T00:00:00", "order": 50, "start": "2005-09-01T00:00:00" }, { "Csoportok": "PNL", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1446, "end": "2004-11-30T00:00:00", "order": 50, "start": "2000-12-15T00:00:00" }, { "Csoportok": "#GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1446, "end": "2004-11-30T00:00:00", "order": 50, "start": "2000-12-15T00:00:00" }, { "Csoportok": "#PRES##GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 821, "end": "2004-11-30T00:00:00", "order": 50, "start": "2002-09-01T00:00:00" }, { "Csoportok": "PNL", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1461, "end": "2012-12-19T00:00:00", "order": 50, "start": "2008-12-19T00:00:00" }, { "Csoportok": "#GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1461, "end": "2012-12-19T00:00:00", "order": 50, "start": "2008-12-19T00:00:00" }, { "Csoportok": "PNL", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1464, "end": "2000-11-30T00:00:00", "order": 50, "start": "1996-11-27T00:00:00" }, { "Csoportok": "#GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 1464, "end": "2000-11-30T00:00:00", "order": 50, "start": "1996-11-27T00:00:00" }, { "Csoportok": "#PRES##GRUP#Grupul parlamentaral Partidului Naţional Liberal", "Name": "George Crin Laurenţiu ANTONESCU", "Típus": "Párt", "duration": 278, "end": "1997-09-01T00:00:00", "order": 50, "start": "1996-11-27T00:00:00" } ] }, "encoding": { "color": { "field": "Típus", "sort": { "field": "order", "op": "mean", "order": "descending" }, "type": "nominal" }, "x": { "field": "start", "title": "", "type": "temporal" }, "x2": { "field": "end" }, "y": { "field": "Csoportok", "sort": { "field": "order", "op": "mean", "order": "descending" }, "title": "", "type": "nominal" } }, "mark": "bar", "title": "George Crin Laurenţiu ANTONESCU" }, "text/plain": [ "\n", "\n", "If you see this message, it means the renderer has not been properly enabled\n", "for the frontend that you are using. For more information, see\n", "https://altair-viz.github.io/user_guide/troubleshooting.html\n" ] }, "execution_count": 252, "metadata": {}, "output_type": "execute_result" } ], "source": [ "alt.Chart(ef,\n", " title=m['Name']['full']\n", " ).mark_bar().encode(\n", " x=alt.X('start:T',title=''),\n", " x2='end:T',\n", " y=alt.Y('Csoportok:N',title='',\n", " sort=alt.EncodingSortField(field=\"order\", op=\"mean\", order='descending')),\n", " color=alt.Color('Típus:N',\n", " sort=alt.EncodingSortField(field=\"order\", op=\"mean\", order='descending'))\n", ")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Save JSON" ] }, { "cell_type": "code", "execution_count": 253, "metadata": {}, "outputs": [], "source": [ "def party_normalizer(party):\n", " if party in ['N/A','NA','NI',['NA', 'NI'],'-','Independent','Minorități',\n", " 'Fără adeziune la formaţiunea politică pentru care a candidat la alegeri']: return '👤'\n", " elif party in ['ALDE RO','ALDE Romania','Partidul Conservator','Liberal Conservator',\n", " 'PC','Partidul Puterii Umaniste','ALDE','PUNR','PUR','PUR-SL']: return '🕊️'\n", " elif party in ['Forumul Democrat al Germanitor din România','FDGR']: return '⚫️'\n", " elif party in ['Partidul Naţional Liberal','PNL-CD',\"PL'93\",'PNL-AT','PAC','FC - Forţa Civică',\n", " 'Partidul Liberal Democrat','PNL','Partida Naţională','Naţional Liberal','Alianţei Civice']: return'📐'\n", " elif party in ['Partidul Democrat','Partidul Democrat-Liberal','Democrat','Democrat Liberal','Democrat-Liberal în feb-2008',\n", " 'Democrat-Liberal','Democrat care se transforma în','PD care se transforma în','PDL în feb-2008','Dreptate şi Adevăr PNL-PD',\n", " 'PD-L','PD','PDL']: return'🔶'\n", " elif party in ['Partidul Mișcarea Populară','PMP']: return '🍏'\n", " elif party in ['Partidul Naţional Ţaranesc Creştin Democrat','PNȚCD','PNTCD']:return '✳️'\n", " elif party in ['Partidul România Mare','PRM']:return '🔱'\n", " elif party in ['FSN','FDSN']:return '⚪️'\n", " elif party in ['USR']:return '🔷'\n", " elif party in ['PP-DD','Democrat Popular']:return '⚛️'\n", " elif party in ['PER','MER','PDAR','FER']:return '🍀'\n", " elif party in ['PSD','Partidul Social Democrat','Partidul Social Democrat + Partidul Conservator',\n", " 'PDSR','PSDR','PSM','P.S.D.','Uniunea PSDă - PSD Român',\n", " 'democrat-agrar şi social-democrat',\n", " 'ecologist şi social-democrat',\n", " 'social-democrat al PSD Român']:return '🌹'\n", " elif party in ['Romániai Magyar Demokrata Szövetség',\n", " 'Uniunea Democrată Maghiară din România','RMDSZ','UDMR']:return '🌷'\n", " elif party in ['PRO Europa']: return '🧑'\n", " elif party in ['Uniunea Națională pentru Progresul României','UNPR']: return '🦅'\n", " else: \n", " return '🔘'" ] }, { "cell_type": "code", "execution_count": 254, "metadata": {}, "outputs": [], "source": [ "def group_party_normalizer(party):\n", " party0=party[:party.rfind('#')+1]\n", " party=party[party.rfind('#')+1:]\n", " party=replace_all(party,{'Grupul parlamentaral ':'',\n", " 'rtidului':'rtidul','fost':'',\n", " 'Partidul Democrat Liberal':'PDL','Partidul Democrat-Liberal':'PDL',\n", " 'Partidul Democrat-liberal':'PDL'}).strip()\n", " party=replace_all(party,{'Grupul parlamentar':'','Partidul Democrat':'PD',\n", " 'Partidul':'','Liberal Conservator':'PC',\n", " }).strip()\n", " if '(' in party:\n", " party=party.split('(')[0].strip()\n", " group_party_dict={'\"Partida Naţională\"':'Partida Naţională',\n", " 'Frontului Salvării Naţionale':'FSN',\n", " 'P.S.D.':'PSD','Conservator':'PC',\n", " 'Democraţiei Sociale din România':'PSD',\n", " 'PD care se transforma în':'PD',\n", " 'PDL în feb-2008':'PDL',\n", " 'Liberal 1993 si al Aliantei Civice':'Alianţei Civice',\n", " 'Naţional Creştin Democrat':'PNTCD',\n", " 'Naţional Liberal':'PNL',\n", " 'socialist':'PSD',\n", " 'Naţional Ţărănesc - creştin şi democrat':'PNTCD',\n", " 'Naţional Ţărănesc Creştin Democrat Civic-Ecologist':'PNTCD',\n", " 'Naţional Ţărănesc Creştin Democrat şi al Ecologist Român':'PNTCD',\n", " 'ţi neafiliaţi':'Independent',\n", " 'Uniunii Democrate Maghiare din România':'RMDSZ',\n", " 'Poporului - Dan Diaconescu':'PP-DD',\n", " 'România Mare':'PRM',\n", " 'Social Democrat':'PSD',\n", " 'Uniunea PSDă - PD':'PSD',\n", " 'Umanist din România':'PUR',\n", " 't neafiliat':'Independent',\n", " 'neafiliat':'Independent',\n", " 'minorităţilor naţionale':'Minorități',\n", " 'Uniunii Naţionale pentru Progresul României':'UNPR',\n", " 'Alianţei Civice':'PAC',\n", " 'de orientare civic-liberală':'PAC',\n", " 'Uniunii Salvaţi România':'USR',\n", " 'Partida Naţională':'PNL',\n", " 'Mişcarea Populară':'PMP',\n", " 'PD Agrar din România':'PDAR',\n", " 'PD în feb-2008':'PD',\n", " 'Unităţii Naţionale Române':'PUNR',\n", " 'Unităţii Naţionale a Românilor':'PUNR',\n", " 'deputaţilor independenţi':'Independent',\n", " 'i neafiliaţi':'Independent',\n", " 'naţional democrat':'PNTCD',\n", " 'progresist':'PC',\n", " 'Democrat Popular':'PP-DD',\n", " 'Dreptate şi Adevăr PNL-PD':'PDL',\n", " 'Uniunea PSDă - PSD Român':'PSD',\n", " 'democrat-agrar şi social-democrat':'PSD',\n", " 'ecologist şi social-democrat':'PSD',\n", " 'social-democrat al PSD Român':'PSD'\n", " }\n", " party=party_normalizer(replace_all(party,\n", " group_party_dict))+' '+\\\n", " replace_all(party,group_party_dict)\n", " return party0+party" ] }, { "cell_type": "code", "execution_count": 255, "metadata": {}, "outputs": [], "source": [ "def party_writer(party):\n", " if party in ['Romániai Magyar Demokrata Szövetség',\n", " 'Uniunea Democrată Maghiară din România','RMDSZ','UDMR']:return 'RMDSZ'\n", " elif party in ['Uniunea PSDă - PSD Român',\n", " 'democrat-agrar şi social-democrat',\n", " 'ecologist şi social-democrat',\n", " 'social-democrat al PSD Român']:\n", " return 'PSD'\n", " elif party in ['Fără adeziune la formaţiunea politică pentru care a candidat la alegeri']:\n", " return 'Independent'\n", " else: \n", " return party" ] }, { "cell_type": "code", "execution_count": 256, "metadata": {}, "outputs": [], "source": [ "# megyek=json.loads(open('E:/Skydrive/Github/universal/ro/hun_megyek.json','r').read())\n", "megyek=json.loads(open('C:/users/csala/Onedrive/Github/universal/ro/hun_megyek.json','r').read())\n", "megyek['La nivel national']='Országos'" ] }, { "cell_type": "code", "execution_count": 257, "metadata": {}, "outputs": [], "source": [ "def extender(r,n=5):\n", " p={}\n", " for i in r:\n", " for j in range(n):\n", " p[i+j*' ']=r[i]+j*' '\n", " return p" ] }, { "cell_type": "code", "execution_count": 258, "metadata": {}, "outputs": [], "source": [ "cc={\"\":\"uu\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/africadesud.gif\":\"za\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/albania.gif\":\"al\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/algeria.gif\":\"dz\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/arabiasaudi.gif\":\"sa\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/argentina.gif\":\"ar\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/armenia.gif\":\"am\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/australia.gif\":\"au\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/austria.gif\":\"at\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/azerbaidjan.gif\":\"az\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/bahrein.gif\":\"bh\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/belarus.gif\":\"by\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/belgia.gif\":\"be\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/bolivia.gif\":\"bo\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/bosnia.gif\":\"ba\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/brazilia.gif\":\"br\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/bulgaria.gif\":\"bg\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/canada.gif\":\"ca\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/cehia.gif\":\"cz\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/chile.gif\":\"cl\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/china.gif\":\"cn\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/cipru.gif\":\"cy\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/columbia.gif\":\"co\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/congo.gif\":\"cg\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/coreea.gif\":\"kr\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/costarica.gif\":\"cr\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/cotedivoir.gif\":\"ci\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/croatia.gif\":\"hr\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/cuba.gif\":\"cu\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/danemarca.gif\":\"dk\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/ecuador.gif\":\"ec\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/egipt.gif\":\"eg\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/elvetia.gif\":\"ch\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/emirate.png\":\"ae\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/estonia.gif\":\"ee\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/filipine.gif\":\"ph\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/finlanda.gif\":\"fi\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/franta.gif\":\"fr\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/georgia.gif\":\"ge\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/germania.gif\":\"de\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/grecia.gif\":\"gr\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/guineea.gif\":\"gn\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/india.gif\":\"in\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/indonezia.gif\":\"id\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/iordania.gif\":\"jo\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/irak.gif\":\"iq\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/iran.gif\":\"ir\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/irlanda.gif\":\"ie\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/islanda.gif\":\"is\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/israel.gif\":\"il\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/italia.gif\":\"it\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/iugoslavia.gif\":\"uu\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/japonia.gif\":\"jp\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/kazahtan.gif\":\"kz\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/kuwait.gif\":\"kw\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/letonia.gif\":\"lv\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/liban.gif\":\"lb\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/lituania.gif\":\"lt\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/luxemburg.gif\":\"lu\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/macedonia.gif\":\"mk\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/malaezia.gif\":\"my\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/malta.gif\":\"mt\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/mareabritanie.gif\":\"gb\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/maroc.gif\":\"ma\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/mexic.gif\":\"mx\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/mongolia.gif\":\"mn\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/muntenegru.gif\":\"me\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/norvegia.gif\":\"no\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/olanda.gif\":\"nl\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/oman.gif\":\"om\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/pakistan.gif\":\"pk\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/panama.gif\":\"pa\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/peru.gif\":\"pe\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/polonia.gif\":\"pl\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/portugalia.gif\":\"pt\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/qatar.gif\":\"qa\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/rusia.gif\":\"ru\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/senegal.gif\":\"sn\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/singapore.gif\":\"sg\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/siria.gif\":\"sy\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/slovacia.gif\":\"sk\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/slovenia.gif\":\"si\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/spania.gif\":\"es\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/srilanka.gif\":\"lk\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/sudan.gif\":\"sd\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/suedia.gif\":\"se\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/thailanda.gif\":\"th\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/tunisia.gif\":\"tn\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/turcia.gif\":\"tr\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/turkmenistan.gif\":\"tm\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/ucraina.gif\":\"ua\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/ungaria.gif\":\"hu\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/urss.gif\":\"uu\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/usa.png\":\"us\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/uruguay.gif\":\"uy\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/venezuela.gif\":\"ve\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/vietnam.gif\":\"vn\",\n", "\"/camera_deputatilor/grupuri_prietenie/flags1/zambia.gif\":\"zm\"}" ] }, { "cell_type": "code", "execution_count": 259, "metadata": {}, "outputs": [], "source": [ "cr={'Delegaţia Parlamentului României la Adunarea Parlamentară a Francofoniei':'Frankofónia',\n", " 'Grupul parlamentar de prietenie cu UNESCO':'🇺🇳 UNESCO',\n", " 'Grupul parlamentar de prietenie cu Republica Franceză - Adunarea Naţională':'🇫🇷 Franciaország',\n", " 'Grupul parlamentar de prietenie cu Republica Franceză - Senat':'🇫🇷 Franciaország',\n", " 'Grupul parlamentar de prietenie cu Republica Serbia':'🇷🇸 Szerbia',\n", " 'Delegaţia Camerei Deputaţilor la Adunarea Interparlamentară a Ortodoxiei':'Ortodoxia',\n", " 'Delegaţia Parlamentului României la Adunarea Parlamentară a Consiliului Europei':'Európa Tanács',\n", " 'Delegaţia Parlamentului României la Adunarea Parlamentară a Cooperării Economice a Mării Negre':'Fekete tenger',\n", " 'Delegaţia Parlamentului României la Adunarea Parlamentară a Mediteranei':'Földközi tenger',\n", " 'Delegaţia Parlamentului României la Adunarea Parlamentară a NATO':'NATO',\n", " 'Delegaţia Parlamentului României la Adunarea Parlamentară a OSCE':'OSCE',\n", " 'Delegaţia Parlamentului României la Adunarea Parlamentară a Uniunii pentru Mediterana':'Földközi tenger',\n", " 'Delegaţia Parlamentului României la Adunarea Uniunii Europei Occidentale':'Kelet-Európa',\n", " 'Delegaţia Parlamentului României la Iniţiativa Central-Europeană - Dimensiunea Parlamentară':'Közép-Európa',\n", " 'Delegaţia permanentă a Parlamentului României la Adunarea Parlamentară a Procesului de Cooperare din Europa de Sud-Est':'Délkelet-Európa',\n", "'Grupul mixt de control parlamentar specializat al Europol':'Europol',\n", " 'Comisia Interparlamentară Bucureşti - Chişinău (partea română)':'🇲🇩 Moldova'}" ] }, { "cell_type": "code", "execution_count": 260, "metadata": {}, "outputs": [], "source": [ "#!pip install pycountry\n", "import pycountry\n", "import gettext\n", "#!pip install emoji-country-flag\n", "import flag\n", "hun = gettext.translation('iso3166', pycountry.LOCALES_DIR,\n", " languages=['hu'])\n", "hun.install()" ] }, { "cell_type": "code", "execution_count": 261, "metadata": {}, "outputs": [], "source": [ "def local_country(c):\n", " if c=='uu': return ''\n", " z=_(pycountry.countries.get(alpha_2=c.upper()).name)\n", " #manual overrides\n", " if z=='Koreai Köztársaság':z='Dél-Korea'\n", " if z=='Nagy-Britannia (Egyesült Királyság)':z='Egyesült Királyság'\n", " if z=='Macedón Köztársaság':z='Macedónia'\n", " if z=='Szíriai Arab Köztársaság':z='Szíria'\n", " if z=='Venezuelai Bolivári Köztársaság':z='Venezuela'\n", " if z=='Orosz Föderáció':z='Oroszország'\n", " g=flag.flagize(':'+c.upper()+':')\n", " return g+' '+z" ] }, { "cell_type": "code", "execution_count": 262, "metadata": {}, "outputs": [], "source": [ "def tolerance_cleaner(ef,dt=30):\n", " hfs=[]\n", " df=ef.sort_values('start').groupby(['Típus','Csoportok','start','end']).first()\n", " df=df.reset_index(level=[2,3], drop=False)\n", " for p in df.index.get_level_values(0).unique():\n", " for r in df.loc[p].index.get_level_values(0).unique():\n", " hf=df.loc[p].loc[[r]].sort_values('start')\n", " hf['dt']=list((hf[1:]['start']-hf['end'][:-1]).dt.days.values)+[0]\n", " hf=hf.reset_index(drop=False)\n", " new_column=[]\n", " counters={i:0 for i in hf['Csoportok'].unique()}\n", " for i in hf.index:\n", " j=hf.loc[i]['Csoportok']\n", " new_column.append(j+counters[j]*' ')\n", " if hf.loc[i]['dt']>dt:\n", " counters[j]+=1\n", " hf['Csoportok1']=new_column\n", " hf['Típus']=p\n", " hf=hf.drop(['dt'],axis=1)\n", " hfs.append(hf)\n", " hfs=pd.concat(hfs)\n", " hfs=hfs.reset_index(drop=True)\n", " return(hfs)" ] }, { "cell_type": "code", "execution_count": 263, "metadata": {}, "outputs": [], "source": [ "pres_all={'#VP#':'','#PRES#':'','#SECR#':'','#TRES#':'','#SEF#':'','#CHES#':''}" ] }, { "cell_type": "code", "execution_count": 279, "metadata": {}, "outputs": [], "source": [ "medals={'#INTER#':'🇺🇳 ','#inter#':'🇺🇳 ','#GRUP#':'🎴 ','#BP#':'',\n", " '#VP#':'🥈','#PRES#':'🥇','#SECR#':'🥉','#TREZ#':'🥉','#PRCV#':'🥉','#SEF#':'🏅','#CHES#':'🏅','#SPEC#':'🚩','#ANCH#':'🏳️',\n", " '#vp#':'🥈','#pres#':'🥇','#secr#':'🥉','#trez#':'🥉','#prcv#':'🥉','#sef#':'🏅','#ches#':'🏅','#spec#':'🚩','#anch#':'🏳️',\n", " }\n", "medals_none={i:'' for i in medals}" ] }, { "cell_type": "code", "execution_count": 280, "metadata": {}, "outputs": [], "source": [ "biz_common={'comisia':'','a camerei deputaţilor şi senatului':'',\n", " 'permanentă':'', 'comună':'', 'specială':'',\n", " 'privind':'','pentru':'','de anchetă':'','parlamentară':'',\n", " ' ':' ',' ':' ',' ':' ',' ':' ',' ':' ',' ':' '}" ] }, { "cell_type": "code", "execution_count": 281, "metadata": {}, "outputs": [], "source": [ "biz_flags={\"Biztonság\":\"🛃\",\n", "\"Egészségügy\":\"♿️\",\n", "\"Emberi jogok, kisebbségek\":\"🚹\",\n", "\"Európa\":\"⏺️\",\n", "\"Parlament\":\"🅿️\",\n", "\"Gazdaság, ipar\":\"⏫\",\n", "\"Infrastruktúra, energia, kommunikáció\":\"➿\",\n", "\"Közigazgatás, környezetvédelem\":\"🔄\",\n", "\"Külpolitika, diaszpóra\":\"🌐\",\n", "\"Mezőgazdaság, erdők, altalajkincsek\":\"🚰\",\n", "\"Munka, szociális és családi ügyek\":\"🚻\",\n", "\"Művészet, média\":\"🎦\",\n", "\"Oktatás, tudomány, sport\":\"🔠\",\n", "\"Pénzügy\":\"🔢\",\n", "\"Állambiztonság\":\"🛂\",\n", "'Más':'⏹️',\n", "\"Állami ügyek\":\"🔀\",\n", "'Költségvetés':'💹',\n", "'Választások':'✅'}" ] }, { "cell_type": "code", "execution_count": 282, "metadata": {}, "outputs": [], "source": [ "def biz_cleaner(biz):\n", " csop=replace_all(biz.strip(),medals_none).lower()\n", " csop=replace_all(csop,biz_common).strip()\n", " #medal=replace_all(biz[:biz.rfind('#')+1],medals)\n", " medal=biz[:biz.rfind('#')+1]\n", " abbr_in={'Művészet, média':['televiziun','mijloace de informare în mas'],\n", " 'Pénzügy':['finan','bănci'],\n", " 'Költségvetés':['curţii de contur','buget','fost cheltuite sumele','sumele din fondul constituit în cotă'],\n", " 'Állami ügyek':['decembrie 198','corupţ','legii privatizări','suspendare din funcţie a preşedintelui',\n", " 'centenarului','marii uniri','constituţie','funcţionarea partidelor politic',\n", " 'privatizare','cod civil','cod penal','funcţionarea justiţiei','abuzurilor şi petiţii',\n", " 'privatizată','valea jiului','codului penal','codului administrati','decoraţii',\n", " '13-15 iunie 199','nicolae ceauşesc','domeniul justiţie'],\n", " 'Mezőgazdaság, erdők, altalajkincsek':['exploatării minereu','agricultură','forestier','irigaţi'],\n", " 'Parlament':['alegerea camerei deputa','adunării deputaţilo','de validar','disciplină','imunităţi',\n", " 'regulamentului camerei deputa','regulamentului senatulu','statutul deputatului şi senatorulu',\n", " 'regulamentului şedinţelor comune','regulament','alegerea membrilor parlamentului',\n", " ' ale camerei deputaţilor şi senatulu'],\n", " 'Állambiztonság':['serviciului de protecție și pază','siguranţă naţional',\n", " 'serviciului de informaţii exter','activităţii sr','centre de detenţie ale cia',\n", " 'securităţii naţional','interceptarea comunicaţiilor','securitatea naţional'],\n", " 'Európa':['europen','schenge','europea'],\n", " \"Közigazgatás, környezetvédelem\":[\"urbanis\",'menajarea teritoriulu','administraţie public','mediu',\n", " 'cadastru'],\n", " 'Infrastruktúra, energia, kommunikáció':['energ',' tarom','tehnologia informaţiei'\n", " 'comunicaţiilor','transporturi','infrastructură',\n", " 'informaţiei şi comunicaţiilor'],\n", " \"Emberi jogok, kisebbségek\":[\"minorităţ\",'demnitate uman','egalitate','antidiscriminare',\n", " 'drepturile fundamentale ale omului','minoritatea','minorități','romi',\n", " 'persoanelor private de libertate','oportunităţi egale',\n", " 'drepturilor persoanelor'],\n", " \"Munka, szociális és családi ügyek\":['problemelor economice, sociale','muncă','familie',\n", " 'protecţie socială','protecţia copilului'],\n", " 'Más':['cazul «parcul bordei','verificarea ','ice dunăre'],\n", " \"Külpolitika, diaszpóra\":['din afara graniţelor','politică extern',\n", " 'românii de pretutindeni','românilor de pretutindeni'],\n", " \"Gazdaság, ipar\":['economică','industrie şi servici','industrii şi servicii','ministerului economiei',\n", " 'pieţei de capital'],\n", " \"Oktatás, tudomány, sport\":['învăţământ', 'ştiinţă', 'tineret', 'sport','spaţiu'],\n", " \"Egészségügy\":['sănătate'],\n", " 'Választások':['alegerilor','electoral'],\n", " \"Biztonság\":['ordinii publice']\n", " } \n", "\n", " for a in abbr_in:\n", " for b in abbr_in[a]:\n", " if b in csop: return medal+biz_flags[a]+' '+a\n", " \n", " a='Más'\n", "# return medal+biz_flags[a]+' '+a\n", " return csop" ] }, { "cell_type": "code", "execution_count": 283, "metadata": {}, "outputs": [], "source": [ "# nmembers['Popescu-Tariceanu Calin Constantin Anton | 1952-01-14']" ] }, { "cell_type": "code", "execution_count": 291, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "0.0 %\n" ] } ], "source": [ "efs=[]\n", "# for ni,n in enumerate(nmembers):\n", "for ni,n in enumerate(['Popescu-Tariceanu Calin Constantin Anton | 1952-01-14']):\n", " if ni<5000:\n", " if ni%50==0: print(ni/len(nmembers)*100,'%')\n", " m=nmembers[n]\n", " data=[]\n", " since=m['Starts']\n", " until=m['Ends']\n", " for p in m['Parties']:\n", " start=pd.to_datetime(p['start'])\n", " end=pd.to_datetime(p['end']) \n", " d={}\n", " d['Name']=m['Name']['full']\n", " party=p['party']\n", " if '#GRUP#' in party:\n", " party=group_party_normalizer(party)\n", " else:\n", " party=party_normalizer(p['party'])+' '+party_writer(p['party'])+' - '+img['party'][party_writer(p['party'])]['name']\n", " d['Csoportok']=party\n", " d['Típus']='Párt'\n", " d['Image']=img['party'][p['party']]['img']\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", " d=dict(d)\n", " d['Csoportok']='🇷🇴 '+megyek[p['judet'].capitalize()]\n", " d['Típus']='Megye'\n", " data.append(d)\n", " for p in m['Countries']:\n", " start=pd.to_datetime(p['start'])\n", " end=pd.to_datetime(p['end']) \n", " d={}\n", " d['Name']=m['Name']['full']\n", " d['Csoportok']=p['country']\n", " d['Típus']='Ország'\n", " d['Image']=img['state'][replace_all(p['country'],pres_all)]\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", " for p in m['Groups']:\n", " start=pd.to_datetime(p['start'])\n", " end=pd.to_datetime(p['end']) \n", " d={}\n", " d['Name']=m['Name']['full']\n", " if '#BP#' not in p['group']:\n", " csop=biz_cleaner(p['group'])\n", " if 'cu unesc' in csop:\n", " d['Csoportok']='#INTER#UNESCO'\n", " d['Típus']='Ország'\n", " d['Image']=img['state']['Grupul parlamentar de prietenie cu UNESCO']\n", " elif 'și parlamentul republicii moldov' in csop:\n", " d['Csoportok']='Moldova'\n", " d['Típus']='Ország'\n", " d['Image']='md'\n", " else:\n", " d['Csoportok']=csop\n", " d['Típus']='Bizottság'\n", " else:\n", " d['Csoportok']=p['group'][:-1]+szen[int(p['group'][-1])-1]\n", " d['Típus']='Kamara'\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", "\n", " for pi,p in enumerate(m['Link']):\n", " start=pd.to_datetime(since[pi])\n", " end=pd.to_datetime(until[pi])\n", " d={}\n", " d['Name']=m['Name']['full']\n", " d['Típus']='Kamara'\n", " kamara=m['Camera'][pi]\n", " pres=''\n", "# if '#' in kamara:\n", "# pres='#'+kamara.split('#')[1]+'#'\n", "# if ('din ') in kamara:\n", "# b=dict(d)\n", "# b['Csoportok']=szen[int(p[-1])-1]\n", "# b['start']=start\n", "# start=max(start,date_ro(kamara[kamara.find('din ')+4:].strip(),False))\n", "# b['end']=start\n", "# b['duration']=pd.to_timedelta(end-start).days\n", "# data.append(b)\n", "# if ('până în ') in kamara:\n", "# b=dict(d)\n", "# b['Csoportok']=szen[int(p[-1])-1]\n", "# b['end']=end\n", "# end=min(end,date_ro(kamara[kamara.find('până în ')+8:].strip(),False))\n", "# b['start']=end\n", "# b['duration']=pd.to_timedelta(end-start).days\n", "# data.append(b)\n", " d['Csoportok']=pres+szen[int(p[-1])-1]\n", " d['start']=start\n", " d['end']=end\n", " d['duration']=pd.to_timedelta(end-start).days\n", " data.append(d)\n", "\n", " ef=pd.DataFrame(data)\n", " ef=ef.set_index('Típus').reset_index()\n", " ef['Simple']=n\n", "\n", " #pres\n", " csv=ef['Csoportok'].values\n", " ef['Medals']=[replace_all(i[:i.rfind('#')+1],medals) if '#' in i else '' for i in csv]\n", " ef['Csoportok']=[replace_all(i,medals_none) for i in csv]\n", "\n", " #countries\n", " if 'Image' in ef.columns:\n", " cz={}\n", " cs=ef[ef['Típus']=='Ország'].groupby('Image').first()['Csoportok']\n", " for i in sorted(ef[ef['Típus']=='Ország']['Image'].unique()):\n", " if i in cc:\n", " cz[cs.loc[i]]=local_country(cc[i])\n", "\n", " #manual overrides\n", " cz['Republica Macedonia']='🇲🇰 Macedónia'\n", " cz['Republica Federală Iugoslavia']='Jugoszlávia'\n", " cz['fosta Republică Iugoslavă Macedonia']='🇲🇰 Macedónia'\n", " cz['Grupul parlamentar de prietenie cu fosta Republică Iugoslavă Macedonia']='🇲🇰 Macedónia'\n", " cz['Republica Franceză - Senat']='🇫🇷 Franciaország'\n", " cz['Republica Serbia']='🇷🇸 Szerbia'\n", " cz['Republica Franceză - Adunarea Naţională']='🇫🇷 Franciaország'\n", " ef=ef.replace(cz).replace(cr)\n", "\n", " #matching\n", " ef['Csoportok9']=ef['Csoportok']\n", " ef['Csoportok']=ef['Medals']+ef['Csoportok']\n", " ef['Csoportok']=ef['Csoportok'].replace('','Más').replace('🥈','🥈 Más')\\\n", " .replace('🥇','🥇 Más').replace('🥉','🥉 Más').replace('🏅','🏅 Más')\n", "\n", " #unique counting\n", " new_column=[]\n", " counters={i:0 for i in ef['Csoportok'].unique()}\n", " for i in ef['Csoportok']:\n", " new_column.append(i+counters[i]*' ')\n", " counters[i]+=1\n", " ef['Csoportok0']=new_column\n", "\n", " #tolerance\n", " ef=tolerance_cleaner(ef).reset_index()\n", "\n", " #append\n", " efs.append(ef)" ] }, { "cell_type": "code", "execution_count": 292, "metadata": {}, "outputs": [], "source": [ "efs2=pd.concat(efs)" ] }, { "cell_type": "code", "execution_count": 293, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame.\n", "Try using .loc[row_indexer,col_indexer] = value instead\n", "\n", "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n", " This is separate from the ipykernel package so we can avoid doing imports until\n" ] } ], "source": [ "efs4=efs2[['start', 'end', 'Name', 'duration',\n", " 'Simple', 'Csoportok','Csoportok0','Csoportok1','Csoportok9','Típus','Medals']]\n", "efs4['Medals']=efs4['Medals'].replace('',' ')\n", "efs4=efs4[efs4['duration']>0]" ] }, { "cell_type": "code", "execution_count": 294, "metadata": {}, "outputs": [], "source": [ "efs4['Name']=efs4['Name'].str.replace('chestor al Camerei Deputaţilor','')\\\n", " .str.replace('vicepreşedinte al Camerei Deputaţilor','')\\\n", " .str.replace('secretar al Camerei Deputaţilor','')\\\n", " .str.replace('Preşedintele Senatului','')\\\n", " .str.replace('Preşedintele Camerei Deputaţilor','')\\\n", " .str.replace('secretar al Senatului','')\\\n", " .str.replace('chestor al Senatului','')\\\n", " .str.replace('vicepreşedinte al Senatului','')" ] }, { "cell_type": "code", "execution_count": 295, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
startendNamedurationSimpleCsoportokCsoportok0Csoportok1Csoportok9TípusMedals
01990-06-181992-10-16Călin Constantin Anton POPESCU-TĂRICEANU851Popescu-Tariceanu Calin Constantin Anton | 195...⏫ Gazdaság, ipar⏫ Gazdaság, ipar⏫ Gazdaság, ipar⏫ Gazdaság, iparBizottság
12008-12-192012-12-19Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...🌐 Külpolitika, diaszpóra🌐 Külpolitika, diaszpóra🌐 Külpolitika, diaszpóra🌐 Külpolitika, diaszpóraBizottság
22012-12-202014-03-01Călin Constantin Anton POPESCU-TĂRICEANU436Popescu-Tariceanu Calin Constantin Anton | 195...🌐 Külpolitika, diaszpóra🌐 Külpolitika, diaszpóra🌐 Külpolitika, diaszpóra🌐 Külpolitika, diaszpóraBizottság
31996-11-272000-11-30Călin Constantin Anton POPESCU-TĂRICEANU1464Popescu-Tariceanu Calin Constantin Anton | 195...🔀 Állami ügyek🔀 Állami ügyek🔀 Állami ügyek🔀 Állami ügyekBizottság
41990-06-181992-10-16Călin Constantin Anton POPESCU-TĂRICEANU851Popescu-Tariceanu Calin Constantin Anton | 195...🔠 Oktatás, tudomány, sport🔠 Oktatás, tudomány, sport🔠 Oktatás, tudomány, sport🔠 Oktatás, tudomány, sportBizottság
52015-02-012016-12-20Călin Constantin Anton POPESCU-TĂRICEANU688Popescu-Tariceanu Calin Constantin Anton | 195...🚩🔀 Állami ügyek🚩🔀 Állami ügyek🚩🔀 Állami ügyek🔀 Állami ügyekBizottság🚩
62004-12-172008-12-13Călin Constantin Anton POPESCU-TĂRICEANU1457Popescu-Tariceanu Calin Constantin Anton | 195...🚹 Emberi jogok, kisebbségek🚹 Emberi jogok, kisebbségek🚹 Emberi jogok, kisebbségek🚹 Emberi jogok, kisebbségekBizottság
72000-12-152004-11-30Călin Constantin Anton POPESCU-TĂRICEANU1446Popescu-Tariceanu Calin Constantin Anton | 195...🥈🔢 Pénzügy🥈🔢 Pénzügy🥈🔢 Pénzügy🔢 PénzügyBizottság🥈
82008-12-192012-12-19Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...🥈🚩🔀 Állami ügyek🥈🚩🔀 Állami ügyek🥈🚩🔀 Állami ügyek🔀 Állami ügyekBizottság🥈🚩
92012-12-202016-12-20Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...🔼 Szenátus🔼 Szenátus🔼 Szenátus🔼 SzenátusKamara
102016-12-212019-07-01Călin Constantin Anton POPESCU-TĂRICEANU922Popescu-Tariceanu Calin Constantin Anton | 195...🔼 Szenátus🔼 Szenátus🔼 Szenátus🔼 SzenátusKamara
111990-06-181992-10-16Călin Constantin Anton POPESCU-TĂRICEANU851Popescu-Tariceanu Calin Constantin Anton | 195...🔽 Képviselőház🔽 Képviselőház🔽 Képviselőház🔽 KépviselőházKamara
121996-11-272000-11-30Călin Constantin Anton POPESCU-TĂRICEANU1464Popescu-Tariceanu Calin Constantin Anton | 195...🔽 Képviselőház🔽 Képviselőház🔽 Képviselőház🔽 KépviselőházKamara
132000-12-152004-11-30Călin Constantin Anton POPESCU-TĂRICEANU1446Popescu-Tariceanu Calin Constantin Anton | 195...🔽 Képviselőház🔽 Képviselőház🔽 Képviselőház🔽 KépviselőházKamara
142004-12-172008-12-13Călin Constantin Anton POPESCU-TĂRICEANU1457Popescu-Tariceanu Calin Constantin Anton | 195...🔽 Képviselőház🔽 Képviselőház🔽 Képviselőház🔽 KépviselőházKamara
152008-12-192012-12-19Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...🔽 Képviselőház🔽 Képviselőház🔽 Képviselőház🔽 KépviselőházKamara
162014-03-012014-09-01Călin Constantin Anton POPESCU-TĂRICEANU184Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
172014-09-012015-02-01Călin Constantin Anton POPESCU-TĂRICEANU153Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
182015-02-012015-09-01Călin Constantin Anton POPESCU-TĂRICEANU212Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
192015-09-012016-02-01Călin Constantin Anton POPESCU-TĂRICEANU153Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
202016-02-012016-09-01Călin Constantin Anton POPESCU-TĂRICEANU213Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
212016-12-212017-02-01Călin Constantin Anton POPESCU-TĂRICEANU42Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
222017-02-012017-09-01Călin Constantin Anton POPESCU-TĂRICEANU212Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
232017-09-012018-02-01Călin Constantin Anton POPESCU-TĂRICEANU153Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
242019-02-012019-07-01Călin Constantin Anton POPESCU-TĂRICEANU150Popescu-Tariceanu Calin Constantin Anton | 195...🥇🔼 Szenátus🥇🔼 Szenátus🥇🔼 Szenátus🔼 SzenátusKamara🥇
251990-06-181992-10-16Călin Constantin Anton POPESCU-TĂRICEANU851Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Arad🇷🇴 Arad🇷🇴 Arad🇷🇴 AradMegye
261996-11-272000-11-30Călin Constantin Anton POPESCU-TĂRICEANU1464Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
272000-12-152002-02-01Călin Constantin Anton POPESCU-TĂRICEANU413Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
282000-12-152004-11-30Călin Constantin Anton POPESCU-TĂRICEANU1446Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
302004-12-172008-12-13Călin Constantin Anton POPESCU-TĂRICEANU1457Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
312012-12-202014-03-01Călin Constantin Anton POPESCU-TĂRICEANU436Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
322014-03-012014-09-01Călin Constantin Anton POPESCU-TĂRICEANU184Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
332014-03-012016-12-20Călin Constantin Anton POPESCU-TĂRICEANU1025Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
342014-09-012016-12-20Călin Constantin Anton POPESCU-TĂRICEANU841Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
352016-12-212019-07-01Călin Constantin Anton POPESCU-TĂRICEANU922Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 Bukarest🇷🇴 BukarestMegye
362008-12-192012-12-19Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...🇷🇴 Ilfov🇷🇴 Ilfov🇷🇴 Ilfov🇷🇴 IlfovMegye
371990-06-181992-10-16Călin Constantin Anton POPESCU-TĂRICEANU851Popescu-Tariceanu Calin Constantin Anton | 195...🇬🇷 Görögország🇬🇷 Görögország🇬🇷 Görögország🇬🇷 GörögországOrszág
382000-12-152004-11-30Călin Constantin Anton POPESCU-TĂRICEANU1446Popescu-Tariceanu Calin Constantin Anton | 195...🇬🇷 Görögország🇬🇷 Görögország🇬🇷 Görögország🇬🇷 GörögországOrszág
391997-02-012000-11-30Călin Constantin Anton POPESCU-TĂRICEANU1398Popescu-Tariceanu Calin Constantin Anton | 195...🇵🇭 Fülöp-szigetek🇵🇭 Fülöp-szigetek🇵🇭 Fülöp-szigetek🇵🇭 Fülöp-szigetekOrszág
402000-12-152004-11-30Călin Constantin Anton POPESCU-TĂRICEANU1446Popescu-Tariceanu Calin Constantin Anton | 195...🇵🇭 Fülöp-szigetek🇵🇭 Fülöp-szigetek🇵🇭 Fülöp-szigetek🇵🇭 Fülöp-szigetekOrszág
412012-12-202015-03-01Călin Constantin Anton POPESCU-TĂRICEANU801Popescu-Tariceanu Calin Constantin Anton | 195...🥇🇫🇷 Franciaország🥇🇫🇷 Franciaország🥇🇫🇷 Franciaország🇫🇷 FranciaországOrszág🥇
422014-03-012014-09-01Călin Constantin Anton POPESCU-TĂRICEANU184Popescu-Tariceanu Calin Constantin Anton | 195...🎴 👤 Independent🎴 👤 Independent🎴 👤 Independent👤 IndependentPárt🎴
431990-06-181992-10-16Călin Constantin Anton POPESCU-TĂRICEANU851Popescu-Tariceanu Calin Constantin Anton | 195...🎴 📐 PNL🎴 📐 PNL🎴 📐 PNL📐 PNLPárt🎴
441996-11-272000-11-30Călin Constantin Anton POPESCU-TĂRICEANU1464Popescu-Tariceanu Calin Constantin Anton | 195...🎴 📐 PNL🎴 📐 PNL🎴 📐 PNL📐 PNLPárt🎴
452000-12-152004-11-30Călin Constantin Anton POPESCU-TĂRICEANU1446Popescu-Tariceanu Calin Constantin Anton | 195...🎴 📐 PNL🎴 📐 PNL🎴 📐 PNL📐 PNLPárt🎴
462004-12-172008-12-13Călin Constantin Anton POPESCU-TĂRICEANU1457Popescu-Tariceanu Calin Constantin Anton | 195...🎴 📐 PNL🎴 📐 PNL🎴 📐 PNL📐 PNLPárt🎴
472008-12-192012-12-19Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...🎴 📐 PNL🎴 📐 PNL🎴 📐 PNL📐 PNLPárt🎴
482012-12-202014-03-01Călin Constantin Anton POPESCU-TĂRICEANU436Popescu-Tariceanu Calin Constantin Anton | 195...🎴 📐 PNL🎴 📐 PNL🎴 📐 PNL📐 PNLPárt🎴
492016-12-212019-07-01Călin Constantin Anton POPESCU-TĂRICEANU922Popescu-Tariceanu Calin Constantin Anton | 195...🎴 🕊️ ALDE🎴 🕊️ ALDE🎴 🕊️ ALDE🕊️ ALDEPárt🎴
502014-09-012016-12-20Călin Constantin Anton POPESCU-TĂRICEANU841Popescu-Tariceanu Calin Constantin Anton | 195...🎴 🕊️ PC🎴 🕊️ PC🎴 🕊️ PC🕊️ PCPárt🎴
512014-03-012016-12-20Călin Constantin Anton POPESCU-TĂRICEANU1025Popescu-Tariceanu Calin Constantin Anton | 195...👤 Independent - Independent👤 Independent - Independent👤 Independent - Independent👤 Independent - IndependentPárt
521990-06-181992-10-16Călin Constantin Anton POPESCU-TĂRICEANU851Popescu-Tariceanu Calin Constantin Anton | 195...📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional LiberalPárt
531996-11-272000-11-30Călin Constantin Anton POPESCU-TĂRICEANU1464Popescu-Tariceanu Calin Constantin Anton | 195...📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional LiberalPárt
542000-12-152004-11-30Călin Constantin Anton POPESCU-TĂRICEANU1446Popescu-Tariceanu Calin Constantin Anton | 195...📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional LiberalPárt
552004-12-172008-12-13Călin Constantin Anton POPESCU-TĂRICEANU1457Popescu-Tariceanu Calin Constantin Anton | 195...📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional LiberalPárt
562008-12-192012-12-19Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional LiberalPárt
572012-12-202014-03-01Călin Constantin Anton POPESCU-TĂRICEANU436Popescu-Tariceanu Calin Constantin Anton | 195...📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional Liberal📐 PNL - Partidul Naţional LiberalPárt
582016-12-212019-07-01Călin Constantin Anton POPESCU-TĂRICEANU922Popescu-Tariceanu Calin Constantin Anton | 195...🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo...🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo...🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo...🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo...Párt
602008-12-192012-12-19Călin Constantin Anton POPESCU-TĂRICEANU1461Popescu-Tariceanu Calin Constantin Anton | 195...🥇🎴 📐 PNL🥇🎴 📐 PNL🥇🎴 📐 PNL📐 PNLPárt🥇🎴
612000-12-152002-02-01Călin Constantin Anton POPESCU-TĂRICEANU413Popescu-Tariceanu Calin Constantin Anton | 195...🥈🎴 📐 PNL🥈🎴 📐 PNL🥈🎴 📐 PNL📐 PNLPárt🥈🎴
\n", "
" ], "text/plain": [ " start end Name duration \\\n", "0 1990-06-18 1992-10-16 Călin Constantin Anton POPESCU-TĂRICEANU 851 \n", "1 2008-12-19 2012-12-19 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "2 2012-12-20 2014-03-01 Călin Constantin Anton POPESCU-TĂRICEANU 436 \n", "3 1996-11-27 2000-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1464 \n", "4 1990-06-18 1992-10-16 Călin Constantin Anton POPESCU-TĂRICEANU 851 \n", "5 2015-02-01 2016-12-20 Călin Constantin Anton POPESCU-TĂRICEANU 688 \n", "6 2004-12-17 2008-12-13 Călin Constantin Anton POPESCU-TĂRICEANU 1457 \n", "7 2000-12-15 2004-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1446 \n", "8 2008-12-19 2012-12-19 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "9 2012-12-20 2016-12-20 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "10 2016-12-21 2019-07-01 Călin Constantin Anton POPESCU-TĂRICEANU 922 \n", "11 1990-06-18 1992-10-16 Călin Constantin Anton POPESCU-TĂRICEANU 851 \n", "12 1996-11-27 2000-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1464 \n", "13 2000-12-15 2004-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1446 \n", "14 2004-12-17 2008-12-13 Călin Constantin Anton POPESCU-TĂRICEANU 1457 \n", "15 2008-12-19 2012-12-19 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "16 2014-03-01 2014-09-01 Călin Constantin Anton POPESCU-TĂRICEANU 184 \n", "17 2014-09-01 2015-02-01 Călin Constantin Anton POPESCU-TĂRICEANU 153 \n", "18 2015-02-01 2015-09-01 Călin Constantin Anton POPESCU-TĂRICEANU 212 \n", "19 2015-09-01 2016-02-01 Călin Constantin Anton POPESCU-TĂRICEANU 153 \n", "20 2016-02-01 2016-09-01 Călin Constantin Anton POPESCU-TĂRICEANU 213 \n", "21 2016-12-21 2017-02-01 Călin Constantin Anton POPESCU-TĂRICEANU 42 \n", "22 2017-02-01 2017-09-01 Călin Constantin Anton POPESCU-TĂRICEANU 212 \n", "23 2017-09-01 2018-02-01 Călin Constantin Anton POPESCU-TĂRICEANU 153 \n", "24 2019-02-01 2019-07-01 Călin Constantin Anton POPESCU-TĂRICEANU 150 \n", "25 1990-06-18 1992-10-16 Călin Constantin Anton POPESCU-TĂRICEANU 851 \n", "26 1996-11-27 2000-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1464 \n", "27 2000-12-15 2002-02-01 Călin Constantin Anton POPESCU-TĂRICEANU 413 \n", "28 2000-12-15 2004-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1446 \n", "30 2004-12-17 2008-12-13 Călin Constantin Anton POPESCU-TĂRICEANU 1457 \n", "31 2012-12-20 2014-03-01 Călin Constantin Anton POPESCU-TĂRICEANU 436 \n", "32 2014-03-01 2014-09-01 Călin Constantin Anton POPESCU-TĂRICEANU 184 \n", "33 2014-03-01 2016-12-20 Călin Constantin Anton POPESCU-TĂRICEANU 1025 \n", "34 2014-09-01 2016-12-20 Călin Constantin Anton POPESCU-TĂRICEANU 841 \n", "35 2016-12-21 2019-07-01 Călin Constantin Anton POPESCU-TĂRICEANU 922 \n", "36 2008-12-19 2012-12-19 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "37 1990-06-18 1992-10-16 Călin Constantin Anton POPESCU-TĂRICEANU 851 \n", "38 2000-12-15 2004-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1446 \n", "39 1997-02-01 2000-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1398 \n", "40 2000-12-15 2004-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1446 \n", "41 2012-12-20 2015-03-01 Călin Constantin Anton POPESCU-TĂRICEANU 801 \n", "42 2014-03-01 2014-09-01 Călin Constantin Anton POPESCU-TĂRICEANU 184 \n", "43 1990-06-18 1992-10-16 Călin Constantin Anton POPESCU-TĂRICEANU 851 \n", "44 1996-11-27 2000-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1464 \n", "45 2000-12-15 2004-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1446 \n", "46 2004-12-17 2008-12-13 Călin Constantin Anton POPESCU-TĂRICEANU 1457 \n", "47 2008-12-19 2012-12-19 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "48 2012-12-20 2014-03-01 Călin Constantin Anton POPESCU-TĂRICEANU 436 \n", "49 2016-12-21 2019-07-01 Călin Constantin Anton POPESCU-TĂRICEANU 922 \n", "50 2014-09-01 2016-12-20 Călin Constantin Anton POPESCU-TĂRICEANU 841 \n", "51 2014-03-01 2016-12-20 Călin Constantin Anton POPESCU-TĂRICEANU 1025 \n", "52 1990-06-18 1992-10-16 Călin Constantin Anton POPESCU-TĂRICEANU 851 \n", "53 1996-11-27 2000-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1464 \n", "54 2000-12-15 2004-11-30 Călin Constantin Anton POPESCU-TĂRICEANU 1446 \n", "55 2004-12-17 2008-12-13 Călin Constantin Anton POPESCU-TĂRICEANU 1457 \n", "56 2008-12-19 2012-12-19 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "57 2012-12-20 2014-03-01 Călin Constantin Anton POPESCU-TĂRICEANU 436 \n", "58 2016-12-21 2019-07-01 Călin Constantin Anton POPESCU-TĂRICEANU 922 \n", "60 2008-12-19 2012-12-19 Călin Constantin Anton POPESCU-TĂRICEANU 1461 \n", "61 2000-12-15 2002-02-01 Călin Constantin Anton POPESCU-TĂRICEANU 413 \n", "\n", " Simple \\\n", "0 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "1 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "2 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "3 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "4 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "5 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "6 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "7 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "8 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "9 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "10 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "11 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "12 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "13 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "14 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "15 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "16 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "17 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "18 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "19 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "20 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "21 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "22 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "23 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "24 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "25 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "26 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "27 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "28 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "30 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "31 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "32 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "33 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "34 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "35 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "36 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "37 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "38 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "39 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "40 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "41 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "42 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "43 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "44 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "45 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "46 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "47 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "48 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "49 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "50 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "51 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "52 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "53 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "54 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "55 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "56 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "57 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "58 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "60 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "61 Popescu-Tariceanu Calin Constantin Anton | 195... \n", "\n", " Csoportok \\\n", "0 ⏫ Gazdaság, ipar \n", "1 🌐 Külpolitika, diaszpóra \n", "2 🌐 Külpolitika, diaszpóra \n", "3 🔀 Állami ügyek \n", "4 🔠 Oktatás, tudomány, sport \n", "5 🚩🔀 Állami ügyek \n", "6 🚹 Emberi jogok, kisebbségek \n", "7 🥈🔢 Pénzügy \n", "8 🥈🚩🔀 Állami ügyek \n", "9 🔼 Szenátus \n", "10 🔼 Szenátus \n", "11 🔽 Képviselőház \n", "12 🔽 Képviselőház \n", "13 🔽 Képviselőház \n", "14 🔽 Képviselőház \n", "15 🔽 Képviselőház \n", "16 🥇🔼 Szenátus \n", "17 🥇🔼 Szenátus \n", "18 🥇🔼 Szenátus \n", "19 🥇🔼 Szenátus \n", "20 🥇🔼 Szenátus \n", "21 🥇🔼 Szenátus \n", "22 🥇🔼 Szenátus \n", "23 🥇🔼 Szenátus \n", "24 🥇🔼 Szenátus \n", "25 🇷🇴 Arad \n", "26 🇷🇴 Bukarest \n", "27 🇷🇴 Bukarest \n", "28 🇷🇴 Bukarest \n", "30 🇷🇴 Bukarest \n", "31 🇷🇴 Bukarest \n", "32 🇷🇴 Bukarest \n", "33 🇷🇴 Bukarest \n", "34 🇷🇴 Bukarest \n", "35 🇷🇴 Bukarest \n", "36 🇷🇴 Ilfov \n", "37 🇬🇷 Görögország \n", "38 🇬🇷 Görögország \n", "39 🇵🇭 Fülöp-szigetek \n", "40 🇵🇭 Fülöp-szigetek \n", "41 🥇🇫🇷 Franciaország \n", "42 🎴 👤 Independent \n", "43 🎴 📐 PNL \n", "44 🎴 📐 PNL \n", "45 🎴 📐 PNL \n", "46 🎴 📐 PNL \n", "47 🎴 📐 PNL \n", "48 🎴 📐 PNL \n", "49 🎴 🕊️ ALDE \n", "50 🎴 🕊️ PC \n", "51 👤 Independent - Independent \n", "52 📐 PNL - Partidul Naţional Liberal \n", "53 📐 PNL - Partidul Naţional Liberal \n", "54 📐 PNL - Partidul Naţional Liberal \n", "55 📐 PNL - Partidul Naţional Liberal \n", "56 📐 PNL - Partidul Naţional Liberal \n", "57 📐 PNL - Partidul Naţional Liberal \n", "58 🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo... \n", "60 🥇🎴 📐 PNL \n", "61 🥈🎴 📐 PNL \n", "\n", " Csoportok0 \\\n", "0 ⏫ Gazdaság, ipar \n", "1 🌐 Külpolitika, diaszpóra \n", "2 🌐 Külpolitika, diaszpóra \n", "3 🔀 Állami ügyek \n", "4 🔠 Oktatás, tudomány, sport \n", "5 🚩🔀 Állami ügyek \n", "6 🚹 Emberi jogok, kisebbségek \n", "7 🥈🔢 Pénzügy \n", "8 🥈🚩🔀 Állami ügyek \n", "9 🔼 Szenátus \n", "10 🔼 Szenátus \n", "11 🔽 Képviselőház \n", "12 🔽 Képviselőház \n", "13 🔽 Képviselőház \n", "14 🔽 Képviselőház \n", "15 🔽 Képviselőház \n", "16 🥇🔼 Szenátus \n", "17 🥇🔼 Szenátus \n", "18 🥇🔼 Szenátus \n", "19 🥇🔼 Szenátus \n", "20 🥇🔼 Szenátus \n", "21 🥇🔼 Szenátus \n", "22 🥇🔼 Szenátus \n", "23 🥇🔼 Szenátus \n", "24 🥇🔼 Szenátus \n", "25 🇷🇴 Arad \n", "26 🇷🇴 Bukarest \n", "27 🇷🇴 Bukarest \n", "28 🇷🇴 Bukarest \n", "30 🇷🇴 Bukarest \n", "31 🇷🇴 Bukarest \n", "32 🇷🇴 Bukarest \n", "33 🇷🇴 Bukarest \n", "34 🇷🇴 Bukarest \n", "35 🇷🇴 Bukarest \n", "36 🇷🇴 Ilfov \n", "37 🇬🇷 Görögország \n", "38 🇬🇷 Görögország \n", "39 🇵🇭 Fülöp-szigetek \n", "40 🇵🇭 Fülöp-szigetek \n", "41 🥇🇫🇷 Franciaország \n", "42 🎴 👤 Independent \n", "43 🎴 📐 PNL \n", "44 🎴 📐 PNL \n", "45 🎴 📐 PNL \n", "46 🎴 📐 PNL \n", "47 🎴 📐 PNL \n", "48 🎴 📐 PNL \n", "49 🎴 🕊️ ALDE \n", "50 🎴 🕊️ PC \n", "51 👤 Independent - Independent \n", "52 📐 PNL - Partidul Naţional Liberal \n", "53 📐 PNL - Partidul Naţional Liberal \n", "54 📐 PNL - Partidul Naţional Liberal \n", "55 📐 PNL - Partidul Naţional Liberal \n", "56 📐 PNL - Partidul Naţional Liberal \n", "57 📐 PNL - Partidul Naţional Liberal \n", "58 🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo... \n", "60 🥇🎴 📐 PNL \n", "61 🥈🎴 📐 PNL \n", "\n", " Csoportok1 \\\n", "0 ⏫ Gazdaság, ipar \n", "1 🌐 Külpolitika, diaszpóra \n", "2 🌐 Külpolitika, diaszpóra \n", "3 🔀 Állami ügyek \n", "4 🔠 Oktatás, tudomány, sport \n", "5 🚩🔀 Állami ügyek \n", "6 🚹 Emberi jogok, kisebbségek \n", "7 🥈🔢 Pénzügy \n", "8 🥈🚩🔀 Állami ügyek \n", "9 🔼 Szenátus \n", "10 🔼 Szenátus \n", "11 🔽 Képviselőház \n", "12 🔽 Képviselőház \n", "13 🔽 Képviselőház \n", "14 🔽 Képviselőház \n", "15 🔽 Képviselőház \n", "16 🥇🔼 Szenátus \n", "17 🥇🔼 Szenátus \n", "18 🥇🔼 Szenátus \n", "19 🥇🔼 Szenátus \n", "20 🥇🔼 Szenátus \n", "21 🥇🔼 Szenátus \n", "22 🥇🔼 Szenátus \n", "23 🥇🔼 Szenátus \n", "24 🥇🔼 Szenátus \n", "25 🇷🇴 Arad \n", "26 🇷🇴 Bukarest \n", "27 🇷🇴 Bukarest \n", "28 🇷🇴 Bukarest \n", "30 🇷🇴 Bukarest \n", "31 🇷🇴 Bukarest \n", "32 🇷🇴 Bukarest \n", "33 🇷🇴 Bukarest \n", "34 🇷🇴 Bukarest \n", "35 🇷🇴 Bukarest \n", "36 🇷🇴 Ilfov \n", "37 🇬🇷 Görögország \n", "38 🇬🇷 Görögország \n", "39 🇵🇭 Fülöp-szigetek \n", "40 🇵🇭 Fülöp-szigetek \n", "41 🥇🇫🇷 Franciaország \n", "42 🎴 👤 Independent \n", "43 🎴 📐 PNL \n", "44 🎴 📐 PNL \n", "45 🎴 📐 PNL \n", "46 🎴 📐 PNL \n", "47 🎴 📐 PNL \n", "48 🎴 📐 PNL \n", "49 🎴 🕊️ ALDE \n", "50 🎴 🕊️ PC \n", "51 👤 Independent - Independent \n", "52 📐 PNL - Partidul Naţional Liberal \n", "53 📐 PNL - Partidul Naţional Liberal \n", "54 📐 PNL - Partidul Naţional Liberal \n", "55 📐 PNL - Partidul Naţional Liberal \n", "56 📐 PNL - Partidul Naţional Liberal \n", "57 📐 PNL - Partidul Naţional Liberal \n", "58 🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo... \n", "60 🥇🎴 📐 PNL \n", "61 🥈🎴 📐 PNL \n", "\n", " Csoportok9 Típus Medals \n", "0 ⏫ Gazdaság, ipar Bizottság \n", "1 🌐 Külpolitika, diaszpóra Bizottság \n", "2 🌐 Külpolitika, diaszpóra Bizottság \n", "3 🔀 Állami ügyek Bizottság \n", "4 🔠 Oktatás, tudomány, sport Bizottság \n", "5 🔀 Állami ügyek Bizottság 🚩 \n", "6 🚹 Emberi jogok, kisebbségek Bizottság \n", "7 🔢 Pénzügy Bizottság 🥈 \n", "8 🔀 Állami ügyek Bizottság 🥈🚩 \n", "9 🔼 Szenátus Kamara \n", "10 🔼 Szenátus Kamara \n", "11 🔽 Képviselőház Kamara \n", "12 🔽 Képviselőház Kamara \n", "13 🔽 Képviselőház Kamara \n", "14 🔽 Képviselőház Kamara \n", "15 🔽 Képviselőház Kamara \n", "16 🔼 Szenátus Kamara 🥇 \n", "17 🔼 Szenátus Kamara 🥇 \n", "18 🔼 Szenátus Kamara 🥇 \n", "19 🔼 Szenátus Kamara 🥇 \n", "20 🔼 Szenátus Kamara 🥇 \n", "21 🔼 Szenátus Kamara 🥇 \n", "22 🔼 Szenátus Kamara 🥇 \n", "23 🔼 Szenátus Kamara 🥇 \n", "24 🔼 Szenátus Kamara 🥇 \n", "25 🇷🇴 Arad Megye \n", "26 🇷🇴 Bukarest Megye \n", "27 🇷🇴 Bukarest Megye \n", "28 🇷🇴 Bukarest Megye \n", "30 🇷🇴 Bukarest Megye \n", "31 🇷🇴 Bukarest Megye \n", "32 🇷🇴 Bukarest Megye \n", "33 🇷🇴 Bukarest Megye \n", "34 🇷🇴 Bukarest Megye \n", "35 🇷🇴 Bukarest Megye \n", "36 🇷🇴 Ilfov Megye \n", "37 🇬🇷 Görögország Ország \n", "38 🇬🇷 Görögország Ország \n", "39 🇵🇭 Fülöp-szigetek Ország \n", "40 🇵🇭 Fülöp-szigetek Ország \n", "41 🇫🇷 Franciaország Ország 🥇 \n", "42 👤 Independent Párt 🎴 \n", "43 📐 PNL Párt 🎴 \n", "44 📐 PNL Párt 🎴 \n", "45 📐 PNL Párt 🎴 \n", "46 📐 PNL Párt 🎴 \n", "47 📐 PNL Párt 🎴 \n", "48 📐 PNL Párt 🎴 \n", "49 🕊️ ALDE Párt 🎴 \n", "50 🕊️ PC Párt 🎴 \n", "51 👤 Independent - Independent Párt \n", "52 📐 PNL - Partidul Naţional Liberal Párt \n", "53 📐 PNL - Partidul Naţional Liberal Párt \n", "54 📐 PNL - Partidul Naţional Liberal Párt \n", "55 📐 PNL - Partidul Naţional Liberal Párt \n", "56 📐 PNL - Partidul Naţional Liberal Párt \n", "57 📐 PNL - Partidul Naţional Liberal Párt \n", "58 🕊️ ALDE - Partidul Alianţa Liberalilor şi Demo... Párt \n", "60 📐 PNL Párt 🥇🎴 \n", "61 📐 PNL Párt 🥈🎴 " ] }, "execution_count": 295, "metadata": {}, "output_type": "execute_result" } ], "source": [ "efs4[efs4['Simple']=='Popescu-Tariceanu Calin Constantin Anton | 1952-01-14']" ] }, { "cell_type": "code", "execution_count": 296, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "29130" ] }, "execution_count": 296, "metadata": {}, "output_type": "execute_result" } ], "source": [ "j=efs4.reset_index().drop('index',axis=1).T.astype(str).to_dict()\n", "open('ignore/member_timelines.json','w').write(json.dumps(list(j.values())))" ] }, { "cell_type": "code", "execution_count": 297, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1" ] }, "execution_count": 297, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(efs4['Simple'].unique())" ] }, { "cell_type": "code", "execution_count": 298, "metadata": {}, "outputs": [], "source": [ "import zipfile\n", "\n", "with zipfile.ZipFile(\"json/member_timelines.zip\", \"w\", compression=zipfile.ZIP_DEFLATED) as zf:\n", " zf.write(\"ignore/member_timelines.json\",\"member_timelines.json\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 1608, "metadata": {}, "outputs": [], "source": [ "members={}\n", "simple={}\n", "simple2={}\n", "for i in efs4[['Name','Simple']].T.iteritems():\n", " if i[1][0] not in simple: simple[i[1][0]]=i[1][1]\n", " if i[1][1] not in simple2: simple2[i[1][1]]=i[1][0]\n", "members['s']=simple\n", "members['s2']=simple2" ] }, { "cell_type": "code", "execution_count": 1609, "metadata": {}, "outputs": [], "source": [ "members['megye']=efs4[efs4['Típus']=='Megye'].sort_values(by='start')[['Simple','Csoportok']].set_index('Csoportok')\\\n", " .drop_duplicates(keep='last').reset_index().set_index('Simple')['Csoportok'].to_dict()" ] }, { "cell_type": "code", "execution_count": 1610, "metadata": {}, "outputs": [], "source": [ "members['part']=efs4[efs4['Típus']=='Párt'].sort_values(by='start')[['Simple','Csoportok']].set_index('Csoportok')\\\n", " .drop_duplicates(keep='last').reset_index().set_index('Simple')['Csoportok'].to_dict()" ] }, { "cell_type": "code", "execution_count": 1611, "metadata": {}, "outputs": [], "source": [ "members['deaths']=deaths" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Vega direct plot" ] }, { "cell_type": "code", "execution_count": 1612, "metadata": {}, "outputs": [ { "data": { "application/vnd.vegalite.v3+json": { "$schema": "https://vega.github.io/schema/vega-lite/v3.3.0.json", "config": { "mark": { "tooltip": null }, "view": { "height": 300, "width": 400 } }, "data": { "name": "data-261e33c7fbd2b6cfc4eaf48afb6de4cd" }, "datasets": { "data-261e33c7fbd2b6cfc4eaf48afb6de4cd": [ { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp#", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 184, "end": "2014-09-01T00:00:00", "start": "2014-03-01T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp#", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 153, "end": "2015-02-01T00:00:00", "start": "2014-09-01T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp#", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 212, "end": "2015-09-01T00:00:00", "start": "2015-02-01T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp#", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 153, "end": "2016-02-01T00:00:00", "start": "2015-09-01T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp#", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 213, "end": "2016-09-01T00:00:00", "start": "2016-02-01T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp# ", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 42, "end": "2017-02-01T00:00:00", "start": "2016-12-21T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp# ", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 212, "end": "2017-09-01T00:00:00", "start": "2017-02-01T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp# ", "Csoportok1": "#bp##bp# ", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 153, "end": "2018-02-01T00:00:00", "start": "2017-09-01T00:00:00" }, { "Csoportok": "#bp##bp#", "Csoportok0": "#bp##bp#", "Csoportok1": "#bp##bp# ", "Csoportok9": "#bp#", "Medals": "#bp#", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 150, "end": "2019-07-01T00:00:00", "start": "2019-02-01T00:00:00" }, { "Csoportok": "⏫ Gazdaság, ipar", "Csoportok0": "⏫ Gazdaság, ipar", "Csoportok1": "⏫ Gazdaság, ipar", "Csoportok9": "⏫ Gazdaság, ipar", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 850, "end": "1992-10-16T00:00:00", "start": "1990-06-19T00:00:00" }, { "Csoportok": "🌐 Külpolitika, diaszpóra", "Csoportok0": "🌐 Külpolitika, diaszpóra", "Csoportok1": "🌐 Külpolitika, diaszpóra", "Csoportok9": "🌐 Külpolitika, diaszpóra", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 1462, "end": "2012-12-20T00:00:00", "start": "2008-12-19T00:00:00" }, { "Csoportok": "🌐 Külpolitika, diaszpóra", "Csoportok0": "🌐 Külpolitika, diaszpóra ", "Csoportok1": "🌐 Külpolitika, diaszpóra", "Csoportok9": "🌐 Külpolitika, diaszpóra", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 436, "end": "2014-03-01T00:00:00", "start": "2012-12-20T00:00:00" }, { "Csoportok": "🔀 Állami ügyek", "Csoportok0": "🔀 Állami ügyek", "Csoportok1": "🔀 Állami ügyek", "Csoportok9": "🔀 Állami ügyek", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 1464, "end": "2000-11-30T00:00:00", "start": "1996-11-27T00:00:00" }, { "Csoportok": "🔠 Oktatás, tudomány, sport", "Csoportok0": "🔠 Oktatás, tudomány, sport", "Csoportok1": "🔠 Oktatás, tudomány, sport", "Csoportok9": "🔠 Oktatás, tudomány, sport", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 850, "end": "1992-10-16T00:00:00", "start": "1990-06-19T00:00:00" }, { "Csoportok": "🚩🔀 Állami ügyek", "Csoportok0": "🚩🔀 Állami ügyek", "Csoportok1": "🚩🔀 Állami ügyek", "Csoportok9": "🔀 Állami ügyek", "Medals": "🚩", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 689, "end": "2016-12-21T00:00:00", "start": "2015-02-01T00:00:00" }, { "Csoportok": "🚹 Emberi jogok, kisebbségek", "Csoportok0": "🚹 Emberi jogok, kisebbségek", "Csoportok1": "🚹 Emberi jogok, kisebbségek", "Csoportok9": "🚹 Emberi jogok, kisebbségek", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 1455, "end": "2008-12-13T00:00:00", "start": "2004-12-19T00:00:00" }, { "Csoportok": "🥈💹 Költségvetés", "Csoportok0": "🥈💹 Költségvetés", "Csoportok1": "🥈💹 Költségvetés", "Csoportok9": "💹 Költségvetés", "Medals": "🥈", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 1446, "end": "2004-11-30T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "🥈🚩🔀 Állami ügyek", "Csoportok0": "🥈🚩🔀 Állami ügyek", "Csoportok1": "🥈🚩🔀 Állami ügyek", "Csoportok9": "🔀 Állami ügyek", "Medals": "🥈🚩", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Bizottság", "duration": 1462, "end": "2012-12-20T00:00:00", "start": "2008-12-19T00:00:00" }, { "Csoportok": "🔼 Szenátus", "Csoportok0": "🔼 Szenátus", "Csoportok1": "🔼 Szenátus", "Csoportok9": "🔼 Szenátus", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 1026, "end": "2014-03-01T00:00:00", "start": "2012-12-20T00:00:00" }, { "Csoportok": "🔽 Képviselőház", "Csoportok0": "🔽 Képviselőház ", "Csoportok1": "🔽 Képviselőház", "Csoportok9": "🔽 Képviselőház", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 851, "end": "1992-10-16T00:00:00", "start": "1990-06-18T00:00:00" }, { "Csoportok": "🔽 Képviselőház", "Csoportok0": "🔽 Képviselőház ", "Csoportok1": "🔽 Képviselőház ", "Csoportok9": "🔽 Képviselőház", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 1464, "end": "2000-11-30T00:00:00", "start": "1996-11-27T00:00:00" }, { "Csoportok": "🔽 Képviselőház", "Csoportok0": "🔽 Képviselőház", "Csoportok1": "🔽 Képviselőház ", "Csoportok9": "🔽 Képviselőház", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 1446, "end": "2004-11-30T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "🔽 Képviselőház", "Csoportok0": "🔽 Képviselőház ", "Csoportok1": "🔽 Képviselőház ", "Csoportok9": "🔽 Képviselőház", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 1457, "end": "2008-12-13T00:00:00", "start": "2004-12-17T00:00:00" }, { "Csoportok": "🔽 Képviselőház", "Csoportok0": "🔽 Képviselőház ", "Csoportok1": "🔽 Képviselőház ", "Csoportok9": "🔽 Képviselőház", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 1462, "end": "2012-12-20T00:00:00", "start": "2008-12-19T00:00:00" }, { "Csoportok": "🥇🔼 Szenátus", "Csoportok0": "🥇🔼 Szenátus ", "Csoportok1": "🥇🔼 Szenátus", "Csoportok9": "🔼 Szenátus", "Medals": "🥇", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 1026, "end": "2016-12-21T00:00:00", "start": "2014-03-01T00:00:00" }, { "Csoportok": "🥇🔼 Szenátus", "Csoportok0": "🥇🔼 Szenátus", "Csoportok1": "🥇🔼 Szenátus", "Csoportok9": "🔼 Szenátus", "Medals": "🥇", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Kamara", "duration": 922, "end": "2019-07-01T00:00:00", "start": "2016-12-21T00:00:00" }, { "Csoportok": "🇷🇴 Arad", "Csoportok0": "🇷🇴 Arad", "Csoportok1": "🇷🇴 Arad", "Csoportok9": "🇷🇴 Arad", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 851, "end": "1992-10-16T00:00:00", "start": "1990-06-18T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 1464, "end": "2000-11-30T00:00:00", "start": "1996-11-27T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 413, "end": "2002-02-01T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest", "Csoportok1": "🇷🇴 Bukarest", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 1446, "end": "2004-11-30T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": -16, "end": "2004-12-01T00:00:00", "start": "2004-12-17T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 1457, "end": "2008-12-13T00:00:00", "start": "2004-12-17T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest ", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 436, "end": "2014-03-01T00:00:00", "start": "2012-12-20T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest ", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 184, "end": "2014-09-01T00:00:00", "start": "2014-03-01T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest ", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 1026, "end": "2016-12-21T00:00:00", "start": "2014-03-01T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest ", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 842, "end": "2016-12-21T00:00:00", "start": "2014-09-01T00:00:00" }, { "Csoportok": "🇷🇴 Bukarest", "Csoportok0": "🇷🇴 Bukarest ", "Csoportok1": "🇷🇴 Bukarest ", "Csoportok9": "🇷🇴 Bukarest", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 922, "end": "2019-07-01T00:00:00", "start": "2016-12-21T00:00:00" }, { "Csoportok": "🇷🇴 Ilfov", "Csoportok0": "🇷🇴 Ilfov ", "Csoportok1": "🇷🇴 Ilfov", "Csoportok9": "🇷🇴 Ilfov", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Megye", "duration": 1462, "end": "2012-12-20T00:00:00", "start": "2008-12-19T00:00:00" }, { "Csoportok": "🇬🇷 Görögország", "Csoportok0": "🇬🇷 Görögország ", "Csoportok1": "🇬🇷 Görögország", "Csoportok9": "🇬🇷 Görögország", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Ország", "duration": 851, "end": "1992-10-16T00:00:00", "start": "1990-06-18T00:00:00" }, { "Csoportok": "🇬🇷 Görögország", "Csoportok0": "🇬🇷 Görögország", "Csoportok1": "🇬🇷 Görögország ", "Csoportok9": "🇬🇷 Görögország", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Ország", "duration": 1446, "end": "2004-11-30T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "🇵🇭 Fülöp-szigetek", "Csoportok0": "🇵🇭 Fülöp-szigetek ", "Csoportok1": "🇵🇭 Fülöp-szigetek", "Csoportok9": "🇵🇭 Fülöp-szigetek", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Ország", "duration": 1398, "end": "2000-11-30T00:00:00", "start": "1997-02-01T00:00:00" }, { "Csoportok": "🇵🇭 Fülöp-szigetek", "Csoportok0": "🇵🇭 Fülöp-szigetek", "Csoportok1": "🇵🇭 Fülöp-szigetek", "Csoportok9": "🇵🇭 Fülöp-szigetek", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Ország", "duration": 1446, "end": "2004-11-30T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "🥇🇫🇷 Franciaország", "Csoportok0": "🥇🇫🇷 Franciaország", "Csoportok1": "🥇🇫🇷 Franciaország", "Csoportok9": "🇫🇷 Franciaország", "Medals": "🥇", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Ország", "duration": 801, "end": "2015-03-01T00:00:00", "start": "2012-12-20T00:00:00" }, { "Csoportok": "🎴 👤 Independent", "Csoportok0": "🎴 👤 Independent", "Csoportok1": "🎴 👤 Independent", "Csoportok9": "👤 Independent", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 184, "end": "2014-09-01T00:00:00", "start": "2014-03-01T00:00:00" }, { "Csoportok": "🎴 📐 PNL", "Csoportok0": "🎴 📐 PNL ", "Csoportok1": "🎴 📐 PNL", "Csoportok9": "📐 PNL", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 851, "end": "1992-10-16T00:00:00", "start": "1990-06-18T00:00:00" }, { "Csoportok": "🎴 📐 PNL", "Csoportok0": "🎴 📐 PNL ", "Csoportok1": "🎴 📐 PNL ", "Csoportok9": "📐 PNL", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1464, "end": "2000-11-30T00:00:00", "start": "1996-11-27T00:00:00" }, { "Csoportok": "🎴 📐 PNL", "Csoportok0": "🎴 📐 PNL", "Csoportok1": "🎴 📐 PNL ", "Csoportok9": "📐 PNL", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1446, "end": "2004-11-30T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "🎴 📐 PNL", "Csoportok0": "🎴 📐 PNL ", "Csoportok1": "🎴 📐 PNL ", "Csoportok9": "📐 PNL", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1457, "end": "2008-12-13T00:00:00", "start": "2004-12-17T00:00:00" }, { "Csoportok": "🎴 📐 PNL", "Csoportok0": "🎴 📐 PNL ", "Csoportok1": "🎴 📐 PNL ", "Csoportok9": "📐 PNL", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1462, "end": "2012-12-20T00:00:00", "start": "2008-12-19T00:00:00" }, { "Csoportok": "🎴 📐 PNL", "Csoportok0": "🎴 📐 PNL ", "Csoportok1": "🎴 📐 PNL ", "Csoportok9": "📐 PNL", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 436, "end": "2014-03-01T00:00:00", "start": "2012-12-20T00:00:00" }, { "Csoportok": "🎴 🕊️ ALDE", "Csoportok0": "🎴 🕊️ ALDE", "Csoportok1": "🎴 🕊️ ALDE", "Csoportok9": "🕊️ ALDE", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 922, "end": "2019-07-01T00:00:00", "start": "2016-12-21T00:00:00" }, { "Csoportok": "🎴 🕊️ PC", "Csoportok0": "🎴 🕊️ PC", "Csoportok1": "🎴 🕊️ PC", "Csoportok9": "🕊️ PC", "Medals": "🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 842, "end": "2016-12-21T00:00:00", "start": "2014-09-01T00:00:00" }, { "Csoportok": "👤 Independent - Independent", "Csoportok0": "👤 Independent - Independent", "Csoportok1": "👤 Independent - Independent", "Csoportok9": "👤 Independent - Independent", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1026, "end": "2016-12-21T00:00:00", "start": "2014-03-01T00:00:00" }, { "Csoportok": "📐 PNL - Partidul Naţional Liberal", "Csoportok0": "📐 PNL - Partidul Naţional Liberal ", "Csoportok1": "📐 PNL - Partidul Naţional Liberal", "Csoportok9": "📐 PNL - Partidul Naţional Liberal", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 851, "end": "1992-10-16T00:00:00", "start": "1990-06-18T00:00:00" }, { "Csoportok": "📐 PNL - Partidul Naţional Liberal", "Csoportok0": "📐 PNL - Partidul Naţional Liberal ", "Csoportok1": "📐 PNL - Partidul Naţional Liberal ", "Csoportok9": "📐 PNL - Partidul Naţional Liberal", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1464, "end": "2000-11-30T00:00:00", "start": "1996-11-27T00:00:00" }, { "Csoportok": "📐 PNL - Partidul Naţional Liberal", "Csoportok0": "📐 PNL - Partidul Naţional Liberal", "Csoportok1": "📐 PNL - Partidul Naţional Liberal ", "Csoportok9": "📐 PNL - Partidul Naţional Liberal", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1446, "end": "2004-11-30T00:00:00", "start": "2000-12-15T00:00:00" }, { "Csoportok": "📐 PNL - Partidul Naţional Liberal", "Csoportok0": "📐 PNL - Partidul Naţional Liberal ", "Csoportok1": "📐 PNL - Partidul Naţional Liberal ", "Csoportok9": "📐 PNL - Partidul Naţional Liberal", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1457, "end": "2008-12-13T00:00:00", "start": "2004-12-17T00:00:00" }, { "Csoportok": "📐 PNL - Partidul Naţional Liberal", "Csoportok0": "📐 PNL - Partidul Naţional Liberal ", "Csoportok1": "📐 PNL - Partidul Naţional Liberal ", "Csoportok9": "📐 PNL - Partidul Naţional Liberal", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1462, "end": "2012-12-20T00:00:00", "start": "2008-12-19T00:00:00" }, { "Csoportok": "📐 PNL - Partidul Naţional Liberal", "Csoportok0": "📐 PNL - Partidul Naţional Liberal ", "Csoportok1": "📐 PNL - Partidul Naţional Liberal ", "Csoportok9": "📐 PNL - Partidul Naţional Liberal", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 436, "end": "2014-03-01T00:00:00", "start": "2012-12-20T00:00:00" }, { "Csoportok": "🕊️ ALDE - Partidul Alianţa Liberalilor şi Democraţilor", "Csoportok0": "🕊️ ALDE - Partidul Alianţa Liberalilor şi Democraţilor", "Csoportok1": "🕊️ ALDE - Partidul Alianţa Liberalilor şi Democraţilor", "Csoportok9": "🕊️ ALDE - Partidul Alianţa Liberalilor şi Democraţilor", "Medals": "", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 922, "end": "2019-07-01T00:00:00", "start": "2016-12-21T00:00:00" }, { "Csoportok": "🥇🎴 📐 PNL", "Csoportok0": "🥇🎴 📐 PNL", "Csoportok1": "🥇🎴 📐 PNL", "Csoportok9": "📐 PNL", "Medals": "🥇🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": -16, "end": "2004-12-01T00:00:00", "start": "2004-12-17T00:00:00" }, { "Csoportok": "🥇🎴 📐 PNL", "Csoportok0": "🥇🎴 📐 PNL ", "Csoportok1": "🥇🎴 📐 PNL ", "Csoportok9": "📐 PNL", "Medals": "🥇🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 1462, "end": "2012-12-20T00:00:00", "start": "2008-12-19T00:00:00" }, { "Csoportok": "🥈🎴 📐 PNL", "Csoportok0": "🥈🎴 📐 PNL", "Csoportok1": "🥈🎴 📐 PNL", "Csoportok9": "📐 PNL", "Medals": "🥈🎴 ", "Name": "Călin Constantin Anton POPESCU-TĂRICEANU", "Simple": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14", "Típus": "Párt", "duration": 413, "end": "2002-02-01T00:00:00", "start": "2000-12-15T00:00:00" } ] }, "encoding": { "color": { "field": "Típus", "sort": { "field": "order", "op": "mean", "order": "descending" }, "type": "nominal" }, "x": { "field": "start", "title": "", "type": "temporal" }, "x2": { "field": "end" }, "y": { "field": "Csoportok", "sort": { "field": "order", "op": "mean", "order": "descending" }, "title": "", "type": "nominal" } }, "mark": "bar", "selection": { "selector010": { "bind": "scales", "encodings": [ "x", "y" ], "type": "interval" } }, "title": "Popescu-Tariceanu Calin Constantin Anton | 1952-01-14" }, "text/plain": [ "\n", "\n", "If you see this message, it means the renderer has not been properly enabled\n", "for the frontend that you are using. For more information, see\n", "https://altair-viz.github.io/user_guide/troubleshooting.html\n" ] }, "execution_count": 1612, "metadata": {}, "output_type": "execute_result" } ], "source": [ "m='Popescu-Tariceanu Calin Constantin Anton | 1952-01-14'\n", "ef=efs4[efs4['Simple']==m]\n", "viz=alt.Chart(ef,\n", " title=m\n", " ).mark_bar().encode(\n", " x=alt.X('start:T',title=''),\n", " x2='end:T',\n", " y=alt.Y('Csoportok:N',title='',\n", " sort=alt.EncodingSortField(field=\"order\", op=\"mean\", order='descending')),\n", " color=alt.Color('Típus:N',\n", " sort=alt.EncodingSortField(field=\"order\", op=\"mean\", order='descending'))\n", ")\n", "# viz.save('json/viz.json')\n", "viz.interactive()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Member images" ] }, { "cell_type": "code", "execution_count": 1613, "metadata": {}, "outputs": [], "source": [ "photos={name:nmembers[name]['Photo'][np.array([p[-10:-6] for p in nmembers[name]['Link']]).argmax()] for name in nmembers}" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Download photos if you need to.." ] }, { "cell_type": "code", "execution_count": 1221, "metadata": {}, "outputs": [], "source": [ "import urllib.request" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "#downloader - run once only\n", "for p in photos:\n", " urllib.request.urlretrieve(photos[p], \"photos3/\"+p.replace('|','+')+'.jpg')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "from PIL import Image\n", "#!pip install python-resize-image\n", "from resizeimage import resizeimage" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "err=[]\n", "for p in photos:\n", " try:\n", " img = Image.open('photos3/'+p.replace('|','+')+'.jpg', 'r')\n", " img = resizeimage.resize_cover(img, [123,150])\n", " img.save('photos4/'+p.replace('|','+')+'.jpg', img.format)\n", " except:\n", " print(p)\n", " err.append(p)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "#run this then iterate cell above until no errors\n", "for p in err:\n", " urllib.request.urlretrieve(photos[p], \"photos3/\"+p.replace('|','+')+'.jpg')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "for p in err:\n", " try:\n", " img = Image.open('photos3/'+p.replace('|','+')+'.jpg', 'r')\n", " img = resizeimage.resize_cover(img, [123,150])\n", " img.save('photos4/'+p.replace('|','+')+'.jpg', img.format)\n", " except:\n", " img = Image.open('photos3/'+p.replace('|','+')+'.jpg', 'r')\n", " img.save('photos4/'+p.replace('|','+')+'.jpg', img.format)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Otherwise continue here:" ] }, { "cell_type": "code", "execution_count": 1614, "metadata": {}, "outputs": [], "source": [ "members['photo']={p:'photos4/'+p.replace('|','+')+'.jpg' for p in photos}" ] }, { "cell_type": "code", "execution_count": 1615, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "957435" ] }, "execution_count": 1615, "metadata": {}, "output_type": "execute_result" } ], "source": [ "open('ignore/member_simple.json','w').write(json.dumps(members))" ] }, { "cell_type": "code", "execution_count": 1616, "metadata": {}, "outputs": [], "source": [ "import zipfile\n", "\n", "with zipfile.ZipFile(\"json/member_simple.zip\", \"w\", compression=zipfile.ZIP_DEFLATED) as zf:\n", " zf.write(\"ignore/member_simple.json\",\"member_simple.json\")" ] }, { "cell_type": "code", "execution_count": 1617, "metadata": {}, "outputs": [], "source": [ "pretty={'- din care declaraţii politice':'🧾 Nyilatkozatok',\n", " 'Declaraţii politice depuse în scris':'🧾 Nyilatkozatok',\n", " 'Luari de cuvânt':'🎙️ Felszólalások', \n", " 'Luari de cuvânt în BP':'🎙️ Felszólalások', \n", " 'Motiuni':'📚 Javaslatok', \n", " 'Proiecte de hotarâre initiate':'📚 Javaslatok', \n", " 'Propuneri legislative initiate':'📚 Javaslatok',\n", " 'Sedințe':'💺 Ülések', \n", " 'Întrebari si interpelari':'🎙️ Felszólalások'}" ] }, { "cell_type": "code", "execution_count": 1618, "metadata": {}, "outputs": [], "source": [ "efx=[]\n", "for n in nmembers:\n", " m=nmembers[n]\n", " data=[]\n", " since=m['Starts']\n", " until=m['Ends']\n", " for pi in range(len(m['Link'])):\n", " p=m['Link'][pi]\n", " d={}\n", " d['Simple']=n\n", " d['Link']=p\n", " d['Session']=p[-10:-6]\n", " for a in m['Activity']:\n", " if type(m['Activity'][a])==list:\n", " g=m['Activity'][a]\n", " else:\n", " g=[m['Activity'][a]]\n", " for h in g:\n", " if h['start']==since[pi]: \n", " if pretty[a] not in d:d[pretty[a]]=0\n", " d[pretty[a]]+=h['value']\n", " data.append(d)\n", " ef=pd.DataFrame(data)\n", "\n", " #append\n", " efx.append(ef)" ] }, { "cell_type": "code", "execution_count": 1619, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n", "of pandas will change to not sort by default.\n", "\n", "To accept the future behavior, pass 'sort=False'.\n", "\n", "To retain the current behavior and silence the warning, pass 'sort=True'.\n", "\n", " \"\"\"Entry point for launching an IPython kernel.\n" ] } ], "source": [ "efx2=pd.concat(efx).fillna(0).reset_index().drop('index',axis=1)" ] }, { "cell_type": "code", "execution_count": 1620, "metadata": {}, "outputs": [], "source": [ "j=efx2.T.astype(str).to_dict()\n", "j2=list(j.values())" ] }, { "cell_type": "code", "execution_count": 1621, "metadata": {}, "outputs": [], "source": [ "j3={}\n", "for i in j2:\n", " if i['Simple'] not in j3:j3[i['Simple']]=[]\n", " j3[i['Simple']].append(i)" ] }, { "cell_type": "code", "execution_count": 1622, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1433467" ] }, "execution_count": 1622, "metadata": {}, "output_type": "execute_result" } ], "source": [ "open('ignore/member_activity.json','w').write(json.dumps(j3))" ] }, { "cell_type": "code", "execution_count": 1623, "metadata": {}, "outputs": [], "source": [ "import zipfile\n", "\n", "with zipfile.ZipFile(\"json/member_activity.zip\", \"w\", compression=zipfile.ZIP_DEFLATED) as zf:\n", " zf.write(\"ignore/member_activity.json\",\"member_activity.json\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.7" }, "toc": { "base_numbering": 1, "nav_menu": {}, "number_sections": true, "sideBar": true, "skip_h1_title": false, "title_cell": "Table of Contents", "title_sidebar": "Contents", "toc_cell": false, "toc_position": {}, "toc_section_display": true, "toc_window_display": false } }, "nbformat": 4, "nbformat_minor": 2 }