Skip to content

Instantly share code, notes, and snippets.

@codebrain001

codebrain001/getting table text.ipynb

Created April 22, 2020 20:06
Show Gist options
  • Save codebrain001/95b63cd614050cdceb1df83ff71cd254 to your computer and use it in GitHub Desktop.
Save codebrain001/95b63cd614050cdceb1df83ff71cd254 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
getting table text.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [],
"source": [
"rows = table.find_all(\"tr\", attrs={\"style\": \"\"})"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"data = []\n",
"for i,item in enumerate(rows):\n",
" \n",
" if i == 0:\n",
" \n",
" data.append(item.text.strip().split(\"\\n\")[:13])\n",
" \n",
" else:\n",
" data.append(item.text.strip().split(\"\\n\")[:12])"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": true,
"jupyter": {
"outputs_hidden": true
}
},
"outputs": [
{
"data": {
"text/plain": [
"[['Country,Other',\n",
" 'TotalCases',\n",
" 'NewCases',\n",
" 'TotalDeaths',\n",
" 'NewDeaths',\n",
" 'TotalRecovered',\n",
" 'ActiveCases',\n",
" 'Serious,Critical',\n",
" 'Tot\\xa0Cases/1M pop',\n",
" 'Deaths/1M pop',\n",
" 'TotalTests',\n",
" 'Tests/',\n",
" '1M pop'],\n",
" ['World',\n",
" '2,614,803',\n",
" '+59,043',\n",
" '182,467',\n",
" '+5,008',\n",
" '714,319',\n",
" '1,718,017',\n",
" '56,671',\n",
" '335',\n",
" '23.4',\n",
" '',\n",
" ''],\n",
" ['USA',\n",
" '831,086',\n",
" '+12,342',\n",
" '46,249 ',\n",
" '+931',\n",
" '83,462',\n",
" '701,375',\n",
" '14,014',\n",
" '2,511',\n",
" '140',\n",
" '4,275,802',\n",
" '12,918'],\n",
" ['Spain',\n",
" '208,389',\n",
" '+4,211',\n",
" '21,717 ',\n",
" '+435',\n",
" '85,915',\n",
" '100,757',\n",
" '7,705',\n",
" '4,457',\n",
" '464',\n",
" '930,230',\n",
" '19,896'],\n",
" ['Italy',\n",
" '187,327',\n",
" '+3,370',\n",
" '25,085 ',\n",
" '+437',\n",
" '54,543',\n",
" '107,699',\n",
" '2,384',\n",
" '3,098',\n",
" '415',\n",
" '1,513,251',\n",
" '25,028'],\n",
" ['France',\n",
" '159,877',\n",
" '+1,827',\n",
" '21,340 ',\n",
" '+544',\n",
" '40,657',\n",
" '97,880',\n",
" '5,218',\n",
" '2,449',\n",
" '327',\n",
" '463,662',\n",
" '7,103'],\n",
" ['Germany',\n",
" '149,771',\n",
" '+1,318',\n",
" '5,211 ',\n",
" '+125',\n",
" '99,400',\n",
" '45,160',\n",
" '2,908',\n",
" '1,788',\n",
" '62',\n",
" '1,728,357',\n",
" '20,629'],\n",
" ['UK',\n",
" '133,495',\n",
" '+4,451',\n",
" '18,100 ',\n",
" '+763',\n",
" 'N/A',\n",
" '115,051',\n",
" '1,559',\n",
" '1,966',\n",
" '267',\n",
" '559,935',\n",
" '8,248'],\n",
" ['Turkey',\n",
" '98,674',\n",
" '+3,083',\n",
" '2,376 ',\n",
" '+117',\n",
" '16,477',\n",
" '79,821',\n",
" '1,814',\n",
" '1,170',\n",
" '28',\n",
" '750,944',\n",
" '8,904'],\n",
" ['Iran',\n",
" '85,996',\n",
" '+1,194',\n",
" '5,391 ',\n",
" '+94',\n",
" '63,113',\n",
" '17,492',\n",
" '3,311',\n",
" '1,024',\n",
" '64',\n",
" '377,396',\n",
" '4,493'],\n",
" ['Russia',\n",
" '57,999',\n",
" '+5,236',\n",
" '513 ',\n",
" '+57',\n",
" '4,420',\n",
" '53,066',\n",
" '700',\n",
" '397',\n",
" '4',\n",
" '2,250,000',\n",
" '15,418'],\n",
" ['Brazil',\n",
" '45,757',\n",
" '+2,678',\n",
" '2,906 ',\n",
" '+165',\n",
" '24,325',\n",
" '18,526',\n",
" '8,318',\n",
" '215',\n",
" '14',\n",
" '291,922',\n",
" '1,373'],\n",
" ['Belgium',\n",
" '41,889',\n",
" '+933',\n",
" '6,262 ',\n",
" '+264',\n",
" '9,433',\n",
" '26,194',\n",
" '1,020',\n",
" '3,614',\n",
" '540',\n",
" '171,400',\n",
" '14,789'],\n",
" ['Canada',\n",
" '39,805',\n",
" '+1,383',\n",
" '1,966 ',\n",
" '+132',\n",
" '13,647',\n",
" '24,192',\n",
" '557',\n",
" '1,055',\n",
" '52',\n",
" '569,878',\n",
" '15,099'],\n",
" ['Netherlands',\n",
" '34,842',\n",
" '+708',\n",
" '4,054 ',\n",
" '+138',\n",
" 'N/A',\n",
" '30,538',\n",
" '1,050',\n",
" '2,033',\n",
" '237',\n",
" '171,415',\n",
" '10,004'],\n",
" ['Switzerland',\n",
" '28,268',\n",
" '+205',\n",
" '1,509 ',\n",
" '+31',\n",
" '19,400',\n",
" '7,359',\n",
" '386',\n",
" '3,266',\n",
" '174',\n",
" '227,554',\n",
" '26,293'],\n",
" ['Portugal',\n",
" '21,982',\n",
" '+603',\n",
" '785 ',\n",
" '+23',\n",
" '1,143',\n",
" '20,054',\n",
" '207',\n",
" '2,156',\n",
" '77',\n",
" '284,741',\n",
" '27,925'],\n",
" ['India',\n",
" '20,471',\n",
" '+391',\n",
" '652 ',\n",
" '+7',\n",
" '3,976',\n",
" '15,843',\n",
" '',\n",
" '15',\n",
" '0.5',\n",
" '462,621',\n",
" '335'],\n",
" ['Peru',\n",
" '19,250',\n",
" '+1,413',\n",
" '530 ',\n",
" '+46',\n",
" '7,027',\n",
" '11,693',\n",
" '396',\n",
" '584',\n",
" '16',\n",
" '170,400',\n",
" '5,168'],\n",
" ['Ireland',\n",
" '16,671',\n",
" '+631',\n",
" '769 ',\n",
" '+39',\n",
" '9,233',\n",
" '6,669',\n",
" '147',\n",
" '3,376',\n",
" '156',\n",
" '111,584',\n",
" '22,598'],\n",
" ['Sweden',\n",
" '16,004',\n",
" '+682',\n",
" '1,937 ',\n",
" '+172',\n",
" '550',\n",
" '13,517',\n",
" '515',\n",
" '1,585',\n",
" '192',\n",
" '94,500',\n",
" '9,357'],\n",
" ['Austria',\n",
" '14,925',\n",
" '+52',\n",
" '510 ',\n",
" '+19',\n",
" '11,328',\n",
" '3,087',\n",
" '176',\n",
" '1,657',\n",
" '57',\n",
" '201,794',\n",
" '22,406'],\n",
" ['Israel',\n",
" '14,498',\n",
" '+556',\n",
" '189 ',\n",
" '+5',\n",
" '5,215',\n",
" '9,094',\n",
" '141',\n",
" '1,675',\n",
" '22',\n",
" '240,303',\n",
" '27,763'],\n",
" ['Saudi Arabia',\n",
" '12,772',\n",
" '+1,141',\n",
" '114 ',\n",
" '+5',\n",
" '1,812',\n",
" '10,846',\n",
" '82',\n",
" '367',\n",
" '3',\n",
" '200,000',\n",
" '5,745'],\n",
" ['Japan',\n",
" '11,512',\n",
" '',\n",
" '281 ',\n",
" '',\n",
" '1,356',\n",
" '9,875',\n",
" '232',\n",
" '91',\n",
" '2',\n",
" '124,550',\n",
" '985'],\n",
" ['Chile',\n",
" '11,296',\n",
" '+464',\n",
" '160 ',\n",
" '+13',\n",
" '5,386',\n",
" '5,750',\n",
" '399',\n",
" '591',\n",
" '8',\n",
" '128,722',\n",
" '6,734'],\n",
" ['Ecuador',\n",
" '10,850',\n",
" '+452',\n",
" '537 ',\n",
" '+17',\n",
" '1,262',\n",
" '9,051',\n",
" '141',\n",
" '615',\n",
" '30',\n",
" '33,389',\n",
" '1,892'],\n",
" ['S. Korea',\n",
" '10,694',\n",
" '+11',\n",
" '238 ',\n",
" '+1',\n",
" '8,277',\n",
" '2,179',\n",
" '55',\n",
" '209',\n",
" '5',\n",
" '577,959',\n",
" '11,273'],\n",
" ['Poland',\n",
" '10,169',\n",
" '+313',\n",
" '426 ',\n",
" '+25',\n",
" '1,513',\n",
" '8,230',\n",
" '160',\n",
" '269',\n",
" '11',\n",
" '238,799',\n",
" '6,310'],\n",
" ['Singapore',\n",
" '10,141',\n",
" '+1,016',\n",
" '12 ',\n",
" '+1',\n",
" '896',\n",
" '9,233',\n",
" '27',\n",
" '1,733',\n",
" '2',\n",
" '94,796',\n",
" '16,203'],\n",
" ['Pakistan',\n",
" '10,076',\n",
" '+511',\n",
" '212 ',\n",
" '+11',\n",
" '2,156',\n",
" '7,708',\n",
" '58',\n",
" '46',\n",
" '1.0',\n",
" '118,020',\n",
" '534'],\n",
" ['Romania',\n",
" '9,710',\n",
" '+468',\n",
" '519 ',\n",
" '+21',\n",
" '2,406',\n",
" '6,785',\n",
" '288',\n",
" '505',\n",
" '27',\n",
" '106,357',\n",
" '5,529'],\n",
" ['Mexico',\n",
" '9,501',\n",
" '+729',\n",
" '857 ',\n",
" '+145',\n",
" '2,627',\n",
" '6,017',\n",
" '378',\n",
" '74',\n",
" '7',\n",
" '49,570',\n",
" '384'],\n",
" ['UAE',\n",
" '8,238',\n",
" '+483',\n",
" '52 ',\n",
" '+6',\n",
" '1,546',\n",
" '6,640',\n",
" '1',\n",
" '833',\n",
" '5',\n",
" '790,000',\n",
" '79,875'],\n",
" ['Denmark',\n",
" '7,912',\n",
" '+217',\n",
" '384 ',\n",
" '+14',\n",
" '5,087',\n",
" '2,441',\n",
" '80',\n",
" '1,366',\n",
" '66',\n",
" '108,465',\n",
" '18,726'],\n",
" ['Indonesia',\n",
" '7,418',\n",
" '+283',\n",
" '635 ',\n",
" '+19',\n",
" '913',\n",
" '5,870',\n",
" '',\n",
" '27',\n",
" '2',\n",
" '55,732',\n",
" '204'],\n",
" ['Belarus',\n",
" '7,281',\n",
" '+558',\n",
" '58 ',\n",
" '+3',\n",
" '769',\n",
" '6,454',\n",
" '92',\n",
" '771',\n",
" '6',\n",
" '114,955',\n",
" '12,165'],\n",
" ['Norway',\n",
" '7,275',\n",
" '+34',\n",
" '187 ',\n",
" '+5',\n",
" '32',\n",
" '7,056',\n",
" '54',\n",
" '1,342',\n",
" '34',\n",
" '148,656',\n",
" '27,421'],\n",
" ['Qatar',\n",
" '7,141',\n",
" '+608',\n",
" '10 ',\n",
" '+1',\n",
" '689',\n",
" '6,442',\n",
" '37',\n",
" '2,479',\n",
" '3',\n",
" '70,012',\n",
" '24,301'],\n",
" ['Serbia',\n",
" '7,114',\n",
" '+224',\n",
" '134 ',\n",
" '+4',\n",
" '1,025',\n",
" '5,955',\n",
" '101',\n",
" '814',\n",
" '15',\n",
" '48,636',\n",
" '5,566'],\n",
" ['Czechia',\n",
" '7,087',\n",
" '+54',\n",
" '208 ',\n",
" '+7',\n",
" '1,989',\n",
" '4,890',\n",
" '80',\n",
" '662',\n",
" '19',\n",
" '186,918',\n",
" '17,454'],\n",
" ['Philippines',\n",
" '6,710',\n",
" '+111',\n",
" '446 ',\n",
" '+9',\n",
" '693',\n",
" '5,571',\n",
" '1',\n",
" '61',\n",
" '4',\n",
" '68,532',\n",
" '625'],\n",
" ['Australia',\n",
" '6,649',\n",
" '+4',\n",
" '74 ',\n",
" '+3',\n",
" '4,920',\n",
" '1,655',\n",
" '47',\n",
" '261',\n",
" '3',\n",
" '452,441',\n",
" '17,743'],\n",
" ['Ukraine',\n",
" '6,592',\n",
" '+467',\n",
" '174 ',\n",
" '+13',\n",
" '424',\n",
" '5,994',\n",
" '45',\n",
" '151',\n",
" '4',\n",
" '67,520',\n",
" '1,544'],\n",
" ['Malaysia',\n",
" '5,532',\n",
" '+50',\n",
" '93 ',\n",
" '+1',\n",
" '3,452',\n",
" '1,987',\n",
" '43',\n",
" '171',\n",
" '3',\n",
" '110,109',\n",
" '3,402'],\n",
" ['Dominican Republic',\n",
" '5,300',\n",
" '+256',\n",
" '260 ',\n",
" '+15',\n",
" '581',\n",
" '4,459',\n",
" '135',\n",
" '489',\n",
" '24',\n",
" '18,261',\n",
" '1,683'],\n",
" ['Panama',\n",
" '4,821',\n",
" '+163',\n",
" '141 ',\n",
" '+5',\n",
" '231',\n",
" '4,449',\n",
" '94',\n",
" '1,117',\n",
" '33',\n",
" '21,902',\n",
" '5,076'],\n",
" ['Colombia',\n",
" '4,149',\n",
" '',\n",
" '196 ',\n",
" '',\n",
" '804',\n",
" '3,149',\n",
" '98',\n",
" '82',\n",
" '4',\n",
" '68,428',\n",
" '1,345'],\n",
" ['Finland',\n",
" '4,129',\n",
" '+115',\n",
" '149 ',\n",
" '+8',\n",
" '2,000',\n",
" '1,980',\n",
" '63',\n",
" '745',\n",
" '27',\n",
" '68,552',\n",
" '12,372'],\n",
" ['Bangladesh',\n",
" '3,772',\n",
" '+390',\n",
" '120 ',\n",
" '+10',\n",
" '92',\n",
" '3,560',\n",
" '1',\n",
" '23',\n",
" '0.7',\n",
" '32,630',\n",
" '198'],\n",
" ['Egypt',\n",
" '3,659',\n",
" '+169',\n",
" '276 ',\n",
" '+12',\n",
" '935',\n",
" '2,448',\n",
" '',\n",
" '36',\n",
" '3',\n",
" '55,000',\n",
" '537'],\n",
" ['Luxembourg',\n",
" '3,654',\n",
" '+36',\n",
" '80 ',\n",
" '+2',\n",
" '711',\n",
" '2,863',\n",
" '32',\n",
" '5,837',\n",
" '128',\n",
" '36,087',\n",
" '57,649'],\n",
" ['South Africa',\n",
" '3,635',\n",
" '+170',\n",
" '65 ',\n",
" '+7',\n",
" '1,055',\n",
" '2,515',\n",
" '36',\n",
" '61',\n",
" '1',\n",
" '133,774',\n",
" '2,256'],\n",
" ['Morocco',\n",
" '3,446',\n",
" '+237',\n",
" '149 ',\n",
" '+4',\n",
" '417',\n",
" '2,880',\n",
" '1',\n",
" '93',\n",
" '4',\n",
" '19,885',\n",
" '539'],\n",
" ['Argentina',\n",
" '3,144',\n",
" '',\n",
" '152 ',\n",
" '+1',\n",
" '872',\n",
" '2,120',\n",
" '123',\n",
" '70',\n",
" '3',\n",
" '39,228',\n",
" '868'],\n",
" ['Algeria',\n",
" '2,910',\n",
" '+99',\n",
" '402 ',\n",
" '+10',\n",
" '1,204',\n",
" '1,304',\n",
" '40',\n",
" '66',\n",
" '9',\n",
" '6,500',\n",
" '148'],\n",
" ['Thailand',\n",
" '2,826',\n",
" '+15',\n",
" '49 ',\n",
" '+1',\n",
" '2,352',\n",
" '425',\n",
" '61',\n",
" '40',\n",
" '0.7',\n",
" '142,589',\n",
" '2,043'],\n",
" ['Moldova',\n",
" '2,778',\n",
" '+164',\n",
" '75 ',\n",
" '+3',\n",
" '560',\n",
" '2,143',\n",
" '212',\n",
" '689',\n",
" '19',\n",
" '11,763',\n",
" '2,916'],\n",
" ['Greece',\n",
" '2,408',\n",
" '+7',\n",
" '121 ',\n",
" '',\n",
" '577',\n",
" '1,710',\n",
" '55',\n",
" '231',\n",
" '12',\n",
" '56,944',\n",
" '5,463'],\n",
" ['Kuwait',\n",
" '2,248',\n",
" '+168',\n",
" '13 ',\n",
" '+2',\n",
" '443',\n",
" '1,792',\n",
" '50',\n",
" '526',\n",
" '3',\n",
" '',\n",
" ''],\n",
" ['Hungary',\n",
" '2,168',\n",
" '+70',\n",
" '225 ',\n",
" '+12',\n",
" '295',\n",
" '1,648',\n",
" '82',\n",
" '224',\n",
" '23',\n",
" '52,702',\n",
" '5,455'],\n",
" ['Kazakhstan',\n",
" '2,135',\n",
" '+140',\n",
" '19 ',\n",
" '',\n",
" '515',\n",
" '1,601',\n",
" '32',\n",
" '114',\n",
" '1',\n",
" '139,207',\n",
" '7,414'],\n",
" ['Bahrain',\n",
" '2,027',\n",
" '+54',\n",
" '7 ',\n",
" '',\n",
" '1,026',\n",
" '994',\n",
" '2',\n",
" '1,191',\n",
" '4',\n",
" '97,796',\n",
" '57,474'],\n",
" ['Croatia',\n",
" '1,950',\n",
" '+42',\n",
" '48 ',\n",
" '',\n",
" '869',\n",
" '1,033',\n",
" '19',\n",
" '475',\n",
" '12',\n",
" '27,614',\n",
" '6,726'],\n",
" ['Iceland',\n",
" '1,785',\n",
" '+7',\n",
" '10 ',\n",
" '',\n",
" '1,462',\n",
" '313',\n",
" '5',\n",
" '5,231',\n",
" '29',\n",
" '44,468',\n",
" '130,312'],\n",
" ['Uzbekistan',\n",
" '1,716',\n",
" '+38',\n",
" '7 ',\n",
" '+1',\n",
" '450',\n",
" '1,259',\n",
" '8',\n",
" '51',\n",
" '0.2',\n",
" '150,000',\n",
" '4,482'],\n",
" ['Iraq',\n",
" '1,631',\n",
" '+29',\n",
" '83 ',\n",
" '',\n",
" '1,146',\n",
" '402',\n",
" '',\n",
" '41',\n",
" '2',\n",
" '62,880',\n",
" '1,563'],\n",
" ['Oman', '1,614', '+106', '8 ', '', '238', '1,368', '3', '316', '2', '', ''],\n",
" ['Estonia',\n",
" '1,559',\n",
" '+7',\n",
" '44 ',\n",
" '+1',\n",
" '184',\n",
" '1,331',\n",
" '7',\n",
" '1,175',\n",
" '33',\n",
" '43,637',\n",
" '32,895'],\n",
" ['Azerbaijan',\n",
" '1,518',\n",
" '+38',\n",
" '20 ',\n",
" '',\n",
" '907',\n",
" '591',\n",
" '14',\n",
" '150',\n",
" '2',\n",
" '108,221',\n",
" '10,674'],\n",
" ['Armenia',\n",
" '1,473',\n",
" '+72',\n",
" '24 ',\n",
" '',\n",
" '633',\n",
" '816',\n",
" '30',\n",
" '497',\n",
" '8',\n",
" '14,966',\n",
" '5,051'],\n",
" ['New Zealand',\n",
" '1,451',\n",
" '+6',\n",
" '14 ',\n",
" '+1',\n",
" '1,036',\n",
" '401',\n",
" '2',\n",
" '301',\n",
" '3',\n",
" '94,797',\n",
" '19,658'],\n",
" ['Lithuania',\n",
" '1,370',\n",
" '+20',\n",
" '38 ',\n",
" '',\n",
" '357',\n",
" '975',\n",
" '17',\n",
" '503',\n",
" '14',\n",
" '76,973',\n",
" '28,275'],\n",
" ['Bosnia and Herzegovina',\n",
" '1,368',\n",
" '+26',\n",
" '53 ',\n",
" '+2',\n",
" '460',\n",
" '855',\n",
" '4',\n",
" '417',\n",
" '16',\n",
" '20,125',\n",
" '6,134'],\n",
" ['Slovenia',\n",
" '1,353',\n",
" '+9',\n",
" '79 ',\n",
" '+2',\n",
" '205',\n",
" '1,069',\n",
" '24',\n",
" '651',\n",
" '38',\n",
" '44,435',\n",
" '21,374'],\n",
" ['North Macedonia',\n",
" '1,259',\n",
" '+28',\n",
" '56 ',\n",
" '+1',\n",
" '272',\n",
" '931',\n",
" '8',\n",
" '604',\n",
" '27',\n",
" '13,000',\n",
" '6,240'],\n",
" ['Slovakia',\n",
" '1,244',\n",
" '+45',\n",
" '14 ',\n",
" '',\n",
" '284',\n",
" '946',\n",
" '7',\n",
" '228',\n",
" '3',\n",
" '52,649',\n",
" '9,643'],\n",
" ['Cuba',\n",
" '1,189',\n",
" '+52',\n",
" '40 ',\n",
" '+2',\n",
" '341',\n",
" '808',\n",
" '16',\n",
" '105',\n",
" '4',\n",
" '30,416',\n",
" '2,685'],\n",
" ['Afghanistan',\n",
" '1,176',\n",
" '+84',\n",
" '40 ',\n",
" '+4',\n",
" '166',\n",
" '970',\n",
" '7',\n",
" '30',\n",
" '1',\n",
" '6,422',\n",
" '165'],\n",
" ['Cameroon', '1,163', '', '43 ', '', '331', '789', '33', '44', '2', '', ''],\n",
" ['Ghana',\n",
" '1,154',\n",
" '+112',\n",
" '9 ',\n",
" '',\n",
" '99',\n",
" '1,046',\n",
" '4',\n",
" '37',\n",
" '0.3',\n",
" '68,591',\n",
" '2,207'],\n",
" ['Hong Kong',\n",
" '1,034',\n",
" '+4',\n",
" '4 ',\n",
" '',\n",
" '678',\n",
" '352',\n",
" '8',\n",
" '138',\n",
" '0.5',\n",
" '131,786',\n",
" '17,579'],\n",
" ['Bulgaria',\n",
" '1,024',\n",
" '+49',\n",
" '49 ',\n",
" '+4',\n",
" '174',\n",
" '801',\n",
" '37',\n",
" '147',\n",
" '7',\n",
" '27,000',\n",
" '3,886'],\n",
" ['Djibouti',\n",
" '974',\n",
" '+29',\n",
" '2 ',\n",
" '',\n",
" '183',\n",
" '789',\n",
" '',\n",
" '986',\n",
" '2',\n",
" '10,272',\n",
" '10,397'],\n",
" ['Ivory Coast', '916', '', '13 ', '', '303', '600', '', '35', '0.5', '', ''],\n",
" ['Tunisia',\n",
" '901',\n",
" '',\n",
" '38 ',\n",
" '',\n",
" '170',\n",
" '693',\n",
" '25',\n",
" '76',\n",
" '3',\n",
" '18,165',\n",
" '1,537'],\n",
" ['Cyprus',\n",
" '790',\n",
" '+6',\n",
" '13 ',\n",
" '+1',\n",
" '98',\n",
" '679',\n",
" '15',\n",
" '654',\n",
" '11',\n",
" '37,081',\n",
" '30,712'],\n",
" ['Nigeria',\n",
" '782',\n",
" '',\n",
" '25 ',\n",
" '',\n",
" '197',\n",
" '560',\n",
" '2',\n",
" '4',\n",
" '0.1',\n",
" '8,003',\n",
" '39'],\n",
" ['Latvia',\n",
" '761',\n",
" '+13',\n",
" '11 ',\n",
" '+2',\n",
" '133',\n",
" '617',\n",
" '5',\n",
" '403',\n",
" '6',\n",
" '39,336',\n",
" '20,855'],\n",
" ['Guinea', '761', '+73', '6 ', '', '164', '591', '', '58', '0.5', '', ''],\n",
" ['Andorra',\n",
" '723',\n",
" '+6',\n",
" '37 ',\n",
" '',\n",
" '309',\n",
" '377',\n",
" '17',\n",
" '9,357',\n",
" '479',\n",
" '1,673',\n",
" '21,653'],\n",
" ['Diamond Princess', '712', '', '13 ', '', '644', '55', '7'],\n",
" ['Lebanon',\n",
" '682',\n",
" '+5',\n",
" '22 ',\n",
" '+1',\n",
" '130',\n",
" '530',\n",
" '26',\n",
" '100',\n",
" '3',\n",
" '22,853',\n",
" '3,348'],\n",
" ['Costa Rica',\n",
" '681',\n",
" '+12',\n",
" '6 ',\n",
" '',\n",
" '180',\n",
" '495',\n",
" '6',\n",
" '134',\n",
" '1',\n",
" '11,766',\n",
" '2,310'],\n",
" ['Niger',\n",
" '657',\n",
" '',\n",
" '20 ',\n",
" '',\n",
" '127',\n",
" '510',\n",
" '',\n",
" '27',\n",
" '0.8',\n",
" '4,832',\n",
" '200'],\n",
" ['Albania',\n",
" '634',\n",
" '+25',\n",
" '27 ',\n",
" '+1',\n",
" '356',\n",
" '251',\n",
" '4',\n",
" '220',\n",
" '9',\n",
" '6,269',\n",
" '2,178'],\n",
" ['Kyrgyzstan',\n",
" '612',\n",
" '+22',\n",
" '7 ',\n",
" '',\n",
" '254',\n",
" '351',\n",
" '5',\n",
" '94',\n",
" '1',\n",
" '26,147',\n",
" '4,008'],\n",
" ['Burkina Faso',\n",
" '609',\n",
" '+9',\n",
" '39 ',\n",
" '+1',\n",
" '389',\n",
" '181',\n",
" '',\n",
" '29',\n",
" '2',\n",
" '',\n",
" ''],\n",
" ['Bolivia',\n",
" '609',\n",
" '+11',\n",
" '37 ',\n",
" '+3',\n",
" '44',\n",
" '528',\n",
" '3',\n",
" '52',\n",
" '3',\n",
" '4,420',\n",
" '379'],\n",
" ['Uruguay',\n",
" '543',\n",
" '',\n",
" '12 ',\n",
" '',\n",
" '324',\n",
" '207',\n",
" '10',\n",
" '156',\n",
" '3',\n",
" '13,923',\n",
" '4,008'],\n",
" ['Honduras',\n",
" '510',\n",
" '+16',\n",
" '46 ',\n",
" '',\n",
" '30',\n",
" '434',\n",
" '10',\n",
" '51',\n",
" '5',\n",
" '2,535',\n",
" '256'],\n",
" ['Channel Islands',\n",
" '498',\n",
" '+2',\n",
" '28 ',\n",
" '+4',\n",
" '285',\n",
" '185',\n",
" '',\n",
" '2,864',\n",
" '161',\n",
" '3,320',\n",
" '19,095'],\n",
" ['San Marino',\n",
" '488',\n",
" '+12',\n",
" '40 ',\n",
" '',\n",
" '62',\n",
" '386',\n",
" '4',\n",
" '14,382',\n",
" '1,179',\n",
" '1,872',\n",
" '55,171'],\n",
" ['Palestine',\n",
" '474',\n",
" '+8',\n",
" '4 ',\n",
" '',\n",
" '71',\n",
" '399',\n",
" '',\n",
" '93',\n",
" '0.8',\n",
" '17,329',\n",
" '3,397'],\n",
" ['Malta',\n",
" '444',\n",
" '+1',\n",
" '3 ',\n",
" '',\n",
" '165',\n",
" '276',\n",
" '2',\n",
" '1,006',\n",
" '7',\n",
" '26,148',\n",
" '59,220'],\n",
" ['Senegal',\n",
" '442',\n",
" '+30',\n",
" '6 ',\n",
" '+1',\n",
" '253',\n",
" '183',\n",
" '1',\n",
" '26',\n",
" '0.4',\n",
" '466',\n",
" '28'],\n",
" ['Jordan',\n",
" '435',\n",
" '+7',\n",
" '7 ',\n",
" '',\n",
" '315',\n",
" '113',\n",
" '5',\n",
" '43',\n",
" '0.7',\n",
" '35,000',\n",
" '3,430'],\n",
" ['Taiwan',\n",
" '426',\n",
" '+1',\n",
" '6 ',\n",
" '',\n",
" '236',\n",
" '184',\n",
" '',\n",
" '18',\n",
" '0.3',\n",
" '56,853',\n",
" '2,387'],\n",
" ['Georgia',\n",
" '416',\n",
" '+8',\n",
" '5 ',\n",
" '+1',\n",
" '107',\n",
" '304',\n",
" '6',\n",
" '104',\n",
" '1',\n",
" '8,375',\n",
" '2,099'],\n",
" ['Réunion', '410', '', ' ', '', '238', '172', '2', '458', '', '', ''],\n",
" ['DRC', '359', '+9', '25 ', '', '45', '289', '', '4', '0.3', '', ''],\n",
" ['Sri Lanka',\n",
" '330',\n",
" '+20',\n",
" '7 ',\n",
" '',\n",
" '105',\n",
" '218',\n",
" '2',\n",
" '15',\n",
" '0.3',\n",
" '7,393',\n",
" '345'],\n",
" ['Mauritius',\n",
" '329',\n",
" '+1',\n",
" '9 ',\n",
" '',\n",
" '261',\n",
" '59',\n",
" '3',\n",
" '259',\n",
" '7',\n",
" '9,755',\n",
" '7,670'],\n",
" ['Mayotte',\n",
" '326',\n",
" '+15',\n",
" '4 ',\n",
" '',\n",
" '125',\n",
" '197',\n",
" '4',\n",
" '1,195',\n",
" '15',\n",
" '2,100',\n",
" '7,698'],\n",
" ['Guatemala',\n",
" '316',\n",
" '+22',\n",
" '8 ',\n",
" '+1',\n",
" '24',\n",
" '284',\n",
" '3',\n",
" '18',\n",
" '0.4',\n",
" '7,200',\n",
" '402'],\n",
" ['Montenegro',\n",
" '315',\n",
" '+2',\n",
" '5 ',\n",
" '',\n",
" '116',\n",
" '194',\n",
" '7',\n",
" '502',\n",
" '8',\n",
" '5,085',\n",
" '8,096'],\n",
" ['Isle of Man',\n",
" '307',\n",
" '',\n",
" '15 ',\n",
" '+6',\n",
" '212',\n",
" '80',\n",
" '20',\n",
" '3,610',\n",
" '176',\n",
" '2,654',\n",
" '31,211'],\n",
" ['Kenya',\n",
" '303',\n",
" '+7',\n",
" '14 ',\n",
" '',\n",
" '74',\n",
" '215',\n",
" '2',\n",
" '6',\n",
" '0.3',\n",
" '14,704',\n",
" '273'],\n",
" ['Mali',\n",
" '293',\n",
" '+35',\n",
" '17 ',\n",
" '+3',\n",
" '73',\n",
" '203',\n",
" '',\n",
" '14',\n",
" '0.8',\n",
" '2,023',\n",
" '100'],\n",
" ['Venezuela',\n",
" '288',\n",
" '',\n",
" '10 ',\n",
" '',\n",
" '122',\n",
" '156',\n",
" '4',\n",
" '10',\n",
" '0.4',\n",
" '347,236',\n",
" '12,211'],\n",
" ['Somalia', '286', '', '8 ', '', '4', '274', '2', '18', '0.5', '', ''],\n",
" ['Tanzania', '284', '+30', '10 ', '', '11', '263', '7', '5', '0.2', '', ''],\n",
" ['Vietnam',\n",
" '268',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '223',\n",
" '45',\n",
" '8',\n",
" '3',\n",
" '',\n",
" '206,253',\n",
" '2,119'],\n",
" ['El Salvador',\n",
" '237',\n",
" '+12',\n",
" '7 ',\n",
" '',\n",
" '63',\n",
" '167',\n",
" '3',\n",
" '37',\n",
" '1',\n",
" '14,375',\n",
" '2,216'],\n",
" ['Jamaica',\n",
" '233',\n",
" '+5',\n",
" '6 ',\n",
" '',\n",
" '27',\n",
" '200',\n",
" '',\n",
" '79',\n",
" '2',\n",
" '1,936',\n",
" '654'],\n",
" ['Paraguay',\n",
" '213',\n",
" '+5',\n",
" '9 ',\n",
" '+1',\n",
" '62',\n",
" '142',\n",
" '1',\n",
" '30',\n",
" '1',\n",
" '5,878',\n",
" '824'],\n",
" ['Faeroe Islands',\n",
" '185',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '178',\n",
" '7',\n",
" '',\n",
" '3,786',\n",
" '',\n",
" '6,270',\n",
" '128,318'],\n",
" ['Congo', '165', '', '6 ', '', '16', '143', '', '30', '1', '', ''],\n",
" ['Martinique', '164', '+1', '14 ', '', '73', '77', '6', '437', '37', '', ''],\n",
" ['Gabon', '156', '', '1 ', '', '16', '139', '2', '70', '0.4', '572', '257'],\n",
" ['Rwanda', '153', '+3', ' ', '', '84', '69', '', '12', '', '6,959', '537'],\n",
" ['Guadeloupe', '148', '', '12 ', '', '73', '63', '13', '370', '30', '', ''],\n",
" ['Sudan', '140', '', '13 ', '', '12', '115', '', '3', '0.3', '', ''],\n",
" ['Brunei ',\n",
" '138',\n",
" '',\n",
" '1 ',\n",
" '',\n",
" '117',\n",
" '20',\n",
" '2',\n",
" '315',\n",
" '2',\n",
" '12,149',\n",
" '27,770'],\n",
" ['Gibraltar',\n",
" '132',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '120',\n",
" '12',\n",
" '1',\n",
" '3,918',\n",
" '',\n",
" '1,912',\n",
" '56,751'],\n",
" ['Myanmar',\n",
" '123',\n",
" '+2',\n",
" '5 ',\n",
" '',\n",
" '7',\n",
" '111',\n",
" '',\n",
" '2',\n",
" '0.09',\n",
" '5,198',\n",
" '96'],\n",
" ['Cambodia', '122', '', ' ', '', '110', '12', '1', '7', '', '5,768', '345'],\n",
" ['Madagascar', '121', '', ' ', '', '52', '69', '1', '4', '', '2,357', '85'],\n",
" ['Ethiopia',\n",
" '116',\n",
" '+2',\n",
" '3 ',\n",
" '',\n",
" '21',\n",
" '92',\n",
" '',\n",
" '1',\n",
" '0.03',\n",
" '9,771',\n",
" '85'],\n",
" ['Trinidad and Tobago',\n",
" '115',\n",
" '',\n",
" '8 ',\n",
" '',\n",
" '37',\n",
" '70',\n",
" '',\n",
" '82',\n",
" '6',\n",
" '1,425',\n",
" '1,018'],\n",
" ['Liberia', '101', '', '8 ', '', '20', '73', '', '20', '2', '', ''],\n",
" ['Aruba',\n",
" '100',\n",
" '+3',\n",
" '2 ',\n",
" '',\n",
" '68',\n",
" '30',\n",
" '4',\n",
" '937',\n",
" '19',\n",
" '1,504',\n",
" '14,087'],\n",
" ['Bermuda',\n",
" '98',\n",
" '',\n",
" '5 ',\n",
" '',\n",
" '39',\n",
" '54',\n",
" '10',\n",
" '1,574',\n",
" '80',\n",
" '877',\n",
" '14,082'],\n",
" ['French Guiana', '97', '', '1 ', '', '83', '13', '1', '325', '3', '', ''],\n",
" ['Monaco', '94', '', '3 ', '', '26', '65', '2', '2,395', '76', '', ''],\n",
" ['Togo', '88', '+2', '6 ', '', '56', '26', '', '11', '0.7', '4,733', '572'],\n",
" ['Maldives', '86', '', ' ', '', '16', '70', '2', '159', '', '4,139', '7,657'],\n",
" ['Equatorial Guinea',\n",
" '84',\n",
" '+1',\n",
" '1 ',\n",
" '+1',\n",
" '7',\n",
" '76',\n",
" '',\n",
" '60',\n",
" '0.7',\n",
" '854',\n",
" '609'],\n",
" ['Liechtenstein',\n",
" '81',\n",
" '',\n",
" '1 ',\n",
" '',\n",
" '55',\n",
" '25',\n",
" '',\n",
" '2,124',\n",
" '26',\n",
" '900',\n",
" '23,605'],\n",
" ['Barbados',\n",
" '75',\n",
" '',\n",
" '5 ',\n",
" '',\n",
" '25',\n",
" '45',\n",
" '4',\n",
" '261',\n",
" '17',\n",
" '1,098',\n",
" '3,821'],\n",
" ['Zambia', '74', '+4', '3 ', '', '35', '36', '1', '4', '0.2', '2,586', '141'],\n",
" ['Cabo Verde', '73', '+5', '1 ', '', '1', '71', '', '131', '2', '', ''],\n",
" ['Sint Maarten',\n",
" '71',\n",
" '+3',\n",
" '11 ',\n",
" '+1',\n",
" '22',\n",
" '38',\n",
" '2',\n",
" '1,656',\n",
" '257',\n",
" '258',\n",
" '6,017'],\n",
" ['Guyana', '67', '+1', '7 ', '', '9', '51', '5', '85', '9', '348', '442'],\n",
" ['Cayman Islands',\n",
" '66',\n",
" '',\n",
" '1 ',\n",
" '',\n",
" '7',\n",
" '58',\n",
" '3',\n",
" '1,004',\n",
" '15',\n",
" '778',\n",
" '11,838'],\n",
" ['Bahamas', '65', '', '9 ', '', '12', '44', '1', '165', '23', '', ''],\n",
" ['Sierra Leone', '61', '+11', ' ', '', '6', '55', '', '8', '', '', ''],\n",
" ['Uganda', '61', '', ' ', '', '45', '16', '', '1', '', '14,761', '323'],\n",
" ['Libya', '59', '', '1 ', '', '15', '43', '', '9', '0.1', '891', '130'],\n",
" ['Haiti', '58', '+1', '4 ', '+1', '2', '52', '', '5', '0.4', '642', '56'],\n",
" ['French Polynesia',\n",
" '57',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '35',\n",
" '22',\n",
" '1',\n",
" '203',\n",
" '',\n",
" '1,655',\n",
" '5,892'],\n",
" ['Benin', '54', '', '1 ', '', '27', '26', '', '4', '0.08', '', ''],\n",
" ['Guinea-Bissau', '50', '', ' ', '', '3', '47', '', '25', '', '1,500', '762'],\n",
" ['Macao', '45', '', ' ', '', '26', '19', '1', '69', '', '', ''],\n",
" ['Nepal', '45', '+3', ' ', '', '7', '38', '', '2', '', '8,773', '301'],\n",
" ['Syria', '42', '', '3 ', '', '6', '33', '', '2', '0.2', '', ''],\n",
" ['Mozambique', '41', '+2', ' ', '', '8', '33', '', '1', '', '1,247', '40'],\n",
" ['Eritrea', '39', '', ' ', '', '6', '33', '', '11', '', '', ''],\n",
" ['Saint Martin', '38', '', '2 ', '', '19', '17', '3', '983', '52', '', ''],\n",
" ['Mongolia', '35', '+1', ' ', '', '8', '27', '', '11', '', '7,130', '2,175'],\n",
" ['Chad', '33', '', ' ', '', '8', '25', '', '2', '', '', ''],\n",
" ['Eswatini', '31', '', '1 ', '', '8', '22', '', '27', '0.9', '714', '615'],\n",
" ['Zimbabwe', '28', '', '3 ', '', '2', '23', '', '2', '0.2', '4,159', '280'],\n",
" ['Angola', '25', '+1', '2 ', '', '6', '17', '', '0.8', '0.06', '', ''],\n",
" ['Antigua and Barbuda',\n",
" '24',\n",
" '+1',\n",
" '3 ',\n",
" '',\n",
" '10',\n",
" '11',\n",
" '1',\n",
" '245',\n",
" '31',\n",
" '108',\n",
" '1,103'],\n",
" ['Malawi', '23', '+5', '3 ', '+1', '3', '17', '1', '1', '0.2', '519', '27'],\n",
" ['Timor-Leste', '23', '', ' ', '', '1', '22', '', '17', '', '322', '244'],\n",
" ['Botswana',\n",
" '22',\n",
" '+2',\n",
" '1 ',\n",
" '',\n",
" '',\n",
" '21',\n",
" '',\n",
" '9',\n",
" '0.4',\n",
" '4,432',\n",
" '1,885'],\n",
" ['Laos', '19', '', ' ', '', '4', '15', '', '3', '', '1,461', '201'],\n",
" ['Belize', '18', '', '2 ', '', '2', '14', '1', '45', '5', '785', '1,974'],\n",
" ['Fiji', '18', '', ' ', '', '8', '10', '', '20', '', '', ''],\n",
" ['New Caledonia',\n",
" '18',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '17',\n",
" '1',\n",
" '1',\n",
" '63',\n",
" '',\n",
" '3,552',\n",
" '12,441'],\n",
" ['Dominica', '16', '', ' ', '', '9', '7', '', '222', '', '377', '5,237'],\n",
" ['Namibia', '16', '', ' ', '', '6', '10', '', '6', '', '524', '206'],\n",
" ['Saint Kitts and Nevis',\n",
" '15',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '1',\n",
" '14',\n",
" '',\n",
" '282',\n",
" '',\n",
" '257',\n",
" '4,831'],\n",
" ['Curaçao', '14', '', '1 ', '', '11', '2', '', '85', '6', '302', '1,840'],\n",
" ['CAR', '14', '', ' ', '', '10', '4', '', '3', '', '', ''],\n",
" ['Grenada', '14', '', ' ', '', '6', '8', '4', '124', '', '92', '818'],\n",
" ['St. Vincent Grenadines',\n",
" '13',\n",
" '+1',\n",
" ' ',\n",
" '',\n",
" '3',\n",
" '10',\n",
" '',\n",
" '117',\n",
" '',\n",
" '99',\n",
" '892'],\n",
" ['Burundi', '11', '+6', '1 ', '', '4', '6', '', '0.9', '0.08', '284', '24'],\n",
" ['Turks and Caicos',\n",
" '11',\n",
" '',\n",
" '1 ',\n",
" '',\n",
" '4',\n",
" '6',\n",
" '',\n",
" '284',\n",
" '26',\n",
" '83',\n",
" '2,144'],\n",
" ['Falkland Islands',\n",
" '11',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '3',\n",
" '8',\n",
" '',\n",
" '3,161',\n",
" '',\n",
" '319',\n",
" '91,667'],\n",
" ['Montserrat', '11', '', ' ', '', '2', '9', '1', '2,204', '', '36', '7,212'],\n",
" ['Seychelles', '11', '', ' ', '', '5', '6', '', '112', '', '', ''],\n",
" ['Nicaragua', '10', '', '2 ', '', '7', '1', '', '2', '0.3', '', ''],\n",
" ['Gambia', '10', '', '1 ', '', '2', '7', '', '4', '0.4', '316', '131'],\n",
" ['Suriname', '10', '', '1 ', '', '6', '3', '', '17', '2', '404', '689'],\n",
" ['MS Zaandam', '9', '', '2 ', '', '', '7'],\n",
" ['Vatican City', '9', '', ' ', '', '2', '7', '', '11,236', '', '', ''],\n",
" ['Papua New Guinea', '8', '+1', ' ', '', '', '8', '', '0.9', '', '604', '68'],\n",
" ['Bhutan', '6', '', ' ', '', '2', '4', '', '8', '', '8,953', '11,603'],\n",
" ['Western Sahara', '6', '', ' ', '', '', '6', '', '10', '', '', ''],\n",
" ['British Virgin Islands',\n",
" '5',\n",
" '',\n",
" '1 ',\n",
" '',\n",
" '3',\n",
" '1',\n",
" '',\n",
" '165',\n",
" '33',\n",
" '',\n",
" ''],\n",
" ['Caribbean Netherlands',\n",
" '5',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '',\n",
" '5',\n",
" '',\n",
" '191',\n",
" '',\n",
" '110',\n",
" '4,195'],\n",
" ['Sao Tome and Principe',\n",
" '4',\n",
" '',\n",
" ' ',\n",
" '',\n",
" '',\n",
" '4',\n",
" '',\n",
" '18',\n",
" '',\n",
" '19',\n",
" '87'],\n",
" ['South Sudan', '4', '', ' ', '', '', '4', '', '0.4', '', '', ''],\n",
" ['Anguilla', '3', '', ' ', '', '1', '2', '', '200', '', '', ''],\n",
" ['Saint Pierre Miquelon', '1', '', ' ', '', '', '1', '', '173', '', '', ''],\n",
" ['Yemen', '1', '', ' ', '', '', '1', '', '0.03', '', '', ''],\n",
" ['China',\n",
" '82,788',\n",
" '+30',\n",
" '4,632 ',\n",
" '',\n",
" '77,151',\n",
" '1,005',\n",
" '78',\n",
" '58',\n",
" '3',\n",
" '',\n",
" ''],\n",
" ['Total:',\n",
" '2,614,803',\n",
" '+59,043',\n",
" '182,467',\n",
" '+5,008',\n",
" '714,319',\n",
" '1,718,017',\n",
" '56,671',\n",
" '335.5',\n",
" '23.4',\n",
" '',\n",
" '']]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"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.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment