Target (28,064 records)
Target
Find how many unique 'agencies' are there in this data set
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
54
Target
Find how many times does each 'Agency' appears in this data set
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Alameda County
9680
Amador County
416
Butte County
3137
Calaveras County
477
Colusa County
436
Contra Costa County
11489
Del Norte County
421
El Dorado County
2214
Fresno County
7539
Glenn County
529
Humboldt County
2281
Imperial County
2236
Inyo County
552
Kern County
10274
Kings County
1465
Lassen County
405
Los Angeles County
99594
Madera County
1186
Marin County
2915
Mariposa County
598
Mendocino County
1315
Merced County
2563
Mono County
341
Monterey County
5397
Napa County
1767
Nevada County
993
Orange County
18327
Placer County
3012
Plumas County
581
Riverside County
22350
Sacramento County
12404
San Benito County
425
San Bernardino County
22473
San Diego County
18717
San Francisco
37606
San Joaquin County
7046
San Luis Obispo County
3096
San Mateo County
8176
Santa Barbara County
5560
Santa Clara County
18496
Santa Cruz County
2704
Shasta County
1890
Sierra County
151
Siskiyou County
805
Solano County
3082
Sonoma County
5014
Stanislaus County
4068
Sutter County
1115
Tehama County
985
Tulare County
4513
Tuolumne County
875
Ventura County
9441
Yolo County
1643
Yuba County
819
Target
Find what is the mean and median "Total Pay' for this entire data set. (Need to check your data type?!)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
62049.1557240503
54777.165
Target
Find what is the mean and median "Total Pay' for each 'Agency'. (Need to check your data type?!)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Alameda County
69056.9972334715
61967.48
Amador County
57505.8668028846
55819.5
Butte County
36511.3860376156
34745
Calaveras County
45889.0754507337
46665.35
Colusa County
49814.2376605505
50979.99
Contra Costa County
56535.5303725302
50134.5
Del Norte County
37530.3030403801
36831
El Dorado County
47326.6449096658
43400.995
Fresno County
46906.7695410528
44590
Glenn County
40498.4256710776
39561.6
Humboldt County
45637.4306269181
43279.04
Imperial County
44802.1984704832
40776.46
Inyo County
45948.3405797101
48147.5
Kern County
56814.09626241
48337.5
Kings County
43687.4689419795
41496
Lassen County
43612.8
41562
Los Angeles County
68019.8338554531
58375
Madera County
45277.2340387859
42928.175
Marin County
63889.2674579758
63634.75
Mariposa County
33228.4448160536
33410.28
Mendocino County
42912.3843422053
41277.55
Merced County
44038.7978774873
45132
Mono County
55366.9673607038
51215.64
Monterey County
59693.8082786733
51578.9
Napa County
58598.4166666667
57219.25
Nevada County
47958.8625679757
46355.8
Orange County
65603.8462039606
60182.59
Placer County
60155.0974269589
57736.745
Plumas County
43435.0244061962
33152.69
Riverside County
55929.5003293064
47421.525
Sacramento County
67308.6621581756
62986.645
San Benito County
50454.4136705882
45885.01
San Bernardino County
47996.6210612734
42204.04
San Diego County
55387.2992525507
52308.17
San Francisco
77611.443142054
74500.015
San Joaquin County
55959.167062163
46789.6
San Luis Obispo County
56310.5967861755
54549.65
San Mateo County
54402.4943321919
51770.315
Santa Barbara County
54990.2414604317
53414.36
Santa Clara County
73486.6590441182
63323.465
Santa Cruz County
58780.0742344675
58534.92
Shasta County
45381.0201640211
41339.18
Sierra County
32780.7425165563
36306.41
Siskiyou County
37609.428
37708.71
Solano County
60775.1130564569
58214.655
Sonoma County
64442.783815317
64326.215
Stanislaus County
48410.8178318586
44750.63
Sutter County
49925.0160717489
48179.11
Tehama County
39662.2007309645
37321.01
Tulare County
57744.1799822732
52529.02
Tuolumne County
40808.502982857
34883.75
Ventura County
63232.0251774177
54586.21
Yolo County
55491.8947048083
53635
Yuba County
55472.4002442002
53487.86
Count the number how man times each job title appears in each Agency
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Summarize Tool Examples
Click the triangle on the right to see the solutions.
Use the Summarize tool to achieve the target output.
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.
Solutions
Find how many unique 'agencies' are there in this data set
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Find how many times does each 'Agency' appears in this data set
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Find what is the mean and median "Total Pay' for this entire data set. (Need to check your data type?!)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Find what is the mean and median "Total Pay' for each 'Agency'. (Need to check your data type?!)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Count the number how man times each job title appears in each Agency
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Horizontal
Practice Exercise 5