Wrangling Dataset state.x77
library(datasets)
df <- as.data.frame(state.x77)
head(df)
## Population Income Illiteracy Life Exp Murder HS Grad Frost Area
## Alabama 3615 3624 2.1 69.05 15.1 41.3 20 50708
## Alaska 365 6315 1.5 69.31 11.3 66.7 152 566432
## Arizona 2212 4530 1.8 70.55 7.8 58.1 15 113417
## Arkansas 2110 3378 1.9 70.66 10.1 39.9 65 51945
## California 21198 5114 1.1 71.71 10.3 62.6 20 156361
## Colorado 2541 4884 0.7 72.06 6.8 63.9 166 103766
library(dplyr)
glimpse(df)
## Rows: 50
## Columns: 8
## $ Population <dbl> 3615, 365, 2212, 2110, 21198, 2541, 3100, 579, 8277, 4931, …
## $ Income <dbl> 3624, 6315, 4530, 3378, 5114, 4884, 5348, 4809, 4815, 4091,…
## $ Illiteracy <dbl> 2.1, 1.5, 1.8, 1.9, 1.1, 0.7, 1.1, 0.9, 1.3, 2.0, 1.9, 0.6,…
## $ `Life Exp` <dbl> 69.05, 69.31, 70.55, 70.66, 71.71, 72.06, 72.48, 70.06, 70.…
## $ Murder <dbl> 15.1, 11.3, 7.8, 10.1, 10.3, 6.8, 3.1, 6.2, 10.7, 13.9, 6.2…
## $ `HS Grad` <dbl> 41.3, 66.7, 58.1, 39.9, 62.6, 63.9, 56.0, 54.6, 52.6, 40.6,…
## $ Frost <dbl> 20, 152, 15, 65, 20, 166, 139, 103, 11, 60, 0, 126, 127, 12…
## $ Area <dbl> 50708, 566432, 113417, 51945, 156361, 103766, 4862, 1982, 5…
Penggunaan Filter
Memfilter negara bagian dengan Income di atas rata-rata
df %>% filter(Income>(mean(df$Income)))
## Population Income Illiteracy Life Exp Murder HS Grad Frost Area
## Alaska 365 6315 1.5 69.31 11.3 66.7 152 566432
## Arizona 2212 4530 1.8 70.55 7.8 58.1 15 113417
## California 21198 5114 1.1 71.71 10.3 62.6 20 156361
## Colorado 2541 4884 0.7 72.06 6.8 63.9 166 103766
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139 4862
## Delaware 579 4809 0.9 70.06 6.2 54.6 103 1982
## Florida 8277 4815 1.3 70.66 10.7 52.6 11 54090
## Hawaii 868 4963 1.9 73.60 6.2 61.9 0 6425
## Illinois 11197 5107 0.9 70.14 10.3 52.6 127 55748
## Indiana 5313 4458 0.7 70.88 7.1 52.9 122 36097
## Iowa 2861 4628 0.5 72.56 2.3 59.0 140 55941
## Kansas 2280 4669 0.6 72.58 4.5 59.9 114 81787
## Maryland 4122 5299 0.9 70.22 8.5 52.3 101 9891
## Massachusetts 5814 4755 1.1 71.83 3.3 58.5 103 7826
## Michigan 9111 4751 0.9 70.63 11.1 52.8 125 56817
## Minnesota 3921 4675 0.6 72.96 2.3 57.6 160 79289
## Nebraska 1544 4508 0.6 72.60 2.9 59.3 139 76483
## Nevada 590 5149 0.5 69.03 11.5 65.2 188 109889
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115 7521
## New York 18076 4903 1.4 70.55 10.9 52.7 82 47831
## North Dakota 637 5087 0.8 72.78 1.4 50.3 186 69273
## Ohio 10735 4561 0.8 70.82 7.4 53.2 124 40975
## Oregon 2284 4660 0.6 72.13 4.2 60.0 44 96184
## Pennsylvania 11860 4449 1.0 70.43 6.1 50.2 126 44966
## Rhode Island 931 4558 1.3 71.90 2.4 46.4 127 1049
## Virginia 4981 4701 1.4 70.08 9.5 47.8 85 39780
## Washington 3559 4864 0.6 71.72 4.3 63.5 32 66570
## Wisconsin 4589 4468 0.7 72.48 3.0 54.5 149 54464
## Wyoming 376 4566 0.6 70.29 6.9 62.9 173 97203
Memfilter negara bagian dengan Murder di bawah rata-rata
df %>% filter(Murder<(mean(df$Murder)))
## Population Income Illiteracy Life Exp Murder HS Grad Frost Area
## Colorado 2541 4884 0.7 72.06 6.8 63.9 166 103766
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139 4862
## Delaware 579 4809 0.9 70.06 6.2 54.6 103 1982
## Hawaii 868 4963 1.9 73.60 6.2 61.9 0 6425
## Idaho 813 4119 0.6 71.87 5.3 59.5 126 82677
## Indiana 5313 4458 0.7 70.88 7.1 52.9 122 36097
## Iowa 2861 4628 0.5 72.56 2.3 59.0 140 55941
## Kansas 2280 4669 0.6 72.58 4.5 59.9 114 81787
## Maine 1058 3694 0.7 70.39 2.7 54.7 161 30920
## Massachusetts 5814 4755 1.1 71.83 3.3 58.5 103 7826
## Minnesota 3921 4675 0.6 72.96 2.3 57.6 160 79289
## Montana 746 4347 0.6 70.56 5.0 59.2 155 145587
## Nebraska 1544 4508 0.6 72.60 2.9 59.3 139 76483
## New Hampshire 812 4281 0.7 71.23 3.3 57.6 174 9027
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115 7521
## North Dakota 637 5087 0.8 72.78 1.4 50.3 186 69273
## Oklahoma 2715 3983 1.1 71.42 6.4 51.6 82 68782
## Oregon 2284 4660 0.6 72.13 4.2 60.0 44 96184
## Pennsylvania 11860 4449 1.0 70.43 6.1 50.2 126 44966
## Rhode Island 931 4558 1.3 71.90 2.4 46.4 127 1049
## South Dakota 681 4167 0.5 72.08 1.7 53.3 172 75955
## Utah 1203 4022 0.6 72.90 4.5 67.3 137 82096
## Vermont 472 3907 0.6 71.64 5.5 57.1 168 9267
## Washington 3559 4864 0.6 71.72 4.3 63.5 32 66570
## West Virginia 1799 3617 1.4 69.48 6.7 41.6 100 24070
## Wisconsin 4589 4468 0.7 72.48 3.0 54.5 149 54464
## Wyoming 376 4566 0.6 70.29 6.9 62.9 173 97203
Penggunaan Select
Mengambil kolom Population dan Area
df %>% select(Population,Area)
## Population Area
## Alabama 3615 50708
## Alaska 365 566432
## Arizona 2212 113417
## Arkansas 2110 51945
## California 21198 156361
## Colorado 2541 103766
## Connecticut 3100 4862
## Delaware 579 1982
## Florida 8277 54090
## Georgia 4931 58073
## Hawaii 868 6425
## Idaho 813 82677
## Illinois 11197 55748
## Indiana 5313 36097
## Iowa 2861 55941
## Kansas 2280 81787
## Kentucky 3387 39650
## Louisiana 3806 44930
## Maine 1058 30920
## Maryland 4122 9891
## Massachusetts 5814 7826
## Michigan 9111 56817
## Minnesota 3921 79289
## Mississippi 2341 47296
## Missouri 4767 68995
## Montana 746 145587
## Nebraska 1544 76483
## Nevada 590 109889
## New Hampshire 812 9027
## New Jersey 7333 7521
## New Mexico 1144 121412
## New York 18076 47831
## North Carolina 5441 48798
## North Dakota 637 69273
## Ohio 10735 40975
## Oklahoma 2715 68782
## Oregon 2284 96184
## Pennsylvania 11860 44966
## Rhode Island 931 1049
## South Carolina 2816 30225
## South Dakota 681 75955
## Tennessee 4173 41328
## Texas 12237 262134
## Utah 1203 82096
## Vermont 472 9267
## Virginia 4981 39780
## Washington 3559 66570
## West Virginia 1799 24070
## Wisconsin 4589 54464
## Wyoming 376 97203
Mengambil kolom Illiteracy, Life Exp, Murder, HS Grad
df %>% select(-Population,-Area,-Income,-Frost)
## Illiteracy Life Exp Murder HS Grad
## Alabama 2.1 69.05 15.1 41.3
## Alaska 1.5 69.31 11.3 66.7
## Arizona 1.8 70.55 7.8 58.1
## Arkansas 1.9 70.66 10.1 39.9
## California 1.1 71.71 10.3 62.6
## Colorado 0.7 72.06 6.8 63.9
## Connecticut 1.1 72.48 3.1 56.0
## Delaware 0.9 70.06 6.2 54.6
## Florida 1.3 70.66 10.7 52.6
## Georgia 2.0 68.54 13.9 40.6
## Hawaii 1.9 73.60 6.2 61.9
## Idaho 0.6 71.87 5.3 59.5
## Illinois 0.9 70.14 10.3 52.6
## Indiana 0.7 70.88 7.1 52.9
## Iowa 0.5 72.56 2.3 59.0
## Kansas 0.6 72.58 4.5 59.9
## Kentucky 1.6 70.10 10.6 38.5
## Louisiana 2.8 68.76 13.2 42.2
## Maine 0.7 70.39 2.7 54.7
## Maryland 0.9 70.22 8.5 52.3
## Massachusetts 1.1 71.83 3.3 58.5
## Michigan 0.9 70.63 11.1 52.8
## Minnesota 0.6 72.96 2.3 57.6
## Mississippi 2.4 68.09 12.5 41.0
## Missouri 0.8 70.69 9.3 48.8
## Montana 0.6 70.56 5.0 59.2
## Nebraska 0.6 72.60 2.9 59.3
## Nevada 0.5 69.03 11.5 65.2
## New Hampshire 0.7 71.23 3.3 57.6
## New Jersey 1.1 70.93 5.2 52.5
## New Mexico 2.2 70.32 9.7 55.2
## New York 1.4 70.55 10.9 52.7
## North Carolina 1.8 69.21 11.1 38.5
## North Dakota 0.8 72.78 1.4 50.3
## Ohio 0.8 70.82 7.4 53.2
## Oklahoma 1.1 71.42 6.4 51.6
## Oregon 0.6 72.13 4.2 60.0
## Pennsylvania 1.0 70.43 6.1 50.2
## Rhode Island 1.3 71.90 2.4 46.4
## South Carolina 2.3 67.96 11.6 37.8
## South Dakota 0.5 72.08 1.7 53.3
## Tennessee 1.7 70.11 11.0 41.8
## Texas 2.2 70.90 12.2 47.4
## Utah 0.6 72.90 4.5 67.3
## Vermont 0.6 71.64 5.5 57.1
## Virginia 1.4 70.08 9.5 47.8
## Washington 0.6 71.72 4.3 63.5
## West Virginia 1.4 69.48 6.7 41.6
## Wisconsin 0.7 72.48 3.0 54.5
## Wyoming 0.6 70.29 6.9 62.9
Penggunaan Arrange
Mengurutkan negara bagian dengan Income tertinggi
df %>% arrange(desc(Income))
## Population Income Illiteracy Life Exp Murder HS Grad Frost
## Alaska 365 6315 1.5 69.31 11.3 66.7 152
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139
## Maryland 4122 5299 0.9 70.22 8.5 52.3 101
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115
## Nevada 590 5149 0.5 69.03 11.5 65.2 188
## California 21198 5114 1.1 71.71 10.3 62.6 20
## Illinois 11197 5107 0.9 70.14 10.3 52.6 127
## North Dakota 637 5087 0.8 72.78 1.4 50.3 186
## Hawaii 868 4963 1.9 73.60 6.2 61.9 0
## New York 18076 4903 1.4 70.55 10.9 52.7 82
## Colorado 2541 4884 0.7 72.06 6.8 63.9 166
## Washington 3559 4864 0.6 71.72 4.3 63.5 32
## Florida 8277 4815 1.3 70.66 10.7 52.6 11
## Delaware 579 4809 0.9 70.06 6.2 54.6 103
## Massachusetts 5814 4755 1.1 71.83 3.3 58.5 103
## Michigan 9111 4751 0.9 70.63 11.1 52.8 125
## Virginia 4981 4701 1.4 70.08 9.5 47.8 85
## Minnesota 3921 4675 0.6 72.96 2.3 57.6 160
## Kansas 2280 4669 0.6 72.58 4.5 59.9 114
## Oregon 2284 4660 0.6 72.13 4.2 60.0 44
## Iowa 2861 4628 0.5 72.56 2.3 59.0 140
## Wyoming 376 4566 0.6 70.29 6.9 62.9 173
## Ohio 10735 4561 0.8 70.82 7.4 53.2 124
## Rhode Island 931 4558 1.3 71.90 2.4 46.4 127
## Arizona 2212 4530 1.8 70.55 7.8 58.1 15
## Nebraska 1544 4508 0.6 72.60 2.9 59.3 139
## Wisconsin 4589 4468 0.7 72.48 3.0 54.5 149
## Indiana 5313 4458 0.7 70.88 7.1 52.9 122
## Pennsylvania 11860 4449 1.0 70.43 6.1 50.2 126
## Montana 746 4347 0.6 70.56 5.0 59.2 155
## New Hampshire 812 4281 0.7 71.23 3.3 57.6 174
## Missouri 4767 4254 0.8 70.69 9.3 48.8 108
## Texas 12237 4188 2.2 70.90 12.2 47.4 35
## South Dakota 681 4167 0.5 72.08 1.7 53.3 172
## Idaho 813 4119 0.6 71.87 5.3 59.5 126
## Georgia 4931 4091 2.0 68.54 13.9 40.6 60
## Utah 1203 4022 0.6 72.90 4.5 67.3 137
## Oklahoma 2715 3983 1.1 71.42 6.4 51.6 82
## Vermont 472 3907 0.6 71.64 5.5 57.1 168
## North Carolina 5441 3875 1.8 69.21 11.1 38.5 80
## Tennessee 4173 3821 1.7 70.11 11.0 41.8 70
## Kentucky 3387 3712 1.6 70.10 10.6 38.5 95
## Maine 1058 3694 0.7 70.39 2.7 54.7 161
## South Carolina 2816 3635 2.3 67.96 11.6 37.8 65
## Alabama 3615 3624 2.1 69.05 15.1 41.3 20
## West Virginia 1799 3617 1.4 69.48 6.7 41.6 100
## New Mexico 1144 3601 2.2 70.32 9.7 55.2 120
## Louisiana 3806 3545 2.8 68.76 13.2 42.2 12
## Arkansas 2110 3378 1.9 70.66 10.1 39.9 65
## Mississippi 2341 3098 2.4 68.09 12.5 41.0 50
## Area
## Alaska 566432
## Connecticut 4862
## Maryland 9891
## New Jersey 7521
## Nevada 109889
## California 156361
## Illinois 55748
## North Dakota 69273
## Hawaii 6425
## New York 47831
## Colorado 103766
## Washington 66570
## Florida 54090
## Delaware 1982
## Massachusetts 7826
## Michigan 56817
## Virginia 39780
## Minnesota 79289
## Kansas 81787
## Oregon 96184
## Iowa 55941
## Wyoming 97203
## Ohio 40975
## Rhode Island 1049
## Arizona 113417
## Nebraska 76483
## Wisconsin 54464
## Indiana 36097
## Pennsylvania 44966
## Montana 145587
## New Hampshire 9027
## Missouri 68995
## Texas 262134
## South Dakota 75955
## Idaho 82677
## Georgia 58073
## Utah 82096
## Oklahoma 68782
## Vermont 9267
## North Carolina 48798
## Tennessee 41328
## Kentucky 39650
## Maine 30920
## South Carolina 30225
## Alabama 50708
## West Virginia 24070
## New Mexico 121412
## Louisiana 44930
## Arkansas 51945
## Mississippi 47296
Mengurutkan negara bagian dengan High School Graduation
tertinggi
df %>% arrange(desc(`HS Grad`))
## Population Income Illiteracy Life Exp Murder HS Grad Frost
## Utah 1203 4022 0.6 72.90 4.5 67.3 137
## Alaska 365 6315 1.5 69.31 11.3 66.7 152
## Nevada 590 5149 0.5 69.03 11.5 65.2 188
## Colorado 2541 4884 0.7 72.06 6.8 63.9 166
## Washington 3559 4864 0.6 71.72 4.3 63.5 32
## Wyoming 376 4566 0.6 70.29 6.9 62.9 173
## California 21198 5114 1.1 71.71 10.3 62.6 20
## Hawaii 868 4963 1.9 73.60 6.2 61.9 0
## Oregon 2284 4660 0.6 72.13 4.2 60.0 44
## Kansas 2280 4669 0.6 72.58 4.5 59.9 114
## Idaho 813 4119 0.6 71.87 5.3 59.5 126
## Nebraska 1544 4508 0.6 72.60 2.9 59.3 139
## Montana 746 4347 0.6 70.56 5.0 59.2 155
## Iowa 2861 4628 0.5 72.56 2.3 59.0 140
## Massachusetts 5814 4755 1.1 71.83 3.3 58.5 103
## Arizona 2212 4530 1.8 70.55 7.8 58.1 15
## Minnesota 3921 4675 0.6 72.96 2.3 57.6 160
## New Hampshire 812 4281 0.7 71.23 3.3 57.6 174
## Vermont 472 3907 0.6 71.64 5.5 57.1 168
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139
## New Mexico 1144 3601 2.2 70.32 9.7 55.2 120
## Maine 1058 3694 0.7 70.39 2.7 54.7 161
## Delaware 579 4809 0.9 70.06 6.2 54.6 103
## Wisconsin 4589 4468 0.7 72.48 3.0 54.5 149
## South Dakota 681 4167 0.5 72.08 1.7 53.3 172
## Ohio 10735 4561 0.8 70.82 7.4 53.2 124
## Indiana 5313 4458 0.7 70.88 7.1 52.9 122
## Michigan 9111 4751 0.9 70.63 11.1 52.8 125
## New York 18076 4903 1.4 70.55 10.9 52.7 82
## Florida 8277 4815 1.3 70.66 10.7 52.6 11
## Illinois 11197 5107 0.9 70.14 10.3 52.6 127
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115
## Maryland 4122 5299 0.9 70.22 8.5 52.3 101
## Oklahoma 2715 3983 1.1 71.42 6.4 51.6 82
## North Dakota 637 5087 0.8 72.78 1.4 50.3 186
## Pennsylvania 11860 4449 1.0 70.43 6.1 50.2 126
## Missouri 4767 4254 0.8 70.69 9.3 48.8 108
## Virginia 4981 4701 1.4 70.08 9.5 47.8 85
## Texas 12237 4188 2.2 70.90 12.2 47.4 35
## Rhode Island 931 4558 1.3 71.90 2.4 46.4 127
## Louisiana 3806 3545 2.8 68.76 13.2 42.2 12
## Tennessee 4173 3821 1.7 70.11 11.0 41.8 70
## West Virginia 1799 3617 1.4 69.48 6.7 41.6 100
## Alabama 3615 3624 2.1 69.05 15.1 41.3 20
## Mississippi 2341 3098 2.4 68.09 12.5 41.0 50
## Georgia 4931 4091 2.0 68.54 13.9 40.6 60
## Arkansas 2110 3378 1.9 70.66 10.1 39.9 65
## Kentucky 3387 3712 1.6 70.10 10.6 38.5 95
## North Carolina 5441 3875 1.8 69.21 11.1 38.5 80
## South Carolina 2816 3635 2.3 67.96 11.6 37.8 65
## Area
## Utah 82096
## Alaska 566432
## Nevada 109889
## Colorado 103766
## Washington 66570
## Wyoming 97203
## California 156361
## Hawaii 6425
## Oregon 96184
## Kansas 81787
## Idaho 82677
## Nebraska 76483
## Montana 145587
## Iowa 55941
## Massachusetts 7826
## Arizona 113417
## Minnesota 79289
## New Hampshire 9027
## Vermont 9267
## Connecticut 4862
## New Mexico 121412
## Maine 30920
## Delaware 1982
## Wisconsin 54464
## South Dakota 75955
## Ohio 40975
## Indiana 36097
## Michigan 56817
## New York 47831
## Florida 54090
## Illinois 55748
## New Jersey 7521
## Maryland 9891
## Oklahoma 68782
## North Dakota 69273
## Pennsylvania 44966
## Missouri 68995
## Virginia 39780
## Texas 262134
## Rhode Island 1049
## Louisiana 44930
## Tennessee 41328
## West Virginia 24070
## Alabama 50708
## Mississippi 47296
## Georgia 58073
## Arkansas 51945
## Kentucky 39650
## North Carolina 48798
## South Carolina 30225
Mengurutkan negara bagian dengan Murder terendah
df %>% arrange(Murder)
## Population Income Illiteracy Life Exp Murder HS Grad Frost
## North Dakota 637 5087 0.8 72.78 1.4 50.3 186
## South Dakota 681 4167 0.5 72.08 1.7 53.3 172
## Iowa 2861 4628 0.5 72.56 2.3 59.0 140
## Minnesota 3921 4675 0.6 72.96 2.3 57.6 160
## Rhode Island 931 4558 1.3 71.90 2.4 46.4 127
## Maine 1058 3694 0.7 70.39 2.7 54.7 161
## Nebraska 1544 4508 0.6 72.60 2.9 59.3 139
## Wisconsin 4589 4468 0.7 72.48 3.0 54.5 149
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139
## Massachusetts 5814 4755 1.1 71.83 3.3 58.5 103
## New Hampshire 812 4281 0.7 71.23 3.3 57.6 174
## Oregon 2284 4660 0.6 72.13 4.2 60.0 44
## Washington 3559 4864 0.6 71.72 4.3 63.5 32
## Kansas 2280 4669 0.6 72.58 4.5 59.9 114
## Utah 1203 4022 0.6 72.90 4.5 67.3 137
## Montana 746 4347 0.6 70.56 5.0 59.2 155
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115
## Idaho 813 4119 0.6 71.87 5.3 59.5 126
## Vermont 472 3907 0.6 71.64 5.5 57.1 168
## Pennsylvania 11860 4449 1.0 70.43 6.1 50.2 126
## Delaware 579 4809 0.9 70.06 6.2 54.6 103
## Hawaii 868 4963 1.9 73.60 6.2 61.9 0
## Oklahoma 2715 3983 1.1 71.42 6.4 51.6 82
## West Virginia 1799 3617 1.4 69.48 6.7 41.6 100
## Colorado 2541 4884 0.7 72.06 6.8 63.9 166
## Wyoming 376 4566 0.6 70.29 6.9 62.9 173
## Indiana 5313 4458 0.7 70.88 7.1 52.9 122
## Ohio 10735 4561 0.8 70.82 7.4 53.2 124
## Arizona 2212 4530 1.8 70.55 7.8 58.1 15
## Maryland 4122 5299 0.9 70.22 8.5 52.3 101
## Missouri 4767 4254 0.8 70.69 9.3 48.8 108
## Virginia 4981 4701 1.4 70.08 9.5 47.8 85
## New Mexico 1144 3601 2.2 70.32 9.7 55.2 120
## Arkansas 2110 3378 1.9 70.66 10.1 39.9 65
## California 21198 5114 1.1 71.71 10.3 62.6 20
## Illinois 11197 5107 0.9 70.14 10.3 52.6 127
## Kentucky 3387 3712 1.6 70.10 10.6 38.5 95
## Florida 8277 4815 1.3 70.66 10.7 52.6 11
## New York 18076 4903 1.4 70.55 10.9 52.7 82
## Tennessee 4173 3821 1.7 70.11 11.0 41.8 70
## Michigan 9111 4751 0.9 70.63 11.1 52.8 125
## North Carolina 5441 3875 1.8 69.21 11.1 38.5 80
## Alaska 365 6315 1.5 69.31 11.3 66.7 152
## Nevada 590 5149 0.5 69.03 11.5 65.2 188
## South Carolina 2816 3635 2.3 67.96 11.6 37.8 65
## Texas 12237 4188 2.2 70.90 12.2 47.4 35
## Mississippi 2341 3098 2.4 68.09 12.5 41.0 50
## Louisiana 3806 3545 2.8 68.76 13.2 42.2 12
## Georgia 4931 4091 2.0 68.54 13.9 40.6 60
## Alabama 3615 3624 2.1 69.05 15.1 41.3 20
## Area
## North Dakota 69273
## South Dakota 75955
## Iowa 55941
## Minnesota 79289
## Rhode Island 1049
## Maine 30920
## Nebraska 76483
## Wisconsin 54464
## Connecticut 4862
## Massachusetts 7826
## New Hampshire 9027
## Oregon 96184
## Washington 66570
## Kansas 81787
## Utah 82096
## Montana 145587
## New Jersey 7521
## Idaho 82677
## Vermont 9267
## Pennsylvania 44966
## Delaware 1982
## Hawaii 6425
## Oklahoma 68782
## West Virginia 24070
## Colorado 103766
## Wyoming 97203
## Indiana 36097
## Ohio 40975
## Arizona 113417
## Maryland 9891
## Missouri 68995
## Virginia 39780
## New Mexico 121412
## Arkansas 51945
## California 156361
## Illinois 55748
## Kentucky 39650
## Florida 54090
## New York 47831
## Tennessee 41328
## Michigan 56817
## North Carolina 48798
## Alaska 566432
## Nevada 109889
## South Carolina 30225
## Texas 262134
## Mississippi 47296
## Louisiana 44930
## Georgia 58073
## Alabama 50708
Penggunaan Summarise
Menghitung Rata-Rata, Tertinggi, dan Terendah Income
df %>% summarize (mean.Income=mean(Income), max.Income = max(Income), min.Income=min(Income))
## mean.Income max.Income min.Income
## 1 4435.8 6315 3098
Penggunaan Mutate
Menghitung Kepadatan negara bagian
mutate(df, Kepadatan = Population/Area)
## Population Income Illiteracy Life Exp Murder HS Grad Frost
## Alabama 3615 3624 2.1 69.05 15.1 41.3 20
## Alaska 365 6315 1.5 69.31 11.3 66.7 152
## Arizona 2212 4530 1.8 70.55 7.8 58.1 15
## Arkansas 2110 3378 1.9 70.66 10.1 39.9 65
## California 21198 5114 1.1 71.71 10.3 62.6 20
## Colorado 2541 4884 0.7 72.06 6.8 63.9 166
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139
## Delaware 579 4809 0.9 70.06 6.2 54.6 103
## Florida 8277 4815 1.3 70.66 10.7 52.6 11
## Georgia 4931 4091 2.0 68.54 13.9 40.6 60
## Hawaii 868 4963 1.9 73.60 6.2 61.9 0
## Idaho 813 4119 0.6 71.87 5.3 59.5 126
## Illinois 11197 5107 0.9 70.14 10.3 52.6 127
## Indiana 5313 4458 0.7 70.88 7.1 52.9 122
## Iowa 2861 4628 0.5 72.56 2.3 59.0 140
## Kansas 2280 4669 0.6 72.58 4.5 59.9 114
## Kentucky 3387 3712 1.6 70.10 10.6 38.5 95
## Louisiana 3806 3545 2.8 68.76 13.2 42.2 12
## Maine 1058 3694 0.7 70.39 2.7 54.7 161
## Maryland 4122 5299 0.9 70.22 8.5 52.3 101
## Massachusetts 5814 4755 1.1 71.83 3.3 58.5 103
## Michigan 9111 4751 0.9 70.63 11.1 52.8 125
## Minnesota 3921 4675 0.6 72.96 2.3 57.6 160
## Mississippi 2341 3098 2.4 68.09 12.5 41.0 50
## Missouri 4767 4254 0.8 70.69 9.3 48.8 108
## Montana 746 4347 0.6 70.56 5.0 59.2 155
## Nebraska 1544 4508 0.6 72.60 2.9 59.3 139
## Nevada 590 5149 0.5 69.03 11.5 65.2 188
## New Hampshire 812 4281 0.7 71.23 3.3 57.6 174
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115
## New Mexico 1144 3601 2.2 70.32 9.7 55.2 120
## New York 18076 4903 1.4 70.55 10.9 52.7 82
## North Carolina 5441 3875 1.8 69.21 11.1 38.5 80
## North Dakota 637 5087 0.8 72.78 1.4 50.3 186
## Ohio 10735 4561 0.8 70.82 7.4 53.2 124
## Oklahoma 2715 3983 1.1 71.42 6.4 51.6 82
## Oregon 2284 4660 0.6 72.13 4.2 60.0 44
## Pennsylvania 11860 4449 1.0 70.43 6.1 50.2 126
## Rhode Island 931 4558 1.3 71.90 2.4 46.4 127
## South Carolina 2816 3635 2.3 67.96 11.6 37.8 65
## South Dakota 681 4167 0.5 72.08 1.7 53.3 172
## Tennessee 4173 3821 1.7 70.11 11.0 41.8 70
## Texas 12237 4188 2.2 70.90 12.2 47.4 35
## Utah 1203 4022 0.6 72.90 4.5 67.3 137
## Vermont 472 3907 0.6 71.64 5.5 57.1 168
## Virginia 4981 4701 1.4 70.08 9.5 47.8 85
## Washington 3559 4864 0.6 71.72 4.3 63.5 32
## West Virginia 1799 3617 1.4 69.48 6.7 41.6 100
## Wisconsin 4589 4468 0.7 72.48 3.0 54.5 149
## Wyoming 376 4566 0.6 70.29 6.9 62.9 173
## Area Kepadatan
## Alabama 50708 0.0712905261
## Alaska 566432 0.0006443845
## Arizona 113417 0.0195032491
## Arkansas 51945 0.0406198864
## California 156361 0.1355708904
## Colorado 103766 0.0244877898
## Connecticut 4862 0.6375976964
## Delaware 1982 0.2921291625
## Florida 54090 0.1530227399
## Georgia 58073 0.0849103714
## Hawaii 6425 0.1350972763
## Idaho 82677 0.0098334482
## Illinois 55748 0.2008502547
## Indiana 36097 0.1471867468
## Iowa 55941 0.0511431687
## Kansas 81787 0.0278772910
## Kentucky 39650 0.0854224464
## Louisiana 44930 0.0847095482
## Maine 30920 0.0342173351
## Maryland 9891 0.4167424932
## Massachusetts 7826 0.7429082545
## Michigan 56817 0.1603569354
## Minnesota 79289 0.0494520047
## Mississippi 47296 0.0494967862
## Missouri 68995 0.0690919632
## Montana 145587 0.0051240839
## Nebraska 76483 0.0201874926
## Nevada 109889 0.0053690542
## New Hampshire 9027 0.0899523651
## New Jersey 7521 0.9750033240
## New Mexico 121412 0.0094224624
## New York 47831 0.3779139052
## North Carolina 48798 0.1115004713
## North Dakota 69273 0.0091955019
## Ohio 40975 0.2619890177
## Oklahoma 68782 0.0394725364
## Oregon 96184 0.0237461532
## Pennsylvania 44966 0.2637548370
## Rhode Island 1049 0.8875119161
## South Carolina 30225 0.0931679074
## South Dakota 75955 0.0089658350
## Tennessee 41328 0.1009727062
## Texas 262134 0.0466822312
## Utah 82096 0.0146535763
## Vermont 9267 0.0509334197
## Virginia 39780 0.1252136752
## Washington 66570 0.0534625207
## West Virginia 24070 0.0747403407
## Wisconsin 54464 0.0842574912
## Wyoming 97203 0.0038681934
Penggunaan 2 fungsi sekaligus
Melihat negara bagian dari yang terpadat
view1 <- df %>%
mutate(df, Kepadatan = Population/Area) %>%
arrange(desc(Kepadatan))
head(view1)
## Population Income Illiteracy Life Exp Murder HS Grad Frost Area
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115 7521
## Rhode Island 931 4558 1.3 71.90 2.4 46.4 127 1049
## Massachusetts 5814 4755 1.1 71.83 3.3 58.5 103 7826
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139 4862
## Maryland 4122 5299 0.9 70.22 8.5 52.3 101 9891
## New York 18076 4903 1.4 70.55 10.9 52.7 82 47831
## Kepadatan
## New Jersey 0.9750033
## Rhode Island 0.8875119
## Massachusetts 0.7429083
## Connecticut 0.6375977
## Maryland 0.4167425
## New York 0.3779139
Melihat negara bagian dengan Income di atas rata-rata dari yang
tertinggi
view2 <- df %>%
filter(Income>mean(Income)) %>%
arrange(desc(Income))
head(view2)
## Population Income Illiteracy Life Exp Murder HS Grad Frost Area
## Alaska 365 6315 1.5 69.31 11.3 66.7 152 566432
## Connecticut 3100 5348 1.1 72.48 3.1 56.0 139 4862
## Maryland 4122 5299 0.9 70.22 8.5 52.3 101 9891
## New Jersey 7333 5237 1.1 70.93 5.2 52.5 115 7521
## Nevada 590 5149 0.5 69.03 11.5 65.2 188 109889
## California 21198 5114 1.1 71.71 10.3 62.6 20 156361