Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
Classic Cars Classic Cars Total 3919615.661953416Motorcycles Motorcycles Total 1166388.34668675Planes Planes Total 975003.57618196Ships Ships Total 714437.13472714Trains Trains Total 226243.47155549Trucks and Buses Trucks and Buses Total 1127789.84608052Vintage Cars Vintage Cars Total 1903150.841226203(blank)(blank) Total 9291501.08 Grand Total 19324129.935702805
| Australia | 193085.54 | 107052 | |
| Austria | 101459.47 | 50497 | |
| Belgium | 20136.96 | 8081 | |
| Canada | 61623.22 | 28279 | |
| Denmark | 157182.48 | 68681 | |
| Finland | 153552.24 | 76762 | |
| France | 388951.2 | 197973 | |
| Germany | 148315 | 72724 | |
| Ireland | 31688.82 | 12126 | |
| Italy | 128576.65 | 56570 | |
| Japan | 47271.49 | 16165 | |
| Norway | 134787.37 | 70673 | |
| Philippines | 53112.09 | 26251 | |
| Singapore | 132890.44 | 64640 | |
| Spain | 476165.15 | 242426 | |
| Sweden | 69088.06 | 34348 | |
| Switzerland | 117713.56 | 62651 | |
| UK | 159377.7 | 92930 | |
| USA | 1344638.22 | 664587 | |
| Australia | 89968.76 | 52518 | |
| Austria | 26047.66 | 10105 | |
| Canada | 4177.49 | 2021 | |
| Finland | 47866.72 | 26269 | |
| France | 226390.31 | 137365 | |
| Germany | 7497.5 | 6061 | |
| Ireland | 4953.2 | 4042 | |
| Italy | 7567.8 | 4040 | |
| Japan | 26536.41 | 18189 | |
| Norway | 51768.63 | 28278 | |
| Philippines | 18061.68 | 14137 | |
| Singapore | 4175.6 | 2020 | |
| Spain | 74634.82 | 38381 | |
| Sweden | 15567.25 | 6060 | |
| UK | 40802.81 | 18180 | |
| USA | 520371.7 | 301009 | |
| Australia | 74853.87 | 50507 | |
| Austria | 17860.44 | 12116 | |
| Belgium | 5624.79 | 2021 | |
| Canada | 25510.07 | 20210 | |
| Denmark | 7586.45 | 4042 | |
| Finland | 34375.13 | 24233 | |
| France | 108155.51 | 64643 | |
| Germany | 23001.26 | 16168 | |
| Ireland | 11784.36 | 8084 | |
| Italy | 98185.65 | 62617 | |
| Japan | 49176.96 | 32336 | |
| Norway | 29500.7 | 22229 | |
| Philippines | 20906.87 | 10095 | |
| Spain | 89985.51 | 60606 | |
| Sweden | 8899.6 | 6057 | |
| UK | 41163.51 | 30309 | |
| USA | 328432.89 | 191923 | |
| Australia | 4159.76 | 4041 | |
| Austria | 9024.73 | 8076 | |
| Belgium | 31708.01 | 22231 | |
| Canada | 40309.01 | 28294 | |
| Denmark | 38697.26 | 28280 | |
| Finland | 29808.44 | 18178 | |
| France | 66486.67 | 42430 | |
| Germany | 5501 | 4042 | |
| Italy | 17703.54 | 12122 | |
| Japan | 18860.02 | 10103 | |
| Singapore | 14155.52 | 8076 | |
| Spain | 124459.97 | 78767 | |
| Sweden | 30915.89 | 20194 | |
| UK | 72959.17 | 46467 | |
| USA | 209688.14 | 141413 | |
| Australia | 1681.35 | 2019 | |
| Belgium | 9017.26 | 6061 | |
| Denmark | 11476.33 | 8082 | |
| Finland | 5117.05 | 4042 | |
| France | 27340.8 | 14146 | |
| Germany | 5043.42 | 4042 | |
| Ireland | 3112.6 | 4042 | |
| Italy | 6274.96 | 6059 | |
| Japan | 3523.67 | 4040 | |
| Norway | 11310.36 | 4042 | |
| Singapore | 13278.71 | 10095 | |
| Spain | 43370.18 | 28276 | |
| Sweden | 3807.68 | 2021 | |
| UK | 12635.54 | 8084 | |
| USA | 69253.56 | 50498 | |
| Australia | 77318.5 | 40407 | |
| Austria | 20472.75 | 10095 | |
| Canada | 51945.98 | 32325 | |
| Denmark | 9588.82 | 4042 | |
| Finland | 40479.33 | 22209 | |
| France | 116982.22 | 60595 | |
| Germany | 10178 | 4042 | |
| Ireland | 3983.05 | 2021 | |
| Italy | 5914.97 | 4040 | |
| Japan | 13349.44 | 6063 | |
| Norway | 37075.64 | 18175 | |
| Singapore | 89027.68 | 46463 | |
| Spain | 177556.78 | 92917 | |
| Sweden | 47931.27 | 22231 | |
| UK | 28142.99 | 16152 | |
| USA | 397842.42 | 226275 | |
| Australia | 189555.32 | 117144 | |
| Austria | 27197.48 | 20197 | |
| Belgium | 41925.6 | 28287 | |
| Canada | 40512.79 | 30302 | |
| Denmark | 21105.81 | 14139 | |
| Finland | 18383 | 14137 | |
| France | 176609.81 | 117204 | |
| Germany | 20935.91 | 18181 | |
| Ireland | 2234.4 | 2021 | |
| Italy | 110450.74 | 82823 | |
| Japan | 29449.82 | 18186 | |
| Norway | 43021 | 28282 | |
| Philippines | 1935.09 | 2019 | |
| Singapore | 34960.46 | 28280 | |
| Spain | 229514.51 | 149488 | |
| Sweden | 33804.46 | 24242 | |
| UK | 123798.74 | 78789 | |
| USA | 757755.9 | 452482 | |
| (blank) | 9291501.08 | ||