#Here is a list of data sets: http://vincentarelbundock.github.io/Rdatasets/ (click on the csv index for a list)
#Please select one, download it and perform the following tasks:
# I have downloaded Gasoline.csv using this link - https://raw.github.com/vincentarelbundock/Rdatasets/master/csv/Ecdat/Gasoline.csv
#1. Use the summary function to gain an overview of the data set. Then display the mean and median for at least two attributes.
gasolineData <- read.csv(file="C:\\R_WorkSpace\\gasoline.csv",header=TRUE, sep=",")
gasolineData
## X country year lgaspcar lincomep lrpmg lcarpcap
## 1 1 AUSTRIA 1960 4.173244 -6.474277 -0.33454761 -9.766840
## 2 2 AUSTRIA 1961 4.100989 -6.426006 -0.35132761 -9.608622
## 3 3 AUSTRIA 1962 4.073177 -6.407308 -0.37951769 -9.457257
## 4 4 AUSTRIA 1963 4.059509 -6.370679 -0.41425139 -9.343155
## 5 5 AUSTRIA 1964 4.037689 -6.322247 -0.44533536 -9.237739
## 6 6 AUSTRIA 1965 4.033983 -6.294668 -0.49706066 -9.123903
## 7 7 AUSTRIA 1966 4.047537 -6.252545 -0.46683773 -9.019822
## 8 8 AUSTRIA 1967 4.052911 -6.234581 -0.50588340 -8.934403
## 9 9 AUSTRIA 1968 4.045507 -6.206894 -0.52241255 -8.847967
## 10 10 AUSTRIA 1969 4.046355 -6.153140 -0.55911051 -8.788686
## 11 11 AUSTRIA 1970 4.080888 -6.081712 -0.59656122 -8.728200
## 12 12 AUSTRIA 1971 4.106720 -6.043626 -0.65445914 -8.635898
## 13 13 AUSTRIA 1972 4.128018 -5.981052 -0.59633184 -8.538338
## 14 14 AUSTRIA 1973 4.199381 -5.895153 -0.59444681 -8.487289
## 15 15 AUSTRIA 1974 4.018495 -5.852381 -0.46602693 -8.430404
## 16 16 AUSTRIA 1975 4.029018 -5.869363 -0.45414221 -8.382815
## 17 17 AUSTRIA 1976 3.985412 -5.811703 -0.50008372 -8.322232
## 18 18 AUSTRIA 1977 3.931676 -5.833288 -0.42191563 -8.249563
## 19 19 AUSTRIA 1978 3.922750 -5.762023 -0.46960312 -8.211041
## 20 20 BELGIUM 1960 4.164016 -6.215091 -0.16570961 -9.405527
## 21 21 BELGIUM 1961 4.124356 -6.176843 -0.17173098 -9.303149
## 22 22 BELGIUM 1962 4.075962 -6.129638 -0.22229138 -9.218070
## 23 23 BELGIUM 1963 4.001266 -6.094019 -0.25046225 -9.114932
## 24 24 BELGIUM 1964 3.994375 -6.036461 -0.27591057 -9.005491
## 25 25 BELGIUM 1965 3.951531 -6.007252 -0.34493695 -8.862581
## 26 26 BELGIUM 1966 3.820538 -5.994108 -0.23639770 -8.754527
## 27 27 BELGIUM 1967 3.906878 -5.964812 -0.26699499 -8.748827
## 28 28 BELGIUM 1968 3.828665 -5.924693 -0.31116076 -8.576513
## 29 29 BELGIUM 1969 3.854601 -5.857532 -0.35480852 -8.521453
## 30 30 BELGIUM 1970 3.870392 -5.797201 -0.37794044 -8.453043
## 31 31 BELGIUM 1971 3.872245 -5.761050 -0.39922992 -8.409457
## 32 32 BELGIUM 1972 3.905402 -5.710230 -0.31064584 -8.362588
## 33 33 BELGIUM 1973 3.895996 -5.644145 -0.37309192 -8.314447
## 34 34 BELGIUM 1974 3.818230 -5.600727 -0.36223563 -8.270595
## 35 35 BELGIUM 1975 3.877778 -5.623003 -0.36430848 -8.228848
## 36 36 BELGIUM 1976 3.864146 -5.567193 -0.37896584 -8.184134
## 37 37 BELGIUM 1977 3.854311 -5.556697 -0.43164133 -8.138534
## 38 38 BELGIUM 1978 3.842742 -5.532940 -0.59094964 -8.104741
## 39 39 CANADA 1960 4.855238 -5.889713 -0.97210650 -8.378917
## 40 40 CANADA 1961 4.826555 -5.884344 -0.97229024 -8.346729
## 41 41 CANADA 1962 4.850533 -5.844552 -0.97860756 -8.320512
## 42 42 CANADA 1963 4.838080 -5.792352 -1.01904791 -8.269422
## 43 43 CANADA 1964 4.839760 -5.760063 -1.00285696 -8.252404
## 44 44 CANADA 1965 4.850828 -5.722822 -1.01712549 -8.223621
## 45 45 CANADA 1966 4.871025 -5.671784 -1.01694436 -8.201236
## 46 46 CANADA 1967 4.852499 -5.608481 -1.02359713 -8.156076
## 47 47 CANADA 1968 4.868782 -5.573924 -1.01984524 -8.123188
## 48 48 CANADA 1969 4.864433 -5.560853 -1.03686389 -8.095113
## 49 49 CANADA 1970 4.899570 -5.514763 -1.06733308 -8.080028
## 50 50 CANADA 1971 4.895075 -5.479919 -1.05803676 -8.039264
## 51 51 CANADA 1972 4.889302 -5.436603 -1.09966703 -7.989531
## 52 52 CANADA 1973 4.899694 -5.414753 -1.13316142 -7.942140
## 53 53 CANADA 1974 4.891591 -5.418456 -1.12379997 -7.900758
## 54 54 CANADA 1975 4.888471 -5.379097 -1.18568427 -7.873313
## 55 55 CANADA 1976 4.837359 -5.361285 -1.06179659 -7.808425
## 56 56 CANADA 1977 4.810992 -5.336967 -1.07084448 -7.768793
## 57 57 CANADA 1978 4.855846 -5.311272 -1.07495073 -7.788061
## 58 58 DENMARK 1960 4.501986 -6.061726 -0.19570260 -9.326161
## 59 59 DENMARK 1961 4.482846 -6.000897 -0.25361844 -9.193136
## 60 60 DENMARK 1962 4.385449 -5.987477 -0.21875400 -9.047284
## 61 61 DENMARK 1963 4.353997 -5.973060 -0.24800936 -8.952783
## 62 62 DENMARK 1964 4.326436 -5.894741 -0.30654923 -8.852607
## 63 63 DENMARK 1965 4.249454 -5.859356 -0.32701542 -8.761954
## 64 64 DENMARK 1966 4.233643 -5.851866 -0.39618846 -8.681541
## 65 65 DENMARK 1967 4.203466 -5.823064 -0.44257369 -8.602121
## 66 66 DENMARK 1968 4.161687 -5.792260 -0.35204752 -8.533774
## 67 67 DENMARK 1969 4.173561 -5.722769 -0.40687922 -8.470459
## 68 68 DENMARK 1970 4.128807 -5.708307 -0.44046082 -8.427060
## 69 69 DENMARK 1971 4.103146 -5.676820 -0.45473954 -8.369399
## 70 70 DENMARK 1972 4.082808 -5.645991 -0.49918863 -8.334673
## 71 71 DENMARK 1973 4.137438 -5.595862 -0.43257185 -8.304602
## 72 72 DENMARK 1974 4.000461 -5.594866 -0.42517720 -8.300177
## 73 73 DENMARK 1975 4.033015 -5.612967 -0.39395431 -8.274632
## 74 74 DENMARK 1976 4.007739 -5.553939 -0.35361534 -8.244087
## 75 75 DENMARK 1977 4.005290 -5.538730 -0.35690917 -8.219858
## 76 76 DENMARK 1978 4.036601 -5.483074 -0.29068135 -8.195805
## 77 77 FRANCE 1960 3.907704 -6.264363 -0.01959833 -9.145706
## 78 78 FRANCE 1961 3.885623 -6.220883 -0.02386000 -9.044253
## 79 79 FRANCE 1962 3.823666 -6.173592 -0.06892022 -8.930133
## 80 80 FRANCE 1963 3.788997 -6.137060 -0.13792900 -8.818632
## 81 81 FRANCE 1964 3.767084 -6.087237 -0.19784646 -8.710965
## 82 82 FRANCE 1965 3.760584 -6.048528 -0.23365325 -8.629390
## 83 83 FRANCE 1966 3.749535 -6.000836 -0.26427164 -8.545771
## 84 84 FRANCE 1967 3.768621 -5.955660 -0.29405795 -8.487370
## 85 85 FRANCE 1968 3.778230 -5.901380 -0.32316179 -8.425551
## 86 86 FRANCE 1969 3.773460 -5.840774 -0.31519087 -8.369136
## 87 87 FRANCE 1970 3.801583 -5.784181 -0.33384616 -8.327089
## 88 88 FRANCE 1971 3.825962 -5.743144 -0.37945667 -8.279522
## 89 89 FRANCE 1972 3.846677 -5.699107 -0.40781642 -8.222764
## 90 90 FRANCE 1973 3.884994 -5.655065 -0.47503429 -8.183905
## 91 91 FRANCE 1974 3.807995 -5.630096 -0.21698191 -8.160328
## 92 92 FRANCE 1975 3.808549 -5.633271 -0.25838174 -8.145466
## 93 93 FRANCE 1976 3.908116 -5.588335 -0.24651309 -8.110406
## 94 94 FRANCE 1977 3.812500 -5.563418 -0.22550681 -8.064147
## 95 95 FRANCE 1978 3.788883 -5.530247 -0.38075942 -8.005655
## 96 96 GERMANY 1960 3.916953 -6.159837 -0.18591078 -9.342481
## 97 97 GERMANY 1961 3.885345 -6.120923 -0.23095384 -9.183841
## 98 98 GERMANY 1962 3.871484 -6.094258 -0.34384171 -9.037280
## 99 99 GERMANY 1963 3.848782 -6.068361 -0.37464672 -8.913630
## 100 100 GERMANY 1964 3.868993 -6.013442 -0.39965256 -8.811013
## 101 101 GERMANY 1965 3.861049 -5.966469 -0.43987825 -8.711888
## 102 102 GERMANY 1966 3.880741 -5.949068 -0.54000197 -8.631192
## 103 103 GERMANY 1967 3.875032 -5.960041 -0.54998139 -8.576013
## 104 104 GERMANY 1968 3.889362 -5.883414 -0.43824222 -8.515865
## 105 105 GERMANY 1969 3.899185 -5.829641 -0.58923137 -8.438061
## 106 106 GERMANY 1970 3.902520 -5.767374 -0.63329520 -8.361929
## 107 107 GERMANY 1971 3.932104 -5.738020 -0.67176311 -8.283823
## 108 108 GERMANY 1972 3.932402 -5.718750 -0.71797458 -8.237162
## 109 109 GERMANY 1973 3.924156 -5.668169 -0.72587521 -8.199004
## 110 110 GERMANY 1974 3.888212 -5.663964 -0.56982876 -8.182680
## 111 111 GERMANY 1975 3.922029 -5.679057 -0.56482380 -8.147343
## 112 112 GERMANY 1976 3.896469 -5.623841 -0.62481298 -8.087061
## 113 113 GERMANY 1977 3.895690 -5.594609 -0.59761210 -8.011102
## 114 114 GERMANY 1978 3.883879 -5.561733 -0.62817279 -7.950079
## 115 115 GREECE 1960 5.037406 -7.164861 -0.08354740 -12.173814
## 116 116 GREECE 1961 5.381495 -7.073347 -0.10421997 -12.051684
## 117 117 GREECE 1962 5.188072 -7.051422 -0.13320751 -11.906389
## 118 118 GREECE 1963 5.083412 -6.982025 -0.15653576 -11.733713
## 119 119 GREECE 1964 5.178627 -6.898713 -0.18051772 -11.550033
## 120 120 GREECE 1965 5.015112 -6.822933 -0.07793999 -11.317051
## 121 121 GREECE 1966 5.048396 -6.775097 -0.11491900 -11.156715
## 122 122 GREECE 1967 4.975775 -6.732434 -0.13775849 -11.010858
## 123 123 GREECE 1968 4.944160 -6.676809 -0.15375883 -10.847622
## 124 124 GREECE 1969 4.894773 -6.591104 -0.17986997 -10.713848
## 125 125 GREECE 1970 4.851824 -6.510271 -0.20252426 -10.564516
## 126 126 GREECE 1971 4.811815 -6.437449 -0.06761078 -10.417716
## 127 127 GREECE 1972 4.795709 -6.348042 -0.11973059 -10.286142
## 128 128 GREECE 1973 4.768582 -6.281170 -0.05191029 -10.156498
## 129 129 GREECE 1974 4.627807 -6.324581 0.31625351 -10.071675
## 130 130 GREECE 1975 4.580962 -6.271588 0.20631574 -9.933334
## 131 131 GREECE 1976 4.479956 -6.224761 0.19319312 -9.776965
## 132 132 GREECE 1977 4.484617 -6.203374 0.23502961 -9.615698
## 133 133 GREECE 1978 4.546400 -6.151117 0.16896037 -9.574983
## 134 134 IRELAND 1960 4.270421 -6.722466 -0.07648118 -9.698144
## 135 135 IRELAND 1961 4.255239 -6.658166 -0.12040874 -9.604869
## 136 136 IRELAND 1962 4.208435 -6.622812 -0.14160039 -9.502161
## 137 137 IRELAND 1963 4.176696 -6.591172 -0.15232915 -9.409332
## 138 138 IRELAND 1964 4.186243 -6.564281 -0.24428212 -9.314421
## 139 139 IRELAND 1965 4.164896 -6.548303 -0.16899366 -9.219422
## 140 140 IRELAND 1966 4.168214 -6.551963 -0.21071901 -9.170906
## 141 141 IRELAND 1967 4.188990 -6.500483 -0.17383533 -9.114685
## 142 142 IRELAND 1968 4.181120 -6.607963 -0.21339314 -9.017196
## 143 143 IRELAND 1969 4.208613 -6.379743 -0.27162842 -8.947265
## 144 144 IRELAND 1970 4.249945 -6.366517 -0.32069023 -8.918929
## 145 145 IRELAND 1971 4.267118 -6.345441 -0.36041067 -8.871952
## 146 146 IRELAND 1972 4.270768 -6.313571 -0.42393131 -8.823949
## 147 147 IRELAND 1973 4.253827 -6.296578 -0.64567297 -8.755768
## 148 148 IRELAND 1974 4.325585 -6.286885 -0.55343875 -8.745203
## 149 149 IRELAND 1975 4.248218 -6.301955 -0.64126416 -8.709478
## 150 150 IRELAND 1976 4.221146 -6.287267 -0.66134256 -8.667224
## 151 151 IRELAND 1977 4.241551 -6.251130 -0.56011483 -8.640727
## 152 152 IRELAND 1978 4.198611 -6.193143 -0.66277808 -8.550991
## 153 153 ITALY 1960 4.050728 -6.727487 0.16507708 -10.142098
## 154 154 ITALY 1961 4.045248 -6.655348 -0.08559038 -9.932662
## 155 155 ITALY 1962 4.028999 -6.599782 -0.18351291 -9.726695
## 156 156 ITALY 1963 3.963086 -6.552672 -0.26541405 -9.478800
## 157 157 ITALY 1964 3.936324 -6.629296 -0.42609643 -9.308466
## 158 158 ITALY 1965 3.874985 -6.602189 -0.32712637 -9.158018
## 159 159 ITALY 1966 3.822735 -6.449683 -0.24887418 -9.014813
## 160 160 ITALY 1967 3.785808 -6.393500 -0.19160048 -8.883282
## 161 161 ITALY 1968 3.763903 -6.334509 -0.20616656 -8.764197
## 162 162 ITALY 1969 3.737389 -6.282857 -0.24756681 -8.666004
## 163 163 ITALY 1970 3.706872 -6.240453 -0.23271512 -8.567338
## 164 164 ITALY 1971 3.648205 -6.222602 -0.14822267 -8.470968
## 165 165 ITALY 1972 3.629243 -6.205654 -0.21508857 -8.380176
## 166 166 ITALY 1973 3.652263 -6.157297 -0.32508487 -8.316705
## 167 167 ITALY 1974 3.499470 -6.125844 -0.22290860 -8.262256
## 168 168 ITALY 1975 3.515680 -6.170100 -0.03270913 -8.217666
## 169 169 ITALY 1976 3.427629 -6.119222 0.10292798 -8.167756
## 170 170 ITALY 1977 3.380209 -6.104541 0.16418805 -8.145660
## 171 171 ITALY 1978 3.394504 -6.083685 0.03482212 -8.112852
## 172 172 JAPAN 1960 5.995287 -6.986196 -0.14532271 -12.235079
## 173 173 JAPAN 1961 5.758484 -6.892951 -0.14874940 -11.870474
## 174 174 JAPAN 1962 5.641915 -6.805829 -0.18731459 -11.587885
## 175 175 JAPAN 1963 5.508082 -6.722760 -0.19996473 -11.270245
## 176 176 JAPAN 1964 5.275328 -6.635915 -0.20386433 -10.976966
## 177 177 JAPAN 1965 5.125851 -6.585563 -0.23786571 -10.721980
## 178 178 JAPAN 1966 5.000821 -6.500188 -0.27411537 -10.469487
## 179 179 JAPAN 1967 4.854861 -6.377596 -0.33167240 -10.176662
## 180 180 JAPAN 1968 4.684666 -6.251877 -0.35126918 -9.881850
## 181 181 JAPAN 1969 4.518290 -6.159308 -0.41685019 -9.607600
## 182 182 JAPAN 1970 4.401597 -6.058737 -0.46203546 -9.382952
## 183 183 JAPAN 1971 4.305624 -6.006080 -0.43941354 -9.209394
## 184 184 JAPAN 1972 4.222976 -5.934694 -0.52100094 -9.054139
## 185 185 JAPAN 1973 4.093884 -5.835869 -0.46270739 -8.924270
## 186 186 JAPAN 1974 4.007964 -5.852553 -0.19090636 -8.846520
## 187 187 JAPAN 1975 3.995984 -5.851706 -0.15948473 -8.775175
## 188 188 JAPAN 1976 3.988162 -5.800428 -0.20726559 -8.716417
## 189 189 JAPAN 1977 3.964672 -5.756856 -0.21904447 -8.655529
## 190 190 JAPAN 1978 3.948746 -5.708845 -0.28707638 -8.594032
## 191 191 NETHERLA 1960 4.646268 -6.216365 -0.20148480 -9.998449
## 192 192 NETHERLA 1961 4.559840 -6.208157 -0.21599265 -9.846711
## 193 193 NETHERLA 1962 4.471717 -6.180614 -0.25968008 -9.690566
## 194 194 NETHERLA 1963 4.377687 -6.162562 -0.29718661 -9.534029
## 195 195 NETHERLA 1964 4.319563 -6.089915 -0.36929389 -9.346112
## 196 196 NETHERLA 1965 4.233002 -6.051261 -0.34197503 -9.175165
## 197 197 NETHERLA 1966 4.168017 -6.038861 -0.34809007 -9.023481
## 198 198 NETHERLA 1967 4.119155 -5.999725 -0.31232019 -8.896225
## 199 199 NETHERLA 1968 4.070735 -5.946620 -0.44450431 -8.758570
## 200 200 NETHERLA 1969 3.987689 -5.880556 -0.41694955 -8.634102
## 201 201 NETHERLA 1970 3.956408 -5.838577 -0.39954544 -8.519498
## 202 202 NETHERLA 1971 3.947804 -5.813041 -0.43393029 -8.457595
## 203 203 NETHERLA 1972 3.915296 -5.785447 -0.31903240 -8.382631
## 204 204 NETHERLA 1973 3.880479 -5.747287 -0.42728193 -8.306707
## 205 205 NETHERLA 1974 3.711384 -5.729251 -0.35253685 -8.250494
## 206 206 NETHERLA 1975 3.718466 -5.743014 -0.43426178 -8.183298
## 207 207 NETHERLA 1976 3.783635 -5.703868 -0.42908393 -8.202468
## 208 208 NETHERLA 1977 3.776682 -5.686731 -0.46474195 -8.162542
## 209 209 NETHERLA 1978 3.882594 -5.660663 -0.55791459 -8.156008
## 210 210 NORWAY 1960 4.435041 -6.090356 -0.13968957 -9.675052
## 211 211 NORWAY 1961 4.332719 -6.037157 -0.15790514 -9.471597
## 212 212 NORWAY 1962 4.234241 -6.012897 -0.19908809 -9.329567
## 213 213 NORWAY 1963 4.216189 -5.966495 -0.23263318 -9.217731
## 214 214 NORWAY 1964 4.164352 -5.927909 -0.26374731 -9.091535
## 215 215 NORWAY 1965 4.131633 -5.881567 -0.31593124 -8.988003
## 216 216 NORWAY 1966 4.084607 -5.851223 -0.25011726 -8.891959
## 217 217 NORWAY 1967 4.064314 -5.805560 -0.26555763 -8.802676
## 218 218 NORWAY 1968 4.103864 -5.773495 -0.30036775 -8.801129
## 219 219 NORWAY 1969 4.086823 -5.735319 -0.33823045 -8.694593
## 220 220 NORWAY 1970 4.088806 -5.741144 -0.39072560 -8.628616
## 221 221 NORWAY 1971 4.078932 -5.699443 -0.30127223 -8.568486
## 222 222 NORWAY 1972 4.077257 -5.658013 -0.26023925 -8.514394
## 223 223 NORWAY 1973 4.061349 -5.623171 -0.33880765 -8.459655
## 224 224 NORWAY 1974 3.960331 -5.578383 -0.15100924 -8.406444
## 225 225 NORWAY 1975 3.996025 -5.551885 -0.32726757 -8.342890
## 226 226 NORWAY 1976 3.978210 -5.497635 -0.35308752 -8.277292
## 227 227 NORWAY 1977 3.988516 -5.458066 -0.38255762 -8.202841
## 228 228 NORWAY 1978 4.002487 -5.423289 -0.30765935 -8.171788
## 229 229 SPAIN 1960 4.749409 -6.166085 1.12531070 -11.588403
## 230 230 SPAIN 1961 4.589239 -6.057794 1.10956235 -11.384047
## 231 231 SPAIN 1962 4.429088 -5.980476 1.05700394 -11.157772
## 232 232 SPAIN 1963 4.346497 -5.905119 0.97683534 -10.984525
## 233 233 SPAIN 1964 4.300577 -5.858530 0.91532254 -10.787927
## 234 234 SPAIN 1965 4.217209 -5.800645 0.81666055 -10.585200
## 235 235 SPAIN 1966 4.113781 -5.735099 0.75671751 -10.329723
## 236 236 SPAIN 1967 4.086322 -5.705594 0.74130811 -10.102983
## 237 237 SPAIN 1968 4.044253 -5.657327 0.70386453 -9.911473
## 238 238 SPAIN 1969 3.994103 -5.601046 0.66948950 -9.720425
## 239 239 SPAIN 1970 3.966046 -5.553247 0.61217208 -9.557360
## 240 240 SPAIN 1971 3.907344 -5.515545 0.60699563 -9.409956
## 241 241 SPAIN 1972 3.891224 -5.458713 0.53716844 -9.270405
## 242 242 SPAIN 1973 3.912812 -5.373716 0.43377166 -9.126627
## 243 243 SPAIN 1974 3.768565 -5.329605 0.52492096 -9.013303
## 244 244 SPAIN 1975 3.752449 -5.330926 0.62955545 -8.916021
## 245 245 SPAIN 1976 3.710875 -5.312855 0.68385409 -8.820635
## 246 246 SPAIN 1977 3.650735 -5.299089 0.52627167 -8.727218
## 247 247 SPAIN 1978 3.620444 -5.285959 0.62141374 -8.634697
## 248 248 SWEDEN 1960 4.063010 -8.072524 -2.52041588 -8.742679
## 249 249 SWEDEN 1961 4.061870 -8.019588 -2.57148340 -8.659885
## 250 250 SWEDEN 1962 4.006439 -7.997249 -2.53448158 -8.577421
## 251 251 SWEDEN 1963 4.002766 -7.966748 -2.60511224 -8.494311
## 252 252 SWEDEN 1964 4.024859 -7.897582 -2.65801626 -8.433472
## 253 253 SWEDEN 1965 4.015463 -7.874805 -2.64476790 -8.369491
## 254 254 SWEDEN 1966 4.002557 -7.860797 -2.63901460 -8.326857
## 255 255 SWEDEN 1967 3.997346 -7.845463 -2.65609762 -8.289485
## 256 256 SWEDEN 1968 3.997585 -7.813987 -2.67918662 -8.248231
## 257 257 SWEDEN 1969 3.991715 -7.771081 -2.73190414 -8.197462
## 258 258 SWEDEN 1970 3.989372 -7.732610 -2.73359211 -8.164506
## 259 259 SWEDEN 1971 3.982062 -7.760113 -2.77884554 -8.142230
## 260 260 SWEDEN 1972 3.980066 -7.742511 -2.77467537 -8.103144
## 261 261 SWEDEN 1973 4.030560 -7.725299 -2.84142900 -8.087055
## 262 262 SWEDEN 1974 3.913159 -7.689531 -2.79840677 -8.036599
## 263 263 SWEDEN 1975 3.973840 -7.679557 -2.76731461 -7.994217
## 264 264 SWEDEN 1976 3.983997 -7.672043 -2.82294480 -7.956066
## 265 265 SWEDEN 1977 4.031011 -7.707376 -2.82005896 -7.968802
## 266 266 SWEDEN 1978 4.067373 -7.679196 -2.89649671 -7.971935
## 267 267 SWITZERL 1960 4.397621 -6.156074 -0.82321833 -9.262400
## 268 268 SWITZERL 1961 4.441330 -6.111640 -0.86558473 -9.158229
## 269 269 SWITZERL 1962 4.287147 -6.093006 -0.82218510 -9.046144
## 270 270 SWITZERL 1963 4.312485 -6.068021 -0.86012004 -8.950780
## 271 271 SWITZERL 1964 4.313427 -6.021471 -0.86767682 -8.839432
## 272 272 SWITZERL 1965 4.288714 -5.996087 -0.90528668 -8.760374
## 273 273 SWITZERL 1966 4.266352 -5.981617 -0.85956665 -8.679116
## 274 274 SWITZERL 1967 4.265919 -5.974918 -0.90656671 -8.619960
## 275 275 SWITZERL 1968 4.217788 -5.953628 -0.87232520 -8.544752
## 276 276 SWITZERL 1969 4.211290 -5.912172 -0.91812162 -8.473379
## 277 277 SWITZERL 1970 4.225297 -5.878636 -0.96344188 -8.406435
## 278 278 SWITZERL 1971 4.280697 -5.848665 -1.03746081 -8.360066
## 279 279 SWITZERL 1972 4.259159 -5.811492 -0.94015345 -8.303625
## 280 280 SWITZERL 1973 4.229816 -5.760413 -0.86722756 -8.246636
## 281 281 SWITZERL 1974 4.166364 -5.751703 -0.88692306 -8.205507
## 282 282 SWITZERL 1975 4.120568 -5.825776 -0.88475790 -8.166077
## 283 283 SWITZERL 1976 4.079572 -5.835963 -0.90736205 -8.128750
## 284 284 SWITZERL 1977 4.100533 -5.820960 -0.91147285 -8.093508
## 285 285 SWITZERL 1978 4.050048 -5.816847 -1.03208811 -8.034372
## 286 286 TURKEY 1960 6.129553 -7.801144 -0.25340821 -13.475185
## 287 287 TURKEY 1961 6.106213 -7.786727 -0.34252375 -13.384728
## 288 288 TURKEY 1962 6.084587 -7.836272 -0.40820484 -13.245942
## 289 289 TURKEY 1963 6.075129 -7.631193 -0.22499174 -13.255045
## 290 290 TURKEY 1964 6.064601 -7.626898 -0.25219448 -13.210310
## 291 291 TURKEY 1965 5.823046 -7.622027 -0.29347614 -12.879336
## 292 292 TURKEY 1966 6.156644 -7.510895 -0.35640491 -12.951138
## 293 293 TURKEY 1967 6.044479 -7.460810 -0.33515022 -12.801852
## 294 294 TURKEY 1968 6.076595 -7.421201 -0.36507386 -12.807355
## 295 295 TURKEY 1969 5.720705 -7.388646 -0.29845417 -12.518545
## 296 296 TURKEY 1970 5.722105 -7.324091 -0.39882648 -12.446583
## 297 297 TURKEY 1971 5.669646 -7.182366 -0.30461880 -12.398827
## 298 298 TURKEY 1972 5.578821 -7.083717 -0.54637424 -12.192044
## 299 299 TURKEY 1973 5.686470 -7.067422 -0.69162023 -11.990216
## 300 300 TURKEY 1974 5.427728 -7.012814 -0.33965308 -11.759400
## 301 301 TURKEY 1975 5.426777 -6.954439 -0.53794675 -11.555029
## 302 302 TURKEY 1976 5.312929 -6.909697 -0.75141027 -11.431642
## 303 303 TURKEY 1977 5.313462 -6.893659 -0.95552413 -11.233800
## 304 304 TURKEY 1978 5.141255 -6.888826 -0.35290961 -11.181325
## 305 305 U.K. 1960 4.100244 -6.186849 -0.39108581 -9.117623
## 306 306 U.K. 1961 4.088636 -6.168858 -0.45185308 -9.048892
## 307 307 U.K. 1962 4.048051 -6.166715 -0.42287690 -8.966885
## 308 308 U.K. 1963 3.985271 -6.130674 -0.46335147 -8.855943
## 309 309 U.K. 1964 3.976781 -6.086370 -0.49577430 -8.749782
## 310 310 U.K. 1965 3.968676 -6.076895 -0.42654915 -8.677608
## 311 311 U.K. 1966 3.957212 -6.069062 -0.47068145 -8.618278
## 312 312 U.K. 1967 3.943631 -6.049429 -0.44118786 -8.544973
## 313 313 U.K. 1968 3.953203 -6.030383 -0.46245080 -8.501871
## 314 314 U.K. 1969 3.948058 -6.031953 -0.38332457 -8.468119
## 315 315 U.K. 1970 3.979705 -6.008259 -0.41899030 -8.445137
## 316 316 U.K. 1971 3.983653 -5.981732 -0.46135978 -8.402793
## 317 317 U.K. 1972 3.992757 -5.973006 -0.52777246 -8.356098
## 318 318 U.K. 1973 3.995364 -5.897564 -0.56529718 -8.306677
## 319 319 U.K. 1974 3.966961 -5.912808 -0.56641296 -8.285771
## 320 320 U.K. 1975 3.912584 -5.923239 -0.20867428 -8.276416
## 321 321 U.K. 1976 3.962305 -5.886809 -0.27354010 -8.269375
## 322 322 U.K. 1977 3.945553 -5.871014 -0.50886285 -8.266517
## 323 323 U.K. 1978 4.000374 -5.840552 -0.78652911 -8.262614
## 324 324 U.S.A. 1960 4.823965 -5.698374 -1.12111489 -8.019458
## 325 325 U.S.A. 1961 4.796317 -5.695218 -1.14624034 -7.999262
## 326 326 U.S.A. 1962 4.798937 -5.648807 -1.16187449 -7.986407
## 327 327 U.S.A. 1963 4.787895 -5.626851 -1.17991524 -7.959542
## 328 328 U.S.A. 1964 4.808274 -5.587147 -1.20026222 -7.929899
## 329 329 U.S.A. 1965 4.805955 -5.536891 -1.19428750 -7.900493
## 330 330 U.S.A. 1966 4.807531 -5.479013 -1.19026054 -7.867978
## 331 331 U.S.A. 1967 4.800883 -5.464960 -1.18991215 -7.841177
## 332 332 U.S.A. 1968 4.834142 -5.430213 -1.20730059 -7.822428
## 333 333 U.S.A. 1969 4.841383 -5.414374 -1.22314272 -7.792706
## 334 334 U.S.A. 1970 4.848484 -5.421965 -1.25176347 -7.765376
## 335 335 U.S.A. 1971 4.860286 -5.406042 -1.28131560 -7.748921
## 336 336 U.S.A. 1972 4.854073 -5.353956 -1.33116930 -7.680418
## 337 337 U.S.A. 1973 4.846375 -5.308156 -1.29066967 -7.637693
## 338 338 U.S.A. 1974 4.798626 -5.328694 -1.23146686 -7.617558
## 339 339 U.S.A. 1975 4.804932 -5.346190 -1.20037697 -7.607010
## 340 340 U.S.A. 1976 4.814891 -5.297946 -1.15468197 -7.574748
## 341 341 U.S.A. 1977 4.811032 -5.256606 -1.17590974 -7.553458
## 342 342 U.S.A. 1978 4.818454 -5.221232 -1.21206183 -7.536176
summary.data.frame(gasolineData)
## X country year lgaspcar
## Min. : 1.00 AUSTRIA: 19 Min. :1960 Min. :3.380
## 1st Qu.: 86.25 BELGIUM: 19 1st Qu.:1964 1st Qu.:3.944
## Median :171.50 CANADA : 19 Median :1969 Median :4.088
## Mean :171.50 DENMARK: 19 Mean :1969 Mean :4.296
## 3rd Qu.:256.75 FRANCE : 19 3rd Qu.:1974 3rd Qu.:4.556
## Max. :342.00 GERMANY: 19 Max. :1978 Max. :6.157
## (Other):228
## lincomep lrpmg lcarpcap
## Min. :-8.073 Min. :-2.8965 Min. :-13.475
## 1st Qu.:-6.320 1st Qu.:-0.6523 1st Qu.: -9.307
## Median :-5.985 Median :-0.3795 Median : -8.658
## Mean :-6.139 Mean :-0.5231 Mean : -9.042
## 3rd Qu.:-5.720 3rd Qu.:-0.2234 3rd Qu.: -8.262
## Max. :-5.221 Max. : 1.1253 Max. : -7.536
##
gasolineYearMean <- mean(gasolineData$year,trim=0,na.rm=TRUE)
gasolineYearMean
## [1] 1969
gasolineLGASPCARMean <- mean(gasolineData$lgaspcar,trim=0,na.rm=TRUE)
gasolineLGASPCARMean
## [1] 4.296242
gasolineYearMedian <- median(gasolineData$year,na.rm = TRUE)
gasolineYearMedian
## [1] 1969
gasolineLGASPCARMedian <- median(gasolineData$lgaspcar,na.rm=TRUE)
gasolineLGASPCARMedian
## [1] 4.087729
#2. Create a new data frame with a subset of the columns and rows. Make sure to rename it.
gasolineSubSetData <- subset.data.frame(gasolineData,year > 1960 & year < 1970, select=c(country,year,lgaspcar))
gasolineSubSetData
## country year lgaspcar
## 2 AUSTRIA 1961 4.100989
## 3 AUSTRIA 1962 4.073177
## 4 AUSTRIA 1963 4.059509
## 5 AUSTRIA 1964 4.037689
## 6 AUSTRIA 1965 4.033983
## 7 AUSTRIA 1966 4.047537
## 8 AUSTRIA 1967 4.052911
## 9 AUSTRIA 1968 4.045507
## 10 AUSTRIA 1969 4.046355
## 21 BELGIUM 1961 4.124356
## 22 BELGIUM 1962 4.075962
## 23 BELGIUM 1963 4.001266
## 24 BELGIUM 1964 3.994375
## 25 BELGIUM 1965 3.951531
## 26 BELGIUM 1966 3.820538
## 27 BELGIUM 1967 3.906878
## 28 BELGIUM 1968 3.828665
## 29 BELGIUM 1969 3.854601
## 40 CANADA 1961 4.826555
## 41 CANADA 1962 4.850533
## 42 CANADA 1963 4.838080
## 43 CANADA 1964 4.839760
## 44 CANADA 1965 4.850828
## 45 CANADA 1966 4.871025
## 46 CANADA 1967 4.852499
## 47 CANADA 1968 4.868782
## 48 CANADA 1969 4.864433
## 59 DENMARK 1961 4.482846
## 60 DENMARK 1962 4.385449
## 61 DENMARK 1963 4.353997
## 62 DENMARK 1964 4.326436
## 63 DENMARK 1965 4.249454
## 64 DENMARK 1966 4.233643
## 65 DENMARK 1967 4.203466
## 66 DENMARK 1968 4.161687
## 67 DENMARK 1969 4.173561
## 78 FRANCE 1961 3.885623
## 79 FRANCE 1962 3.823666
## 80 FRANCE 1963 3.788997
## 81 FRANCE 1964 3.767084
## 82 FRANCE 1965 3.760584
## 83 FRANCE 1966 3.749535
## 84 FRANCE 1967 3.768621
## 85 FRANCE 1968 3.778230
## 86 FRANCE 1969 3.773460
## 97 GERMANY 1961 3.885345
## 98 GERMANY 1962 3.871484
## 99 GERMANY 1963 3.848782
## 100 GERMANY 1964 3.868993
## 101 GERMANY 1965 3.861049
## 102 GERMANY 1966 3.880741
## 103 GERMANY 1967 3.875032
## 104 GERMANY 1968 3.889362
## 105 GERMANY 1969 3.899185
## 116 GREECE 1961 5.381495
## 117 GREECE 1962 5.188072
## 118 GREECE 1963 5.083412
## 119 GREECE 1964 5.178627
## 120 GREECE 1965 5.015112
## 121 GREECE 1966 5.048396
## 122 GREECE 1967 4.975775
## 123 GREECE 1968 4.944160
## 124 GREECE 1969 4.894773
## 135 IRELAND 1961 4.255239
## 136 IRELAND 1962 4.208435
## 137 IRELAND 1963 4.176696
## 138 IRELAND 1964 4.186243
## 139 IRELAND 1965 4.164896
## 140 IRELAND 1966 4.168214
## 141 IRELAND 1967 4.188990
## 142 IRELAND 1968 4.181120
## 143 IRELAND 1969 4.208613
## 154 ITALY 1961 4.045248
## 155 ITALY 1962 4.028999
## 156 ITALY 1963 3.963086
## 157 ITALY 1964 3.936324
## 158 ITALY 1965 3.874985
## 159 ITALY 1966 3.822735
## 160 ITALY 1967 3.785808
## 161 ITALY 1968 3.763903
## 162 ITALY 1969 3.737389
## 173 JAPAN 1961 5.758484
## 174 JAPAN 1962 5.641915
## 175 JAPAN 1963 5.508082
## 176 JAPAN 1964 5.275328
## 177 JAPAN 1965 5.125851
## 178 JAPAN 1966 5.000821
## 179 JAPAN 1967 4.854861
## 180 JAPAN 1968 4.684666
## 181 JAPAN 1969 4.518290
## 192 NETHERLA 1961 4.559840
## 193 NETHERLA 1962 4.471717
## 194 NETHERLA 1963 4.377687
## 195 NETHERLA 1964 4.319563
## 196 NETHERLA 1965 4.233002
## 197 NETHERLA 1966 4.168017
## 198 NETHERLA 1967 4.119155
## 199 NETHERLA 1968 4.070735
## 200 NETHERLA 1969 3.987689
## 211 NORWAY 1961 4.332719
## 212 NORWAY 1962 4.234241
## 213 NORWAY 1963 4.216189
## 214 NORWAY 1964 4.164352
## 215 NORWAY 1965 4.131633
## 216 NORWAY 1966 4.084607
## 217 NORWAY 1967 4.064314
## 218 NORWAY 1968 4.103864
## 219 NORWAY 1969 4.086823
## 230 SPAIN 1961 4.589239
## 231 SPAIN 1962 4.429088
## 232 SPAIN 1963 4.346497
## 233 SPAIN 1964 4.300577
## 234 SPAIN 1965 4.217209
## 235 SPAIN 1966 4.113781
## 236 SPAIN 1967 4.086322
## 237 SPAIN 1968 4.044253
## 238 SPAIN 1969 3.994103
## 249 SWEDEN 1961 4.061870
## 250 SWEDEN 1962 4.006439
## 251 SWEDEN 1963 4.002766
## 252 SWEDEN 1964 4.024859
## 253 SWEDEN 1965 4.015463
## 254 SWEDEN 1966 4.002557
## 255 SWEDEN 1967 3.997346
## 256 SWEDEN 1968 3.997585
## 257 SWEDEN 1969 3.991715
## 268 SWITZERL 1961 4.441330
## 269 SWITZERL 1962 4.287147
## 270 SWITZERL 1963 4.312485
## 271 SWITZERL 1964 4.313427
## 272 SWITZERL 1965 4.288714
## 273 SWITZERL 1966 4.266352
## 274 SWITZERL 1967 4.265919
## 275 SWITZERL 1968 4.217788
## 276 SWITZERL 1969 4.211290
## 287 TURKEY 1961 6.106213
## 288 TURKEY 1962 6.084587
## 289 TURKEY 1963 6.075129
## 290 TURKEY 1964 6.064601
## 291 TURKEY 1965 5.823046
## 292 TURKEY 1966 6.156644
## 293 TURKEY 1967 6.044479
## 294 TURKEY 1968 6.076595
## 295 TURKEY 1969 5.720705
## 306 U.K. 1961 4.088636
## 307 U.K. 1962 4.048051
## 308 U.K. 1963 3.985271
## 309 U.K. 1964 3.976781
## 310 U.K. 1965 3.968676
## 311 U.K. 1966 3.957212
## 312 U.K. 1967 3.943631
## 313 U.K. 1968 3.953203
## 314 U.K. 1969 3.948058
## 325 U.S.A. 1961 4.796317
## 326 U.S.A. 1962 4.798937
## 327 U.S.A. 1963 4.787895
## 328 U.S.A. 1964 4.808274
## 329 U.S.A. 1965 4.805955
## 330 U.S.A. 1966 4.807531
## 331 U.S.A. 1967 4.800883
## 332 U.S.A. 1968 4.834142
## 333 U.S.A. 1969 4.841383
#3. Create new column names for the new data frame
colnames(gasolineSubSetData) <- c("COUNTRY_NAME","YEAR","LGASPCAR")
summary.data.frame(gasolineSubSetData)
## COUNTRY_NAME YEAR LGASPCAR
## AUSTRIA: 9 Min. :1961 Min. :3.737
## BELGIUM: 9 1st Qu.:1963 1st Qu.:3.995
## CANADA : 9 Median :1965 Median :4.175
## DENMARK: 9 Mean :1965 Mean :4.382
## FRANCE : 9 3rd Qu.:1967 3rd Qu.:4.798
## GERMANY: 9 Max. :1969 Max. :6.157
## (Other):108
#4. Use the summary function to create an overview of your new data frame. The print the mean and median for the same two attributes. Please compare.
gasolineSubsetYearMean <- mean(gasolineSubSetData$YEAR,trim=0,na.rm=TRUE)
gasolineSubsetYearMean
## [1] 1965
gasolineSubsetLGASPCARMean <- mean(gasolineSubSetData$LGASPCAR,trim=0,na.rm=TRUE)
gasolineSubsetLGASPCARMean
## [1] 4.382067
gasolineSubsetYearMedian <- median(gasolineSubSetData$YEAR,na.rm = TRUE)
gasolineSubsetYearMedian
## [1] 1965
gasolineSubsetLGASPCARMedian <- median(gasolineSubSetData$LGASPCAR,na.rm = TRUE)
gasolineSubsetLGASPCARMedian
## [1] 4.175129
#Compare Year Mean for original and subset data frames
if (gasolineYearMean > gasolineSubsetYearMean) {
compareYearMean <- "Mean of year values in dataframe gasolineData"
compareYearMean <- paste(compareYearMean,gasolineYearMean,sep = " - ")
compareYearMean <- paste(compareYearMean," is greater than the mean value for YEAR from gasolineSubSetData", sep=" ")
compareYearMean <- paste(compareYearMean, gasolineSubsetYearMean, sep = " - ")
}else if (gasolineYearMean < gasolineSubsetYearMean){
compareYearMean <- "Mean of year values in dataframe gasolineData"
compareYearMean <- paste(compareYearMean,gasolineYearMean,sep = " - ")
compareYearMean <- paste(compareYearMean," is lesser than the mean value for YEAR from gasolineSubSetData", sep=" ")
compareYearMean <- paste(compareYearMean, gasolineSubsetYearMean, sep = " - ")
}else {
compareYearMean <- "Mean of year values in dataframe gasolineData"
compareYearMean <- paste(compareYearMean,gasolineYearMean,sep = " - ")
compareYearMean <- paste(compareYearMean," is equal to the mean value for YEAR from gasolineSubSetData", sep=" ")
compareYearMean <- paste(compareYearMean, gasolineSubsetYearMean, sep = " - ")
}
compareYearMean
## [1] "Mean of year values in dataframe gasolineData - 1969 is greater than the mean value for YEAR from gasolineSubSetData - 1965"
#Compare Year Median for original and subset data frames
if (gasolineYearMedian > gasolineSubsetYearMedian) {
compareYearMedian <- "Median of year values in dataframe gasolineData"
compareYearMedian <- paste(compareYearMedian,gasolineYearMedian,sep = " - ")
compareYearMedian <- paste(compareYearMedian," is greater than the mean value for YEAR from gasolineSubSetData", sep=" ")
compareYearMedian <- paste(compareYearMedian, gasolineSubsetYearMedian, sep = " - ")
}else if (gasolineYearMedian < gasolineSubsetYearMedian){
compareYearMedian <- "Median of year values in dataframe gasolineData"
compareYearMedian <- paste(compareYearMedian,gasolineYearMedian,sep = " - ")
compareYearMedian <- paste(compareYearMedian," is lesser than the mean value for YEAR from gasolineSubSetData", sep=" ")
compareYearMedian <- paste(compareYearMedian, gasolineSubsetYearMedian, sep = " - ")
}else {
compareYearMedian <- "Mean of year values in dataframe gasolineData"
compareYearMedian <- paste(compareYearMedian,gasolineYearMedian,sep = " - ")
compareYearMedian <- paste(compareYearMedian," is equal to the mean value for YEAR from gasolineSubSetData", sep=" ")
compareYearMedian <- paste(compareYearMedian, gasolineSubsetYearMedian, sep = " - ")
}
compareYearMedian
## [1] "Median of year values in dataframe gasolineData - 1969 is greater than the mean value for YEAR from gasolineSubSetData - 1965"
##Compare LGASPCAR Mean for original and subset data frames
if (gasolineLGASPCARMean > gasolineSubsetLGASPCARMean) {
compareLGASPCARMean <- "Mean of lgaspcar values in dataframe gasolineData"
compareLGASPCARMean <- paste(compareLGASPCARMean,gasolineLGASPCARMean,sep = " - ")
compareLGASPCARMean <- paste(compareLGASPCARMean," is greater than the mean value for LGASPCAR from gasolineSubSetData", sep=" ")
compareLGASPCARMean <- paste(compareLGASPCARMean, gasolineSubsetLGASPCARMean, sep = " - ")
}else if (gasolineLGASPCARMean < gasolineSubsetLGASPCARMean){
compareLGASPCARMean <- "Mean of lgaspcar values in dataframe gasolineData"
compareLGASPCARMean <- paste(compareLGASPCARMean,gasolineLGASPCARMean,sep = " - ")
compareLGASPCARMean <- paste(compareLGASPCARMean," is lesser than the mean value for LGASPCAR from gasolineSubSetData", sep=" ")
compareLGASPCARMean <- paste(compareLGASPCARMean, gasolineSubsetLGASPCARMean, sep = " - ")
}else {
compareLGASPCARMean <- "Mean of lgaspcar values in dataframe gasolineData"
compareLGASPCARMean <- paste(compareLGASPCARMean,gasolineLGASPCARMean,sep = " - ")
compareLGASPCARMean <- paste(compareLGASPCARMean," is equal to the mean value for LGASPCAR from gasolineSubSetData", sep=" ")
compareLGASPCARMean <- paste(compareLGASPCARMean, gasolineSubsetLGASPCARMean, sep = " - ")
}
compareLGASPCARMean
## [1] "Mean of lgaspcar values in dataframe gasolineData - 4.29624202535702 is lesser than the mean value for LGASPCAR from gasolineSubSetData - 4.38206653997901"
##Compare LGASPCAR Median for original and subset data frames
if (gasolineLGASPCARMedian > gasolineSubsetLGASPCARMedian) {
compareLGASPCARMedian <- "Median of lgaspcar values in dataframe gasolineData"
compareLGASPCARMedian <- paste(compareLGASPCARMedian,gasolineLGASPCARMedian,sep = " - ")
compareLGASPCARMedian <- paste(compareLGASPCARMedian," is greater than the mean value for YEAR from gasolineSubSetData", sep=" ")
compareYearMedian <- paste(compareYearMedian, gasolineSubsetLGASPCARMedian, sep = " - ")
}else if (gasolineLGASPCARMedian < gasolineSubsetLGASPCARMedian){
compareLGASPCARMedian <- "Median of year values in dataframe gasolineData"
compareLGASPCARMedian <- paste(compareLGASPCARMedian,gasolineLGASPCARMedian,sep = " - ")
compareLGASPCARMedian <- paste(compareLGASPCARMedian," is lesser than the mean value for YEAR from gasolineSubSetData", sep=" ")
compareLGASPCARMedian <- paste(compareLGASPCARMedian, gasolineSubsetLGASPCARMedian, sep = " - ")
}else {
compareLGASPCARMedian <- "Mean of year values in dataframe gasolineData"
compareLGASPCARMedian <- paste(compareLGASPCARMedian,gasolineLGASPCARMedian,sep = " - ")
compareLGASPCARMedian <- paste(compareLGASPCARMedian," is equal to the mean value for YEAR from gasolineSubSetData", sep=" ")
compareLGASPCARMedian <- paste(compareLGASPCARMedian, gasolineSubsetLGASPCARMedian, sep = " - ")
}
compareLGASPCARMedian
## [1] "Median of year values in dataframe gasolineData - 4.08772930245 is lesser than the mean value for YEAR from gasolineSubSetData - 4.175128505"
#5. For at least 3 values in a column please rename so that every value in that column is renamed.For example, suppose I have 20 values of the letter "e" in one column. Rename those values so that all 20 would show as "excellent".
# I have chose to abbreviate country names U.S.A. and U.K. to United States Of America and United Kingdom respectively.
gasolineSubSetData$COUNTRY_NAME <- as.character(gasolineSubSetData$COUNTRY_NAME)
gasolineSubSetData$COUNTRY_NAME[gasolineSubSetData$COUNTRY_NAME == "U.S.A."] <- "United States Of America"
gasolineSubSetData$COUNTRY_NAME[gasolineSubSetData$COUNTRY_NAME == "U.K."] <- "United Kingdom"
# To see the changes
resultGasolineData <- gasolineSubSetData[(length(gasolineSubSetData$COUNTRY_NAME)-20):length(gasolineSubSetData$COUNTRY_NAME),]
resultGasolineData
## COUNTRY_NAME YEAR LGASPCAR
## 293 TURKEY 1967 6.044479
## 294 TURKEY 1968 6.076595
## 295 TURKEY 1969 5.720705
## 306 United Kingdom 1961 4.088636
## 307 United Kingdom 1962 4.048051
## 308 United Kingdom 1963 3.985271
## 309 United Kingdom 1964 3.976781
## 310 United Kingdom 1965 3.968676
## 311 United Kingdom 1966 3.957212
## 312 United Kingdom 1967 3.943631
## 313 United Kingdom 1968 3.953203
## 314 United Kingdom 1969 3.948058
## 325 United States Of America 1961 4.796317
## 326 United States Of America 1962 4.798937
## 327 United States Of America 1963 4.787895
## 328 United States Of America 1964 4.808274
## 329 United States Of America 1965 4.805955
## 330 United States Of America 1966 4.807531
## 331 United States Of America 1967 4.800883
## 332 United States Of America 1968 4.834142
## 333 United States Of America 1969 4.841383
#6. Display enough rows to see examples of all of steps 1-5 above
#Displaying last 30 rows as the abbreviations can be see at the end of the data frame
newSubsetWithChanges <- gasolineSubSetData[(length(gasolineSubSetData$COUNTRY_NAME)-30):length(gasolineSubSetData$COUNTRY_NAME),]
newSubsetWithChanges
## COUNTRY_NAME YEAR LGASPCAR
## 273 SWITZERL 1966 4.266352
## 274 SWITZERL 1967 4.265919
## 275 SWITZERL 1968 4.217788
## 276 SWITZERL 1969 4.211290
## 287 TURKEY 1961 6.106213
## 288 TURKEY 1962 6.084587
## 289 TURKEY 1963 6.075129
## 290 TURKEY 1964 6.064601
## 291 TURKEY 1965 5.823046
## 292 TURKEY 1966 6.156644
## 293 TURKEY 1967 6.044479
## 294 TURKEY 1968 6.076595
## 295 TURKEY 1969 5.720705
## 306 United Kingdom 1961 4.088636
## 307 United Kingdom 1962 4.048051
## 308 United Kingdom 1963 3.985271
## 309 United Kingdom 1964 3.976781
## 310 United Kingdom 1965 3.968676
## 311 United Kingdom 1966 3.957212
## 312 United Kingdom 1967 3.943631
## 313 United Kingdom 1968 3.953203
## 314 United Kingdom 1969 3.948058
## 325 United States Of America 1961 4.796317
## 326 United States Of America 1962 4.798937
## 327 United States Of America 1963 4.787895
## 328 United States Of America 1964 4.808274
## 329 United States Of America 1965 4.805955
## 330 United States Of America 1966 4.807531
## 331 United States Of America 1967 4.800883
## 332 United States Of America 1968 4.834142
## 333 United States Of America 1969 4.841383
#7. BONUS - place the original .csv in a github file and have R read from the link. This will be a very useful skill as you progress in your data science education and career.
require(RCurl)
## Loading required package: RCurl
## Loading required package: bitops
# I have first checked in the csv file into my local repository in GitHub and I am retrieving this as below -
gasolineFromGitHub <-read.csv(text=getURL("https://raw.githubusercontent.com/samsri01/Repo-For-CSV-File-Storage/master/gasoline.csv"),header=TRUE)
gasolineFromGitHub
## X country year lgaspcar lincomep lrpmg lcarpcap
## 1 1 AUSTRIA 1960 4.173244 -6.474277 -0.33454761 -9.766840
## 2 2 AUSTRIA 1961 4.100989 -6.426006 -0.35132761 -9.608622
## 3 3 AUSTRIA 1962 4.073177 -6.407308 -0.37951769 -9.457257
## 4 4 AUSTRIA 1963 4.059509 -6.370679 -0.41425139 -9.343155
## 5 5 AUSTRIA 1964 4.037689 -6.322247 -0.44533536 -9.237739
## 6 6 AUSTRIA 1965 4.033983 -6.294668 -0.49706066 -9.123903
## 7 7 AUSTRIA 1966 4.047537 -6.252545 -0.46683773 -9.019822
## 8 8 AUSTRIA 1967 4.052911 -6.234581 -0.50588340 -8.934403
## 9 9 AUSTRIA 1968 4.045507 -6.206894 -0.52241255 -8.847967
## 10 10 AUSTRIA 1969 4.046355 -6.153140 -0.55911051 -8.788686
## 11 11 AUSTRIA 1970 4.080888 -6.081712 -0.59656122 -8.728200
## 12 12 AUSTRIA 1971 4.106720 -6.043626 -0.65445914 -8.635898
## 13 13 AUSTRIA 1972 4.128018 -5.981052 -0.59633184 -8.538338
## 14 14 AUSTRIA 1973 4.199381 -5.895153 -0.59444681 -8.487289
## 15 15 AUSTRIA 1974 4.018495 -5.852381 -0.46602693 -8.430404
## 16 16 AUSTRIA 1975 4.029018 -5.869363 -0.45414221 -8.382815
## 17 17 AUSTRIA 1976 3.985412 -5.811703 -0.50008372 -8.322232
## 18 18 AUSTRIA 1977 3.931676 -5.833288 -0.42191563 -8.249563
## 19 19 AUSTRIA 1978 3.922750 -5.762023 -0.46960312 -8.211041
## 20 20 BELGIUM 1960 4.164016 -6.215091 -0.16570961 -9.405527
## 21 21 BELGIUM 1961 4.124356 -6.176843 -0.17173098 -9.303149
## 22 22 BELGIUM 1962 4.075962 -6.129638 -0.22229138 -9.218070
## 23 23 BELGIUM 1963 4.001266 -6.094019 -0.25046225 -9.114932
## 24 24 BELGIUM 1964 3.994375 -6.036461 -0.27591057 -9.005491
## 25 25 BELGIUM 1965 3.951531 -6.007252 -0.34493695 -8.862581
## 26 26 BELGIUM 1966 3.820538 -5.994108 -0.23639770 -8.754527
## 27 27 BELGIUM 1967 3.906878 -5.964812 -0.26699499 -8.748827
## 28 28 BELGIUM 1968 3.828665 -5.924693 -0.31116076 -8.576513
## 29 29 BELGIUM 1969 3.854601 -5.857532 -0.35480852 -8.521453
## 30 30 BELGIUM 1970 3.870392 -5.797201 -0.37794044 -8.453043
## 31 31 BELGIUM 1971 3.872245 -5.761050 -0.39922992 -8.409457
## 32 32 BELGIUM 1972 3.905402 -5.710230 -0.31064584 -8.362588
## 33 33 BELGIUM 1973 3.895996 -5.644145 -0.37309192 -8.314447
## 34 34 BELGIUM 1974 3.818230 -5.600727 -0.36223563 -8.270595
## 35 35 BELGIUM 1975 3.877778 -5.623003 -0.36430848 -8.228848
## 36 36 BELGIUM 1976 3.864146 -5.567193 -0.37896584 -8.184134
## 37 37 BELGIUM 1977 3.854311 -5.556697 -0.43164133 -8.138534
## 38 38 BELGIUM 1978 3.842742 -5.532940 -0.59094964 -8.104741
## 39 39 CANADA 1960 4.855238 -5.889713 -0.97210650 -8.378917
## 40 40 CANADA 1961 4.826555 -5.884344 -0.97229024 -8.346729
## 41 41 CANADA 1962 4.850533 -5.844552 -0.97860756 -8.320512
## 42 42 CANADA 1963 4.838080 -5.792352 -1.01904791 -8.269422
## 43 43 CANADA 1964 4.839760 -5.760063 -1.00285696 -8.252404
## 44 44 CANADA 1965 4.850828 -5.722822 -1.01712549 -8.223621
## 45 45 CANADA 1966 4.871025 -5.671784 -1.01694436 -8.201236
## 46 46 CANADA 1967 4.852499 -5.608481 -1.02359713 -8.156076
## 47 47 CANADA 1968 4.868782 -5.573924 -1.01984524 -8.123188
## 48 48 CANADA 1969 4.864433 -5.560853 -1.03686389 -8.095113
## 49 49 CANADA 1970 4.899570 -5.514763 -1.06733308 -8.080028
## 50 50 CANADA 1971 4.895075 -5.479919 -1.05803676 -8.039264
## 51 51 CANADA 1972 4.889302 -5.436603 -1.09966703 -7.989531
## 52 52 CANADA 1973 4.899694 -5.414753 -1.13316142 -7.942140
## 53 53 CANADA 1974 4.891591 -5.418456 -1.12379997 -7.900758
## 54 54 CANADA 1975 4.888471 -5.379097 -1.18568427 -7.873313
## 55 55 CANADA 1976 4.837359 -5.361285 -1.06179659 -7.808425
## 56 56 CANADA 1977 4.810992 -5.336967 -1.07084448 -7.768793
## 57 57 CANADA 1978 4.855846 -5.311272 -1.07495073 -7.788061
## 58 58 DENMARK 1960 4.501986 -6.061726 -0.19570260 -9.326161
## 59 59 DENMARK 1961 4.482846 -6.000897 -0.25361844 -9.193136
## 60 60 DENMARK 1962 4.385449 -5.987477 -0.21875400 -9.047284
## 61 61 DENMARK 1963 4.353997 -5.973060 -0.24800936 -8.952783
## 62 62 DENMARK 1964 4.326436 -5.894741 -0.30654923 -8.852607
## 63 63 DENMARK 1965 4.249454 -5.859356 -0.32701542 -8.761954
## 64 64 DENMARK 1966 4.233643 -5.851866 -0.39618846 -8.681541
## 65 65 DENMARK 1967 4.203466 -5.823064 -0.44257369 -8.602121
## 66 66 DENMARK 1968 4.161687 -5.792260 -0.35204752 -8.533774
## 67 67 DENMARK 1969 4.173561 -5.722769 -0.40687922 -8.470459
## 68 68 DENMARK 1970 4.128807 -5.708307 -0.44046082 -8.427060
## 69 69 DENMARK 1971 4.103146 -5.676820 -0.45473954 -8.369399
## 70 70 DENMARK 1972 4.082808 -5.645991 -0.49918863 -8.334673
## 71 71 DENMARK 1973 4.137438 -5.595862 -0.43257185 -8.304602
## 72 72 DENMARK 1974 4.000461 -5.594866 -0.42517720 -8.300177
## 73 73 DENMARK 1975 4.033015 -5.612967 -0.39395431 -8.274632
## 74 74 DENMARK 1976 4.007739 -5.553939 -0.35361534 -8.244087
## 75 75 DENMARK 1977 4.005290 -5.538730 -0.35690917 -8.219858
## 76 76 DENMARK 1978 4.036601 -5.483074 -0.29068135 -8.195805
## 77 77 FRANCE 1960 3.907704 -6.264363 -0.01959833 -9.145706
## 78 78 FRANCE 1961 3.885623 -6.220883 -0.02386000 -9.044253
## 79 79 FRANCE 1962 3.823666 -6.173592 -0.06892022 -8.930133
## 80 80 FRANCE 1963 3.788997 -6.137060 -0.13792900 -8.818632
## 81 81 FRANCE 1964 3.767084 -6.087237 -0.19784646 -8.710965
## 82 82 FRANCE 1965 3.760584 -6.048528 -0.23365325 -8.629390
## 83 83 FRANCE 1966 3.749535 -6.000836 -0.26427164 -8.545771
## 84 84 FRANCE 1967 3.768621 -5.955660 -0.29405795 -8.487370
## 85 85 FRANCE 1968 3.778230 -5.901380 -0.32316179 -8.425551
## 86 86 FRANCE 1969 3.773460 -5.840774 -0.31519087 -8.369136
## 87 87 FRANCE 1970 3.801583 -5.784181 -0.33384616 -8.327089
## 88 88 FRANCE 1971 3.825962 -5.743144 -0.37945667 -8.279522
## 89 89 FRANCE 1972 3.846677 -5.699107 -0.40781642 -8.222764
## 90 90 FRANCE 1973 3.884994 -5.655065 -0.47503429 -8.183905
## 91 91 FRANCE 1974 3.807995 -5.630096 -0.21698191 -8.160328
## 92 92 FRANCE 1975 3.808549 -5.633271 -0.25838174 -8.145466
## 93 93 FRANCE 1976 3.908116 -5.588335 -0.24651309 -8.110406
## 94 94 FRANCE 1977 3.812500 -5.563418 -0.22550681 -8.064147
## 95 95 FRANCE 1978 3.788883 -5.530247 -0.38075942 -8.005655
## 96 96 GERMANY 1960 3.916953 -6.159837 -0.18591078 -9.342481
## 97 97 GERMANY 1961 3.885345 -6.120923 -0.23095384 -9.183841
## 98 98 GERMANY 1962 3.871484 -6.094258 -0.34384171 -9.037280
## 99 99 GERMANY 1963 3.848782 -6.068361 -0.37464672 -8.913630
## 100 100 GERMANY 1964 3.868993 -6.013442 -0.39965256 -8.811013
## 101 101 GERMANY 1965 3.861049 -5.966469 -0.43987825 -8.711888
## 102 102 GERMANY 1966 3.880741 -5.949068 -0.54000197 -8.631192
## 103 103 GERMANY 1967 3.875032 -5.960041 -0.54998139 -8.576013
## 104 104 GERMANY 1968 3.889362 -5.883414 -0.43824222 -8.515865
## 105 105 GERMANY 1969 3.899185 -5.829641 -0.58923137 -8.438061
## 106 106 GERMANY 1970 3.902520 -5.767374 -0.63329520 -8.361929
## 107 107 GERMANY 1971 3.932104 -5.738020 -0.67176311 -8.283823
## 108 108 GERMANY 1972 3.932402 -5.718750 -0.71797458 -8.237162
## 109 109 GERMANY 1973 3.924156 -5.668169 -0.72587521 -8.199004
## 110 110 GERMANY 1974 3.888212 -5.663964 -0.56982876 -8.182680
## 111 111 GERMANY 1975 3.922029 -5.679057 -0.56482380 -8.147343
## 112 112 GERMANY 1976 3.896469 -5.623841 -0.62481298 -8.087061
## 113 113 GERMANY 1977 3.895690 -5.594609 -0.59761210 -8.011102
## 114 114 GERMANY 1978 3.883879 -5.561733 -0.62817279 -7.950079
## 115 115 GREECE 1960 5.037406 -7.164861 -0.08354740 -12.173814
## 116 116 GREECE 1961 5.381495 -7.073347 -0.10421997 -12.051684
## 117 117 GREECE 1962 5.188072 -7.051422 -0.13320751 -11.906389
## 118 118 GREECE 1963 5.083412 -6.982025 -0.15653576 -11.733713
## 119 119 GREECE 1964 5.178627 -6.898713 -0.18051772 -11.550033
## 120 120 GREECE 1965 5.015112 -6.822933 -0.07793999 -11.317051
## 121 121 GREECE 1966 5.048396 -6.775097 -0.11491900 -11.156715
## 122 122 GREECE 1967 4.975775 -6.732434 -0.13775849 -11.010858
## 123 123 GREECE 1968 4.944160 -6.676809 -0.15375883 -10.847622
## 124 124 GREECE 1969 4.894773 -6.591104 -0.17986997 -10.713848
## 125 125 GREECE 1970 4.851824 -6.510271 -0.20252426 -10.564516
## 126 126 GREECE 1971 4.811815 -6.437449 -0.06761078 -10.417716
## 127 127 GREECE 1972 4.795709 -6.348042 -0.11973059 -10.286142
## 128 128 GREECE 1973 4.768582 -6.281170 -0.05191029 -10.156498
## 129 129 GREECE 1974 4.627807 -6.324581 0.31625351 -10.071675
## 130 130 GREECE 1975 4.580962 -6.271588 0.20631574 -9.933334
## 131 131 GREECE 1976 4.479956 -6.224761 0.19319312 -9.776965
## 132 132 GREECE 1977 4.484617 -6.203374 0.23502961 -9.615698
## 133 133 GREECE 1978 4.546400 -6.151117 0.16896037 -9.574983
## 134 134 IRELAND 1960 4.270421 -6.722466 -0.07648118 -9.698144
## 135 135 IRELAND 1961 4.255239 -6.658166 -0.12040874 -9.604869
## 136 136 IRELAND 1962 4.208435 -6.622812 -0.14160039 -9.502161
## 137 137 IRELAND 1963 4.176696 -6.591172 -0.15232915 -9.409332
## 138 138 IRELAND 1964 4.186243 -6.564281 -0.24428212 -9.314421
## 139 139 IRELAND 1965 4.164896 -6.548303 -0.16899366 -9.219422
## 140 140 IRELAND 1966 4.168214 -6.551963 -0.21071901 -9.170906
## 141 141 IRELAND 1967 4.188990 -6.500483 -0.17383533 -9.114685
## 142 142 IRELAND 1968 4.181120 -6.607963 -0.21339314 -9.017196
## 143 143 IRELAND 1969 4.208613 -6.379743 -0.27162842 -8.947265
## 144 144 IRELAND 1970 4.249945 -6.366517 -0.32069023 -8.918929
## 145 145 IRELAND 1971 4.267118 -6.345441 -0.36041067 -8.871952
## 146 146 IRELAND 1972 4.270768 -6.313571 -0.42393131 -8.823949
## 147 147 IRELAND 1973 4.253827 -6.296578 -0.64567297 -8.755768
## 148 148 IRELAND 1974 4.325585 -6.286885 -0.55343875 -8.745203
## 149 149 IRELAND 1975 4.248218 -6.301955 -0.64126416 -8.709478
## 150 150 IRELAND 1976 4.221146 -6.287267 -0.66134256 -8.667224
## 151 151 IRELAND 1977 4.241551 -6.251130 -0.56011483 -8.640727
## 152 152 IRELAND 1978 4.198611 -6.193143 -0.66277808 -8.550991
## 153 153 ITALY 1960 4.050728 -6.727487 0.16507708 -10.142098
## 154 154 ITALY 1961 4.045248 -6.655348 -0.08559038 -9.932662
## 155 155 ITALY 1962 4.028999 -6.599782 -0.18351291 -9.726695
## 156 156 ITALY 1963 3.963086 -6.552672 -0.26541405 -9.478800
## 157 157 ITALY 1964 3.936324 -6.629296 -0.42609643 -9.308466
## 158 158 ITALY 1965 3.874985 -6.602189 -0.32712637 -9.158018
## 159 159 ITALY 1966 3.822735 -6.449683 -0.24887418 -9.014813
## 160 160 ITALY 1967 3.785808 -6.393500 -0.19160048 -8.883282
## 161 161 ITALY 1968 3.763903 -6.334509 -0.20616656 -8.764197
## 162 162 ITALY 1969 3.737389 -6.282857 -0.24756681 -8.666004
## 163 163 ITALY 1970 3.706872 -6.240453 -0.23271512 -8.567338
## 164 164 ITALY 1971 3.648205 -6.222602 -0.14822267 -8.470968
## 165 165 ITALY 1972 3.629243 -6.205654 -0.21508857 -8.380176
## 166 166 ITALY 1973 3.652263 -6.157297 -0.32508487 -8.316705
## 167 167 ITALY 1974 3.499470 -6.125844 -0.22290860 -8.262256
## 168 168 ITALY 1975 3.515680 -6.170100 -0.03270913 -8.217666
## 169 169 ITALY 1976 3.427629 -6.119222 0.10292798 -8.167756
## 170 170 ITALY 1977 3.380209 -6.104541 0.16418805 -8.145660
## 171 171 ITALY 1978 3.394504 -6.083685 0.03482212 -8.112852
## 172 172 JAPAN 1960 5.995287 -6.986196 -0.14532271 -12.235079
## 173 173 JAPAN 1961 5.758484 -6.892951 -0.14874940 -11.870474
## 174 174 JAPAN 1962 5.641915 -6.805829 -0.18731459 -11.587885
## 175 175 JAPAN 1963 5.508082 -6.722760 -0.19996473 -11.270245
## 176 176 JAPAN 1964 5.275328 -6.635915 -0.20386433 -10.976966
## 177 177 JAPAN 1965 5.125851 -6.585563 -0.23786571 -10.721980
## 178 178 JAPAN 1966 5.000821 -6.500188 -0.27411537 -10.469487
## 179 179 JAPAN 1967 4.854861 -6.377596 -0.33167240 -10.176662
## 180 180 JAPAN 1968 4.684666 -6.251877 -0.35126918 -9.881850
## 181 181 JAPAN 1969 4.518290 -6.159308 -0.41685019 -9.607600
## 182 182 JAPAN 1970 4.401597 -6.058737 -0.46203546 -9.382952
## 183 183 JAPAN 1971 4.305624 -6.006080 -0.43941354 -9.209394
## 184 184 JAPAN 1972 4.222976 -5.934694 -0.52100094 -9.054139
## 185 185 JAPAN 1973 4.093884 -5.835869 -0.46270739 -8.924270
## 186 186 JAPAN 1974 4.007964 -5.852553 -0.19090636 -8.846520
## 187 187 JAPAN 1975 3.995984 -5.851706 -0.15948473 -8.775175
## 188 188 JAPAN 1976 3.988162 -5.800428 -0.20726559 -8.716417
## 189 189 JAPAN 1977 3.964672 -5.756856 -0.21904447 -8.655529
## 190 190 JAPAN 1978 3.948746 -5.708845 -0.28707638 -8.594032
## 191 191 NETHERLA 1960 4.646268 -6.216365 -0.20148480 -9.998449
## 192 192 NETHERLA 1961 4.559840 -6.208157 -0.21599265 -9.846711
## 193 193 NETHERLA 1962 4.471717 -6.180614 -0.25968008 -9.690566
## 194 194 NETHERLA 1963 4.377687 -6.162562 -0.29718661 -9.534029
## 195 195 NETHERLA 1964 4.319563 -6.089915 -0.36929389 -9.346112
## 196 196 NETHERLA 1965 4.233002 -6.051261 -0.34197503 -9.175165
## 197 197 NETHERLA 1966 4.168017 -6.038861 -0.34809007 -9.023481
## 198 198 NETHERLA 1967 4.119155 -5.999725 -0.31232019 -8.896225
## 199 199 NETHERLA 1968 4.070735 -5.946620 -0.44450431 -8.758570
## 200 200 NETHERLA 1969 3.987689 -5.880556 -0.41694955 -8.634102
## 201 201 NETHERLA 1970 3.956408 -5.838577 -0.39954544 -8.519498
## 202 202 NETHERLA 1971 3.947804 -5.813041 -0.43393029 -8.457595
## 203 203 NETHERLA 1972 3.915296 -5.785447 -0.31903240 -8.382631
## 204 204 NETHERLA 1973 3.880479 -5.747287 -0.42728193 -8.306707
## 205 205 NETHERLA 1974 3.711384 -5.729251 -0.35253685 -8.250494
## 206 206 NETHERLA 1975 3.718466 -5.743014 -0.43426178 -8.183298
## 207 207 NETHERLA 1976 3.783635 -5.703868 -0.42908393 -8.202468
## 208 208 NETHERLA 1977 3.776682 -5.686731 -0.46474195 -8.162542
## 209 209 NETHERLA 1978 3.882594 -5.660663 -0.55791459 -8.156008
## 210 210 NORWAY 1960 4.435041 -6.090356 -0.13968957 -9.675052
## 211 211 NORWAY 1961 4.332719 -6.037157 -0.15790514 -9.471597
## 212 212 NORWAY 1962 4.234241 -6.012897 -0.19908809 -9.329567
## 213 213 NORWAY 1963 4.216189 -5.966495 -0.23263318 -9.217731
## 214 214 NORWAY 1964 4.164352 -5.927909 -0.26374731 -9.091535
## 215 215 NORWAY 1965 4.131633 -5.881567 -0.31593124 -8.988003
## 216 216 NORWAY 1966 4.084607 -5.851223 -0.25011726 -8.891959
## 217 217 NORWAY 1967 4.064314 -5.805560 -0.26555763 -8.802676
## 218 218 NORWAY 1968 4.103864 -5.773495 -0.30036775 -8.801129
## 219 219 NORWAY 1969 4.086823 -5.735319 -0.33823045 -8.694593
## 220 220 NORWAY 1970 4.088806 -5.741144 -0.39072560 -8.628616
## 221 221 NORWAY 1971 4.078932 -5.699443 -0.30127223 -8.568486
## 222 222 NORWAY 1972 4.077257 -5.658013 -0.26023925 -8.514394
## 223 223 NORWAY 1973 4.061349 -5.623171 -0.33880765 -8.459655
## 224 224 NORWAY 1974 3.960331 -5.578383 -0.15100924 -8.406444
## 225 225 NORWAY 1975 3.996025 -5.551885 -0.32726757 -8.342890
## 226 226 NORWAY 1976 3.978210 -5.497635 -0.35308752 -8.277292
## 227 227 NORWAY 1977 3.988516 -5.458066 -0.38255762 -8.202841
## 228 228 NORWAY 1978 4.002487 -5.423289 -0.30765935 -8.171788
## 229 229 SPAIN 1960 4.749409 -6.166085 1.12531070 -11.588403
## 230 230 SPAIN 1961 4.589239 -6.057794 1.10956235 -11.384047
## 231 231 SPAIN 1962 4.429088 -5.980476 1.05700394 -11.157772
## 232 232 SPAIN 1963 4.346497 -5.905119 0.97683534 -10.984525
## 233 233 SPAIN 1964 4.300577 -5.858530 0.91532254 -10.787927
## 234 234 SPAIN 1965 4.217209 -5.800645 0.81666055 -10.585200
## 235 235 SPAIN 1966 4.113781 -5.735099 0.75671751 -10.329723
## 236 236 SPAIN 1967 4.086322 -5.705594 0.74130811 -10.102983
## 237 237 SPAIN 1968 4.044253 -5.657327 0.70386453 -9.911473
## 238 238 SPAIN 1969 3.994103 -5.601046 0.66948950 -9.720425
## 239 239 SPAIN 1970 3.966046 -5.553247 0.61217208 -9.557360
## 240 240 SPAIN 1971 3.907344 -5.515545 0.60699563 -9.409956
## 241 241 SPAIN 1972 3.891224 -5.458713 0.53716844 -9.270405
## 242 242 SPAIN 1973 3.912812 -5.373716 0.43377166 -9.126627
## 243 243 SPAIN 1974 3.768565 -5.329605 0.52492096 -9.013303
## 244 244 SPAIN 1975 3.752449 -5.330926 0.62955545 -8.916021
## 245 245 SPAIN 1976 3.710875 -5.312855 0.68385409 -8.820635
## 246 246 SPAIN 1977 3.650735 -5.299089 0.52627167 -8.727218
## 247 247 SPAIN 1978 3.620444 -5.285959 0.62141374 -8.634697
## 248 248 SWEDEN 1960 4.063010 -8.072524 -2.52041588 -8.742679
## 249 249 SWEDEN 1961 4.061870 -8.019588 -2.57148340 -8.659885
## 250 250 SWEDEN 1962 4.006439 -7.997249 -2.53448158 -8.577421
## 251 251 SWEDEN 1963 4.002766 -7.966748 -2.60511224 -8.494311
## 252 252 SWEDEN 1964 4.024859 -7.897582 -2.65801626 -8.433472
## 253 253 SWEDEN 1965 4.015463 -7.874805 -2.64476790 -8.369491
## 254 254 SWEDEN 1966 4.002557 -7.860797 -2.63901460 -8.326857
## 255 255 SWEDEN 1967 3.997346 -7.845463 -2.65609762 -8.289485
## 256 256 SWEDEN 1968 3.997585 -7.813987 -2.67918662 -8.248231
## 257 257 SWEDEN 1969 3.991715 -7.771081 -2.73190414 -8.197462
## 258 258 SWEDEN 1970 3.989372 -7.732610 -2.73359211 -8.164506
## 259 259 SWEDEN 1971 3.982062 -7.760113 -2.77884554 -8.142230
## 260 260 SWEDEN 1972 3.980066 -7.742511 -2.77467537 -8.103144
## 261 261 SWEDEN 1973 4.030560 -7.725299 -2.84142900 -8.087055
## 262 262 SWEDEN 1974 3.913159 -7.689531 -2.79840677 -8.036599
## 263 263 SWEDEN 1975 3.973840 -7.679557 -2.76731461 -7.994217
## 264 264 SWEDEN 1976 3.983997 -7.672043 -2.82294480 -7.956066
## 265 265 SWEDEN 1977 4.031011 -7.707376 -2.82005896 -7.968802
## 266 266 SWEDEN 1978 4.067373 -7.679196 -2.89649671 -7.971935
## 267 267 SWITZERL 1960 4.397621 -6.156074 -0.82321833 -9.262400
## 268 268 SWITZERL 1961 4.441330 -6.111640 -0.86558473 -9.158229
## 269 269 SWITZERL 1962 4.287147 -6.093006 -0.82218510 -9.046144
## 270 270 SWITZERL 1963 4.312485 -6.068021 -0.86012004 -8.950780
## 271 271 SWITZERL 1964 4.313427 -6.021471 -0.86767682 -8.839432
## 272 272 SWITZERL 1965 4.288714 -5.996087 -0.90528668 -8.760374
## 273 273 SWITZERL 1966 4.266352 -5.981617 -0.85956665 -8.679116
## 274 274 SWITZERL 1967 4.265919 -5.974918 -0.90656671 -8.619960
## 275 275 SWITZERL 1968 4.217788 -5.953628 -0.87232520 -8.544752
## 276 276 SWITZERL 1969 4.211290 -5.912172 -0.91812162 -8.473379
## 277 277 SWITZERL 1970 4.225297 -5.878636 -0.96344188 -8.406435
## 278 278 SWITZERL 1971 4.280697 -5.848665 -1.03746081 -8.360066
## 279 279 SWITZERL 1972 4.259159 -5.811492 -0.94015345 -8.303625
## 280 280 SWITZERL 1973 4.229816 -5.760413 -0.86722756 -8.246636
## 281 281 SWITZERL 1974 4.166364 -5.751703 -0.88692306 -8.205507
## 282 282 SWITZERL 1975 4.120568 -5.825776 -0.88475790 -8.166077
## 283 283 SWITZERL 1976 4.079572 -5.835963 -0.90736205 -8.128750
## 284 284 SWITZERL 1977 4.100533 -5.820960 -0.91147285 -8.093508
## 285 285 SWITZERL 1978 4.050048 -5.816847 -1.03208811 -8.034372
## 286 286 TURKEY 1960 6.129553 -7.801144 -0.25340821 -13.475185
## 287 287 TURKEY 1961 6.106213 -7.786727 -0.34252375 -13.384728
## 288 288 TURKEY 1962 6.084587 -7.836272 -0.40820484 -13.245942
## 289 289 TURKEY 1963 6.075129 -7.631193 -0.22499174 -13.255045
## 290 290 TURKEY 1964 6.064601 -7.626898 -0.25219448 -13.210310
## 291 291 TURKEY 1965 5.823046 -7.622027 -0.29347614 -12.879336
## 292 292 TURKEY 1966 6.156644 -7.510895 -0.35640491 -12.951138
## 293 293 TURKEY 1967 6.044479 -7.460810 -0.33515022 -12.801852
## 294 294 TURKEY 1968 6.076595 -7.421201 -0.36507386 -12.807355
## 295 295 TURKEY 1969 5.720705 -7.388646 -0.29845417 -12.518545
## 296 296 TURKEY 1970 5.722105 -7.324091 -0.39882648 -12.446583
## 297 297 TURKEY 1971 5.669646 -7.182366 -0.30461880 -12.398827
## 298 298 TURKEY 1972 5.578821 -7.083717 -0.54637424 -12.192044
## 299 299 TURKEY 1973 5.686470 -7.067422 -0.69162023 -11.990216
## 300 300 TURKEY 1974 5.427728 -7.012814 -0.33965308 -11.759400
## 301 301 TURKEY 1975 5.426777 -6.954439 -0.53794675 -11.555029
## 302 302 TURKEY 1976 5.312929 -6.909697 -0.75141027 -11.431642
## 303 303 TURKEY 1977 5.313462 -6.893659 -0.95552413 -11.233800
## 304 304 TURKEY 1978 5.141255 -6.888826 -0.35290961 -11.181325
## 305 305 U.K. 1960 4.100244 -6.186849 -0.39108581 -9.117623
## 306 306 U.K. 1961 4.088636 -6.168858 -0.45185308 -9.048892
## 307 307 U.K. 1962 4.048051 -6.166715 -0.42287690 -8.966885
## 308 308 U.K. 1963 3.985271 -6.130674 -0.46335147 -8.855943
## 309 309 U.K. 1964 3.976781 -6.086370 -0.49577430 -8.749782
## 310 310 U.K. 1965 3.968676 -6.076895 -0.42654915 -8.677608
## 311 311 U.K. 1966 3.957212 -6.069062 -0.47068145 -8.618278
## 312 312 U.K. 1967 3.943631 -6.049429 -0.44118786 -8.544973
## 313 313 U.K. 1968 3.953203 -6.030383 -0.46245080 -8.501871
## 314 314 U.K. 1969 3.948058 -6.031953 -0.38332457 -8.468119
## 315 315 U.K. 1970 3.979705 -6.008259 -0.41899030 -8.445137
## 316 316 U.K. 1971 3.983653 -5.981732 -0.46135978 -8.402793
## 317 317 U.K. 1972 3.992757 -5.973006 -0.52777246 -8.356098
## 318 318 U.K. 1973 3.995364 -5.897564 -0.56529718 -8.306677
## 319 319 U.K. 1974 3.966961 -5.912808 -0.56641296 -8.285771
## 320 320 U.K. 1975 3.912584 -5.923239 -0.20867428 -8.276416
## 321 321 U.K. 1976 3.962305 -5.886809 -0.27354010 -8.269375
## 322 322 U.K. 1977 3.945553 -5.871014 -0.50886285 -8.266517
## 323 323 U.K. 1978 4.000374 -5.840552 -0.78652911 -8.262614
## 324 324 U.S.A. 1960 4.823965 -5.698374 -1.12111489 -8.019458
## 325 325 U.S.A. 1961 4.796317 -5.695218 -1.14624034 -7.999262
## 326 326 U.S.A. 1962 4.798937 -5.648807 -1.16187449 -7.986407
## 327 327 U.S.A. 1963 4.787895 -5.626851 -1.17991524 -7.959542
## 328 328 U.S.A. 1964 4.808274 -5.587147 -1.20026222 -7.929899
## 329 329 U.S.A. 1965 4.805955 -5.536891 -1.19428750 -7.900493
## 330 330 U.S.A. 1966 4.807531 -5.479013 -1.19026054 -7.867978
## 331 331 U.S.A. 1967 4.800883 -5.464960 -1.18991215 -7.841177
## 332 332 U.S.A. 1968 4.834142 -5.430213 -1.20730059 -7.822428
## 333 333 U.S.A. 1969 4.841383 -5.414374 -1.22314272 -7.792706
## 334 334 U.S.A. 1970 4.848484 -5.421965 -1.25176347 -7.765376
## 335 335 U.S.A. 1971 4.860286 -5.406042 -1.28131560 -7.748921
## 336 336 U.S.A. 1972 4.854073 -5.353956 -1.33116930 -7.680418
## 337 337 U.S.A. 1973 4.846375 -5.308156 -1.29066967 -7.637693
## 338 338 U.S.A. 1974 4.798626 -5.328694 -1.23146686 -7.617558
## 339 339 U.S.A. 1975 4.804932 -5.346190 -1.20037697 -7.607010
## 340 340 U.S.A. 1976 4.814891 -5.297946 -1.15468197 -7.574748
## 341 341 U.S.A. 1977 4.811032 -5.256606 -1.17590974 -7.553458
## 342 342 U.S.A. 1978 4.818454 -5.221232 -1.21206183 -7.536176