search

jschulberg / Dog-Returns

A data science analysis to classify whether or not an adopted dog will be returned.
0 stars 0 forks source link

Clean up `Weight` Column #12

Closed jschulberg closed 2 years ago

jschulberg commented 2 years ago

We'll need to clean up the weight column, although it doesn't look too bad. For most of them, we just need to remove "lbs" from the text so we can make it a continuous variable. Here's a breakdown of all the values in the weight column:

Weight Count of ID
40.00lbs 255
20 255
10.00lbs 245
10 243
40 235
35 226
45.00lbs 225
30 203
30.00lbs 202
45 189
15 186
25 186
(blank) 183
8 175
50 172
35.00lbs 171
12 171
8.00lbs 138
12.00lbs 138
20.00lbs 138
50.00lbs 135
5.00lbs 115
15.00lbs 109
25.00lbs 105
6 102
7.00lbs 97
55.00lbs 91
14.00lbs 88
55 81
14 80
9.00lbs 78
60.00lbs 77
Labrador Retriever 76
6.00lbs 76
9 75
17 75
13 73
60 72
18 69
7 66
5 66
11 63
13.00lbs 53
11.00lbs 52
18.00lbs 51
22 47
Shepherd 46
33.00lbs 45
38.00lbs 42
24 41
42.00lbs 40
48.00lbs 40
42 40
44.00lbs 39
23.00lbs 39
19 39
34.00lbs 38
43.00lbs 37
65 37
16.00lbs 37
4 37
32 36
26 35
17.00lbs 34
16 34
28 34
32.00lbs 33
39.00lbs 33
28.00lbs 33
29.00lbs 32
70 32
38 32
65.00lbs 31
41.00lbs 31
22.00lbs 31
27 31
23 31
70.00lbs 30
10 lbs 30
33 30
8/10/2021 29
10/12/2021 29
27.00lbs 29
37 29
40 lbs 28
24.00lbs 28
34 28
36.00lbs 26
47 26
21 26
48 25
44 25
46.00lbs 24
26.00lbs 24
52.00lbs 24
57.00lbs 24
37.00lbs 24
21.00lbs 24
47.00lbs 23
43 23
29 23
35 lbs 22
4.00lbs 22
52 22
46 22
31.00lbs 21
3.00lbs 21
49.00lbs 20
6.50lbs 20
39 20
36 20
56.00lbs 19
12 lbs 19
55 lbs 18
19.00lbs 18
62.00lbs 17
50 lbs 17
41 17
31 16
5/6/2021 15
8 lbs 15
53.00lbs 15
57 15
58.00lbs 14
30 lbs 14
45-50 14
45 lbs 14
30-35 14
20 lbs 14
49 14
61.00lbs 13
54.00lbs 13
51.00lbs 13
54 13
56 13
80.00lbs 12
12/15/2021 12
25-30 12
51 12
58 12
15 lbs 12
5 lbs 11
25 lbs 11
45 - 50 11
35-40 11
2.00lbs 11
14 lbs 11
75 11
62 11
80 11
7 lbs 10
7/9/2021 10
8/10/2018 10
40-45 10
7.5 10
75.00lbs 9
68.00lbs 9
3-5.00lbs 9
3 9
Chocolate Labrador 8
60 lbs 8
9/10/2021 8
Retriever 8
6/10/2021 8
64.00lbs 8
6-7.00lbs 8
Terrier 8
Mastiff 8
10/13/2021 8
90.00lbs 8
4 lbs 8
3.50lbs 8
40 - 45 8
20-25 8
53 8
8.4 8
10.5 8
Pointer 7
Labrador Retriever, Beagle 7
8.00-9.00lbs 7
Labrador Retriever, Pointer 7
3/6/2021 7
Male 7
Chihuahua 7
30 - 35 7
6.80lbs 7
35 - 40 7
4.5 - 7 7
18 lbs 7
15-20 7
8.5 7
13.5 7
12.5 7
8.2 7
7.2 7
67.00lbs 6
Beagle 6
6/8/2021 6
Hound 6
8lbs 6
9.20lbs 6
6-7lbs as of 9/14 6
Dachshund 6
Shepherd, Retriever 6
7.40lbs 6
8.50lbs 6
5/6/2017 6
9.80lbs 6
37 lbs 6
59.00lbs 6
5.40lbs 6
4.5-7.4lbs 6
50-55 6
11 lbs 6
68 6
2.5 - 3.5 6
20 - 25 6
10-12.00lbs 6
63 6
7.5-10 5
9 lbs 5
8.10lbs 5
63.00lbs 5
Shepherd, Terrier 5
7/10/2021 5
8-9lbs 5
9.40lbs 5
5.50lbs 5
4.60lbs 5
28 lbs 5
3.4-4.5 5
4.50lbs 5
33 lbs 5
6 lbs 5
6.20lbs 5
25 - 30 5
42 lbs 5
67 5
90 5
2-3 lbs 5
72 5
2.5 - 3.25 5
13.50lbs 5
59 5
10.4 5
14.5 5
10.8 5
12.2 5
6.8 5
7.6 5
13.2 5
5.5 5
12.6 5
11.5 5
8/9/2021 4
71.00lbs 4
78.00lbs 4
American Staffordshire Terrier 4
Labrador, Terrier 4
6/7/2021 4
8.20lbs 4
8 to 10 4
9.60lbs 4
72.00lbs 4
85.00lbs 4
65 lbs 4
7-8 lbs 4
Australian Shepherd 4
5.5 - 8.5 4
52 lbs 4
5-10 pounds 4
43 lbs 4
47 lbs 4
27 lbs 4
36 lbs 4
39 lbs 4
41 lbs 4
100 4
10.00-12.00lbs 4
2.3 - 3.0 4
15 - 20 4
61 4
10.80lbs 4
- 4
13 - 15 4
13+ 4
17.60lbs 4
69 4
10-12lbs 4
23-27 4
18.40lbs 4
85 4
17.8 4
5.1 4
30.4 4
5.8 4
7.4 4
18.2 4
30.2 4
26.2 4
9.5 4
7.1 4
10.2 4
15.6 4
13.6 4
8.6 4
2 4
8.8 4
24.4 4
7.90lbs 3
76.00lbs 3
12/14/2014 3
69.00lbs 3
68 lbs 3
8.40lbs 3
Shepherd, Pointer 3
8.80lbs 3
73.00lbs 3
7.00-10.00lbs 3
8/11/2021 3
8--9.00lbs 3
7.60lbs 3
7.10lbs 3
70 lbs 3
9.50lbs 3
7/8/2014 3
9.90lbs 3
6/8/2017 3
Feist 3
66.00lbs 3
female 3
77.00lbs 3
Flat-coated Retriever 3
64 lbs 3
Golden Retriever 3
12/14/2021 3
Great Pyrenees 3
49 lbs 3
26 lbs 3
54 lbs 3
3.80lbs 3
6.5 lbs 3
38 lbs 3
5.10lbs 3
30-35 lbs 3
56 lbs 3
44 lbs 3
6 to 9 3
32 lbs 3
48 lbs 3
20-25lbs 3
12.90lbs 3
64 3
13.40lbs 3
20-24 3
71 3
12.60lbs 3
14 - 17 3
2.50lbs 3
76 3
12-15.00lbs 3
16 lbs 3
10.10lbs 3
61.2 3
20-30 3
11.80lbs 3
10.20lbs 3
5.2 3
37.6 3
9.8 3
8.3 3
22.6 3
15.5 3
6.4 3
26.6 3
21.8 3
14.2 3
16.4 3
19.2 3
10.6 3
28.5 3
6.2 3
28.6 3
9.6 3
19.5 3
36.8 3
29.6 3
37.2 3
19.8 3
37.8 3
6.5 3
10.3 3
20.2 3
16.5 3
2.3 3
2.5 3
9.2 3
11.2 3
32.6 3
11.8 3
9.4 3
16.2 3
15.4 3
20.6 3
86.00lbs 2
Miniature Pinscher, Chihuahua 2
Labrador Retriever, Shepherd 2
9.10lbs 2
72 lbs 2
7.14lbs 2
Husky, Shepherd 2
6lbs 2
Maltese 2
9.70lbs 2
65-70 2
8.60lbs 2
Terrier, Chihuahua 2
93.00lbs 2
60.60lbs 2
Beagle, Pug 2
Jack Russell Terrier 2
Boston Terrier 2
Labrador Retriever, Terrier 2
Boxer 2
Maltese, Poodle 2
Bulldog 2
Plott Hound 2
Chesapeake Bay Retriever 2
Puggle 2
8.14lbs 2
Shepherd, Wire-haired Terrier 2
81.00lbs 2
Wire-Haired Terrier 2
69 lbs 2
88.00lbs 2
82.00lbs 2
Husky 2
7.12lbs 2
50-60 2
36.60lbs 2
53 lbs 2
32 - 35 2
4.80lbs 2
3.90lbs 2
34.50lbs 2
3.60lbs 2
4.30lbs 2
45.80lbs 2
57 lbs 2
3.10lbs 2
4.98lbs 2
47.40lbs 2
51 lbs 2
39.60lbs 2
51.60lbs 2
28 - 29 2
3.20lbs 2
39.80lbs 2
55 - 60 2
30.80lbs 2
30lbs 2
5.20lbs 2
58 lbs 2
34 lbs 2
6.40lbs 2
50 - 60 2
25lbs 2
46 lbs 2
12.80lbs 2
54.8 2
20lbs 2
83 2
66 2
13.20lbs 2
15 pounds 2
10.50lbs 2
18-20 2
23.20lbs 2
19.60lbs 2
10.60lbs 2
54.6 2
17 lbs 2
10.9 lbs 2
11.20lbs 2
11.10lbs 2
17.20lbs 2
18.60lbs 2
17.40lbs 2
19 lbs 2
17.50lbs 2
19.40lbs 2
21 lbs 2
12.5 g 2
21.40lbs 2
12.70lbs 2
50.6 2
14.80lbs 2
52.2 2
11.05lbs 2
86 2
20.60lbs 2
18.00-20.00lbs 2
15.00-20.00lbs 2
73 2
15.20lbs 2
18.20lbs 2
15.80lbs 2
10-12 lbs 2
11.60lbs 2
22 lbs 2
17-20 2
23 - 25 2
18 - 19 2
24 lbs 2
18 - 20 2
23.60lbs 2
16.50lbs 2
16.80lbs 2
14.20lbs 2
13 lbs 2
13.80lbs 2
6.1 2
5.6 2
43.5 2
4.7 2
34.2 2
4.8 2
39.4 2
11.4 2
4.4 2
21.4 2
32.8 2
21.5 2
35.7 2
22.4 2
4.2 2
22.8 2
40.4 2
7.8 2
17.2 2
23.4 2
47.6 2
23.5 2
29.8 2
23.6 2
14.8 2
24.2 2
34.8 2
3.2 2
15.2 2
24.6 2
15.8 2
24.8 2
38.9 2
12.4 2
40.2 2
25.4 2
41.8 2
25.6 2
43.7 2
12.8 2
17.6 2
3.5 2
47.2 2
5.4 2
18.5 2
28.4 2
31.2 2
Pomeranian 1
73 lbs 1
St. Bernard 1
Border Collie 1
Beagle, Rat Terrier 1
7.20lbs 1
71 lbs 1
Boston Terrier, Shepherd 1
Bassett Hound, Wire-Haired Terrier 1
9.02lbs 1
7/8/2021 1
7.21lbs 1
o 1
Bulldog, Terrier 1
Retriever, Shepherd 1
Catahoula Leopard Dog 1
Australian Shepherd, Spaniel, Dachshund 1
Cattle Dog 1
weeks 1
9.11lbs 1
6/8/2014 1
7.50lbs 1
89 lbs 1
Chihuahua, Feist 1
9.0lbs 1
Chihuauha 1
Miniature Pinscher, Terrier 1
65.80lbs 1
Airedale Terrier 1
Cocker Spaniel 1
7.5 lbs 1
7.5lbs 1
Schnauzer, Wire-Haired Terrier 1
Dachshund, Chihuahua 1
85 - 90 1
Dachshund, Terrier 1
Shih Tzu 1
English Bulldog, Boston Terrier 1
Bassett Hound mix 1
Fawn 1
Whippet, Terrier, Labrador Retriever 1
8.70lbs 1
10/12/2013 1
9.7lbs 1
7/9/2014 1
8.90lbs 1
Beagle, Hound 1
German Shepherd 1
89.00lbs 1
Golden 1
63 lbs 1
62 lbs 1
8.2 lbs 1
Golden Retriever, Basset Hound 1
Airdale Terrier 1
9.8 lbs 1
n 1
7.3lbs 1
over 100 1
8.12lbs 1
7.40lbs (update) 1
9.8lbs 1
Pug 1
Hound, Pointer 1
70.50lbs 1
Hound, Shepherd 1
RUNT 1
9.14lbs 1
Sheltie, Shepherd 1
90 - 100 1
Shepherd, Labrador Retriever 1
65.00llbs 1
65-70.00lbs 1
Labrador 1
bandit 1
Labrador mix 1
Spaniel 1
10/11/2021 1
66 lbs 1
61lbs 1
Terrier, Pointer 1
10/15/2021 1
Whippet, Shepherd 1
12/10/2021 1
Wire Haired Terrier 1
Labrador Retriever, Border Collie 1
4/6/2013 1
Labrador Retriever, Cattle Dog 1
10/15/2013 1
Labrador Retriever, Flat-coated Retriever 1
8.30lbs 1
Labrador Retriever, Hound 1
7.50lbs 1
7.82lbs 1
87.00lbs 1
91.00lbs 1
74.00lbs 1
9.2 lbs 1
76 lbs 1
Labrador, Heeler 1
8.36lbs 1
83.00lbs 1
67 lbs 1
7.9lbs 1
78.14lbs 1
95.00lbs 1
61 lbs 1
97.00lbs 1
10/10/2021 1
Maltese, Terrier 1
84.00lbs 1
Labrador Retreiver 1
10/14/2021 1
7.70lbs 1
11/10/2021 1
Labrador Retriever, Basset Hound 1
7.13lbs 1
7.80lbs 1
12/18/2021 1
Great Pyrenees, Golden Retriever 1
8.13lbs 1
Heeler, Pointer 1
36.40lbs 1
53.20 lbs 1
5.9lbs 1
40 - 50 1
35.20lbs 1
31.00-35.00lbs 1
5.55lbs 1
26.45lbs 1
4.16lbs 1
40.14lbs 1
3 lbs 1
40.40lbs 1
29.10lbs 1
40.60lbs 1
5.45lbs 1
3 years 1
5.80lbs 1
40-45 lbs 1
28.00lbls 1
40-50 1
52.00 lbs 1
40-50 lbs 1
30? 1
31.10lbs 1
37.00 lbs 1
6.81lbs 1
4.70lbs 1
60 - 65 1
6.4lbs 1
28.80lbs 1
5.3lbs 1
41.20lbs 1
39.68lbs 1
31.30lbs 1
5.70lbs 1
26.70lbs 1
5.90lbs 1
42.20lbs 1
35-45 1
42.80lbs 1
36.80lbs 1
31.75lbs 1
34.70lbs 1
43.00 lbs 1
36.82lbs 1
37.7 lbs 1
4.40lbs 1
43.40lbs 1
55.00bs 1
43.60lbs 1
56.2 lbs 1
37.80lbs 1
57.80lbs 1
44.00 lbs 1
35.60 lbs 1
37.92lbs 1
6.10lbs 1
44.10lbs 1
6.30lbs 1
44.60lbs 1
31 lbs 1
25.80lbs 1
5.34lbs 1
32.20lbs 1
33.50lbs 1
45.00lb 1
33.60 lbs 1
27.40lbs 1
5.54lbs 1
45.14lbs 1
5.5-8.5 1
45.20lbs 1
5.72lbs 1
45.64lbs 1
5.83lbs 1
36.16lbs 1
5.98lbs 1
32.40lbs 1
50 - 55 1
45-50 lbs 1
30.60lbs 1
35-40 lbs 1
34.20lbs 1
6.60lbs 1
4.10lbs 1
6.80 lbs 1
4.20lbs 1
25.30lbs 1
34.80lbs 1
29.70lbs 1
35 - 37 1
47.20lbs 1
4.34lbs 1
38.80lbs 1
53.60lbs 1
47.50lbs 1
3.40lbs 1
47.60lbs 1
35.00-40.00lbs 1
25.60lbs 1
25.10lbs 1
26.20lbs 1
36.10lbs 1
48.90 lbs 1
56.20lbs 1
39.12lbs 1
29.00lbs a/o 10/16 1
33.07lbs 1
4.6lbs 1
49.80lbs 1
58.40lbs 1
4lbs 7oz as of 9/2/2021 1
35.70lbs 1
33.20 lbs 1
28.70lbs 1
5.00-6.00lbs 1
6.12lbs 1
33.20lbs 1
6.26lbs 1
39.16lbs 1
29.20lbs 1
5.11lbs 1
37.48lbs 1
5.13lbs 1
5.2 lbs 1
6.70lbs 1
32.60 lbs 1
35-40.00lbs 1
46.60lbs 1
6.9lbs 1
26.60lbs 1
60 - 70 1
41.10 lbs 1
41.12lbs 1
12.40lbs 1
1.48lbs A/O 6/3 1
2.90lbs 1
14.10lbs 1
23 lbs 1
10.3lbs 1
2.11lbs 1
14.4 lbs 1
20.4 lbs 1
14.40lbs 1
21-30 1
14.5 lbs 1
71.6 1
14.50lbs 1
12.50lbs 1
14.60lbs 1
12.8 g 1
10.40lbs 1
20 pounds 1
14.90 g 1
13 - 10 1
14.90lbs 1
21.20lbs 1
15 - 18 1
22.50lbs 1
72.8 1
13-15.00lbs 1
55.8 1
24.80lbs 1
10.70lbs 1
19.20lbs 1
15.00 lbs 1
67.2 1
10.80 lbs 1
12.7 g 1
74 1
95 1
63.4 1
99 1
15.40lbs 1
20.00ls 1
15.50lbs 1
20.80lbs 1
10.90lbs 1
120 1
15.87lbs 1
51.2 1
15.8lbs 1
21.80lbs 1
15-18 1
70.8 1
100.00lbs 1
22.70lbs 1
51.5 1
52.4 1
76.6 1
136.00lbs 1
16.11lbs 1
55.6 1
16.20lbs 1
10.30lbs 1
16.30lbs 1
19.10lbs 1
77 1
89 1
16.60lbs 1
19lbs 1
77.6 1
2.10lbs A/O 6/3 1
78 1
2.20lbs 1
53.6 1
92 1
17.11lbs 1
2.5 lbs 1
81 1
2.70lbs 1
17.30lbs 1
2.90lbs A/O 6/3 1
11.12lbs 1
12.9lbs 1
11.16lbs 1
120 lbs 1
82 1
20.20lbs 1
17.70lbs 1
51.6 1
17.90lbs 1
12lbs 1
17-18 1
107 1
11.50lbs 1
50.8 1
11.6 g 1
21.00bls 1
11.6 lbs 1
21.10lbs 1
18 .00lbs 1
13.5 g 1
65.6 1
21.8lbs 1
11.8 lbs 1
13.50 g 1
57.6 1
22.30lbs 1
11.8bs 1
22.60lbs 1
18.30lbs 1
13.60 g 1
11.90lbs 1
49.6 1
53.9 1
23.10lbs 1
18.73lbs 1
23.40lbs 1
18.80lbs 1
14 - 10 1
12.00 lbs 1
24.00bs 1
18-22 1
24.60lbs 1
18-25 1
24lbs 1
18lbs 1
87 1
39.8 1
49.5 1
44.5 1
21.9 1
23.8 1
26.8 1
16.8 1
11.7 1
47.5 1
27.2 1
6.3 1
27.4 1
12.1 1
27.6 1
40.6 1
22.2 1
43.4 1
22.3 1
21.6 1
13.3 1
48.2 1
13.4 1
20.4 1
28.8 1
37.7 1
3.6 1
38.4 1
29.2 1
24.1 1
29.4 1
20.8 1
18.8 1
41.4 1
29.7 1
42.4 1
2.4 1
11.1 1
13.7 1
45.2 1
13.8 1
11.6 1
5.7 1
47.8 1
30.6 1
26.1 1
30.8 1
36.4 1
1.3 1
4.11 1
18.6 1
1.2 1
31.5 1
9.9 1
31.8 1
38.2 1
14.4 1
38.6 1
5.9 1
10.1 1
22.7 1
39.6 1
14.6 1
4.3 1
33.1 1
24.3 1
33.2 1
16.6 1
33.4 1
4.9 1
33.6 1
42.2 1
11.3 1
6.7 1
20.1 1
21.3 1
34.5 1
19.6 1
34.6 1
25.1 1
23.2 1
45.8 1
4.1 1
4.5 1
35.2 1
47.4 1
35.5 1
8.1 1
35.6 1
4.6 1
23.3 1
48.5 1
35.8 1
49.2 1
7.3 1
5.15 1
36.2 1
Grand Total 10489
jschulberg commented 2 years ago

@jschulberg to address why there are some dates in the WEIGHT column.

Example: ID #FLRN-MD-18-0166