{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "4a5ca34c", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 27, "id": "f3029fdc", "metadata": {}, "outputs": [], "source": [ "wb= pd.read_csv('API_NY.GDP.MKTP.CD_DS2_en_csv_v2_2445719.csv', skiprows=4)\n", "sc= pd.read_excel('scimagojr country rank 1996-2020.xlsx',index_col= 'Country')\n", "ei= pd.read_excel('energy Indicators.xls',skiprows=17, skipfooter=38)" ] }, { "cell_type": "code", "execution_count": 3, "id": "2e4b47f4", "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", "
Unnamed: 0Unnamed: 1Unnamed: 2PetajoulesGigajoules%
0NaNAfghanistanAfghanistan3211078.669280
1NaNAlbaniaAlbania10235100.000000
2NaNAlgeriaAlgeria1959510.551010
3NaNAmerican SamoaAmerican Samoa......0.641026
4NaNAndorraAndorra912188.695650
.....................
222NaNViet NamViet Nam25542845.321520
223NaNWallis and Futuna IslandsWallis and Futuna Islands0260.000000
224NaNYemenYemen344130.000000
225NaNZambiaZambia4002699.714670
226NaNZimbabweZimbabwe4803252.536120
\n", "

227 rows × 6 columns

\n", "
" ], "text/plain": [ " Unnamed: 0 Unnamed: 1 Unnamed: 2 \\\n", "0 NaN Afghanistan Afghanistan \n", "1 NaN Albania Albania \n", "2 NaN Algeria Algeria \n", "3 NaN American Samoa American Samoa \n", "4 NaN Andorra Andorra \n", ".. ... ... ... \n", "222 NaN Viet Nam Viet Nam \n", "223 NaN Wallis and Futuna Islands Wallis and Futuna Islands \n", "224 NaN Yemen Yemen \n", "225 NaN Zambia Zambia \n", "226 NaN Zimbabwe Zimbabwe \n", "\n", " Petajoules Gigajoules % \n", "0 321 10 78.669280 \n", "1 102 35 100.000000 \n", "2 1959 51 0.551010 \n", "3 ... ... 0.641026 \n", "4 9 121 88.695650 \n", ".. ... ... ... \n", "222 2554 28 45.321520 \n", "223 0 26 0.000000 \n", "224 344 13 0.000000 \n", "225 400 26 99.714670 \n", "226 480 32 52.536120 \n", "\n", "[227 rows x 6 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ei" ] }, { "cell_type": "code", "execution_count": 4, "id": "edd679d7", "metadata": {}, "outputs": [], "source": [ "columns= ['Rank', 'Documents', 'Citable documents', 'Citations', 'Self-citations', \\\n", " 'Citations per document', 'H index', 'Energy Supply', 'Energy Supply per Capita', \\\n", " '% Renewable', '2006', '2007', '2008', '2009', '2010', '2011', '2012', '2013', '2014', '2015']" ] }, { "cell_type": "code", "execution_count": 5, "id": "794d9bdd", "metadata": {}, "outputs": [], "source": [ "replace=[\"Korea, Rep.\",\"Iran, Islamic Rep.\",\"Hong Kong SAR, China\"]\n", "v= [\"South Korea\",\"Iran\",\"Hong Kong\"]\n", "wb.replace(replace, v,inplace=True)" ] }, { "cell_type": "code", "execution_count": 8, "id": "0079606a", "metadata": {}, "outputs": [], "source": [ "wb.set_axis?" ] }, { "cell_type": "code", "execution_count": 7, "id": "35c8a614", "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", "
Country NameCountry CodeIndicator NameIndicator Code196019611962196319641965...201220132014201520162017201820192020Unnamed: 65
Country Name
ArubaArubaABWGDP (current US$)NY.GDP.MKTP.CDNaNNaNNaNNaNNaNNaN...2.534637e+092.701676e+092.765363e+092.919553e+092.965922e+093.056425e+09NaNNaNNaNNaN
AfghanistanAfghanistanAFGGDP (current US$)NY.GDP.MKTP.CD5.377778e+085.488889e+085.466667e+087.511112e+088.000000e+081.006667e+09...2.000160e+102.056107e+102.048489e+101.990711e+101.801775e+101.886995e+101.835388e+101.929110e+10NaNNaN
AngolaAngolaAGOGDP (current US$)NY.GDP.MKTP.CDNaNNaNNaNNaNNaNNaN...1.280529e+111.367099e+111.457122e+111.161936e+111.011239e+111.221238e+111.013532e+118.881570e+10NaNNaN
AlbaniaAlbaniaALBGDP (current US$)NY.GDP.MKTP.CDNaNNaNNaNNaNNaNNaN...1.231983e+101.277622e+101.322814e+101.138685e+101.186120e+101.301969e+101.514702e+101.527918e+10NaNNaN
AndorraAndorraANDGDP (current US$)NY.GDP.MKTP.CDNaNNaNNaNNaNNaNNaN...3.188809e+093.193704e+093.271808e+092.789870e+092.896679e+093.000181e+093.218316e+093.154058e+09NaNNaN
..................................................................
KosovoKosovoXKXGDP (current US$)NY.GDP.MKTP.CDNaNNaNNaNNaNNaNNaN...6.499807e+097.074778e+097.396705e+096.442916e+096.719172e+097.245707e+097.942962e+097.926134e+09NaNNaN
Yemen, Rep.Yemen, Rep.YEMGDP (current US$)NY.GDP.MKTP.CDNaNNaNNaNNaNNaNNaN...3.540134e+104.041524e+104.320647e+104.245062e+103.093598e+102.673614e+102.348627e+102.258108e+10NaNNaN
South AfricaSouth AfricaZAFGDP (current US$)NY.GDP.MKTP.CD7.575397e+097.972997e+098.497997e+099.423396e+091.037400e+101.133440e+10...3.963327e+113.668294e+113.509046e+113.176205e+112.963573e+113.495541e+113.682889e+113.514316e+11NaNNaN
ZambiaZambiaZMBGDP (current US$)NY.GDP.MKTP.CD7.130000e+086.962857e+086.931429e+087.187143e+088.394286e+081.082857e+09...2.550306e+102.804555e+102.715073e+102.124334e+102.095475e+102.586817e+102.631214e+102.330977e+10NaNNaN
ZimbabweZimbabweZWEGDP (current US$)NY.GDP.MKTP.CD1.052990e+091.096647e+091.117602e+091.159512e+091.217138e+091.311436e+09...1.711485e+101.909102e+101.949552e+101.996312e+102.054868e+102.204090e+102.431156e+102.144076e+10NaNNaN
\n", "

264 rows × 66 columns

\n", "
" ], "text/plain": [ " Country Name Country Code Indicator Name Indicator Code \\\n", "Country Name \n", "Aruba Aruba ABW GDP (current US$) NY.GDP.MKTP.CD \n", "Afghanistan Afghanistan AFG GDP (current US$) NY.GDP.MKTP.CD \n", "Angola Angola AGO GDP (current US$) NY.GDP.MKTP.CD \n", "Albania Albania ALB GDP (current US$) NY.GDP.MKTP.CD \n", "Andorra Andorra AND GDP (current US$) NY.GDP.MKTP.CD \n", "... ... ... ... ... \n", "Kosovo Kosovo XKX GDP (current US$) NY.GDP.MKTP.CD \n", "Yemen, Rep. Yemen, Rep. YEM GDP (current US$) NY.GDP.MKTP.CD \n", "South Africa South Africa ZAF GDP (current US$) NY.GDP.MKTP.CD \n", "Zambia Zambia ZMB GDP (current US$) NY.GDP.MKTP.CD \n", "Zimbabwe Zimbabwe ZWE GDP (current US$) NY.GDP.MKTP.CD \n", "\n", " 1960 1961 1962 1963 \\\n", "Country Name \n", "Aruba NaN NaN NaN NaN \n", "Afghanistan 5.377778e+08 5.488889e+08 5.466667e+08 7.511112e+08 \n", "Angola NaN NaN NaN NaN \n", "Albania NaN NaN NaN NaN \n", "Andorra NaN NaN NaN NaN \n", "... ... ... ... ... \n", "Kosovo NaN NaN NaN NaN \n", "Yemen, Rep. NaN NaN NaN NaN \n", "South Africa 7.575397e+09 7.972997e+09 8.497997e+09 9.423396e+09 \n", "Zambia 7.130000e+08 6.962857e+08 6.931429e+08 7.187143e+08 \n", "Zimbabwe 1.052990e+09 1.096647e+09 1.117602e+09 1.159512e+09 \n", "\n", " 1964 1965 ... 2012 2013 \\\n", "Country Name ... \n", "Aruba NaN NaN ... 2.534637e+09 2.701676e+09 \n", "Afghanistan 8.000000e+08 1.006667e+09 ... 2.000160e+10 2.056107e+10 \n", "Angola NaN NaN ... 1.280529e+11 1.367099e+11 \n", "Albania NaN NaN ... 1.231983e+10 1.277622e+10 \n", "Andorra NaN NaN ... 3.188809e+09 3.193704e+09 \n", "... ... ... ... ... ... \n", "Kosovo NaN NaN ... 6.499807e+09 7.074778e+09 \n", "Yemen, Rep. NaN NaN ... 3.540134e+10 4.041524e+10 \n", "South Africa 1.037400e+10 1.133440e+10 ... 3.963327e+11 3.668294e+11 \n", "Zambia 8.394286e+08 1.082857e+09 ... 2.550306e+10 2.804555e+10 \n", "Zimbabwe 1.217138e+09 1.311436e+09 ... 1.711485e+10 1.909102e+10 \n", "\n", " 2014 2015 2016 2017 \\\n", "Country Name \n", "Aruba 2.765363e+09 2.919553e+09 2.965922e+09 3.056425e+09 \n", "Afghanistan 2.048489e+10 1.990711e+10 1.801775e+10 1.886995e+10 \n", "Angola 1.457122e+11 1.161936e+11 1.011239e+11 1.221238e+11 \n", "Albania 1.322814e+10 1.138685e+10 1.186120e+10 1.301969e+10 \n", "Andorra 3.271808e+09 2.789870e+09 2.896679e+09 3.000181e+09 \n", "... ... ... ... ... \n", "Kosovo 7.396705e+09 6.442916e+09 6.719172e+09 7.245707e+09 \n", "Yemen, Rep. 4.320647e+10 4.245062e+10 3.093598e+10 2.673614e+10 \n", "South Africa 3.509046e+11 3.176205e+11 2.963573e+11 3.495541e+11 \n", "Zambia 2.715073e+10 2.124334e+10 2.095475e+10 2.586817e+10 \n", "Zimbabwe 1.949552e+10 1.996312e+10 2.054868e+10 2.204090e+10 \n", "\n", " 2018 2019 2020 Unnamed: 65 \n", "Country Name \n", "Aruba NaN NaN NaN NaN \n", "Afghanistan 1.835388e+10 1.929110e+10 NaN NaN \n", "Angola 1.013532e+11 8.881570e+10 NaN NaN \n", "Albania 1.514702e+10 1.527918e+10 NaN NaN \n", "Andorra 3.218316e+09 3.154058e+09 NaN NaN \n", "... ... ... ... ... \n", "Kosovo 7.942962e+09 7.926134e+09 NaN NaN \n", "Yemen, Rep. 2.348627e+10 2.258108e+10 NaN NaN \n", "South Africa 3.682889e+11 3.514316e+11 NaN NaN \n", "Zambia 2.631214e+10 2.330977e+10 NaN NaN \n", "Zimbabwe 2.431156e+10 2.144076e+10 NaN NaN \n", "\n", "[264 rows x 66 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "wb" ] }, { "cell_type": "code", "execution_count": 9, "id": "7661f8ec", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1484318219633.63" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "wb['2014']['South Korea']" ] }, { "cell_type": "code", "execution_count": null, "id": "e6e38db8", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 10, "id": "10d0f676", "metadata": {}, "outputs": [], "source": [ "ei.drop(['Unnamed: 0', 'Unnamed: 2'], axis =1, inplace=True)\n", "ei.rename({'Unnamed: 1':'Country Name','Petajoules':'Energy Supply', 'Gigajoules':'Energy Supply per Capita',\\\n", " '%':'% Renewable' },\n", " axis=1, inplace=True)\n", "to_replace= [\"Republic of Korea\",\"United States of America\",\"United Kingdom of Great Britain and Northern Ireland\",\\\n", " \"China, Hong Kong Special Administrative Region\",'Iran (Islamic Republic of)']\n", "values=[\"South Korea\",\"United States\",\"United Kingdom\",\"Hong Kong\", 'Iran']\n", "ei.replace(to_replace, values, inplace=True)\n", "ei['Energy Supply']= 1000000*ei['Energy Supply']\n", "ei.set_axis(ei['Country Name'], inplace =True)" ] }, { "cell_type": "code", "execution_count": 11, "id": "627e00aa", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "9172000000" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ei['Energy Supply'][\"Iran\"]" ] }, { "cell_type": "code", "execution_count": null, "id": "96f51fa6", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 12, "id": "16691710", "metadata": {}, "outputs": [], "source": [ "sc.rename_axis('Country Name', inplace= True)" ] }, { "cell_type": "code", "execution_count": 13, "id": "d1e956a6", "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", "
RankRegionDocumentsCitable documentsCitationsSelf-citationsCitations per documentH index
Country Name
China1Asiatic Region273437272374233676416152398.55245
United States2Northern America175891172431223054472447212.68363
India3Asiatic Region55082537754631651629448.41181
Japan4Asiatic Region50523500654880621199309.66193
United Kingdom5Western Europe433894228461567011129014.19226
Germany6Western Europe38739380134331489514511.18196
Russian Federation7Eastern Europe3673536560115938549933.1690
Canada8Northern America334723286356808010095316.97227
Italy9Western Europe27983269403529938782812.61166
South Korea10Asiatic Region27655274453284886153111.88155
France11Western Europe25232247323438606573413.63178
Iran12Middle East22933227343072809703813.40141
Spain13Western Europe21955215973524976458816.06176
Brazil14Latin America2152421236183915451728.54127
Australia15Pacific Region20614201473143075158315.25176
\n", "
" ], "text/plain": [ " Rank Region Documents Citable documents \\\n", "Country Name \n", "China 1 Asiatic Region 273437 272374 \n", "United States 2 Northern America 175891 172431 \n", "India 3 Asiatic Region 55082 53775 \n", "Japan 4 Asiatic Region 50523 50065 \n", "United Kingdom 5 Western Europe 43389 42284 \n", "Germany 6 Western Europe 38739 38013 \n", "Russian Federation 7 Eastern Europe 36735 36560 \n", "Canada 8 Northern America 33472 32863 \n", "Italy 9 Western Europe 27983 26940 \n", "South Korea 10 Asiatic Region 27655 27445 \n", "France 11 Western Europe 25232 24732 \n", "Iran 12 Middle East 22933 22734 \n", "Spain 13 Western Europe 21955 21597 \n", "Brazil 14 Latin America 21524 21236 \n", "Australia 15 Pacific Region 20614 20147 \n", "\n", " Citations Self-citations Citations per document H index \n", "Country Name \n", "China 2336764 1615239 8.55 245 \n", "United States 2230544 724472 12.68 363 \n", "India 463165 162944 8.41 181 \n", "Japan 488062 119930 9.66 193 \n", "United Kingdom 615670 111290 14.19 226 \n", "Germany 433148 95145 11.18 196 \n", "Russian Federation 115938 54993 3.16 90 \n", "Canada 568080 100953 16.97 227 \n", "Italy 352993 87828 12.61 166 \n", "South Korea 328488 61531 11.88 155 \n", "France 343860 65734 13.63 178 \n", "Iran 307280 97038 13.40 141 \n", "Spain 352497 64588 16.06 176 \n", "Brazil 183915 45172 8.54 127 \n", "Australia 314307 51583 15.25 176 " ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sc" ] }, { "cell_type": "code", "execution_count": 14, "id": "b2663396", "metadata": {}, "outputs": [], "source": [ "frames=[wb,ei,sc]\n", "final= pd.concat(frames, axis=1)" ] }, { "cell_type": "code", "execution_count": 15, "id": "9a9ca3f2", "metadata": {}, "outputs": [], "source": [ "final1=final[columns].sort_values('Rank')[:15]" ] }, { "cell_type": "code", "execution_count": 16, "id": "240950f6", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "266298911661.144" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "final1['2006']['Iran']" ] }, { "cell_type": "code", "execution_count": 17, "id": "7449b835", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "(15, 20)" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "final1.shape" ] }, { "cell_type": "code", "execution_count": 18, "id": "0f088206", "metadata": {}, "outputs": [], "source": [ "l=[127191000000.0,90838000000.0,18984000000.0,7920000000.0,30709000000.0,\n", "10431000000.0,13261000000.0,33195000000.0,10597000000.0,11007000000.0,\n", "6530000000.0,4923000000.0,9172000000.0,5386000000.0,12149000000.0]" ] }, { "cell_type": "code", "execution_count": 19, "id": "6b625c52", "metadata": { "scrolled": true }, "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", "
2006200720082009201020112012201320142015
Country Name
China2.752132e+123.550343e+124.594307e+125.101703e+126.087164e+127.551500e+128.532230e+129.570406e+121.047568e+131.106155e+13
United States1.381461e+131.445186e+131.471284e+131.444893e+131.499205e+131.554258e+131.619701e+131.678485e+131.752716e+131.822470e+13
India9.402599e+111.216735e+121.198896e+121.341887e+121.675615e+121.823050e+121.827638e+121.856722e+122.039127e+122.103588e+12
Japan4.530377e+124.515265e+125.037908e+125.231383e+125.700098e+126.157460e+126.203213e+125.155717e+124.850414e+124.389476e+12
United Kingdom2.713750e+123.100882e+122.922667e+122.410910e+122.475244e+122.659310e+122.704888e+122.786023e+123.063803e+122.928591e+12
Germany2.992197e+123.421229e+123.730028e+123.397791e+123.396354e+123.744409e+123.527345e+123.732743e+123.883920e+123.356236e+12
Russian Federation9.899305e+111.299706e+121.660846e+121.222644e+121.524917e+122.045926e+122.208296e+122.292473e+122.059242e+121.363481e+12
Canada1.315415e+121.464977e+121.549131e+121.371153e+121.613464e+121.788648e+121.828689e+121.847209e+121.803533e+121.556130e+12
Italy1.947920e+122.210293e+122.398857e+122.191242e+122.134018e+122.291991e+122.087077e+122.141315e+122.159134e+121.835899e+12
South Korea1.053217e+121.172614e+121.047339e+129.439419e+111.144067e+121.253223e+121.278428e+121.370795e+121.484318e+121.465773e+12
France2.318594e+122.657213e+122.918383e+122.690222e+122.642610e+122.861408e+122.683825e+122.811078e+122.852166e+122.438208e+12
Iran2.662989e+113.498816e+114.123362e+114.163970e+114.868076e+115.807649e+115.988685e+114.602931e+114.326870e+113.849515e+11
Spain1.259344e+121.472131e+121.625225e+121.485583e+121.420722e+121.478773e+121.324820e+121.354757e+121.369399e+121.195119e+12
Brazil1.107640e+121.397084e+121.695825e+121.667020e+122.208872e+122.616201e+122.465189e+122.472807e+122.455994e+121.802214e+12
Australia7.460542e+118.530996e+111.053996e+129.278052e+111.146138e+121.396650e+121.546152e+121.576184e+121.467484e+121.351694e+12
\n", "
" ], "text/plain": [ " 2006 2007 2008 2009 \\\n", "Country Name \n", "China 2.752132e+12 3.550343e+12 4.594307e+12 5.101703e+12 \n", "United States 1.381461e+13 1.445186e+13 1.471284e+13 1.444893e+13 \n", "India 9.402599e+11 1.216735e+12 1.198896e+12 1.341887e+12 \n", "Japan 4.530377e+12 4.515265e+12 5.037908e+12 5.231383e+12 \n", "United Kingdom 2.713750e+12 3.100882e+12 2.922667e+12 2.410910e+12 \n", "Germany 2.992197e+12 3.421229e+12 3.730028e+12 3.397791e+12 \n", "Russian Federation 9.899305e+11 1.299706e+12 1.660846e+12 1.222644e+12 \n", "Canada 1.315415e+12 1.464977e+12 1.549131e+12 1.371153e+12 \n", "Italy 1.947920e+12 2.210293e+12 2.398857e+12 2.191242e+12 \n", "South Korea 1.053217e+12 1.172614e+12 1.047339e+12 9.439419e+11 \n", "France 2.318594e+12 2.657213e+12 2.918383e+12 2.690222e+12 \n", "Iran 2.662989e+11 3.498816e+11 4.123362e+11 4.163970e+11 \n", "Spain 1.259344e+12 1.472131e+12 1.625225e+12 1.485583e+12 \n", "Brazil 1.107640e+12 1.397084e+12 1.695825e+12 1.667020e+12 \n", "Australia 7.460542e+11 8.530996e+11 1.053996e+12 9.278052e+11 \n", "\n", " 2010 2011 2012 2013 \\\n", "Country Name \n", "China 6.087164e+12 7.551500e+12 8.532230e+12 9.570406e+12 \n", "United States 1.499205e+13 1.554258e+13 1.619701e+13 1.678485e+13 \n", "India 1.675615e+12 1.823050e+12 1.827638e+12 1.856722e+12 \n", "Japan 5.700098e+12 6.157460e+12 6.203213e+12 5.155717e+12 \n", "United Kingdom 2.475244e+12 2.659310e+12 2.704888e+12 2.786023e+12 \n", "Germany 3.396354e+12 3.744409e+12 3.527345e+12 3.732743e+12 \n", "Russian Federation 1.524917e+12 2.045926e+12 2.208296e+12 2.292473e+12 \n", "Canada 1.613464e+12 1.788648e+12 1.828689e+12 1.847209e+12 \n", "Italy 2.134018e+12 2.291991e+12 2.087077e+12 2.141315e+12 \n", "South Korea 1.144067e+12 1.253223e+12 1.278428e+12 1.370795e+12 \n", "France 2.642610e+12 2.861408e+12 2.683825e+12 2.811078e+12 \n", "Iran 4.868076e+11 5.807649e+11 5.988685e+11 4.602931e+11 \n", "Spain 1.420722e+12 1.478773e+12 1.324820e+12 1.354757e+12 \n", "Brazil 2.208872e+12 2.616201e+12 2.465189e+12 2.472807e+12 \n", "Australia 1.146138e+12 1.396650e+12 1.546152e+12 1.576184e+12 \n", "\n", " 2014 2015 \n", "Country Name \n", "China 1.047568e+13 1.106155e+13 \n", "United States 1.752716e+13 1.822470e+13 \n", "India 2.039127e+12 2.103588e+12 \n", "Japan 4.850414e+12 4.389476e+12 \n", "United Kingdom 3.063803e+12 2.928591e+12 \n", "Germany 3.883920e+12 3.356236e+12 \n", "Russian Federation 2.059242e+12 1.363481e+12 \n", "Canada 1.803533e+12 1.556130e+12 \n", "Italy 2.159134e+12 1.835899e+12 \n", "South Korea 1.484318e+12 1.465773e+12 \n", "France 2.852166e+12 2.438208e+12 \n", "Iran 4.326870e+11 3.849515e+11 \n", "Spain 1.369399e+12 1.195119e+12 \n", "Brazil 2.455994e+12 1.802214e+12 \n", "Australia 1.467484e+12 1.351694e+12 " ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "final1.iloc[:,10:]" ] }, { "cell_type": "code", "execution_count": 20, "id": "8d1df660", "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", "
Country NameEnergy SupplyEnergy Supply per Capita% Renewable
Country Name
AfghanistanAfghanistan3210000001078.669280
AlbaniaAlbania10200000035100.000000
AlgeriaAlgeria1959000000510.551010
American SamoaAmerican Samoa....................................................0.641026
AndorraAndorra900000012188.695650
...............
Viet NamViet Nam25540000002845.321520
Wallis and Futuna IslandsWallis and Futuna Islands0260.000000
YemenYemen344000000130.000000
ZambiaZambia4000000002699.714670
ZimbabweZimbabwe4800000003252.536120
\n", "

227 rows × 4 columns

\n", "
" ], "text/plain": [ " Country Name \\\n", "Country Name \n", "Afghanistan Afghanistan \n", "Albania Albania \n", "Algeria Algeria \n", "American Samoa American Samoa \n", "Andorra Andorra \n", "... ... \n", "Viet Nam Viet Nam \n", "Wallis and Futuna Islands Wallis and Futuna Islands \n", "Yemen Yemen \n", "Zambia Zambia \n", "Zimbabwe Zimbabwe \n", "\n", " Energy Supply \\\n", "Country Name \n", "Afghanistan 321000000 \n", "Albania 102000000 \n", "Algeria 1959000000 \n", "American Samoa ................................................. \n", "Andorra 9000000 \n", "... ... \n", "Viet Nam 2554000000 \n", "Wallis and Futuna Islands 0 \n", "Yemen 344000000 \n", "Zambia 400000000 \n", "Zimbabwe 480000000 \n", "\n", " Energy Supply per Capita % Renewable \n", "Country Name \n", "Afghanistan 10 78.669280 \n", "Albania 35 100.000000 \n", "Algeria 51 0.551010 \n", "American Samoa ... 0.641026 \n", "Andorra 121 88.695650 \n", "... ... ... \n", "Viet Nam 28 45.321520 \n", "Wallis and Futuna Islands 26 0.000000 \n", "Yemen 13 0.000000 \n", "Zambia 26 99.714670 \n", "Zimbabwe 32 52.536120 \n", "\n", "[227 rows x 4 columns]" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ei" ] }, { "cell_type": "code", "execution_count": 21, "id": "3d3500cc", "metadata": {}, "outputs": [], "source": [ "l=[127191000000.0,90838000000.0,18984000000.0,7920000000.0,30709000000.0,\n", " 10431000000.0,13261000000.0,33195000000.0,10597000000.0,11007000000.0,\n", " 6530000000.0,4923000000.0,9172000000.0,5386000000.0,12149000000.0]" ] }, { "cell_type": "code", "execution_count": 23, "id": "896f78ed", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "264" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(wb)" ] }, { "cell_type": "code", "execution_count": 28, "id": "eaed7095", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "208" ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(sc)" ] }, { "cell_type": "code", "execution_count": 25, "id": "0f3bc850", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "227" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(ei)" ] }, { "cell_type": "code", "execution_count": 30, "id": "0e84bc5e", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "193" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "208-15\n" ] }, { "cell_type": "code", "execution_count": 29, "id": "4d5cb0b6", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "249" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "264-15" ] }, { "cell_type": "code", "execution_count": 31, "id": "410c1633", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "212" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "227-15" ] }, { "cell_type": "code", "execution_count": 33, "id": "37e5aa48", "metadata": {}, "outputs": [], "source": [ "import numpy as np" ] }, { "cell_type": "code", "execution_count": 38, "id": "5ecd3aef", "metadata": {}, "outputs": [], "source": [ "a= np.arange(1,31).reshape((5,6))" ] }, { "cell_type": "code", "execution_count": 41, "id": "f33a2b83", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "array([[ 1, 2, 3, 4, 5, 6],\n", " [ 7, 8, 9, 10, 11, 12],\n", " [13, 14, 15, 16, 17, 18],\n", " [19, 20, 21, 22, 23, 24],\n", " [25, 26, 27, 28, 29, 30]])" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "a" ] }, { "cell_type": "code", "execution_count": null, "id": "2cd51e60", "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.8.8" } }, "nbformat": 4, "nbformat_minor": 5 }