{"cells": [{"cell_type": "markdown", "metadata": {}, "source": ["# DataFrames Pandas\n", "\n", "Un Data Frame est un objet qui est pr\u00e9sent dans la plupart des logiciels de traitements de donn\u00e9es, c\u2019est une matrice \u00e0 2 dimensions, chaque colonne a un type et toutes les cellules de cette colonne sont de ce type (nombre, dates, texte). Une cellule peut contenir une valeur manquante. On peut consid\u00e9rer chaque colonne comme les variables d\u2019une table (pandas.Dataframe - cette page contient toutes les m\u00e9thodes de la classe)."]}, {"cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [{"data": {"text/html": ["
\n", ""], "text/plain": ["\n", " | country | \n", "sub_item | \n", "year | \n", "currency | \n", "VA1 | \n", "code | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Argentina | \n", "Agriculture, hunting, forestry fishing | \n", "1993 | \n", "Argentine peso | \n", "1.214900e+10 | \n", "AB | \n", "1.214900e+10 | \n", "2.123000e+09 | \n", "
1 | \n", "Argentina | \n", "Mining and quarrying | \n", "1993 | \n", "Argentine peso | \n", "3.525000e+09 | \n", "C | \n", "3.525000e+09 | \n", "8.007000e+08 | \n", "
2 | \n", "Argentina | \n", "Manufacturing | \n", "1993 | \n", "Argentine peso | \n", "3.890700e+10 | \n", "D | \n", "3.890700e+10 | \n", "1.766600e+10 | \n", "
3 | \n", "Argentina | \n", "Electricity, gas and water supply | \n", "1993 | \n", "Argentine peso | \n", "4.461000e+09 | \n", "E | \n", "4.461000e+09 | \n", "2.213000e+09 | \n", "
4 | \n", "Argentina | \n", "Construction | \n", "1993 | \n", "Argentine peso | \n", "1.339300e+10 | \n", "F | \n", "1.339300e+10 | \n", "4.355000e+09 | \n", "
\n", " | country | \n", "sub_item | \n", "year | \n", "currency | \n", "VA1 | \n", "code | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|---|
1 | \n", "Argentina | \n", "Mining and quarrying | \n", "1993 | \n", "Argentine peso | \n", "3.525000e+09 | \n", "C | \n", "3.525000e+09 | \n", "8.007000e+08 | \n", "
2 | \n", "Argentina | \n", "Manufacturing | \n", "1993 | \n", "Argentine peso | \n", "3.890700e+10 | \n", "D | \n", "3.890700e+10 | \n", "1.766600e+10 | \n", "
\n", " | country | \n", "sub_item | \n", "year | \n", "currency | \n", "VA1 | \n", "code | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Argentina | \n", "Agriculture, hunting, forestry fishing | \n", "1993 | \n", "Argentine peso | \n", "1.214900e+10 | \n", "AB | \n", "1.214900e+10 | \n", "2.123000e+09 | \n", "
1 | \n", "Argentina | \n", "Mining and quarrying | \n", "1993 | \n", "Argentine peso | \n", "3.525000e+09 | \n", "C | \n", "3.525000e+09 | \n", "8.007000e+08 | \n", "
2 | \n", "Argentina | \n", "Manufacturing | \n", "1993 | \n", "Argentine peso | \n", "3.890700e+10 | \n", "D | \n", "3.890700e+10 | \n", "1.766600e+10 | \n", "
\n", " | country | \n", "year | \n", "
---|---|---|
0 | \n", "Argentina | \n", "1993 | \n", "
1 | \n", "Argentina | \n", "1993 | \n", "
2 | \n", "Argentina | \n", "1993 | \n", "
3 | \n", "Argentina | \n", "1993 | \n", "
4 | \n", "Argentina | \n", "1993 | \n", "
5 | \n", "Argentina | \n", "1993 | \n", "
6 | \n", "Argentina | \n", "1993 | \n", "
7 | \n", "Argentina | \n", "1993 | \n", "
8 | \n", "Argentina | \n", "1993 | \n", "
9 | \n", "Argentina | \n", "1994 | \n", "
10 | \n", "Argentina | \n", "1994 | \n", "
11 | \n", "Argentina | \n", "1994 | \n", "
12 | \n", "Argentina | \n", "1994 | \n", "
13 | \n", "Argentina | \n", "1994 | \n", "
14 | \n", "Argentina | \n", "1994 | \n", "
15 | \n", "Argentina | \n", "1994 | \n", "
16 | \n", "Argentina | \n", "1994 | \n", "
17 | \n", "Argentina | \n", "1994 | \n", "
18 | \n", "Argentina | \n", "1995 | \n", "
19 | \n", "Argentina | \n", "1995 | \n", "
20 | \n", "Argentina | \n", "1995 | \n", "
21 | \n", "Argentina | \n", "1995 | \n", "
22 | \n", "Argentina | \n", "1995 | \n", "
23 | \n", "Argentina | \n", "1995 | \n", "
24 | \n", "Argentina | \n", "1995 | \n", "
25 | \n", "Argentina | \n", "1995 | \n", "
26 | \n", "Argentina | \n", "1995 | \n", "
27 | \n", "Argentina | \n", "1996 | \n", "
28 | \n", "Argentina | \n", "1996 | \n", "
29 | \n", "Argentina | \n", "1996 | \n", "
... | \n", "... | \n", "... | \n", "
4209 | \n", "Venezuela | \n", "1998 | \n", "
4210 | \n", "Venezuela | \n", "1999 | \n", "
4211 | \n", "Venezuela | \n", "1999 | \n", "
4212 | \n", "Venezuela | \n", "1999 | \n", "
4213 | \n", "Venezuela | \n", "1999 | \n", "
4214 | \n", "Venezuela | \n", "1999 | \n", "
4215 | \n", "Venezuela | \n", "1999 | \n", "
4216 | \n", "Venezuela | \n", "1999 | \n", "
4217 | \n", "Venezuela | \n", "1999 | \n", "
4218 | \n", "Venezuela | \n", "1999 | \n", "
4219 | \n", "Venezuela | \n", "2000 | \n", "
4220 | \n", "Venezuela | \n", "2000 | \n", "
4221 | \n", "Venezuela | \n", "2000 | \n", "
4222 | \n", "Venezuela | \n", "2000 | \n", "
4223 | \n", "Venezuela | \n", "2000 | \n", "
4224 | \n", "Venezuela | \n", "2000 | \n", "
4225 | \n", "Venezuela | \n", "2000 | \n", "
4226 | \n", "Venezuela | \n", "2000 | \n", "
4227 | \n", "Venezuela | \n", "2000 | \n", "
4228 | \n", "Venezuela | \n", "2001 | \n", "
4229 | \n", "Venezuela | \n", "2001 | \n", "
4230 | \n", "Venezuela | \n", "2001 | \n", "
4231 | \n", "Venezuela | \n", "2001 | \n", "
4232 | \n", "Venezuela | \n", "2001 | \n", "
4233 | \n", "Venezuela | \n", "2001 | \n", "
4234 | \n", "Venezuela | \n", "2001 | \n", "
4235 | \n", "Venezuela | \n", "2001 | \n", "
4236 | \n", "Venezuela | \n", "2001 | \n", "
4237 | \n", "Venezuela | \n", "2002 | \n", "
4238 | \n", "Venezuela | \n", "2002 | \n", "
4239 rows \u00d7 2 columns
\n", "\n", " | year | \n", "VA1 | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|
count | \n", "4239.000000 | \n", "4.239000e+03 | \n", "4.233000e+03 | \n", "4.239000e+03 | \n", "
mean | \n", "1989.912715 | \n", "1.802346e+12 | \n", "1.801822e+12 | \n", "6.371376e+11 | \n", "
std | \n", "11.140271 | \n", "1.086676e+13 | \n", "1.087452e+13 | \n", "3.957470e+12 | \n", "
min | \n", "1966.000000 | \n", "2.000000e+00 | \n", "0.000000e+00 | \n", "1.000000e+00 | \n", "
25% | \n", "1981.000000 | \n", "8.538500e+09 | \n", "8.513000e+09 | \n", "2.773500e+09 | \n", "
50% | \n", "1991.000000 | \n", "4.565900e+10 | \n", "4.565900e+10 | \n", "1.555100e+10 | \n", "
75% | \n", "1999.000000 | \n", "2.597610e+11 | \n", "2.601340e+11 | \n", "9.198150e+10 | \n", "
max | \n", "2010.000000 | \n", "2.711389e+14 | \n", "2.711389e+14 | \n", "9.220360e+13 | \n", "
\n", " | country | \n", "sub_item | \n", "currency | \n", "VA1 | \n", "code | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|
year | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1993 | \n", "Argentina | \n", "Agriculture, hunting, forestry fishing | \n", "Argentine peso | \n", "1.214900e+10 | \n", "AB | \n", "1.214900e+10 | \n", "2.123000e+09 | \n", "
1993 | \n", "Argentina | \n", "Mining and quarrying | \n", "Argentine peso | \n", "3.525000e+09 | \n", "C | \n", "3.525000e+09 | \n", "8.007000e+08 | \n", "
1993 | \n", "Argentina | \n", "Manufacturing | \n", "Argentine peso | \n", "3.890700e+10 | \n", "D | \n", "3.890700e+10 | \n", "1.766600e+10 | \n", "
1993 | \n", "Argentina | \n", "Electricity, gas and water supply | \n", "Argentine peso | \n", "4.461000e+09 | \n", "E | \n", "4.461000e+09 | \n", "2.213000e+09 | \n", "
1993 | \n", "Argentina | \n", "Construction | \n", "Argentine peso | \n", "1.339300e+10 | \n", "F | \n", "1.339300e+10 | \n", "4.355000e+09 | \n", "
1993 | \n", "Argentina | \n", "Wholesale retail trade, repair of motor vehicl... | \n", "Argentine peso | \n", "3.929400e+10 | \n", "GH | \n", "3.929400e+10 | \n", "1.092000e+10 | \n", "
1993 | \n", "Argentina | \n", "Transport, storage and communications | \n", "Argentine peso | \n", "1.613400e+10 | \n", "I | \n", "1.613400e+10 | \n", "6.213000e+09 | \n", "
1993 | \n", "Argentina | \n", "Financial intermediation real estate, renting ... | \n", "Argentine peso | \n", "4.320200e+10 | \n", "JK | \n", "4.320200e+10 | \n", "8.039000e+09 | \n", "
1993 | \n", "Argentina | \n", "Total Economy | \n", "Argentine peso | \n", "2.166090e+11 | \n", "TOT | \n", "2.117210e+11 | \n", "8.955300e+10 | \n", "
1993 | \n", "Bolivia | \n", "Total Economy | \n", "boliviano | \n", "2.255600e+10 | \n", "TOT | \n", "2.255600e+10 | \n", "8.821000e+09 | \n", "
1993 | \n", "Brazil | \n", "Agriculture, hunting, forestry fishing | \n", "real | \n", "9.560000e+08 | \n", "AB | \n", "9.560000e+08 | \n", "1.960000e+08 | \n", "
1993 | \n", "Brazil | \n", "Mining and quarrying | \n", "real | \n", "1.480000e+08 | \n", "C | \n", "1.480000e+08 | \n", "3.600000e+07 | \n", "
1993 | \n", "Brazil | \n", "Manufacturing | \n", "real | \n", "3.672000e+09 | \n", "D | \n", "3.672000e+09 | \n", "1.006000e+09 | \n", "
1993 | \n", "Brazil | \n", "Electricity, gas and water supply | \n", "real | \n", "3.930000e+08 | \n", "E | \n", "3.930000e+08 | \n", "2.480000e+08 | \n", "
1993 | \n", "Brazil | \n", "Construction | \n", "real | \n", "1.044000e+09 | \n", "F | \n", "1.044000e+09 | \n", "2.050000e+08 | \n", "
1993 | \n", "Brazil | \n", "Wholesale retail trade, repair of motor vehicl... | \n", "real | \n", "1.172000e+09 | \n", "GH | \n", "1.172000e+09 | \n", "4.960000e+08 | \n", "
1993 | \n", "Brazil | \n", "Transport, storage and communications | \n", "real | \n", "6.820000e+08 | \n", "I | \n", "6.820000e+08 | \n", "3.250000e+08 | \n", "
1993 | \n", "Brazil | \n", "Financial intermediation real estate, renting ... | \n", "real | \n", "5.559000e+09 | \n", "JK | \n", "5.559000e+09 | \n", "1.460000e+09 | \n", "
1993 | \n", "Brazil | \n", "Total Economy | \n", "real | \n", "1.655200e+10 | \n", "TOT | \n", "1.655200e+10 | \n", "6.363000e+09 | \n", "
1993 | \n", "Chile | \n", "Total Economy | \n", "Chilean peso | \n", "1.660178e+13 | \n", "TOT | \n", "1.660178e+13 | \n", "6.582086e+12 | \n", "
1993 | \n", "Colombia | \n", "Agriculture, hunting, forestry fishing | \n", "Colombian peso | \n", "7.823940e+12 | \n", "AB | \n", "7.823937e+12 | \n", "1.544580e+12 | \n", "
1993 | \n", "Colombia | \n", "Mining and quarrying | \n", "Colombian peso | \n", "2.237211e+12 | \n", "C | \n", "2.237211e+12 | \n", "6.405010e+11 | \n", "
1993 | \n", "Colombia | \n", "Manufacturing | \n", "Colombian peso | \n", "8.275730e+12 | \n", "D | \n", "8.275730e+12 | \n", "3.349123e+12 | \n", "
1993 | \n", "Colombia | \n", "Electricity, gas and water supply | \n", "Colombian peso | \n", "1.607909e+12 | \n", "E | \n", "1.607909e+12 | \n", "4.512400e+11 | \n", "
1993 | \n", "Colombia | \n", "Construction | \n", "Colombian peso | \n", "3.648933e+12 | \n", "F | \n", "3.648933e+12 | \n", "1.326030e+12 | \n", "
1993 | \n", "Colombia | \n", "Wholesale retail trade, repair of motor vehicl... | \n", "Colombian peso | \n", "6.521734e+12 | \n", "GH | \n", "6.521734e+12 | \n", "2.652296e+12 | \n", "
1993 | \n", "Colombia | \n", "Transport, storage and communications | \n", "Colombian peso | \n", "3.750715e+12 | \n", "I | \n", "3.750715e+12 | \n", "1.697697e+12 | \n", "
1993 | \n", "Colombia | \n", "Financial intermediation real estate, renting ... | \n", "Colombian peso | \n", "8.494946e+12 | \n", "JK | \n", "8.494946e+12 | \n", "1.571843e+12 | \n", "
1993 | \n", "Colombia | \n", "Total Economy | \n", "Colombian peso | \n", "5.059828e+13 | \n", "TOT | \n", "5.059828e+13 | \n", "1.882861e+13 | \n", "
1993 | \n", "Denmark | \n", "Agriculture, hunting, forestry fishing | \n", "Danish krone | \n", "2.584700e+10 | \n", "AB | \n", "2.584700e+10 | \n", "6.645000e+09 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1993 | \n", "Spain | \n", "Financial intermediation real estate, renting ... | \n", "peseta | \n", "1.106390e+13 | \n", "JK | \n", "1.106390e+13 | \n", "3.062300e+12 | \n", "
1993 | \n", "Spain | \n", "Total Economy | \n", "peseta | \n", "6.162560e+13 | \n", "TOT | \n", "6.162560e+13 | \n", "3.006070e+13 | \n", "
1993 | \n", "Sweden | \n", "Agriculture, hunting, forestry fishing | \n", "Swedish krona | \n", "2.749800e+10 | \n", "AB | \n", "2.749800e+10 | \n", "8.543000e+09 | \n", "
1993 | \n", "Sweden | \n", "Mining and quarrying | \n", "Swedish krona | \n", "3.467000e+09 | \n", "C | \n", "3.467000e+09 | \n", "2.414000e+09 | \n", "
1993 | \n", "Sweden | \n", "Manufacturing | \n", "Swedish krona | \n", "2.601340e+11 | \n", "D | \n", "2.601340e+11 | \n", "1.779260e+11 | \n", "
1993 | \n", "Sweden | \n", "Electricity, gas and water supply | \n", "Swedish krona | \n", "4.278100e+10 | \n", "E | \n", "4.278100e+10 | \n", "8.195000e+09 | \n", "
1993 | \n", "Sweden | \n", "Construction | \n", "Swedish krona | \n", "7.949000e+10 | \n", "F | \n", "7.949000e+10 | \n", "6.192000e+10 | \n", "
1993 | \n", "Sweden | \n", "Wholesale retail trade, repair of motor vehicl... | \n", "Swedish krona | \n", "1.396150e+11 | \n", "GH | \n", "1.396150e+11 | \n", "1.110160e+11 | \n", "
1993 | \n", "Sweden | \n", "Transport, storage and communications | \n", "Swedish krona | \n", "8.499200e+10 | \n", "I | \n", "8.499200e+10 | \n", "5.889300e+10 | \n", "
1993 | \n", "Sweden | \n", "Financial intermediation real estate, renting ... | \n", "Swedish krona | \n", "3.169450e+11 | \n", "JK | \n", "3.169450e+11 | \n", "9.304900e+10 | \n", "
1993 | \n", "Sweden | \n", "Total Economy | \n", "Swedish krona | \n", "1.328816e+12 | \n", "TOT | \n", "1.328816e+12 | \n", "8.516030e+11 | \n", "
1993 | \n", "Thailand | \n", "Agriculture, hunting, forestry fishing | \n", "baht | \n", "2.739010e+11 | \n", "AB | \n", "2.739010e+11 | \n", "3.091700e+10 | \n", "
1993 | \n", "Thailand | \n", "Mining and quarrying | \n", "baht | \n", "3.778900e+10 | \n", "C | \n", "3.778900e+10 | \n", "5.041000e+09 | \n", "
1993 | \n", "Thailand | \n", "Manufacturing | \n", "baht | \n", "7.990670e+11 | \n", "D | \n", "7.990670e+11 | \n", "2.956290e+11 | \n", "
1993 | \n", "Thailand | \n", "Electricity, gas and water supply | \n", "baht | \n", "7.315900e+10 | \n", "E | \n", "7.315900e+10 | \n", "1.835000e+10 | \n", "
1993 | \n", "Thailand | \n", "Construction | \n", "baht | \n", "2.109040e+11 | \n", "F | \n", "2.109040e+11 | \n", "8.201700e+10 | \n", "
1993 | \n", "Thailand | \n", "Wholesale retail trade, repair of motor vehicl... | \n", "baht | \n", "3.711790e+11 | \n", "GH | \n", "3.711790e+11 | \n", "5.910000e+10 | \n", "
1993 | \n", "Thailand | \n", "Transport, storage and communications | \n", "baht | \n", "2.366030e+11 | \n", "I | \n", "2.366030e+11 | \n", "5.369300e+10 | \n", "
1993 | \n", "Thailand | \n", "Financial intermediation real estate, renting ... | \n", "baht | \n", "2.778150e+11 | \n", "JK | \n", "2.778150e+11 | \n", "6.928200e+10 | \n", "
1993 | \n", "Thailand | \n", "Total Economy | \n", "baht | \n", "2.784561e+12 | \n", "TOT | \n", "2.784561e+12 | \n", "8.666570e+11 | \n", "
1993 | \n", "Turkey | \n", "Total Economy | \n", "New Turkish lira | \n", "1.976292e+09 | \n", "TOT | \n", "1.976292e+09 | \n", "6.119037e+08 | \n", "
1993 | \n", "Venezuela | \n", "Agriculture, hunting, forestry fishing | \n", "bolivar | \n", "2.916830e+11 | \n", "AB | \n", "2.916830e+11 | \n", "7.117200e+10 | \n", "
1993 | \n", "Venezuela | \n", "Mining and quarrying | \n", "bolivar | \n", "8.411670e+11 | \n", "C | \n", "8.411670e+11 | \n", "9.630300e+10 | \n", "
1993 | \n", "Venezuela | \n", "Manufacturing | \n", "bolivar | \n", "9.605900e+11 | \n", "D | \n", "9.605900e+11 | \n", "2.825770e+11 | \n", "
1993 | \n", "Venezuela | \n", "Electricity, gas and water supply | \n", "bolivar | \n", "1.420870e+11 | \n", "E | \n", "1.420870e+11 | \n", "3.532400e+10 | \n", "
1993 | \n", "Venezuela | \n", "Construction | \n", "bolivar | \n", "3.322990e+11 | \n", "F | \n", "3.322990e+11 | \n", "1.072110e+11 | \n", "
1993 | \n", "Venezuela | \n", "Wholesale retail trade, repair of motor vehicl... | \n", "bolivar | \n", "1.045332e+12 | \n", "GH | \n", "1.045332e+12 | \n", "4.531180e+11 | \n", "
1993 | \n", "Venezuela | \n", "Transport, storage and communications | \n", "bolivar | \n", "4.044280e+11 | \n", "I | \n", "4.044280e+11 | \n", "1.226970e+11 | \n", "
1993 | \n", "Venezuela | \n", "Financial intermediation real estate, renting ... | \n", "bolivar | \n", "6.991300e+11 | \n", "JK | \n", "6.991300e+11 | \n", "1.585720e+11 | \n", "
1993 | \n", "Venezuela | \n", "Total Economy | \n", "bolivar | \n", "5.449065e+12 | \n", "TOT | \n", "5.449065e+12 | \n", "1.863825e+12 | \n", "
120 rows \u00d7 7 columns
\n", "\n", " | \n", " | \n", " | sub_item | \n", "currency | \n", "VA1 | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|
year | \n", "country | \n", "code | \n", "\n", " | \n", " | \n", " | \n", " | \n", " |
1993 | \n", "Argentina | \n", "AB | \n", "Agriculture, hunting, forestry fishing | \n", "Argentine peso | \n", "1.214900e+10 | \n", "1.214900e+10 | \n", "2.123000e+09 | \n", "
C | \n", "Mining and quarrying | \n", "Argentine peso | \n", "3.525000e+09 | \n", "3.525000e+09 | \n", "8.007000e+08 | \n", "||
D | \n", "Manufacturing | \n", "Argentine peso | \n", "3.890700e+10 | \n", "3.890700e+10 | \n", "1.766600e+10 | \n", "||
E | \n", "Electricity, gas and water supply | \n", "Argentine peso | \n", "4.461000e+09 | \n", "4.461000e+09 | \n", "2.213000e+09 | \n", "||
F | \n", "Construction | \n", "Argentine peso | \n", "1.339300e+10 | \n", "1.339300e+10 | \n", "4.355000e+09 | \n", "
\n", " | \n", " | \n", " | sub_item | \n", "currency | \n", "VA1 | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|
year | \n", "country | \n", "code | \n", "\n", " | \n", " | \n", " | \n", " | \n", " |
1966 | \n", "Denmark | \n", "AB | \n", "Agriculture, hunting, forestry fishing | \n", "Danish krone | \n", "5.694000e+09 | \n", "5.694000e+09 | \n", "1.191000e+09 | \n", "
C | \n", "Mining and quarrying | \n", "Danish krone | \n", "2.530000e+08 | \n", "2.530000e+08 | \n", "8.000000e+07 | \n", "||
D | \n", "Manufacturing | \n", "Danish krone | \n", "1.543800e+10 | \n", "1.543800e+10 | \n", "1.095700e+10 | \n", "||
E | \n", "Electricity, gas and water supply | \n", "Danish krone | \n", "1.320000e+09 | \n", "1.320000e+09 | \n", "3.430000e+08 | \n", "||
F | \n", "Construction | \n", "Danish krone | \n", "6.928000e+09 | \n", "6.928000e+09 | \n", "4.857000e+09 | \n", "
\n", " | \n", " | \n", " | sub_item | \n", "currency | \n", "VA1 | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|
year | \n", "country | \n", "code | \n", "\n", " | \n", " | \n", " | \n", " | \n", " |
1966 | \n", "Denmark | \n", "AB | \n", "Agriculture, hunting, forestry fishing | \n", "Danish krone | \n", "5.694000e+09 | \n", "5.694000e+09 | \n", "1.191000e+09 | \n", "
1967 | \n", "Denmark | \n", "AB | \n", "Agriculture, hunting, forestry fishing | \n", "Danish krone | \n", "5.419000e+09 | \n", "5.419000e+09 | \n", "1.213000e+09 | \n", "
1968 | \n", "Denmark | \n", "AB | \n", "Agriculture, hunting, forestry fishing | \n", "Danish krone | \n", "5.686000e+09 | \n", "5.686000e+09 | \n", "1.221000e+09 | \n", "
1969 | \n", "Denmark | \n", "AB | \n", "Agriculture, hunting, forestry fishing | \n", "Danish krone | \n", "6.707000e+09 | \n", "6.707000e+09 | \n", "1.245000e+09 | \n", "
1970 | \n", "Bolivia | \n", "AB | \n", "Agriculture, hunting, forestry fishing | \n", "boliviano | \n", "2.240000e+03 | \n", "2.000000e+03 | \n", "4.030000e+02 | \n", "
\n", " | country | \n", "year | \n", "VA1 | \n", "
---|---|---|---|
0 | \n", "Argentina | \n", "1993 | \n", "1.214900e+10 | \n", "
1 | \n", "Argentina | \n", "1993 | \n", "3.525000e+09 | \n", "
2 | \n", "Argentina | \n", "1993 | \n", "3.890700e+10 | \n", "
3 | \n", "Argentina | \n", "1993 | \n", "4.461000e+09 | \n", "
4 | \n", "Argentina | \n", "1993 | \n", "1.339300e+10 | \n", "
5 | \n", "Argentina | \n", "1993 | \n", "3.929400e+10 | \n", "
6 | \n", "Argentina | \n", "1993 | \n", "1.613400e+10 | \n", "
7 | \n", "Argentina | \n", "1993 | \n", "4.320200e+10 | \n", "
8 | \n", "Argentina | \n", "1993 | \n", "2.166090e+11 | \n", "
9 | \n", "Argentina | \n", "1994 | \n", "1.308500e+10 | \n", "
10 | \n", "Argentina | \n", "1994 | \n", "3.818000e+09 | \n", "
11 | \n", "Argentina | \n", "1994 | \n", "4.159600e+10 | \n", "
12 | \n", "Argentina | \n", "1994 | \n", "4.730000e+09 | \n", "
13 | \n", "Argentina | \n", "1994 | \n", "1.431100e+10 | \n", "
14 | \n", "Argentina | \n", "1994 | \n", "4.279800e+10 | \n", "
15 | \n", "Argentina | \n", "1994 | \n", "1.825100e+10 | \n", "
16 | \n", "Argentina | \n", "1994 | \n", "4.859900e+10 | \n", "
17 | \n", "Argentina | \n", "1994 | \n", "2.358460e+11 | \n", "
18 | \n", "Argentina | \n", "1995 | \n", "1.380850e+10 | \n", "
19 | \n", "Argentina | \n", "1995 | \n", "4.838400e+09 | \n", "
20 | \n", "Argentina | \n", "1995 | \n", "4.450210e+10 | \n", "
21 | \n", "Argentina | \n", "1995 | \n", "5.111000e+09 | \n", "
22 | \n", "Argentina | \n", "1995 | \n", "1.341400e+10 | \n", "
23 | \n", "Argentina | \n", "1995 | \n", "4.119850e+10 | \n", "
24 | \n", "Argentina | \n", "1995 | \n", "1.905990e+10 | \n", "
25 | \n", "Argentina | \n", "1995 | \n", "5.133940e+10 | \n", "
26 | \n", "Argentina | \n", "1995 | \n", "2.423343e+11 | \n", "
27 | \n", "Argentina | \n", "1996 | \n", "1.527000e+10 | \n", "
28 | \n", "Argentina | \n", "1996 | \n", "5.888900e+09 | \n", "
29 | \n", "Argentina | \n", "1996 | \n", "4.772340e+10 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
4209 | \n", "Venezuela | \n", "1998 | \n", "5.057137e+13 | \n", "
4210 | \n", "Venezuela | \n", "1999 | \n", "2.880633e+12 | \n", "
4211 | \n", "Venezuela | \n", "1999 | \n", "8.321318e+12 | \n", "
4212 | \n", "Venezuela | \n", "1999 | \n", "8.204542e+12 | \n", "
4213 | \n", "Venezuela | \n", "1999 | \n", "9.316080e+11 | \n", "
4214 | \n", "Venezuela | \n", "1999 | \n", "3.400098e+12 | \n", "
4215 | \n", "Venezuela | \n", "1999 | \n", "9.794983e+12 | \n", "
4216 | \n", "Venezuela | \n", "1999 | \n", "5.716383e+12 | \n", "
4217 | \n", "Venezuela | \n", "1999 | \n", "9.124555e+12 | \n", "
4218 | \n", "Venezuela | \n", "1999 | \n", "6.033646e+13 | \n", "
4219 | \n", "Venezuela | \n", "2000 | \n", "3.258018e+12 | \n", "
4220 | \n", "Venezuela | \n", "2000 | \n", "1.591774e+13 | \n", "
4221 | \n", "Venezuela | \n", "2000 | \n", "1.062152e+13 | \n", "
4222 | \n", "Venezuela | \n", "2000 | \n", "1.137058e+12 | \n", "
4223 | \n", "Venezuela | \n", "2000 | \n", "3.842038e+12 | \n", "
4224 | \n", "Venezuela | \n", "2000 | \n", "1.168852e+13 | \n", "
4225 | \n", "Venezuela | \n", "2000 | \n", "6.920770e+12 | \n", "
4226 | \n", "Venezuela | \n", "2000 | \n", "1.100281e+13 | \n", "
4227 | \n", "Venezuela | \n", "2000 | \n", "7.974029e+13 | \n", "
4228 | \n", "Venezuela | \n", "2001 | \n", "3.872766e+12 | \n", "
4229 | \n", "Venezuela | \n", "2001 | \n", "1.321210e+13 | \n", "
4230 | \n", "Venezuela | \n", "2001 | \n", "1.095207e+13 | \n", "
4231 | \n", "Venezuela | \n", "2001 | \n", "1.355214e+12 | \n", "
4232 | \n", "Venezuela | \n", "2001 | \n", "5.032111e+12 | \n", "
4233 | \n", "Venezuela | \n", "2001 | \n", "1.347735e+13 | \n", "
4234 | \n", "Venezuela | \n", "2001 | \n", "8.063945e+12 | \n", "
4235 | \n", "Venezuela | \n", "2001 | \n", "1.334013e+13 | \n", "
4236 | \n", "Venezuela | \n", "2001 | \n", "8.804319e+13 | \n", "
4237 | \n", "Venezuela | \n", "2002 | \n", "4.549229e+12 | \n", "
4238 | \n", "Venezuela | \n", "2002 | \n", "1.074291e+14 | \n", "
4239 rows \u00d7 3 columns
\n", "\n", " | index | \n", "country | \n", "sub_item | \n", "year | \n", "currency | \n", "VA1 | \n", "code | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "Argentina | \n", "Agriculture, hunting, forestry fishing | \n", "1993 | \n", "Argentine peso | \n", "1.214900e+10 | \n", "AB | \n", "1.214900e+10 | \n", "2.123000e+09 | \n", "
0 | \n", "0 | \n", "Argentina | \n", "Agriculture, hunting, forestry fishing | \n", "1993 | \n", "Argentine peso | \n", "1.214900e+10 | \n", "AB | \n", "1.214900e+10 | \n", "2.123000e+09 | \n", "
\n", " | index | \n", "country | \n", "sub_item | \n", "year | \n", "currency | \n", "VA1 | \n", "code | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|---|---|
559 | \n", "559 | \n", "Chile | \n", "Mining and quarrying | \n", "2009 | \n", "Chilean peso | \n", "1.404654e+13 | \n", "C | \n", "1.404654e+13 | \n", "1.588307e+12 | \n", "
560 | \n", "560 | \n", "Chile | \n", "Manufacturing | \n", "2009 | \n", "Chilean peso | \n", "1.126610e+13 | \n", "D | \n", "1.126610e+13 | \n", "3.666442e+12 | \n", "
561 | \n", "561 | \n", "Chile | \n", "Electricity, gas and water supply | \n", "2009 | \n", "Chilean peso | \n", "3.633492e+12 | \n", "E | \n", "3.633492e+12 | \n", "3.030204e+11 | \n", "
562 | \n", "562 | \n", "Chile | \n", "Construction | \n", "2009 | \n", "Chilean peso | \n", "6.804767e+12 | \n", "F | \n", "6.804767e+12 | \n", "4.335883e+12 | \n", "
563 | \n", "563 | \n", "Chile | \n", "Wholesale retail trade, repair of motor vehicl... | \n", "2009 | \n", "Chilean peso | \n", "8.163060e+12 | \n", "GH | \n", "8.163060e+12 | \n", "5.358225e+12 | \n", "
564 | \n", "564 | \n", "Chile | \n", "Transport, storage and communications | \n", "2009 | \n", "Chilean peso | \n", "6.600354e+12 | \n", "I | \n", "6.600354e+12 | \n", "2.894256e+12 | \n", "
565 | \n", "565 | \n", "Chile | \n", "Financial intermediation real estate, renting ... | \n", "2009 | \n", "Chilean peso | \n", "1.819692e+13 | \n", "JK | \n", "1.819692e+13 | \n", "5.991782e+12 | \n", "
566 | \n", "566 | \n", "Chile | \n", "Total Economy | \n", "2009 | \n", "Chilean peso | \n", "8.650220e+13 | \n", "TOT | \n", "8.650220e+13 | \n", "3.658516e+13 | \n", "
269 | \n", "269 | \n", "Bolivia | \n", "Total Economy | \n", "2009 | \n", "boliviano | \n", "1.021160e+11 | \n", "TOT | \n", "1.021160e+11 | \n", "3.381017e+10 | \n", "
270 | \n", "270 | \n", "Bolivia | \n", "Total Economy | \n", "2010 | \n", "boliviano | \n", "1.159344e+11 | \n", "TOT | \n", "1.159344e+11 | \n", "3.647705e+10 | \n", "
\n", " | country | \n", "code | \n", "year | \n", "
---|---|---|---|
0 | \n", "Argentina | \n", "AB | \n", "1993 | \n", "
1 | \n", "ArgentinaArgentina | \n", "ABC | \n", "3986 | \n", "
2 | \n", "ArgentinaArgentinaArgentina | \n", "ABCD | \n", "5979 | \n", "
3 | \n", "ArgentinaArgentinaArgentinaArgentina | \n", "ABCDE | \n", "7972 | \n", "
4 | \n", "ArgentinaArgentinaArgentinaArgentinaArgentina | \n", "ABCDEF | \n", "9965 | \n", "
\n", " | index | \n", "country | \n", "sub_item | \n", "year | \n", "currency | \n", "VA1 | \n", "code | \n", "VA2 | \n", "WAGE1 | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "Argentina | \n", "Agriculture, hunting, forestry fishing | \n", "1993 | \n", "Argentine peso | \n", "1.214900e+10 | \n", "AB | \n", "1.214900e+10 | \n", "2.123000e+09 | \n", "
1 | \n", "1 | \n", "Argentina | \n", "Mining and quarrying | \n", "1993 | \n", "Argentine peso | \n", "3.525000e+09 | \n", "C | \n", "3.525000e+09 | \n", "8.007000e+08 | \n", "
2 | \n", "2 | \n", "Argentina | \n", "Manufacturing | \n", "1993 | \n", "Argentine peso | \n", "3.890700e+10 | \n", "D | \n", "3.890700e+10 | \n", "1.766600e+10 | \n", "
3 | \n", "3 | \n", "Argentina | \n", "Electricity, gas and water supply | \n", "1993 | \n", "Argentine peso | \n", "4.461000e+09 | \n", "E | \n", "4.461000e+09 | \n", "2.213000e+09 | \n", "
4 | \n", "4 | \n", "Argentina | \n", "Construction | \n", "1993 | \n", "Argentine peso | \n", "1.339300e+10 | \n", "F | \n", "1.339300e+10 | \n", "4.355000e+09 | \n", "
\n", " | index | \n", "code | \n", "VA1 | \n", "
---|---|---|---|
0 | \n", "Argentina-1993 | \n", "AB | \n", "1.214900e+10 | \n", "
1 | \n", "Argentina-1993 | \n", "C | \n", "3.525000e+09 | \n", "
2 | \n", "Argentina-1993 | \n", "D | \n", "3.890700e+10 | \n", "
3 | \n", "Argentina-1993 | \n", "E | \n", "4.461000e+09 | \n", "
4 | \n", "Argentina-1993 | \n", "F | \n", "1.339300e+10 | \n", "
code | \n", "AB | \n", "C | \n", "D | \n", "E | \n", "F | \n", "GH | \n", "I | \n", "JK | \n", "TOT | \n", "
---|---|---|---|---|---|---|---|---|---|
index | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Argentina-1993 | \n", "1.214900e+10 | \n", "3.525000e+09 | \n", "3.890700e+10 | \n", "4.461000e+09 | \n", "1.339300e+10 | \n", "3.929400e+10 | \n", "1.613400e+10 | \n", "4.320200e+10 | \n", "2.166090e+11 | \n", "
Argentina-1994 | \n", "1.308500e+10 | \n", "3.818000e+09 | \n", "4.159600e+10 | \n", "4.730000e+09 | \n", "1.431100e+10 | \n", "4.279800e+10 | \n", "1.825100e+10 | \n", "4.859900e+10 | \n", "2.358460e+11 | \n", "
Argentina-1995 | \n", "1.380850e+10 | \n", "4.838400e+09 | \n", "4.450210e+10 | \n", "5.111000e+09 | \n", "1.341400e+10 | \n", "4.119850e+10 | \n", "1.905990e+10 | \n", "5.133940e+10 | \n", "2.423343e+11 | \n", "
Argentina-1996 | \n", "1.527000e+10 | \n", "5.888900e+09 | \n", "4.772340e+10 | \n", "5.232400e+09 | \n", "1.352680e+10 | \n", "4.454100e+10 | \n", "2.050140e+10 | \n", "5.237490e+10 | \n", "2.546081e+11 | \n", "
Argentina-1997 | \n", "1.529300e+10 | \n", "5.632500e+09 | \n", "5.338210e+10 | \n", "5.501700e+09 | \n", "1.508030e+10 | \n", "4.912050e+10 | \n", "2.295190e+10 | \n", "5.468300e+10 | \n", "2.730922e+11 | \n", "
code | \n", "AB | \n", "C | \n", "D | \n", "E | \n", "F | \n", "GH | \n", "I | \n", "JK | \n", "TOT | \n", "
---|---|---|---|---|---|---|---|---|---|
index | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Venezuela-1998 | \n", "2.461132e+12 | \n", "5.412143e+12 | \n", "7.463681e+12 | \n", "8.678680e+11 | \n", "3.443028e+12 | \n", "8.775614e+12 | \n", "4.893346e+12 | \n", "7.898823e+12 | \n", "5.057137e+13 | \n", "
Venezuela-1999 | \n", "2.880633e+12 | \n", "8.321318e+12 | \n", "8.204542e+12 | \n", "9.316080e+11 | \n", "3.400098e+12 | \n", "9.794983e+12 | \n", "5.716383e+12 | \n", "9.124555e+12 | \n", "6.033646e+13 | \n", "
Venezuela-2000 | \n", "3.258018e+12 | \n", "1.591774e+13 | \n", "1.062152e+13 | \n", "1.137058e+12 | \n", "3.842038e+12 | \n", "1.168852e+13 | \n", "6.920770e+12 | \n", "1.100281e+13 | \n", "7.974029e+13 | \n", "
Venezuela-2001 | \n", "3.872766e+12 | \n", "1.321210e+13 | \n", "1.095207e+13 | \n", "1.355214e+12 | \n", "5.032111e+12 | \n", "1.347735e+13 | \n", "8.063945e+12 | \n", "1.334013e+13 | \n", "8.804319e+13 | \n", "
Venezuela-2002 | \n", "4.549229e+12 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1.074291e+14 | \n", "