worldometer scraping (1).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['#', 'Country,other', 'TotalCases', 'NewCases', 'TotalDeaths', 'NewDeaths', 'TotalRecovered', 'NewRecovered', 'ActiveCases', 'Serious,Critical', 'TotalCases/1M pop', 'Deaths/1M pop', 'TotalTests', 'Tests/1M pop', 'Population'], ['1', 'USA', '7,679,644', '', '215,032 ', '', '4,895,078', '', '2,569,534', '14,283', '23,165', '649', '112,503,131', '339,360', '331,515,730 '], ['2', 'India', '6,685,082', '+3,009', '103,600 ', '', '5,662,490', '+3,380', '918,992', '8,944', '4,832', '75', '81,071,797', '58,596', '1,383,567,415 '], ['3', 'Brazil', '4,940,499', '', '146,773 ', '', '4,295,302', '', '498,424', '8,318', '23,199', '689', '17,900,000', '84,054', '212,958,012 '], ['4', 'Russia', '1,225,889', '', '21,475 ', '', '982,324', '', '222,090', '2,300', '8,399', '147', '48,042,343', '329,167', '145,951,147 '], ['5', 'Colombia', '862,158', '', '26,844 ', '', '766,300', '', '69,014', '2,220', '16,897', '526', '3,930,262', '77,026', '51,025,119 '], ['6', 'Spain', '852,838', '', '32,225 ', '', 'N/A', 'N/A', 'N/A', '1,580', '18,239', '689', '13,689,776', '292,769', '46,759,607 '], ['7', 'Peru', '829,999', '', '32,834 ', '', '712,888', '', '84,277', '1,269', '25,082', '992', '3,961,345', '119,708', '33,091,634 '], ['8', 'Argentina', '809,728', '', '21,468 ', '', '649,017', '', '139,243', '3,978', '17,873', '474', '2,084,513', '46,011', '45,304,806 '], ['9', 'Mexico', '761,665', '', '79,088 ', '', '550,053', '', '132,524', '2,401', '5,891', '612', '2,003,141', '15,494', '129,288,090 '], ['10', 'South Africa', '682,215', '', '17,016 ', '', '615,684', '', '49,515', '539', '11,465', '286', '4,280,340', '71,933', '59,504,141 '], ['11', 'France', '624,274', '', '32,299 ', '', '98,680', '', '493,295', '1,415', '9,558', '495', '11,616,000', '177,854', '65,311,915 '], ['12', 'UK', '515,571', '', '42,369 ', '', 'N/A', 'N/A', 'N/A', '368', '7,584', '623', '25,865,851', '380,490', '67,980,370 '], ['13', 'Iran', '475,674', '', '27,192 ', '', '392,293', '', '56,189', '4,167', '5,644', '323', '4,151,445', '49,261', '84,273,859 '], ['14', 'Chile', '471,746', '', '13,037 ', '', '443,453', '', '15,256', '853', '24,622', '680', '3,502,751', '182,822', '19,159,383 '], ['15', 'Iraq', '382,949', '', '9,464 ', '', '312,158', '', '61,327', '556', '9,466', '234', '2,371,348', '58,618', '40,454,349 '], ['16', 'Bangladesh', '370,132', '', '5,375 ', '', '283,182', '', '81,575', '', '2,242', '33', '2,001,431', '12,121', '165,120,172 '], ['17', 'Saudi Arabia', '336,766', '', '4,898 ', '', '322,055', '', '9,813', '938', '9,634', '140', '6,725,148', '192,395', '34,954,860 '], ['18', 'Italy', '327,586', '', '36,002 ', '', '232,681', '', '58,903', '323', '5,420', '596', '11,844,346', '195,975', '60,438,050 '], ['19', 'Turkey', '326,046', '', '8,498 ', '', '286,370', '', '31,178', '1,412', '3,855', '100', '10,931,917', '129,254', '84,577,023 '], ['20', 'Philippines', '324,762', '', '5,840 ', '', '273,123', '', '45,799', '1,758', '2,953', '53', '3,914,732', '35,601', '109,961,842 '], ['21', 'Pakistan', '315,727', '+467', '6,523 ', '+6', '300,616', '+780', '8,588', '516', '1,422', '29', '3,702,607', '16,678', '222,000,149 '], ['22', 'Indonesia', '307,120', '', '11,253 ', '', '232,593', '', '63,274', '', '1,120', '41', '3,515,165', '12,816', '274,282,230 '], ['23', 'Germany', '304,657', '', '9,616 ', '', '263,700', '', '31,341', '447', '3,633', '115', '16,999,253', '202,722', '83,855,064 '], ['24', 'Israel', '273,826', '+1,517', '1,757 ', '', '208,763', '+4,408', '63,306', '875', '29,771', '191', '3,733,880', '405,963', '9,197,590 '], ['25', 'Ukraine', '234,584', '+4,348', '4,520 ', '+90', '103,401', '+2,149', '126,663', '177', '5,373', '104', '2,397,905', '54,918', '43,663,012 '], ['26', 'Canada', '168,960', '', '9,504 ', '', '142,334', '', '17,122', '126', '4,466', '251', '7,695,259', '203,421', '37,829,211 '], ['27', 'Ecuador', '141,339', '', '11,681 ', '', '120,511', '', '9,147', '356', '7,979', '659', '455,122', '25,695', '17,712,769 '], ['28', 'Netherlands', '140,471', '', '6,461 ', '', 'N/A', 'N/A', 'N/A', '177', '8,193', '377', '2,603,166', '151,833', '17,144,953 '], ['29', 'Romania', '137,491', '', '5,048 ', '', '108,526', '', '23,917', '592', '7,160', '263', '2,516,746', '131,059', '19,203,100 '], ['30', 'Bolivia', '137,107', '+239', '8,129 ', '+28', '98,007', '+460', '30,971', '71', '11,704', '694', '308,129', '26,303', '11,714,567 '], ['31', 'Morocco', '134,695', '', '2,369 ', '', '113,336', '', '18,990', '457', '3,638', '64', '2,731,907', '73,785', '37,025,060 '], ['32', 'Belgium', '132,203', '+1,968', '10,078 ', '+14', '19,712', '+33', '102,413', '195', '11,394', '869', '3,426,621', '295,322', '11,602,989 '], ['33', 'Qatar', '126,692', '', '216 ', '', '123,664', '', '2,812', '59', '45,121', '77', '800,519', '285,105', '2,807,805 '], ['34', 'Panama', '115,919', '', '2,430 ', '', '92,423', '', '21,066', '119', '26,756', '561', '508,442', '117,357', '4,332,425 '], ['35', 'Dominican Republic', '115,054', '', '2,144 ', '', '90,942', '', '21,968', '169', '10,578', '197', '496,200', '45,621', '10,876,468 '], ['36', 'Kazakhstan', '108,296', '+60', '1,725 ', '', '103,367', '+90', '3,204', '221', '5,750', '92', '2,973,489', '157,866', '18,835,477 '], ['37', 'Kuwait', '107,592', '', '628 ', '', '99,549', '', '7,415', '129', '25,097', '146', '761,025', '177,519', '4,287,017 '], ['38', 'Egypt', '103,781', '', '5,990 ', '', '97,398', '', '393', '41', '1,009', '58', '135,000', '1,313', '102,833,416 '], ['39', 'Poland', '102,080', '', '2,659 ', '', '73,552', '', '25,869', '219', '2,698', '70', '3,465,605', '91,597', '37,835,532 '], ['40', 'Oman', '101,814', '', '985 ', '', '90,600', '', '10,229', '207', '19,809', '192', '376,700', '73,291', '5,139,805 '], ['41', 'UAE', '99,733', '', '429 ', '', '89,410', '', '9,894', '', '10,052', '43', '10,220,534', '1,030,123', '9,921,664 '], ['42', 'Sweden', '94,283', '', '5,895 ', '', 'N/A', 'N/A', 'N/A', '20', '9,320', '583', '1,661,484', '164,245', '10,115,901 '], ['43', 'Guatemala', '94,182', '', '3,302 ', '', '82,828', '', '8,052', '5', '5,232', '183', '338,692', '18,815', '18,001,305 '], ['44', 'Nepal', '89,263', '', '554 ', '', '65,202', '', '23,507', '', '3,049', '19', '1,088,229', '37,176', '29,272,508 '], ['45', 'Japan', '85,739', '', '1,599 ', '', '78,609', '', '5,531', '131', '678', '13', '2,173,035', '17,195', '126,372,667 '], ['46', 'Czechia', '85,566', '', '758 ', '', '46,636', '', '38,172', '245', '7,986', '71', '1,457,315', '136,016', '10,714,267 '], ['47', 'Costa Rica', '81,129', '', '987 ', '', '49,703', '', '30,439', '212', '15,888', '193', '243,276', '47,642', '5,106,348 '], ['48', 'Belarus', '80,696', '', '862 ', '', '75,303', '', '4,531', '', '8,541', '91', '1,949,656', '206,346', '9,448,493 '], ['49', 'Honduras', '80,020', '+391', '2,433 ', '+11', '29,768', '+463', '47,819', '29', '8,046', '245', '188,174', '18,920', '9,945,548 '], ['50', 'Portugal', '79,885', '', '2,018 ', '', '50,454', '', '27,413', '106', '7,841', '198', '2,647,756', '259,871', '10,188,741 '], ['51', 'Ethiopia', '79,437', '', '1,230 ', '', '34,016', '', '44,191', '292', '687', '11', '1,307,632', '11,303', '115,691,975 '], ['52', 'Venezuela', '79,117', '', '658 ', '', '69,832', '', '8,627', '215', '2,784', '23', '1,965,367', '69,168', '28,414,349 '], ['53', 'Bahrain', '73,116', '', '261 ', '', '67,933', '', '4,922', '61', '42,598', '152', '1,488,703', '867,330', '1,716,420 '], ['54', 'Nigeria', '59,465', '', '1,113 ', '', '50,951', '', '7,401', '7', '287', '5', '535,733', '2,583', '207,446,404 '], ['55', 'Uzbekistan', '59,197', '+251', '487 ', '+2', '55,751', '+118', '2,959', '252', '1,762', '14', '1,377,915', '41,015', '33,595,577 '], ['56', 'Singapore', '57,819', '', '27 ', '', '57,597', '', '195', '', '9,863', '5', '2,885,545', '492,207', '5,862,465 '], ['57', 'Moldova', '56,901', '', '1,375 ', '', '41,467', '', '14,059', '744', '14,114', '341', '293,824', '72,883', '4,031,452 '], ['58', 'Switzerland', '55,932', '', '2,078 ', '', '45,800', '', '8,054', '32', '6,450', '240', '1,417,260', '163,442', '8,671,313 '], ['59', 'Armenia', '53,083', '+406', '990 ', '+6', '44,932', '+222', '7,161', '', '17,905', '334', '309,945', '104,545', '2,964,716 '], ['60', 'Algeria', '52,270', '', '1,768 ', '', '36,672', '', '13,830', '23', '1,186', '40', '', '', '44,056,057 '], ['61', 'Austria', '48,896', '', '818 ', '', '39,058', '', '9,020', '101', '5,421', '91', '1,698,268', '188,278', '9,019,985 '], ['62', 'Kyrgyzstan', '47,799', '+164', '1,066 ', '', '43,644', '+123', '3,089', '24', '7,295', '163', '276,522', '42,203', '6,552,140 '], ['63', 'Ghana', '46,829', '', '303 ', '', '46,060', '', '466', '4', '1,499', '10', '488,427', '15,635', '31,240,028 '], ['64', 'Lebanon', '45,657', '', '414 ', '', '20,243', '', '25,000', '167', '6,697', '61', '896,623', '131,523', '6,817,233 '], ['65', 'Paraguay', '44,715', '', '947 ', '', '27,887', '', '15,881', '152', '6,249', '132', '290,507', '40,599', '7,155,451 '], ['66', 'Palestine', '41,957', '', '339 ', '', '35,182', '', '6,436', '', '8,176', '66', '437,500', '85,252', '5,131,832 '], ['67', 'Azerbaijan', '40,788', '', '598 ', '', '38,587', '', '1,603', '', '4,013', '59', '1,140,194', '112,188', '10,163,210 '], ['68', 'Kenya', '39,449', '', '735 ', '', '27,035', '', '11,679', '', '730', '14', '564,078', '10,431', '54,075,779 '], ['69', 'Afghanistan', '39,422', '', '1,466 ', '', '32,879', '', '5,077', '93', '1,007', '37', '112,278', '2,868', '39,153,520 '], ['70', 'Ireland', '38,549', '', '1,810 ', '', '23,364', '', '13,375', '20', '7,784', '365', '1,245,263', '251,455', '4,952,238 '], ['71', 'Libya', '37,437', '', '596 ', '', '22,076', '', '14,765', '', '5,429', '86', '222,054', '32,202', '6,895,673 '], ['72', 'Serbia', '33,952', '', '756 ', '', '31,536', '', '1,660', '20', '3,890', '87', '1,159,806', '132,885', '8,727,922 '], ['73', 'Hungary', '32,298', '+818', '853 ', '+20', '8,723', '+558', '22,722', '37', '3,346', '88', '771,297', '79,896', '9,653,780 '], ['74', 'Denmark', '30,057', '', '659 ', '', '23,122', '', '6,276', '30', '5,184', '114', '4,084,612', '704,533', '5,797,614 '], ['75', 'El Salvador', '29,539', '', '869 ', '+4', '24,406', '', '4,264', '36', '4,548', '134', '408,212', '62,851', '6,494,868 '], ['76', 'Bosnia and Herzegovina', '28,449', '', '888 ', '', '22,032', '', '5,529', '', '8,686', '271', '248,975', '76,015', '3,275,322 '], ['77', 'Australia', '27,173', '+24', '895 ', '+1', '24,892', '', '1,386', '4', '1,062', '35', '7,812,955', '305,464', '25,577,350 '], ['78', 'S. Korea', '24,239', '+75', '422 ', '', '22,083', '+197', '1,734', '105', '473', '8', '2,365,433', '46,127', '51,280,942 '], ['79', 'Tunisia', '22,230', '', '321 ', '', '5,032', '', '16,877', '116', '1,876', '27', '250,479', '21,136', '11,851,061 '], ['80', 'Bulgaria', '21,870', '', '854 ', '', '15,179', '', '5,837', '59', '3,154', '123', '546,789', '78,852', '6,934,328 '], ['81', 'Cameroon', '20,924', '', '420 ', '', '19,764', '', '740', '30', '783', '16', '149,000', '5,577', '26,714,844 '], ['82', 'Greece', '20,142', '', '417 ', '', '9,989', '', '9,736', '83', '1,935', '40', '1,355,126', '130,183', '10,409,368 '], ['83', 'Ivory Coast', '19,885', '', '120 ', '', '19,490', '', '275', '', '749', '5', '166,699', '6,280', '26,545,355 '], ['84', 'North Macedonia', '18,873', '', '760 ', '', '15,487', '', '2,626', '3', '9,059', '365', '195,541', '93,859', '2,083,351 '], ['85', 'Myanmar', '18,781', '', '444 ', '', '5,548', '', '12,789', '', '345', '8', '332,875', '6,107', '54,506,087 '], ['86', 'Croatia', '17,797', '', '300 ', '', '16,031', '', '1,466', '24', '4,342', '73', '328,392', '80,126', '4,098,448 '], ['87', 'Jordan', '17,464', '', '110 ', '', '5,292', '', '12,062', '48', '1,707', '11', '1,311,436', '128,198', '10,229,730 '], ['88', 'Madagascar', '16,570', '', '233 ', '', '15,601', '', '736', '14', '594', '8', '73,053', '2,621', '27,872,790 '], ['89', 'Senegal', '15,122', '', '312 ', '', '12,870', '', '1,940', '6', '897', '19', '183,115', '10,863', '16,856,459 '], ['90', 'Zambia', '15,089', '', '334 ', '', '14,306', '', '449', '', '815', '18', '164,951', '8,909', '18,514,858 '], ['91', 'Norway', '14,605', '', '275 ', '', '11,190', '', '3,140', '3', '2,688', '51', '1,095,488', '201,658', '5,432,411 '], ['92', 'Albania', '14,410', '', '400 ', '', '8,825', '', '5,185', '23', '5,009', '139', '88,622', '30,804', '2,876,957 '], ['93', 'Sudan', '13,653', '', '836 ', '', '6,764', '', '6,053', '', '310', '19', '', '', '44,111,819 '], ['94', 'Slovakia', '13,492', '', '55 ', '', '4,865', '', '8,572', '37', '2,471', '10', '496,284', '90,889', '5,460,347 '], ['95', 'Malaysia', '12,813', '', '137 ', '', '10,340', '', '2,336', '32', '395', '4', '1,627,612', '50,120', '32,474,352 '], ['96', 'Montenegro', '12,359', '', '182 ', '', '8,308', '', '3,869', '17', '19,677', '290', '72,393', '115,260', '628,087 '], ['97', 'Namibia', '11,654', '', '125 ', '', '9,451', '', '2,078', '8', '4,565', '49', '103,854', '40,682', '2,552,818 '], ['98', 'Guinea', '10,800', '', '67 ', '', '10,161', '', '572', '24', '817', '5', '33,676', '2,547', '13,223,514 '], ['99', 'DRC', '10,778', '', '274 ', '', '10,239', '', '265', '', '119', '3', '', '', '90,250,563 '], ['100', 'Finland', '10,702', '', '346 ', '', '8,100', '', '2,256', '8', '1,931', '62', '1,084,319', '195,619', '5,543,011 '], ['101', 'Maldives', '10,567', '', '34 ', '', '9,427', '', '1,106', '12', '19,460', '63', '150,743', '277,606', '543,011 '], ['102', 'French Guiana', '10,057', '', '68 ', '', '9,710', '', '279', '4', '33,450', '226', '67,833', '225,615', '300,658 '], ['103', 'Tajikistan', '9,974', '', '78 ', '', '8,794', '', '1,102', '', '1,040', '8', '', '', '9,592,672 '], ['104', 'Mozambique', '9,296', '', '66 ', '', '6,104', '', '3,126', '', '295', '2', '1,446,106', '45,940', '31,478,070 '], ['105', 'Georgia', '9,245', '+549', '58 ', '+4', '4,887', '+268', '4,300', '', '2,319', '15', '679,169', '170,341', '3,987,118 '], ['106', 'Uganda', '8,965', '', '82 ', '', '5,078', '', '3,805', '', '194', '2', '493,595', '10,706', '46,105,806 '], ['107', 'Luxembourg', '8,925', '', '127 ', '', '7,793', '', '1,005', '2', '14,198', '202', '856,798', '1,362,976', '628,623 '], ['108', 'Haiti', '8,827', '', '229 ', '', '6,992', '', '1,606', '', '772', '20', '28,916', '2,528', '11,438,886 '], ['109', 'Gabon', '8,808', '', '54 ', '', '8,135', '', '619', '3', '3,934', '24', '185,889', '83,016', '2,239,196 '], ['110', 'Zimbabwe', '7,898', '', '228 ', '', '6,424', '', '1,246', '', '529', '15', '160,162', '10,735', '14,919,287 '], ['111', 'Mauritania', '7,523', '', '162 ', '', '7,204', '', '157', '3', '1,607', '35', '81,120', '17,330', '4,680,832 '], ['112', 'Jamaica', '7,012', '', '120 ', '', '2,635', '', '4,257', '12', '2,365', '40', '81,132', '27,367', '2,964,592 '], ['113', 'Slovenia', '6,573', '', '156 ', '', '4,314', '', '2,103', '26', '3,162', '75', '237,545', '114,258', '2,079,014 '], ['114', 'Cabo Verde', '6,433', '', '68 ', '', '5,524', '', '841', '', '11,538', '122', '87,076', '156,171', '557,570 '], ['115', 'Cuba', '5,845', '', '123 ', '', '5,232', '', '490', '1', '516', '11', '651,035', '57,488', '11,324,770 '], ['116', 'Malawi', '5,794', '', '180 ', '', '4,541', '', '1,073', '4', '301', '9', '54,472', '2,829', '19,256,143 '], ['117', 'Eswatini', '5,579', '', '112 ', '', '5,141', '', '326', '11', '4,796', '96', '45,325', '38,962', '1,163,316 '], ['118', 'Angola', '5,530', '', '199 ', '', '2,591', '', '2,740', '16', '167', '6', '85,213', '2,572', '33,124,688 '], ['119', 'Guadeloupe', '5,528', '', '57 ', '', '2,199', '', '3,272', '24', '13,815', '142', '55,187', '137,919', '400,142 '], ['120', 'Djibouti', '5,421', '', '61 ', '', '5,352', '', '8', '', '5,466', '62', '78,079', '78,729', '991,743 '], ['121', 'Lithuania', '5,285', '', '94 ', '', '2,497', '', '2,694', '', '1,949', '35', '801,362', '295,494', '2,711,942 '], ['122', 'Nicaragua', '5,170', '', '151 ', '', '2,913', '', '2,106', '', '778', '23', '', '', '6,645,180 '], ['123', 'Hong Kong', '5,125', '', '105 ', '', '4,864', '', '156', '11', '682', '14', '3,311,279', '440,740', '7,513,000 '], ['124', 'Congo', '5,089', '', '89 ', '', '3,887', '', '1,113', '', '916', '16', '', '', '5,552,838 '], ['125', 'Equatorial Guinea', '5,045', '', '83 ', '', '4,879', '', '83', '4', '3,566', '59', '60,916', '43,062', '1,414,597 '], ['126', 'Suriname', '4,954', '', '106 ', '', '4,755', '', '93', '6', '8,425', '180', '14,770', '25,118', '588,014 '], ['127', 'Rwanda', '4,867', '', '29 ', '', '3,226', '', '1,612', '', '373', '2', '506,658', '38,871', '13,034,340 '], ['128', 'CAR', '4,845', '', '62 ', '', '1,914', '', '2,869', '2', '999', '13', '32,263', '6,650', '4,851,534 '], ['129', 'Trinidad and Tobago', '4,767', '', '82 ', '', '2,884', '', '1,801', '14', '3,403', '59', '32,474', '23,184', '1,400,691 '], ['130', 'Bahamas', '4,452', '', '96 ', '', '2,375', '', '1,981', '96', '11,293', '244', '21,592', '54,770', '394,231 '], ['131', 'Syria', '4,411', '', '207 ', '', '1,168', '', '3,036', '', '250', '12', '', '', '17,609,496 '], ['132', 'Réunion', '4,328', '', '16 ', '', '3,360', '', '952', '17', '4,825', '18', '35,419', '39,486', '896,997 '], ['133', 'Aruba', '4,094', '', '31 ', '', '3,612', '', '451', '12', '38,302', '290', '32,982', '308,572', '106,886 '], ['134', 'Mayotte', '3,892', '', '42 ', '', '2,964', '', '886', '2', '14,178', '153', '13,000', '47,359', '274,501 '], ['135', 'Somalia', '3,745', '', '99 ', '', '3,010', '', '636', '', '234', '6', '', '', '16,005,981 '], ['136', 'Sri Lanka', '3,733', '+220', '13 ', '', '3,259', '', '461', '', '174', '0.6', '298,501', '13,925', '21,437,046 '], ['137', 'Estonia', '3,617', '', '67 ', '', '2,755', '', '795', '2', '2,726', '50', '221,992', '167,317', '1,326,773 '], ['138', 'Thailand', '3,600', '+10', '59 ', '', '3,390', '', '151', '1', '52', '0.8', '749,213', '10,727', '69,846,526 '], ['139', 'Gambia', '3,594', '', '115 ', '', '2,226', '', '1,253', '', '1,477', '47', '17,472', '7,179', '2,433,927 '], ['140', 'Malta', '3,327', '', '39 ', '', '2,770', '', '518', '', '7,530', '88', '265,630', '601,170', '441,855 '], ['141', 'Mali', '3,189', '', '131 ', '', '2,482', '', '576', '', '156', '6', '56,337', '2,762', '20,398,911 '], ['142', 'Guyana', '3,188', '', '90 ', '', '1,972', '', '1,126', '14', '4,048', '114', '15,078', '19,145', '787,557 '], ['143', 'Botswana', '3,172', '', '16 ', '', '710', '', '2,446', '1', '1,342', '7', '184,076', '77,870', '2,363,874 '], ['144', 'Iceland', '2,980', '', '10 ', '', '2,300', '', '670', '3', '8,718', '29', '289,017', '845,504', '341,828 '], ['145', 'South Sudan', '2,726', '', '50 ', '', '1,290', '', '1,386', '', '243', '4', '12,044', '1,073', '11,228,079 '], ['146', 'Guinea-Bissau', '2,385', '', '40 ', '', '1,728', '', '617', '5', '1,205', '20', '', '', '1,979,923 '], ['147', 'Andorra', '2,370', '', '53 ', '', '1,615', '', '702', '9', '30,661', '686', '137,457', '1,778,274', '77,298 '], ['148', 'Benin', '2,357', '', '41 ', '', '1,973', '', '343', '', '193', '3', '203,831', '16,702', '12,204,208 '], ['149', 'Sierra Leone', '2,269', '', '72 ', '', '1,706', '', '491', '', '283', '9', '', '', '8,018,812 '], ['150', 'French Polynesia', '2,228', '', '9 ', '', '1,769', '', '450', '7', '7,919', '32', '26,355', '93,678', '281,337 '], ['151', 'Belize', '2,204', '+8', '30 ', '', '1,378', '', '796', '5', '5,517', '75', '16,071', '40,228', '399,497 '], ['152', 'Burkina Faso', '2,184', '', '59 ', '', '1,420', '', '705', '', '104', '3', '', '', '21,049,165 '], ['153', 'Uruguay', '2,155', '', '48 ', '', '1,862', '', '245', '3', '620', '14', '248,736', '71,539', '3,476,925 '], ['154', 'Latvia', '2,126', '', '39 ', '', '1,307', '', '780', '4', '1,131', '21', '336,577', '178,979', '1,880,541 '], ['155', 'Yemen', '2,041', '', '592 ', '', '1,323', '', '126', '', '68', '20', '', '', '29,994,833 '], ['156', 'Togo', '1,864', '', '48 ', '', '1,403', '', '413', '', '224', '6', '95,658', '11,486', '8,328,475 '], ['157', 'New Zealand', '1,858', '+3', '25 ', '', '1,790', '', '43', '1', '371', '5', '985,639', '197,045', '5,002,100 '], ['158', 'Cyprus', '1,847', '', '22 ', '', '1,369', '', '456', '1', '1,527', '18', '394,211', '325,881', '1,209,677 '], ['159', 'Lesotho', '1,683', '', '39 ', '', '926', '', '718', '', '784', '18', '19,428', '9,050', '2,146,723 '], ['160', 'Martinique', '1,543', '', '21 ', '', '98', '', '1,424', '16', '4,113', '56', '36,331', '96,834', '375,187 '], ['161', 'Liberia', '1,354', '', '82 ', '', '1,236', '', '36', '2', '266', '16', '29,514', '5,801', '5,088,158 '], ['162', 'Chad', '1,223', '', '86 ', '', '1,075', '', '62', '', '74', '5', '', '', '16,545,547 '], ['163', 'Niger', '1,200', '', '69 ', '', '1,115', '', '16', '', '49', '3', '26,229', '1,074', '24,425,957 '], ['164', 'Vietnam', '1,097', '', '35 ', '', '1,022', '', '40', '', '11', '0.4', '1,009,145', '10,343', '97,568,899 '], ['165', 'Sao Tome and Principe', '913', '', '15 ', '', '888', '', '10', '', '4,146', '68', '5,122', '23,259', '220,212 '], ['166', 'San Marino', '732', '', '42 ', '', '680', '', '10', '3', '21,561', '1,237', '7,755', '228,424', '33,950 '], ['167', 'Diamond Princess', '712', '', '13 ', '', '651', '', '48', '4', '', '', '', '', ' '], ['168', 'Turks and Caicos', '695', '', '6 ', '', '656', '', '33', '4', '17,887', '154', '3,504', '90,184', '38,854 '], ['169', 'Channel Islands', '686', '', '48 ', '', '600', '', '38', '2', '3,936', '275', '123,884', '710,817', '174,284 '], ['170', 'Sint Maarten', '686', '+7', '22 ', '', '592', '+20', '72', '6', '15,952', '512', '4,642', '107,946', '43,003 '], ['171', 'Papua New Guinea', '540', '', '7 ', '', '527', '', '6', '', '60', '0.8', '25,955', '2,887', '8,990,835 '], ['172', 'Taiwan', '518', '', '7 ', '', '485', '', '26', '', '22', '0.3', '94,734', '3,976', '23,828,244 '], ['173', 'Burundi', '514', '', '1 ', '', '472', '', '41', '', '43', '0.08', '37,522', '3,132', '11,980,524 '], ['174', 'Tanzania', '509', '', '21 ', '', '183', '', '305', '7', '8', '0.3', '', '', '60,166,421 '], ['175', 'Comoros', '487', '', '7 ', '', '466', '', '14', '', '557', '8', '', '', '874,369 '], ['176', 'Faeroe Islands', '475', '', ' ', '', '441', '', '34', '', '9,711', '', '134,070', '2,741,045', '48,912 '], ['177', 'Curaçao', '462', '', '1 ', '', '242', '', '219', '2', '2,812', '6', '8,045', '48,974', '164,271 '], ['178', 'Gibraltar', '432', '', ' ', '', '363', '', '69', '', '12,824', '', '49,149', '1,458,947', '33,688 '], ['179', 'Saint Martin', '412', '', '8 ', '', '309', '', '95', '11', '10,608', '206', '5,170', '133,120', '38,837 '], ['180', 'Eritrea', '398', '', ' ', '', '358', '', '40', '', '112', '', '', '', '3,559,223 '], ['181', 'Mauritius', '387', '', '10 ', '', '357', '', '20', '', '304', '8', '253,248', '199,043', '1,272,330 '], ['182', 'Isle of Man', '344', '', '24 ', '', '316', '', '4', '', '4,040', '282', '13,627', '160,031', '85,152 '], ['183', 'Mongolia', '315', '+1', ' ', '', '307', '', '8', '1', '96', '', '74,445', '22,614', '3,292,006 '], ['184', 'Bhutan', '299', '+1', ' ', '', '248', '+11', '51', '', '386', '', '144,498', '186,730', '773,835 '], ['185', 'Cambodia', '280', '', ' ', '', '276', '+1', '4', '', '17', '', '145,448', '8,668', '16,779,316 '], ['186', 'Monaco', '223', '', '2 ', '', '193', '', '28', '1', '5,672', '51', '51,953', '1,321,455', '39,315 '], ['187', 'Cayman Islands', '213', '', '1 ', '', '210', '', '2', '', '3,231', '15', '40,092', '608,155', '65,924 '], ['188', 'Barbados', '200', '', '7 ', '', '182', '', '11', '', '696', '24', '24,849', '86,441', '287,469 '], ['189', 'Bermuda', '181', '', '9 ', '', '170', '', '2', '', '2,909', '145', '67,860', '1,090,716', '62,216 '], ['190', 'Brunei ', '146', '', '3 ', '', '142', '', '1', '', '333', '7', '58,914', '134,329', '438,580 '], ['191', 'Seychelles', '146', '', ' ', '', '143', '', '3', '', '1,482', '', '5,200', '52,788', '98,508 '], ['192', 'Liechtenstein', '127', '', '1 ', '', '116', '', '10', '', '3,328', '26', '900', '23,587', '38,157 '], ['193', 'Caribbean Netherlands', '124', '', '1 ', '', '46', '', '77', '', '4,717', '38', '2,575', '97,957', '26,287 '], ['194', 'Antigua and Barbuda', '107', '', '3 ', '', '96', '', '8', '', '1,090', '31', '2,958', '30,140', '98,142 '], ['195', 'British Virgin Islands', '71', '', '1 ', '', '66', '', '4', '2', '2,344', '33', '4,841', '159,853', '30,284 '], ['196', 'St. Vincent Grenadines', '64', '', ' ', '', '64', '', '0', '', '576', '', '5,386', '48,508', '111,034 '], ['197', 'St. Barth', '62', '', ' ', '', '37', '', '25', '', '6,272', '', '2,668', '269,904', '9,885 '], ['198', 'Macao', '46', '', ' ', '', '46', '', '0', '', '71', '', '4,238', '6,504', '651,645 '], ['199', 'Fiji', '32', '', '2 ', '', '28', '', '2', '1', '36', '2', '10,385', '11,563', '898,158 '], ['200', 'Dominica', '31', '', ' ', '', '24', '', '7', '', '430', '', '2,612', '36,261', '72,034 '], ['201', 'Timor-Leste', '28', '', ' ', '', '28', '', '0', '', '21', '', '8,073', '6,093', '1,324,935 '], ['202', 'New Caledonia', '27', '', ' ', '', '27', '', '0', '', '94', '', '14,585', '50,957', '286,219 '], ['203', 'Saint Lucia', '27', '', ' ', '', '27', '', '0', '', '147', '', '8,439', '45,902', '183,849 '], ['204', 'Grenada', '24', '', ' ', '', '24', '', '0', '', '213', '', '6,252', '55,494', '112,661 '], ['205', 'Laos', '23', '', ' ', '', '22', '', '1', '', '3', '', '55,110', '7,546', '7,303,065 '], ['206', 'Saint Kitts and Nevis', '19', '', ' ', '', '17', '', '2', '', '356', '', '2,455', '46,062', '53,298 '], ['207', 'Saint Pierre Miquelon', '16', '', ' ', '', '6', '', '10', '', '2,765', '', '1,967', '339,959', '5,786 '], ['208', 'Greenland', '14', '', ' ', '', '14', '', '0', '', '246', '', '8,254', '145,327', '56,796 '], ['209', 'Montserrat', '13', '', '1 ', '', '12', '', '0', '', '2,604', '200', '483', '96,735', '4,993 '], ['210', 'Falkland Islands', '13', '', ' ', '', '13', '', '0', '', '3,708', '', '2,261', '644,894', '3,506 '], ['211', 'Vatican City', '12', '', ' ', '', '12', '', '0', '', '14,963', '', '', '', '802 '], ['212', 'Western Sahara', '10', '', '1 ', '', '8', '', '1', '', '17', '2', '', '', '601,097 '], ['213', 'MS Zaandam', '9', '', '2 ', '', '', '', '7', '', '', '', '', '', ' '], ['214', 'Anguilla', '3', '', ' ', '', '3', '', '0', '', '199', '', '1,020', '67,828', '15,038 '], ['215', 'Solomon Islands', '1', '', ' ', '', '', '', '1', '', '1', '', '', '', '691,194 ']]\n"
     ]
    }
   ],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "url=BeautifulSoup('https://www.worldometers.info/coronavirus/','html.parser')\n",
    "start=requests.get(url)\n",
    "s1=start.text\n",
    "soup=BeautifulSoup(s1,'lxml')\n",
    "tags=soup.table\n",
    "tag=tags.find_all('tr')\n",
    "list1=[]\n",
    "for i in range(len(tag)):\n",
    "    x=tag[i].get_text()\n",
    "    list1.append(x)\n",
    "del list1[1:7]\n",
    "del list1[1:3]\n",
    "list1=list1[:216]\n",
    "final=[]\n",
    "for j in list1:\n",
    "    y=j.split('\\n')[1:-1]\n",
    "    final.append(y)\n",
    "for k in range(len(final)):\n",
    "    del final[k][-2:]\n",
    "final[0]=['#',\n",
    "  'Country,other',\n",
    "  'TotalCases',\n",
    "  'NewCases',\n",
    "  'TotalDeaths',\n",
    "  'NewDeaths',\n",
    "  'TotalRecovered',\n",
    "  'NewRecovered',\n",
    "  'ActiveCases',\n",
    "  'Serious,Critical',\n",
    "  'TotalCases/1M pop',\n",
    "  'Deaths/1M pop',\n",
    "  'TotalTests',\n",
    "  'Tests/1M pop',\n",
    "  'Population']\n",
    "#print(final[2])\n",
    "print(final)\n",
    "#print(len(final[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "with open(\"out.csv\", \"w\", encoding=\"utf8\") as f:\n",
    "    writer = csv.writer(f)\n",
    "    writer.writerows(final)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>#</th>\n",
       "      <th>Country,other</th>\n",
       "      <th>TotalCases</th>\n",
       "      <th>NewCases</th>\n",
       "      <th>TotalDeaths</th>\n",
       "      <th>NewDeaths</th>\n",
       "      <th>TotalRecovered</th>\n",
       "      <th>NewRecovered</th>\n",
       "      <th>ActiveCases</th>\n",
       "      <th>Serious,Critical</th>\n",
       "      <th>TotalCases/1M pop</th>\n",
       "      <th>Deaths/1M pop</th>\n",
       "      <th>TotalTests</th>\n",
       "      <th>Tests/1M pop</th>\n",
       "      <th>Population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "      <td>7,679,644</td>\n",
       "      <td>NaN</td>\n",
       "      <td>215,032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,895,078</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,569,534</td>\n",
       "      <td>14,283</td>\n",
       "      <td>23,165</td>\n",
       "      <td>649</td>\n",
       "      <td>112,503,131</td>\n",
       "      <td>339,360</td>\n",
       "      <td>331,515,730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>India</td>\n",
       "      <td>6,685,082</td>\n",
       "      <td>+3,009</td>\n",
       "      <td>103,600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5,662,490</td>\n",
       "      <td>+3,380</td>\n",
       "      <td>918,992</td>\n",
       "      <td>8,944</td>\n",
       "      <td>4,832</td>\n",
       "      <td>75</td>\n",
       "      <td>81,071,797</td>\n",
       "      <td>58,596</td>\n",
       "      <td>1,383,567,415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>4,940,499</td>\n",
       "      <td>NaN</td>\n",
       "      <td>146,773</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,302</td>\n",
       "      <td>NaN</td>\n",
       "      <td>498,424</td>\n",
       "      <td>8,318</td>\n",
       "      <td>23,199</td>\n",
       "      <td>689</td>\n",
       "      <td>17,900,000</td>\n",
       "      <td>84,054</td>\n",
       "      <td>212,958,012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Russia</td>\n",
       "      <td>1,225,889</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21,475</td>\n",
       "      <td>NaN</td>\n",
       "      <td>982,324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222,090</td>\n",
       "      <td>2,300</td>\n",
       "      <td>8,399</td>\n",
       "      <td>147</td>\n",
       "      <td>48,042,343</td>\n",
       "      <td>329,167</td>\n",
       "      <td>145,951,147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>862,158</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26,844</td>\n",
       "      <td>NaN</td>\n",
       "      <td>766,300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69,014</td>\n",
       "      <td>2,220</td>\n",
       "      <td>16,897</td>\n",
       "      <td>526</td>\n",
       "      <td>3,930,262</td>\n",
       "      <td>77,026</td>\n",
       "      <td>51,025,119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>211</td>\n",
       "      <td>Vatican City</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14,963</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>212</td>\n",
       "      <td>Western Sahara</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>601,097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>213</td>\n",
       "      <td>MS Zaandam</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>214</td>\n",
       "      <td>Anguilla</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>199</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,020</td>\n",
       "      <td>67,828</td>\n",
       "      <td>15,038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>215</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>691,194</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>215 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       #    Country,other TotalCases NewCases TotalDeaths  NewDeaths  \\\n",
       "0      1              USA  7,679,644      NaN    215,032         NaN   \n",
       "1      2            India  6,685,082   +3,009    103,600         NaN   \n",
       "2      3           Brazil  4,940,499      NaN    146,773         NaN   \n",
       "3      4           Russia  1,225,889      NaN     21,475         NaN   \n",
       "4      5         Colombia    862,158      NaN     26,844         NaN   \n",
       "..   ...              ...        ...      ...         ...        ...   \n",
       "210  211     Vatican City         12      NaN                    NaN   \n",
       "211  212   Western Sahara         10      NaN          1         NaN   \n",
       "212  213       MS Zaandam          9      NaN          2         NaN   \n",
       "213  214         Anguilla          3      NaN                    NaN   \n",
       "214  215  Solomon Islands          1      NaN                    NaN   \n",
       "\n",
       "    TotalRecovered NewRecovered ActiveCases Serious,Critical  \\\n",
       "0        4,895,078          NaN   2,569,534           14,283   \n",
       "1        5,662,490       +3,380     918,992            8,944   \n",
       "2        4,295,302          NaN     498,424            8,318   \n",
       "3          982,324          NaN     222,090            2,300   \n",
       "4          766,300          NaN      69,014            2,220   \n",
       "..             ...          ...         ...              ...   \n",
       "210             12          NaN           0              NaN   \n",
       "211              8          NaN           1              NaN   \n",
       "212            NaN          NaN           7              NaN   \n",
       "213              3          NaN           0              NaN   \n",
       "214            NaN          NaN           1              NaN   \n",
       "\n",
       "    TotalCases/1M pop Deaths/1M pop   TotalTests Tests/1M pop      Population  \n",
       "0              23,165           649  112,503,131      339,360    331,515,730   \n",
       "1               4,832            75   81,071,797       58,596  1,383,567,415   \n",
       "2              23,199           689   17,900,000       84,054    212,958,012   \n",
       "3               8,399           147   48,042,343      329,167    145,951,147   \n",
       "4              16,897           526    3,930,262       77,026     51,025,119   \n",
       "..                ...           ...          ...          ...             ...  \n",
       "210            14,963           NaN          NaN          NaN            802   \n",
       "211                17             2          NaN          NaN        601,097   \n",
       "212               NaN           NaN          NaN          NaN                  \n",
       "213               199           NaN        1,020       67,828         15,038   \n",
       "214                 1           NaN          NaN          NaN        691,194   \n",
       "\n",
       "[215 rows x 15 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "x=pd.read_csv('out.csv')\n",
    "x\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "f\n"
     ]
    }
   ],
   "source": [
    "# print(\"f\")"
   ]
  },
  {
   "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": []
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['S.N.', 'Date', 'NEPSE Index', 'Absolute Change', 'Percentage Change'], ['1', '2020-05-12', '1226.16', '-25.2967', '-2.0214%'], ['2', '2020-05-13', '1201.58', '-24.5815', '-2.0048%'], ['3', '2020-06-29', '1188.71', '-12.8695', '-1.0711%'], ['4', '2020-06-30', '1260.76', '72.0494', '6.0612%'], ['5', '2020-07-01', '1336.53', '75.7677', '6.0097%'], ['6', '2020-07-02', '1256.11', '-80.4136', '-6.0166%'], ['7', '2020-07-05', '1265.46', '9.3477', '0.7442%'], ['8', '2020-07-06', '1298.73', '33.2734', '2.6294%'], ['9', '2020-07-07', '1336.67', '37.933', '2.9208%'], ['10', '2020-07-08', '1326.54', '-10.1293', '-0.7578%'], ['11', '2020-07-09', '1331.11', '4.5688', '0.3444%'], ['12', '2020-07-12', '1340.29', '9.0241', '0.6779%'], ['13', '2020-07-13', '1342.41', '2.1153', '0.1578%'], ['14', '2020-07-14', '1347.45', '5.0375', '0.3753%'], ['15', '2020-07-15', '1362.35', '14.9019', '1.1059%'], ['16', '2020-07-16', '1394.77', '32.4222', '2.3799%'], ['17', '2020-07-19', '1479.03', '84.2631', '6.0414%'], ['18', '2020-07-20', '1464.94', '-14.0942', '-0.9529%'], ['19', '2020-07-21', '1449.95', '-14.9912', '-1.0233%'], ['20', '2020-07-22', '1432.45', '-17.5011', '-1.207%'], ['21', '2020-07-23', '1442.62', '10.1283', '0.707%'], ['22', '2020-07-26', '1465.11', '22.4001', '1.5526%'], ['23', '2020-07-27', '1462.48', '-2.6245', '-0.1791%'], ['24', '2020-07-28', '1454.89', '-7.5942', '-0.5193%'], ['25', '2020-07-29', '1431.53', '-23.3616', '-1.6057%'], ['26', '2020-07-30', '1439.06', '7.5332', '0.5262%'], ['27', '2020-08-02', '1396.28', '-42.7822', '-2.9729%'], ['28', '2020-08-03', '1403.87', '7.5872', '0.5434%'], ['29', '2020-08-05', '1382.67', '-21.2017', '-1.5102%'], ['30', '2020-08-06', '1381.38', '-1.2877', '-0.0931%'], ['31', '2020-08-09', '1392.68', '11.304', '0.8183%'], ['32', '2020-08-10', '1430.42', '37.7378', '2.7097%'], ['33', '2020-08-11', '1423.81', '-6.6093', '-0.4621%'], ['34', '2020-08-12', '1425.32', '1.5097', '0.106%'], ['35', '2020-08-13', '1408.79', '-16.5282', '-1.1596%'], ['36', '2020-08-16', '1391.46', '-17.3272', '-1.2299%'], ['37', '2020-08-17', '1402.22', '10.7533', '0.7728%'], ['38', '2020-08-18', '1407.9', '5.6814', '0.4052%'], ['39', '2020-08-19', '1391.3', '-16.6041', '-1.1794%'], ['40', '2020-08-20', '1397.57', '6.2755', '0.4511%'], ['41', '2020-08-23', '1410.34', '12.774', '0.914%'], ['42', '2020-08-24', '1431.61', '21.2621', '1.5076%'], ['43', '2020-08-25', '1440.94', '9.3354', '0.6521%'], ['44', '2020-08-26', '1462.04', '21.0972', '1.4641%'], ['45', '2020-08-27', '1458.04', '-3.9994', '-0.2735%'], ['46', '2020-08-30', '1462.68', '4.6395', '0.3182%'], ['47', '2020-08-31', '1484.99', '22.3134', '1.5255%'], ['48', '2020-09-02', '1510.57', '25.58', '1.7226%'], ['49', '2020-09-03', '1510.42', '-0.1481', '-0.0098%'], ['50', '2020-09-06', '1499.98', '-10.4461', '-0.6916%'], ['51', '2020-09-07', '1487.81', '-12.1678', '-0.8112%'], ['52', '2020-09-08', '1495.16', '7.3458', '0.4937%'], ['53', '2020-09-09', '1508.21', '13.0515', '0.8729%'], ['54', '2020-09-10', '1520.69', '12.4864', '0.8279%'], ['55', '2020-09-13', '1537.25', '16.5554', '1.0887%'], ['56', '2020-09-14', '1540.51', '3.262', '0.2122%'], ['57', '2020-09-15', '1536.04', '-4.4735', '-0.2904%'], ['58', '2020-09-16', '1541.4', '5.3631', '0.3492%'], ['59', '2020-09-17', '1572.19', '30.7838', '1.9971%'], ['60', '2020-09-20', '1575.18', '2.9983', '0.1907%'], ['61', '2020-09-21', '1569.06', '-6.119', '-0.3885%'], ['62', '2020-09-22', '1546.16', '-22.9063', '-1.4599%'], ['63', '2020-09-23', '1555.53', '9.369', '0.606%'], ['64', '2020-09-24', '1561.27', '5.7427', '0.3692%'], ['65', '2020-09-27', '1565.56', '4.2857', '0.2745%'], ['66', '2020-09-28', '1560.83', '-4.7251', '-0.3018%'], ['67', '2020-09-29', '1553.62', '-7.2068', '-0.4617%'], ['68', '2020-09-30', '1550.43', '-3.1892', '-0.2053%'], ['69', '2020-10-01', '1571.04', '20.6086', '1.3292%']]\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\msi\\anaconda3\\lib\\site-packages\\bs4\\__init__.py:414: MarkupResemblesLocatorWarning: \"http://www.nepalstock.com/indices\" looks like a URL. Beautiful Soup is not an HTTP client. You should probably use an HTTP client like requests to get the document behind the URL, and feed that document to Beautiful Soup.\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S.N.</th>\n",
       "      <th>Date</th>\n",
       "      <th>NEPSE Index</th>\n",
       "      <th>Absolute Change</th>\n",
       "      <th>Percentage Change</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2020-05-12</td>\n",
       "      <td>1226.16</td>\n",
       "      <td>-25.2967</td>\n",
       "      <td>-2.0214%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2020-05-13</td>\n",
       "      <td>1201.58</td>\n",
       "      <td>-24.5815</td>\n",
       "      <td>-2.0048%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2020-06-29</td>\n",
       "      <td>1188.71</td>\n",
       "      <td>-12.8695</td>\n",
       "      <td>-1.0711%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2020-06-30</td>\n",
       "      <td>1260.76</td>\n",
       "      <td>72.0494</td>\n",
       "      <td>6.0612%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2020-07-01</td>\n",
       "      <td>1336.53</td>\n",
       "      <td>75.7677</td>\n",
       "      <td>6.0097%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>65</td>\n",
       "      <td>2020-09-27</td>\n",
       "      <td>1565.56</td>\n",
       "      <td>4.2857</td>\n",
       "      <td>0.2745%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>66</td>\n",
       "      <td>2020-09-28</td>\n",
       "      <td>1560.83</td>\n",
       "      <td>-4.7251</td>\n",
       "      <td>-0.3018%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>67</td>\n",
       "      <td>2020-09-29</td>\n",
       "      <td>1553.62</td>\n",
       "      <td>-7.2068</td>\n",
       "      <td>-0.4617%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>68</td>\n",
       "      <td>2020-09-30</td>\n",
       "      <td>1550.43</td>\n",
       "      <td>-3.1892</td>\n",
       "      <td>-0.2053%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>69</td>\n",
       "      <td>2020-10-01</td>\n",
       "      <td>1571.04</td>\n",
       "      <td>20.6086</td>\n",
       "      <td>1.3292%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>349 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    S.N.        Date NEPSE Index Absolute Change Percentage Change\n",
       "0      1  2020-05-12     1226.16        -25.2967          -2.0214%\n",
       "1      2  2020-05-13     1201.58        -24.5815          -2.0048%\n",
       "2      3  2020-06-29     1188.71        -12.8695          -1.0711%\n",
       "3      4  2020-06-30     1260.76         72.0494           6.0612%\n",
       "4      5  2020-07-01     1336.53         75.7677           6.0097%\n",
       "..   ...         ...         ...             ...               ...\n",
       "344   65  2020-09-27     1565.56          4.2857           0.2745%\n",
       "345   66  2020-09-28     1560.83         -4.7251          -0.3018%\n",
       "346   67  2020-09-29     1553.62         -7.2068          -0.4617%\n",
       "347   68  2020-09-30     1550.43         -3.1892          -0.2053%\n",
       "348   69  2020-10-01     1571.04         20.6086           1.3292%\n",
       "\n",
       "[349 rows x 5 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "url=BeautifulSoup('http://www.nepalstock.com/indices','html.parser')\n",
    "start=requests.get(url)\n",
    "v1=start.text\n",
    "soup=BeautifulSoup(v1,'lxml')\n",
    "tags=soup.table\n",
    "tag=tags.find_all('tr')\n",
    "list1=[]\n",
    "#print(len(tag))\n",
    "for i in range(len(tag)):\n",
    "    x=tag[i].get_text()\n",
    "    list1.append(x)\n",
    "list1=list1[1:]\n",
    "final=[]\n",
    "for i in list1:\n",
    "    y=i.split('\\n')[1:-1]\n",
    "    final.append(y)\n",
    "print(final)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S.N.</th>\n",
       "      <th>Date</th>\n",
       "      <th>NEPSE Index</th>\n",
       "      <th>Absolute Change</th>\n",
       "      <th>Percentage Change</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2020-05-12</td>\n",
       "      <td>1226.16</td>\n",
       "      <td>-25.2967</td>\n",
       "      <td>-2.0214%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2020-05-13</td>\n",
       "      <td>1201.58</td>\n",
       "      <td>-24.5815</td>\n",
       "      <td>-2.0048%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2020-06-29</td>\n",
       "      <td>1188.71</td>\n",
       "      <td>-12.8695</td>\n",
       "      <td>-1.0711%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2020-06-30</td>\n",
       "      <td>1260.76</td>\n",
       "      <td>72.0494</td>\n",
       "      <td>6.0612%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2020-07-01</td>\n",
       "      <td>1336.53</td>\n",
       "      <td>75.7677</td>\n",
       "      <td>6.0097%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>65</td>\n",
       "      <td>2020-09-27</td>\n",
       "      <td>1565.56</td>\n",
       "      <td>4.2857</td>\n",
       "      <td>0.2745%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>66</td>\n",
       "      <td>2020-09-28</td>\n",
       "      <td>1560.83</td>\n",
       "      <td>-4.7251</td>\n",
       "      <td>-0.3018%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>67</td>\n",
       "      <td>2020-09-29</td>\n",
       "      <td>1553.62</td>\n",
       "      <td>-7.2068</td>\n",
       "      <td>-0.4617%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>68</td>\n",
       "      <td>2020-09-30</td>\n",
       "      <td>1550.43</td>\n",
       "      <td>-3.1892</td>\n",
       "      <td>-0.2053%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>69</td>\n",
       "      <td>2020-10-01</td>\n",
       "      <td>1571.04</td>\n",
       "      <td>20.6086</td>\n",
       "      <td>1.3292%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>419 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    S.N.        Date NEPSE Index Absolute Change Percentage Change\n",
       "0      1  2020-05-12     1226.16        -25.2967          -2.0214%\n",
       "1      2  2020-05-13     1201.58        -24.5815          -2.0048%\n",
       "2      3  2020-06-29     1188.71        -12.8695          -1.0711%\n",
       "3      4  2020-06-30     1260.76         72.0494           6.0612%\n",
       "4      5  2020-07-01     1336.53         75.7677           6.0097%\n",
       "..   ...         ...         ...             ...               ...\n",
       "414   65  2020-09-27     1565.56          4.2857           0.2745%\n",
       "415   66  2020-09-28     1560.83         -4.7251          -0.3018%\n",
       "416   67  2020-09-29     1553.62         -7.2068          -0.4617%\n",
       "417   68  2020-09-30     1550.43         -3.1892          -0.2053%\n",
       "418   69  2020-10-01     1571.04         20.6086           1.3292%\n",
       "\n",
       "[419 rows x 5 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import csv\n",
    "n = len(final)\n",
    "with open('stock1.csv','a') as csvFile:\n",
    "  writer = csv.writer(csvFile)\n",
    "  for i in range(n):\n",
    "    writer.writerow(final[i])\n",
    "import pandas as pd\n",
    "x=pd.read_csv('stock1.csv')\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[2], [32, 2, 5], [56, 8]]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x=[[2,6,8],[32,2,5,9,4],[56,8,4,32]]\n",
    "for i in range(len(x)):\n",
    "    del x[i][-2:]\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[2], [32, 2, 5], [56, 8]]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x=[[2,6,8],[32,2,5,9,4],[56,8,4,32]]\n",
    "for i in range(len(x)):\n",
    "    del x[i][-2:]\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'56'"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x=[1,3,5,6]\n",
    "list1=[]\n",
    "for i in x:\n",
    "    y=str(i)\n",
    "    list1.append(y)\n",
    "x=list1[2:]\n",
    "x\n",
    "list2=\"\".join(x)\n",
    "list2    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Tests/1M pop'"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x=['#',\n",
    "  'Country,Other',\n",
    "  'TotalCases',\n",
    "  'NewCases',\n",
    "  'TotalDeaths',\n",
    "  'NewDeaths',\n",
    "  'TotalRecovered',\n",
    "  'NewRecovered',\n",
    "  'ActiveCases',\n",
    "  'Serious,Critical',\n",
    "  'Tot\\xa0Cases/1M pop',\n",
    "  'Deaths/1M pop',\n",
    "  'TotalTests',\n",
    "  'Tests/',\n",
    "  '1M pop',\n",
    "  '',\n",
    "  'Population']\n",
    "y=x[13:16]\n",
    "z=\"\".join(y)\n",
    "z\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "15\n"
     ]
    }
   ],
   "source": [
    "x=['#',\n",
    "  'Country,Other',\n",
    "  'TotalCases',\n",
    "  'NewCases',\n",
    "  'TotalDeaths',\n",
    "  'NewDeaths',\n",
    "  'TotalRecovered',\n",
    "  'NewRecovered',\n",
    "  'ActiveCases',\n",
    "  'Serious,Critical',\n",
    "  'Tot\\xa0Cases/1M pop',\n",
    "  'Deaths/1M pop',\n",
    "  'TotalTests',\n",
    "  'Tests/1M pop',\n",
    "  'Population']\n",
    "print(len(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[6, 6, 6, 6, 6], [6, 8, 9, 3], [3, 8, 9, 34]]\n"
     ]
    }
   ],
   "source": [
    "x=[[1,43,6,7,4],[6,8,9,3],[3,8,9,34]]\n",
    "x[0]=[6,6,6,6,6]\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['#', 'Country,other', 'TotalCases', 'NewCases', 'TotalDeaths', 'NewDeaths', 'TotalRecovered', 'ActiveCases', 'Serious,Critical', 'TotalCases/1M pop', 'Deaths/1M pop', 'TotalTests', 'Tests/1M pop', 'Population'], ['1', 'USA', '7,646,516', '+9,604', '214,707 ', '+96', '4,863,291', '2,568,518', '14,202', '23,066', '648', '111,701,905', '336,948', '331,510,437 '], ['2', 'India', '6,650,456', '+28,276', '103,005 ', '+291', '5,621,193', '926,258', '8,944', '4,807', '74', '79,982,394', '57,810', '1,383,530,375 '], ['3', 'Brazil', '4,918,022', '+2,733', '146,417 ', '+42', '4,263,208', '508,397', '8,318', '23,094', '688', '17,900,000', '84,056', '212,953,890 '], ['4', 'Russia', '1,225,889', '+10,888', '21,475 ', '+117', '982,324', '222,090', '2,300', '8,399', '147', '48,042,343', '329,168', '145,950,977 '], ['5', 'Colombia', '855,052', '', '26,712 ', '', '761,674', '66,666', '2,220', '16,758', '524', '3,894,289', '76,323', '51,023,638 '], ['6', 'Peru', '828,169', '', '32,742 ', '', '706,223', '89,204', '1,287', '25,027', '989', '3,952,298', '119,439', '33,090,379 '], ['7', 'Spain', '810,807', '', '32,086 ', '', 'N/A', 'N/A', '1,566', '17,340', '686', '12,723,989', '272,115', '46,759,558 '], ['8', 'Argentina', '798,486', '', '21,018 ', '', '636,672', '140,796', '3,950', '17,625', '464', '2,064,250', '45,565', '45,303,674 '], ['9', 'Mexico', '761,665', '+3,712', '79,088 ', '+208', '550,053', '132,524', '2,401', '5,891', '612', '2,003,141', '15,494', '129,284,391 '], ['10', 'South Africa', '681,289', '', '16,976 ', '', '614,781', '49,532', '539', '11,450', '285', '4,269,626', '71,756', '59,502,099 '], ['11', 'France', '619,190', '', '32,230 ', '', '97,778', '489,182', '1,276', '9,481', '493', '11,469,737', '175,616', '65,311,522 '], ['12', 'UK', '515,571', '+12,594', '42,369 ', '+19', 'N/A', 'N/A', '368', '7,584', '623', '25,865,851', '380,495', '67,979,397 '], ['13', 'Iran', '475,674', '+3,902', '27,192 ', '+235', '392,293', '56,189', '4,167', '5,645', '323', '4,151,445', '49,263', '84,270,921 '], ['14', 'Chile', '471,746', '+1,567', '13,037 ', '+58', '443,453', '15,256', '853', '24,623', '680', '3,502,751', '182,826', '19,158,936 '], ['15', 'Iraq', '382,949', '+3,808', '9,464 ', '+65', '312,158', '61,327', '556', '9,467', '234', '2,371,348', '58,621', '40,451,877 '], ['16', 'Bangladesh', '370,132', '+1,442', '5,375 ', '+27', '283,182', '81,575', '', '2,242', '33', '2,001,431', '12,121', '165,115,692 '], ['17', 'Saudi Arabia', '336,766', '+379', '4,898 ', '+23', '322,055', '9,813', '938', '9,635', '140', '6,725,148', '192,403', '34,953,378 '], ['18', 'Italy', '327,586', '+2,257', '36,002 ', '+16', '232,681', '58,903', '323', '5,420', '596', '11,844,346', '195,974', '60,438,292 '], ['19', 'Philippines', '324,762', '+2,291', '5,840 ', '+64', '273,123', '45,799', '1,758', '2,954', '53', '3,914,732', '35,602', '109,957,856 '], ['20', 'Turkey', '324,443', '', '8,441 ', '', '285,050', '30,952', '1,475', '3,836', '100', '10,806,285', '127,772', '84,574,545 '], ['21', 'Pakistan', '315,260', '+644', '6,517 ', '+4', '299,836', '8,907', '515', '1,420', '29', '3,678,534', '16,571', '221,988,411 '], ['22', 'Indonesia', '307,120', '+3,622', '11,253 ', '+102', '232,593', '63,274', '', '1,120', '41', '3,515,165', '12,816', '274,274,332 '], ['23', 'Germany', '302,980', '+1,409', '9,609 ', '+7', '263,700', '29,671', '447', '3,613', '115', '16,999,253', '202,724', '83,854,334 '], ['24', 'Israel', '268,175', '+1,400', '1,719 ', '', '201,392', '65,064', '878', '29,157', '187', '3,733,880', '405,963', '9,197,590 '], ['25', 'Ukraine', '230,236', '+3,774', '4,430 ', '+33', '101,252', '124,554', '177', '5,273', '101', '2,382,259', '54,559', '43,663,726 '], ['26', 'Canada', '167,963', '+1,807', '9,492 ', '+11', '141,660', '16,811', '126', '4,440', '251', '7,625,793', '201,590', '37,828,308 '], ['27', 'Ecuador', '141,339', '+305', '11,681 ', '+34', '120,511', '9,147', '356', '7,980', '659', '455,122', '25,696', '17,712,036 '], ['28', 'Netherlands', '140,471', '+4,579', '6,461 ', '+7', 'N/A', 'N/A', '177', '8,193', '377', '2,603,166', '151,834', '17,144,850 '], ['29', 'Romania', '137,491', '+1,591', '5,048 ', '+45', '108,526', '23,917', '592', '7,160', '263', '2,516,746', '131,057', '19,203,449 '], ['30', 'Bolivia', '136,868', '+299', '8,101 ', '+28', '97,547', '31,220', '71', '11,684', '692', '307,040', '26,211', '11,714,131 '], ['31', 'Morocco', '133,272', '', '2,330 ', '', '111,036', '19,906', '461', '3,600', '63', '2,711,203', '73,229', '37,023,865 '], ['32', 'Belgium', '130,235', '+2,612', '10,064 ', '+20', '19,679', '100,492', '186', '11,224', '867', '3,402,761', '293,269', '11,602,851 '], ['33', 'Qatar', '126,692', '+194', '216 ', '', '123,664', '2,812', '59', '45,121', '77', '800,519', '285,105', '2,807,805 '], ['34', 'Panama', '115,286', '', '2,423 ', '', '91,809', '21,054', '110', '26,611', '559', '504,299', '116,406', '4,332,239 '], ['35', 'Dominican Republic', '115,054', '+574', '2,144 ', '+10', '90,942', '21,968', '169', '10,579', '197', '496,200', '45,623', '10,876,171 '], ['36', 'Kazakhstan', '108,236', '+59', '1,725 ', '', '103,277', '3,234', '221', '5,747', '92', '2,973,489', '157,872', '18,834,863 '], ['37', 'Kuwait', '107,592', '+567', '628 ', '+4', '99,549', '7,415', '129', '25,098', '146', '761,025', '177,526', '4,286,844 '], ['38', 'Egypt', '103,683', '', '5,981 ', '', '97,355', '347', '41', '1,008', '58', '135,000', '1,313', '102,828,135 '], ['39', 'Poland', '102,080', '+2,006', '2,659 ', '+29', '73,552', '25,869', '219', '2,698', '70', '3,465,605', '91,596', '37,835,645 '], ['40', 'Oman', '101,814', '+544', '985 ', '+8', '90,600', '10,229', '207', '19,810', '192', '376,700', '73,296', '5,139,449 '], ['41', 'UAE', '99,733', '+932', '429 ', '+3', '89,410', '9,894', '', '10,052', '43', '10,220,534', '1,030,157', '9,921,338 '], ['42', 'Sweden', '94,283', '', '5,895 ', '', 'N/A', 'N/A', '20', '9,320', '583', '1,661,484', '164,248', '10,115,730 '], ['43', 'Guatemala', '94,182', '+219', '3,302 ', '+9', '82,828', '8,052', '5', '5,232', '183', '338,692', '18,816', '18,000,398 '], ['44', 'Nepal', '89,263', '+2,440', '554 ', '+19', '65,202', '23,507', '', '3,050', '19', '1,088,229', '37,178', '29,271,074 '], ['45', 'Japan', '85,739', '+400', '1,599 ', '+2', '78,609', '5,531', '131', '678', '13', '2,173,035', '17,195', '126,373,720 '], ['46', 'Czechia', '83,696', '+1,250', '757 ', '+30', '45,176', '37,763', '245', '7,812', '71', '1,457,315', '136,017', '10,714,212 '], ['47', 'Belarus', '80,696', '+401', '862 ', '+5', '75,303', '4,531', '', '8,541', '91', '1,949,656', '206,346', '9,448,502 '], ['48', 'Portugal', '79,885', '+734', '2,018 ', '+13', '50,454', '27,413', '106', '7,840', '198', '2,647,756', '259,869', '10,188,821 '], ['49', 'Honduras', '79,629', '+841', '2,422 ', '+23', '29,305', '47,902', '30', '8,007', '244', '186,350', '18,738', '9,945,117 '], ['50', 'Costa Rica', '79,182', '', '950 ', '', '45,007', '33,225', '213', '15,507', '186', '238,248', '46,658', '5,106,221 '], ['51', 'Ethiopia', '78,819', '', '1,222 ', '', '33,060', '44,537', '285', '681', '11', '1,301,570', '11,251', '115,684,171 '], ['52', 'Venezuela', '78,434', '', '653 ', '', '68,917', '8,864', '215', '2,760', '23', '1,965,367', '69,168', '28,414,568 '], ['53', 'Bahrain', '72,662', '', '261 ', '+1', '67,475', '4,926', '63', '42,337', '152', '1,478,163', '861,271', '1,716,258 '], ['54', 'Nigeria', '59,345', '', '1,113 ', '', '50,768', '7,464', '7', '286', '5', '535,733', '2,583', '207,432,403 '], ['55', 'Uzbekistan', '58,946', '+334', '485 ', '+5', '55,633', '2,828', '252', '1,755', '14', '1,377,915', '41,016', '33,594,251 '], ['56', 'Singapore', '57,819', '+7', '27 ', '', '57,597', '195', '', '9,863', '5', '2,885,545', '492,217', '5,862,339 '], ['57', 'Moldova', '56,901', '+322', '1,375 ', '+9', '41,467', '14,059', '744', '14,114', '341', '293,824', '72,882', '4,031,478 '], ['58', 'Switzerland', '55,932', '+1,548', '2,078 ', '+1', '45,800', '8,054', '32', '6,450', '240', '1,417,260', '163,446', '8,671,140 '], ['59', 'Armenia', '52,677', '+181', '984 ', '+7', '44,710', '6,983', '', '17,768', '332', '308,019', '103,895', '2,964,701 '], ['60', 'Algeria', '52,270', '+134', '1,768 ', '+8', '36,672', '13,830', '23', '1,187', '40', '', '', '44,053,891 '], ['61', 'Austria', '48,896', '+750', '818 ', '+5', '39,058', '9,020', '101', '5,421', '91', '1,698,268', '188,281', '9,019,845 '], ['62', 'Kyrgyzstan', '47,635', '+207', '1,066 ', '', '43,521', '3,048', '24', '7,270', '163', '276,522', '42,205', '6,551,846 '], ['63', 'Ghana', '46,829', '', '303 ', '', '46,060', '466', '4', '1,499', '10', '488,427', '15,636', '31,238,252 '], ['64', 'Lebanon', '44,482', '', '406 ', '', '19,782', '24,294', '161', '6,525', '60', '889,920', '130,538', '6,817,317 '], ['65', 'Paraguay', '44,182', '', '929 ', '', '27,203', '16,050', '145', '6,175', '130', '288,502', '40,321', '7,155,212 '], ['66', 'Palestine', '41,957', '+459', '339 ', '+9', '35,182', '6,436', '', '8,176', '66', '437,500', '85,258', '5,131,507 '], ['67', 'Azerbaijan', '40,788', '+97', '598 ', '+2', '38,587', '1,603', '', '4,013', '59', '1,140,194', '112,191', '10,162,960 '], ['68', 'Kenya', '39,449', '+22', '735 ', '+4', '27,035', '11,679', '', '730', '14', '564,078', '10,432', '54,072,535 '], ['69', 'Afghanistan', '39,422', '+81', '1,466 ', '+4', '32,879', '5,077', '93', '1,007', '37', '112,278', '2,868', '39,151,119 '], ['70', 'Ireland', '38,032', '', '1,810 ', '', '23,364', '12,858', '20', '7,680', '366', '1,245,263', '251,462', '4,952,088 '], ['71', 'Libya', '37,437', '+628', '596 ', '+4', '22,076', '14,765', '', '5,429', '86', '222,054', '32,203', '6,895,418 '], ['72', 'Serbia', '33,952', '+51', '756 ', '+2', '31,536', '1,660', '20', '3,890', '87', '1,159,806', '132,883', '8,728,018 '], ['73', 'Hungary', '31,480', '+905', '833 ', '+11', '8,165', '22,482', '40', '3,261', '86', '765,598', '79,305', '9,653,847 '], ['74', 'Denmark', '30,057', '+377', '659 ', '+1', '23,122', '6,276', '30', '5,184', '114', '4,084,612', '704,540', '5,797,559 '], ['75', 'El Salvador', '29,539', '+89', '865 ', '+2', '24,406', '4,268', '37', '4,548', '133', '408,212', '62,852', '6,494,778 '], ['76', 'Bosnia and Herzegovina', '28,449', '+95', '888 ', '+9', '22,032', '5,529', '', '8,686', '271', '248,975', '76,014', '3,275,378 '], ['77', 'Australia', '27,149', '+13', '894 ', '', '24,892', '1,363', '6', '1,061', '35', '7,794,939', '304,769', '25,576,542 '], ['78', 'S. Korea', '24,164', '+73', '422 ', '+1', '21,886', '1,856', '107', '471', '8', '2,352,378', '45,872', '51,280,822 '], ['79', 'Tunisia', '22,230', '', '321 ', '', '5,032', '16,877', '116', '1,876', '27', '250,479', '21,136', '11,850,723 '], ['80', 'Bulgaria', '21,587', '', '844 ', '', '15,014', '5,729', '56', '3,113', '122', '543,076', '78,315', '6,934,471 '], ['81', 'Cameroon', '20,924', '', '420 ', '', '19,764', '740', '30', '783', '16', '149,000', '5,578', '26,713,033 '], ['82', 'Greece', '20,142', '+300', '417 ', '+8', '9,989', '9,736', '83', '1,935', '40', '1,355,126', '130,182', '10,409,506 '], ['83', 'Ivory Coast', '19,882', '', '120 ', '', '19,449', '313', '', '749', '5', '166,529', '6,274', '26,543,565 '], ['84', 'North Macedonia', '18,873', '+83', '760 ', '+4', '15,487', '2,626', '3', '9,059', '365', '195,541', '93,859', '2,083,351 '], ['85', 'Myanmar', '18,781', '+987', '444 ', '+32', '5,548', '12,789', '', '345', '8', '332,875', '6,107', '54,505,092 '], ['86', 'Croatia', '17,797', '+138', '300 ', '+2', '16,031', '1,466', '24', '4,342', '73', '328,392', '80,125', '4,098,517 '], ['87', 'Jordan', '17,464', '+1,824', '110 ', '+9', '5,292', '12,062', '48', '1,707', '11', '1,311,436', '128,202', '10,229,453 '], ['88', 'Madagascar', '16,570', '+12', '233 ', '+1', '15,601', '736', '14', '595', '8', '73,053', '2,621', '27,870,839 '], ['89', 'Senegal', '15,122', '+28', '312 ', '', '12,870', '1,940', '6', '897', '19', '183,115', '10,864', '16,855,249 '], ['90', 'Zambia', '15,089', '+37', '334 ', '+1', '14,306', '449', '', '815', '18', '164,951', '8,910', '18,513,446 '], ['91', 'Norway', '14,527', '+70', '275 ', '', '11,190', '3,062', '3', '2,674', '51', '1,075,807', '198,039', '5,432,295 '], ['92', 'Albania', '14,410', '+144', '400 ', '+4', '8,825', '5,185', '23', '5,009', '139', '88,622', '30,804', '2,876,966 '], ['93', 'Sudan', '13,653', '', '836 ', '', '6,764', '6,053', '', '310', '19', '', '', '44,109,014 '], ['94', 'Slovakia', '13,492', '+353', '55 ', '', '4,865', '8,572', '37', '2,471', '10', '496,284', '90,889', '5,460,340 '], ['95', 'Malaysia', '12,813', '+432', '137 ', '', '10,340', '2,336', '32', '395', '4', '1,581,208', '48,693', '32,473,219 '], ['96', 'Montenegro', '12,359', '+232', '182 ', '+3', '8,308', '3,869', '17', '19,677', '290', '72,393', '115,260', '628,087 '], ['97', 'Namibia', '11,626', '', '123 ', '', '9,429', '2,074', '8', '4,554', '48', '103,254', '40,449', '2,552,692 '], ['98', 'DRC', '10,778', '+18', '274 ', '', '10,239', '265', '', '119', '3', '', '', '90,243,090 '], ['99', 'Guinea', '10,754', '', '66 ', '', '10,098', '590', '24', '813', '5', '33,676', '2,547', '13,222,537 '], ['100', 'Finland', '10,702', '+164', '346 ', '+1', '8,100', '2,256', '8', '1,931', '62', '1,084,319', '195,620', '5,542,988 '], ['101', 'Maldives', '10,530', '', '34 ', '', '9,364', '1,132', '12', '19,393', '63', '149,135', '274,658', '542,985 '], ['102', 'French Guiana', '10,057', '+28', '68 ', '+1', '9,710', '279', '4', '33,452', '226', '67,833', '225,631', '300,637 '], ['103', 'Tajikistan', '9,974', '+39', '78 ', '', '8,794', '1,102', '', '1,040', '8', '', '', '9,592,085 '], ['104', 'Mozambique', '9,296', '+100', '66 ', '', '6,104', '3,126', '', '295', '2', '1,446,106', '45,944', '31,475,668 '], ['105', 'Uganda', '8,965', '+157', '82 ', '+1', '5,078', '3,805', '', '194', '2', '493,595', '10,707', '46,101,840 '], ['106', 'Luxembourg', '8,925', '+35', '127 ', '+1', '7,793', '1,005', '2', '14,198', '202', '856,798', '1,363,037', '628,595 '], ['107', 'Haiti', '8,819', '', '229 ', '', '6,992', '1,598', '', '771', '20', '28,702', '2,509', '11,438,507 '], ['108', 'Gabon', '8,797', '', '54 ', '', '8,067', '676', '3', '3,929', '24', '180,173', '80,468', '2,239,052 '], ['109', 'Georgia', '8,696', '+578', '54 ', '+4', '4,619', '4,023', '', '2,181', '14', '679,169', '170,340', '3,987,139 '], ['110', 'Zimbabwe', '7,888', '', '228 ', '', '6,359', '1,301', '', '529', '15', '160,162', '10,736', '14,918,696 '], ['111', 'Mauritania', '7,520', '', '162 ', '', '7,188', '170', '3', '1,607', '35', '80,832', '17,270', '4,680,497 '], ['112', 'Jamaica', '7,012', '+117', '120 ', '', '2,635', '4,257', '12', '2,365', '40', '81,132', '27,367', '2,964,557 '], ['113', 'Slovenia', '6,573', '+75', '156 ', '+1', '4,314', '2,103', '26', '3,162', '75', '237,545', '114,259', '2,079,013 '], ['114', 'Cabo Verde', '6,360', '', '65 ', '', '5,416', '879', '', '11,407', '117', '76,576', '137,343', '557,554 '], ['115', 'Cuba', '5,845', '+36', '123 ', '+1', '5,232', '490', '1', '516', '11', '651,035', '57,488', '11,324,788 '], ['116', 'Malawi', '5,786', '', '179 ', '', '4,541', '1,066', '4', '300', '9', '54,351', '2,823', '19,254,787 '], ['117', 'Eswatini', '5,569', '', '111 ', '', '5,127', '331', '11', '4,787', '95', '45,325', '38,963', '1,163,283 '], ['118', 'Guadeloupe', '5,528', '', '57 ', '', '2,199', '3,272', '24', '13,815', '142', '55,187', '137,919', '400,142 '], ['119', 'Djibouti', '5,419', '', '61 ', '', '5,349', '9', '', '5,464', '62', '77,743', '78,393', '991,704 '], ['120', 'Angola', '5,402', '', '195 ', '', '2,577', '2,630', '16', '163', '6', '85,213', '2,573', '33,121,882 '], ['121', 'Lithuania', '5,285', '+100', '94 ', '', '2,497', '2,694', '', '1,949', '35', '801,362', '295,483', '2,712,045 '], ['122', 'Nicaragua', '5,170', '', '151 ', '', '2,913', '2,106', '', '778', '23', '', '', '6,644,965 '], ['123', 'Hong Kong', '5,125', '+11', '105 ', '', '4,864', '156', '11', '682', '14', '3,311,279', '440,750', '7,512,834 '], ['124', 'Congo', '5,089', '', '89 ', '', '3,887', '1,113', '', '917', '16', '', '', '5,552,466 '], ['125', 'Equatorial Guinea', '5,045', '', '83 ', '', '4,879', '83', '4', '3,567', '59', '60,916', '43,066', '1,414,470 '], ['126', 'Suriname', '4,941', '', '106 ', '', '4,741', '94', '6', '8,403', '180', '14,638', '24,895', '588,000 '], ['127', 'Rwanda', '4,866', '', '29 ', '', '3,216', '1,621', '', '373', '2', '504,670', '38,721', '13,033,460 '], ['128', 'CAR', '4,845', '', '62 ', '', '1,914', '2,869', '2', '999', '13', '32,263', '6,650', '4,851,305 '], ['129', 'Trinidad and Tobago', '4,766', '+3', '81 ', '', '2,884', '1,801', '14', '3,403', '58', '32,354', '23,099', '1,400,679 '], ['130', 'Bahamas', '4,409', '', '96 ', '', '2,375', '1,938', '96', '11,184', '244', '21,445', '54,398', '394,221 '], ['131', 'Syria', '4,366', '', '205 ', '', '1,155', '3,006', '', '248', '12', '', '', '17,608,331 '], ['132', 'Réunion', '4,328', '+150', '16  ', '', '3,360', '952', '17', '4,825', '18', '35,419', '39,487', '896,980 '], ['133', 'Aruba', '4,079', '', '30 ', '', '3,532', '517', '12', '38,163', '281', '32,776', '306,647', '106,885 '], ['134', 'Mayotte', '3,892', '+113', '42 ', '', '2,964', '886', '2', '14,179', '153', '13,000', '47,362', '274,483 '], ['135', 'Somalia', '3,745', '', '99 ', '', '3,010', '636', '', '234', '6', '', '', '16,004,765 '], ['136', 'Estonia', '3,617', '+10', '67 ', '', '2,755', '795', '2', '2,726', '50', '221,992', '167,318', '1,326,770 '], ['137', 'Gambia', '3,594', '', '115 ', '', '2,226', '1,253', '', '1,477', '47', '17,472', '7,179', '2,433,741 '], ['138', 'Thailand', '3,590', '+5', '59 ', '', '3,390', '141', '1', '51', '0.8', '749,213', '10,727', '69,846,049 '], ['139', 'Sri Lanka', '3,493', '+91', '13 ', '', '3,259', '221', '', '163', '0.6', '296,611', '13,837', '21,436,802 '], ['140', 'Malta', '3,327', '+57', '39 ', '', '2,770', '518', '', '7,530', '88', '265,630', '601,174', '441,852 '], ['141', 'Mali', '3,184', '', '131 ', '', '2,479', '574', '', '156', '6', '56,337', '2,762', '20,397,311 '], ['142', 'Botswana', '3,172', '', '16 ', '', '710', '2,446', '1', '1,342', '7', '184,076', '77,875', '2,363,744 '], ['143', 'Guyana', '3,093', '', '87 ', '', '1,920', '1,086', '18', '3,927', '110', '14,815', '18,812', '787,547 '], ['144', 'Iceland', '2,980', '+59', '10 ', '', '2,300', '670', '3', '8,718', '29', '289,017', '845,519', '341,822 '], ['145', 'South Sudan', '2,726', '', '50 ', '', '1,290', '1,386', '', '243', '4', '12,044', '1,073', '11,227,721 '], ['146', 'Andorra', '2,370', '+260', '53 ', '', '1,615', '702', '9', '30,661', '686', '137,457', '1,778,274', '77,298 '], ['147', 'Guinea-Bissau', '2,362', '', '39 ', '', '1,549', '774', '5', '1,193', '20', '', '', '1,979,796 '], ['148', 'Benin', '2,357', '', '41 ', '', '1,973', '343', '', '193', '3', '203,831', '16,703', '12,203,338 '], ['149', 'Sierra Leone', '2,269', '', '72 ', '', '1,706', '491', '', '283', '9', '', '', '8,018,368 '], ['150', 'Belize', '2,196', '+65', '30 ', '+1', '1,378', '788', '5', '5,497', '75', '15,982', '40,007', '399,477 '], ['151', 'Burkina Faso', '2,167', '', '59 ', '', '1,419', '689', '', '103', '3', '', '', '21,047,594 '], ['152', 'Uruguay', '2,145', '', '48 ', '', '1,844', '253', '2', '617', '14', '246,766', '70,973', '3,476,892 '], ['153', 'Latvia', '2,126', '+40', '39 ', '+1', '1,307', '780', '4', '1,130', '21', '336,577', '178,973', '1,880,597 '], ['154', 'Yemen', '2,041', '', '591 ', '', '1,320', '130', '', '68', '20', '', '', '29,993,034 '], ['155', 'French Polynesia', '1,964', '', '8 ', '', '1,555', '401', '11', '6,981', '28', '26,355', '93,679', '281,333 '], ['156', 'New Zealand', '1,855', '+1', '25 ', '', '1,790', '40', '', '371', '5', '982,819', '196,481', '5,002,100 '], ['157', 'Togo', '1,854', '', '48 ', '', '1,392', '414', '', '223', '6', '95,110', '11,421', '8,327,944 '], ['158', 'Cyprus', '1,847', '+23', '22 ', '', '1,369', '456', '1', '1,527', '18', '394,211', '325,888', '1,209,653 '], ['159', 'Lesotho', '1,683', '', '39 ', '', '926', '718', '', '784', '18', '19,428', '9,050', '2,146,677 '], ['160', 'Martinique', '1,543', '', '21 ', '', '98', '1,424', '16', '4,113', '56', '36,331', '96,834', '375,188 '], ['161', 'Liberia', '1,348', '', '82 ', '', '1,236', '30', '', '265', '16', '', '', '5,087,832 '], ['162', 'Chad', '1,217', '', '86 ', '', '1,075', '56', '', '74', '5', '', '', '16,544,254 '], ['163', 'Niger', '1,200', '', '69 ', '', '1,115', '16', '', '49', '3', '26,062', '1,067', '24,423,548 '], ['164', 'Vietnam', '1,097', '+1', '35 ', '', '1,022', '40', '', '11', '0.4', '1,009,145', '10,343', '97,566,509 '], ['165', 'Sao Tome and Principe', '913', '', '15 ', '', '887', '11', '', '4,146', '68', '5,109', '23,202', '220,201 '], ['166', 'San Marino', '732', '', '42 ', '', '680', '10', '3', '21,561', '1,237', '7,755', '228,424', '33,950 '], ['167', 'Diamond Princess', '712', '', '13 ', '', '651', '48', '4', '', '', '', '', ' '], ['168', 'Turks and Caicos', '695', '', '6 ', '', '656', '33', '4', '17,888', '154', '3,464', '89,159', '38,852 '], ['169', 'Sint Maarten', '679', '+1', '22 ', '', '572', '85', '6', '15,790', '512', '3,803', '88,438', '43,002 '], ['170', 'Channel Islands', '678', '', '48 ', '', '600', '30', '2', '3,890', '275', '123,884', '710,833', '174,280 '], ['171', 'Papua New Guinea', '540', '', '7 ', '', '527', '6', '', '60', '0.8', '25,955', '2,887', '8,990,371 '], ['172', 'Taiwan', '518', '+1', '7 ', '', '485', '26', '', '22', '0.3', '94,734', '3,976', '23,828,127 '], ['173', 'Burundi', '514', '+1', '1 ', '', '472', '41', '', '43', '0.08', '37,522', '3,132', '11,979,552 '], ['174', 'Tanzania', '509', '', '21 ', '', '183', '305', '7', '8', '0.3', '', '', '60,161,754 '], ['175', 'Comoros', '487', '', '7 ', '', '466', '14', '', '557', '8', '', '', '874,319 '], ['176', 'Faeroe Islands', '475', '+1', ' ', '', '441', '34', '', '9,711', '', '134,070', '2,741,045', '48,912 '], ['177', 'Curaçao', '452', '', '1 ', '', '231', '220', '2', '2,752', '6', '8,045', '48,975', '164,269 '], ['178', 'Gibraltar', '432', '', ' ', '', '363', '69', '', '12,824', '', '49,149', '1,458,947', '33,688 '], ['179', 'Saint Martin', '412', '', '8 ', '', '309', '95', '11', '10,609', '206', '5,170', '133,127', '38,835 '], ['180', 'Eritrea', '398', '', ' ', '', '358', '40', '', '112', '', '', '', '3,559,089 '], ['181', 'Mauritius', '385', '', '10 ', '', '357', '18', '', '303', '8', '246,326', '193,603', '1,272,324 '], ['182', 'Isle of Man', '344', '+2', '24 ', '', '316', '4', '', '4,040', '282', '13,627', '160,033', '85,151 '], ['183', 'Mongolia', '314', '+1', ' ', '', '307', '7', '1', '95', '', '73,641', '22,371', '3,291,861 '], ['184', 'Bhutan', '298', '+15', ' ', '', '237', '61', '', '385', '', '142,510', '184,166', '773,812 '], ['185', 'Cambodia', '280', '+2', ' ', '', '275', '5', '', '17', '', '144,119', '8,589', '16,778,683 '], ['186', 'Monaco', '222', '', '2 ', '', '189', '31', '1', '5,647', '51', '51,953', '1,321,455', '39,315 '], ['187', 'Cayman Islands', '213', '', '1 ', '', '209', '3', '', '3,231', '15', '39,814', '603,956', '65,922 '], ['188', 'Barbados', '199', '', '7 ', '', '182', '10', '', '692', '24', '24,628', '85,672', '287,468 '], ['189', 'Bermuda', '181', '', '9 ', '', '169', '3', '', '2,909', '145', '66,664', '1,071,476', '62,217 '], ['190', 'Brunei ', '146', '', '3 ', '', '142', '1', '', '333', '7', '58,914', '134,333', '438,568 '], ['191', 'Seychelles', '146', '', ' ', '', '143', '3', '', '1,482', '', '5,200', '52,789', '98,506 '], ['192', 'Liechtenstein', '127', '+1', '1 ', '', '116', '10', '', '3,328', '26', '900', '23,587', '38,157 '], ['193', 'Caribbean Netherlands', '124', '', '1 ', '', '46', '77', '', '4,717', '38', '2,575', '97,961', '26,286 '], ['194', 'Antigua and Barbuda', '107', '', '3 ', '', '96', '8', '', '1,090', '31', '2,878', '29,325', '98,140 '], ['195', 'British Virgin Islands', '71', '', '1 ', '', '66', '4', '2', '2,344', '33', '4,841', '159,853', '30,284 '], ['196', 'St. Vincent Grenadines', '64', '', ' ', '', '64', '0', '', '576', '', '5,360', '48,274', '111,033 '], ['197', 'St. Barth', '62', '', ' ', '', '37', '25', '', '6,272', '', '2,668', '269,904', '9,885 '], ['198', 'Macao', '46', '', ' ', '', '46', '0', '', '71', '', '4,238', '6,504', '651,620 '], ['199', 'Fiji', '32', '', '2  ', '', '28', '2', '1', '36', '2', '10,385', '11,563', '898,141 '], ['200', 'Dominica', '31', '', ' ', '', '24', '7', '', '430', '', '2,612', '36,261', '72,033 '], ['201', 'Timor-Leste', '28', '', ' ', '', '28', '0', '', '21', '', '8,073', '6,093', '1,324,866 '], ['202', 'New Caledonia', '27', '', ' ', '', '27', '0', '', '94', '', '14,585', '50,959', '286,212 '], ['203', 'Saint Lucia', '27', '', ' ', '', '27', '0', '', '147', '', '8,439', '45,902', '183,847 '], ['204', 'Grenada', '24', '', ' ', '', '24', '0', '', '213', '', '6,252', '55,494', '112,660 '], ['205', 'Laos', '23', '', ' ', '', '22', '1', '', '3', '', '55,110', '7,546', '7,302,776 '], ['206', 'Saint Kitts and Nevis', '19', '', ' ', '', '17', '2', '', '356', '', '2,431', '45,612', '53,297 '], ['207', 'Saint Pierre Miquelon', '16', '', ' ', '', '6', '10', '', '2,765', '', '1,967', '339,959', '5,786 '], ['208', 'Greenland', '14', '', ' ', '', '14', '0', '', '246', '', '8,254', '145,327', '56,796 '], ['209', 'Montserrat', '13', '', '1 ', '', '12', '0', '', '2,604', '200', '449', '89,926', '4,993 '], ['210', 'Falkland Islands', '13', '', ' ', '', '13', '0', '', '3,709', '', '2,261', '645,078', '3,505 '], ['211', 'Vatican City', '12', '', ' ', '', '12', '0', '', '14,963', '', '', '', '802 '], ['212', 'Western Sahara', '10', '', '1 ', '', '8', '1', '', '17', '2', '', '', '601,057 '], ['213', 'MS Zaandam', '9', '', '2 ', '', '', '7', '', '', '', '', '', ' '], ['214', 'Anguilla', '3', '', ' ', '', '3', '0', '', '199', '', '1,020', '67,828', '15,038 '], ['215', 'Solomon Islands', '1', '', ' ', '', '', '1', '', '1', '', '', '', '691,148 ']]\n",
      "['2', 'India', '6,650,456', '+28,276', '103,005 ', '+291', '5,621,193', '926,258', '8,944', '4,807', '74', '79,982,394', '57,810', '1,383,530,375 ']\n",
      "14\n"
     ]
    }
   ],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "url=BeautifulSoup('https://www.worldometers.info/coronavirus/','html.parser')\n",
    "start=requests.get(url)\n",
    "s1=start.text\n",
    "soup=BeautifulSoup(s1,'lxml')\n",
    "tags=soup.table\n",
    "tag=tags.find_all('tr')\n",
    "list1=[]\n",
    "for i in range(len(tag)):\n",
    "    x=tag[i].get_text()\n",
    "    list1.append(x)\n",
    "del list1[1:7]\n",
    "del list1[1:3]\n",
    "list1=list1[:216]\n",
    "final=[]\n",
    "for j in list1:\n",
    "    y=j.split('\\n')[1:-1]\n",
    "    final.append(y)\n",
    "for k in range(len(final)):\n",
    "    del final[k][-2:]\n",
    "    del final[k][7]\n",
    "final[0]=['#',\n",
    "  'Country,other',\n",
    "  'TotalCases',\n",
    "  'NewCases',\n",
    "  'TotalDeaths',\n",
    "  'NewDeaths',\n",
    "  'TotalRecovered',\n",
    "  'ActiveCases',\n",
    "  'Serious,Critical',\n",
    "  'TotalCases/1M pop',\n",
    "  'Deaths/1M pop',\n",
    "  'TotalTests',\n",
    "  'Tests/1M pop',\n",
    "  'Population']\n",
    "print(final)\n",
    "#print(final[2])\n",
    "#print(len(final[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "n = len(final)\n",
    "with open('world.csv','a') as csvFile:\n",
    "  writer = csv.writer(csvFile)\n",
    "  for i in range(n):\n",
    "    writer.writerow(final[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['a', 'f', '', 's', 'r', '']\n"
     ]
    }
   ],
   "source": [
    "x=[\"a\",\"f\",'',\"s\",\"r\",'']\n",
    "for i in range(len(x)):\n",
    "    if '' in x:\n",
    "    x.replace()"
   ]
  },
  {
   "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}