How many parts are defective?

Already run for you

import io
import pandas as pd

readings = pd.read_csv(io.StringIO("""reading_id,temperature_c,vibration_mm_s,pressure_bar,rpm,defective
1,91.3,3.1,5.8,1588,Yes
2,73.1,3.8,5.8,1448,No
3,61.2,0.2,5.5,1480,Yes
4,75.5,3.7,5.7,1415,No
5,75.7,4.4,6.8,1467,No
6,70.1,4.2,5.5,1364,No
7,62.7,3.6,5.5,1376,No
8,75.6,2.4,6.6,1489,No
9,75.6,3.2,5.3,1475,No
10,68.9,2.6,5.1,1521,No
11,58.1,3.8,6.2,1637,Yes
12,70.8,3.8,7.2,1372,No
13,65.5,3.1,5.5,1511,No
14,69.8,4,5.8,1423,No
15,79,3,7.3,1514,No
16,81.7,4.9,6.7,1249,No
17,71,5.2,6.3,1424,No
18,81.9,4.2,5.5,1605,No
19,79,0.9,5,1753,No
20,77,3.1,5.2,1559,No
21,75.1,2.5,7.9,1455,No
22,82.3,3.9,6.6,1531,No
23,71.3,2.1,4.5,1656,No
24,76.6,0.7,6.4,1542,No
25,85.8,3.9,5.7,1424,No
26,89.2,4.9,6.2,1662,Yes
27,90.3,1.4,5.9,1439,Yes
28,75,3.4,6.5,1566,No
29,73.6,2.2,7.1,1503,No
30,88.3,1.8,6.7,1509,No
31,88.2,2.9,4.7,1527,No
32,84.8,4.4,6.4,1656,No
33,44.4,5.8,5.4,1492,Yes
34,72.2,1.9,5.8,1604,No
35,75.5,1,6.5,1551,No
36,78.5,3.5,4.3,1621,No
37,89.8,3,7.1,1744,No
38,73.6,0.5,6.2,1393,Yes
39,79,4.9,5.2,1773,No
40,85.9,4.3,4.5,1774,No
41,73.5,1.7,7.1,1491,No
42,62.4,3.8,6.7,1323,No
43,88.4,3.4,5.4,1577,No
44,74.1,4.2,6.7,1394,No
45,93.1,2.3,6.5,1471,Yes
46,64,2.5,6.7,1254,No
47,72.2,2.8,6.3,1306,No
48,55.9,3.8,6.6,1347,Yes
49,76,1,6.8,1425,No
50,85.6,2.3,6.7,1321,No
51,68.2,1.8,5.5,1520,No
52,78.4,4,6.1,1671,No
53,78.6,2.3,3.1,1524,No
54,85.1,3.3,6,1576,No
55,69.7,2,6.6,1582,No
56,76.1,0.3,6.1,1366,Yes
57,77.7,4.4,6.6,1471,No
58,90.4,5.7,6.1,1701,Yes
59,78.1,3.8,6.3,1481,No
60,80.1,3.1,5.4,1623,No
61,64.7,2.2,4.7,1495,No
62,92.3,5.8,6.9,1423,Yes
63,60.1,1,5.6,1556,Yes
64,75.5,1.5,6.7,1583,No
65,72.1,3.1,4.4,1411,No
66,66.1,0.9,3.9,1298,Yes
67,65,1.5,5.7,1595,No
68,71.7,3.1,5.2,1460,No
69,75.9,3.5,7.3,1359,No
70,70.8,4.1,6.2,1565,No
71,76.8,2.9,6.2,1635,No
72,72,1.6,4.7,1450,No
73,66.4,4,7.3,1547,No
74,95.5,0.4,7.6,1483,Yes
75,67.9,2.5,5.9,1397,No
76,72.9,1.7,6.6,1466,No
77,75.6,1.8,7.1,1718,No
78,79.1,2.1,7.1,1386,No
79,76.2,2.4,6.6,1505,No
80,97.6,2.3,6.6,1422,Yes
81,85.2,1.5,5.9,1380,No
82,76,1.8,6.4,1507,No
83,83.7,1.9,5.9,1472,No
84,82.4,2.6,4.5,1571,No
85,72.5,2.4,6,1373,No
86,76.5,3.8,4.2,1572,No
87,77.9,3.6,4.9,1515,No
88,63,2.8,5.2,1537,No
89,89,3.9,5,1597,No
90,87.2,2,5.9,1523,No
91,91.2,3.3,6.2,1767,Yes
92,73.1,7,6.3,1311,Yes
93,63.5,3.9,6.4,1612,No
94,74.3,4,6.9,1641,No
95,89.5,1.8,5.4,1507,Yes
96,85,0.8,6.4,1509,Yes
97,88.4,3.6,6.3,1458,No
98,72.6,7,5.7,1364,Yes
99,69.4,2,5.3,1307,No
100,74.4,1.5,6.2,1522,No
101,90.6,3.6,5.8,1592,No
102,80.4,1.4,5.2,1509,No
103,83.2,2.4,6.3,1604,No
104,71.5,0.6,5.7,1349,No
105,61.4,2.7,7.1,1190,No
106,71,1.7,5.8,1592,No
107,59,1.3,6.4,1369,Yes
108,71.8,1.3,5.9,1529,No
109,76.4,4.5,4.4,1447,No
110,60.3,0.5,6.5,1604,Yes
111,72.7,1.9,6.5,1862,No
112,84.3,2.8,7.2,1521,No
113,71.4,2.8,8,1542,No
114,82.4,5,6.5,1668,No
115,66.4,3.2,6,1371,No
116,58.7,5.1,5.6,1570,Yes
117,79.7,2.7,6.9,1429,No
118,78.1,3.8,4.2,1558,No
119,72.5,3.4,6.8,1513,No
120,77.1,3.1,8.1,1627,No
121,69.4,4.6,6.3,1456,No
122,74,5.4,6.7,1700,No
123,62.7,4.7,5.9,1627,Yes
124,65.3,0.7,5.5,1513,Yes
125,77.2,2.5,6.2,1550,No
126,64.9,4.2,6.5,1541,No
127,76,3.7,7.2,1542,No
128,80,2.9,6.3,1505,No
129,83.9,3.6,7.9,1428,No
130,78.3,4.1,6.2,1350,No
131,64.7,4.1,6.2,1631,No
132,83.8,2.1,5.6,1289,Yes
133,80.9,3,7.6,1444,No
134,73.1,1.5,7.7,1695,No
135,73.8,1.7,6.8,1489,No
136,83.3,3.1,5.2,1312,No
137,87.9,2.1,6.9,1433,No
138,73.1,2.6,4.8,1469,No
139,73.6,3.7,6.7,1369,No
140,69.6,3.6,6.6,1423,No
141,64.9,3,5.6,1680,No
142,83.1,3,6.5,1751,No
143,96.9,2.7,6.4,1463,Yes
144,79.9,2.7,6.5,1578,No
145,67.5,5.3,7,1724,Yes
146,83.5,3.9,5.6,1336,No
147,82.2,4.8,5,1510,No
148,73,5.1,6.3,1552,No
149,73.2,4.1,5.6,1431,No
150,76.8,4.2,4.7,1394,No
151,61.8,0.6,5,1470,Yes
152,72.3,4.2,5.7,1543,No
153,57.5,0.8,7.2,1572,Yes
154,76.5,3.3,7.1,1467,No
155,75.7,4.4,6.4,1682,No
156,69.6,1.5,4.3,1380,No
157,78,2.6,6.9,1411,No
158,59.2,5.4,6.9,1527,Yes
159,81.7,0.2,5.6,1412,No
160,86.1,4.8,6.6,1747,No
161,89.6,2,7.3,1413,No
162,70,2.7,5.9,1412,No
163,75.3,5,5.5,1529,No
164,71.9,5.4,6.5,1439,No
165,77.3,2.1,4.9,1308,No
166,82.8,4.9,6.3,1543,No
167,76.5,0.9,5.9,1615,Yes
168,82.3,4.7,6.2,1558,No
169,74.5,3.8,5.4,1415,No
170,65.8,1,6.7,1570,No
171,78,3,8.2,1428,No
172,69.9,3.2,4.6,1703,No
173,64.8,7.2,4.1,1616,Yes
174,63.4,1.3,5.3,1429,No
175,69.5,5.1,5.2,1517,No
176,76.6,2.3,7,1704,No
177,82.1,1.9,6.5,1566,No
178,78.1,3.4,5.8,1404,No
179,49.6,2.1,6.2,1462,Yes
180,83.7,1.6,7.6,1500,No
181,80.1,1.9,6.3,1687,No
182,68.7,4.6,7.3,1437,No
183,64.2,3.1,4.9,1566,No
184,73.9,2.6,5.9,1360,No
185,67.9,3.6,5.1,1618,No
186,102.9,2.2,5.8,1455,Yes
187,73,4.6,6.2,1546,No
188,69.3,3.8,6.8,1579,No
189,69,3.3,5.6,1393,No
190,75.6,0.2,7.7,1541,Yes
191,68.1,4.8,5.3,1512,Yes
192,80.1,1.2,5.1,1701,No
193,65.5,1.5,7.6,1539,No
194,74.7,4.5,7.8,1470,No
195,74.6,5.1,5.7,1718,No
196,75,3.8,6.5,1371,No
197,67.2,2.3,4.9,1381,No
198,84.2,2.3,7.1,1470,No
199,76.4,1.8,6.7,1610,No
200,55.9,3.7,4.6,1628,Yes
201,73,1.2,5.9,1468,No
202,56.9,3.6,5,1420,Yes
203,79.3,2.7,6.9,1598,No
204,87.2,2,6.2,1649,No
205,83.3,3.3,5.8,1776,No
206,90.8,0.7,7.4,1323,Yes
207,86.6,2.8,6.1,1439,No
208,64.2,1.7,6.3,1626,No
209,74.2,3.4,7.4,1526,No
210,89.9,5.4,5.3,1468,Yes
211,78.7,3,7,1407,No
212,98.1,3.8,5.6,1661,Yes
213,71.8,1.4,7.1,1564,No
214,79.6,4,6.7,1470,No
215,61.9,2.6,6,1689,No
216,84,5,6.9,1513,No
217,70.4,4.2,6.5,1455,No
218,77.4,4.6,4.9,1368,No
219,68.1,5.5,6.2,1589,Yes
220,69.7,0.4,7.1,1443,Yes
221,82.7,2.5,4.7,1696,No
222,76,3.2,5.1,1400,No
223,70.2,4.9,5.5,1533,No
224,58.9,3.9,6.2,1227,Yes
225,75,3.3,6.3,1414,No
226,69.8,1.9,6.1,1520,No
227,73.2,1.9,6.4,1712,No
228,69.4,1.8,6.7,1603,No
229,72.5,2.7,6.3,1630,No
230,72.7,2.5,5.6,1429,No
231,69.4,1.6,6.8,1481,Yes
232,65.6,3.2,5.1,1468,No
233,74,4.3,5.8,1439,No
234,67.5,3.5,5.4,1553,No
235,72.8,2.1,5.6,1342,No
236,76.2,6.2,6.2,1664,Yes
237,81.9,4.2,6.4,1442,No
238,78.5,2.6,6.4,1631,No
239,85.6,4.4,6.5,1516,No
240,80.1,1.5,5.5,1619,No
241,47.5,2.8,6.3,1171,Yes
242,69.3,1.5,5.5,1577,No
243,80.5,0.8,6.4,1574,No
244,75.1,2.4,7.2,1473,Yes
245,65.3,2,6.5,1608,No
246,83.7,1.6,6.3,1503,No
247,83.7,0.2,5.9,1436,Yes
248,69.5,4,6,1534,No
249,75.7,1.2,5.9,1523,No
250,77.3,2.3,7.3,1369,No
251,68.6,1.9,6.8,1578,No
252,69.5,0.2,6.9,1508,Yes
253,61.6,1.5,5.8,1534,Yes
254,75.4,2.5,5,1546,No
255,64.5,2.9,6,1359,No
256,80.6,4,6.6,1520,No
257,80.6,3.2,6.2,1310,No
258,77.1,1.9,5.3,1834,No
259,65.4,3.4,7,1550,No
260,70.5,2.6,7.6,1621,No
261,79.8,3.2,5.7,1446,No
262,73,1.5,4.5,1639,Yes
263,81.6,6.2,5.6,1523,Yes
264,87.5,0.2,7.3,1474,Yes
265,95.5,1.8,7.3,1371,Yes
266,78.3,4.1,5.2,1487,No
267,71.6,3.9,4.6,1488,No
268,101.6,1.8,5.5,1475,Yes
269,71,3.3,4.5,1502,No
270,60.6,2.9,4.3,1384,No
271,75.7,4.4,5.3,1826,No
272,65.9,3.8,6.9,1272,No
273,66,4.1,7.1,1365,No
274,76.4,4.6,5.5,1553,No
275,63.4,3.4,7,1642,No
276,74.5,4.5,5.3,1692,No
277,78.9,0.3,5.7,1455,Yes
278,69.2,2.5,6.5,1483,No
279,78.2,3.3,4.8,1633,No
280,80.2,2.8,5.3,1400,No
281,63,3.2,5.6,1632,No
282,81.6,2.9,5.5,1343,No
283,77.8,2,6.3,1677,No
284,72,2.4,6.2,1472,No
285,71.3,2.4,5,1682,No
286,75.4,3.8,5.3,1445,No
287,77.6,1.7,6.6,1454,No
288,86.1,4.3,6.6,1481,No
289,69.1,1.8,6.7,1853,No
290,71.3,4.3,6.5,1387,No
291,74,4.5,7.3,1425,No
292,53.9,3.7,4.7,1469,Yes
293,73.4,2.4,6.9,1471,No
294,75.3,3.6,5.9,1540,No
295,73.2,4.3,5.2,1565,No
296,64.7,2,6.7,1410,No
297,79.2,7,4.3,1589,Yes
298,79.2,3.2,6.1,1567,No
299,69.4,3.6,6.6,1456,Yes
300,80.9,1.9,6,1202,No
301,65,2.4,3.2,1616,No
302,80.3,2.6,6.8,1443,No
303,74,4.1,5.5,1483,No
304,85.7,5.4,7.5,1516,Yes
305,79.1,1.8,5.1,1357,No
306,95.6,4.5,4.8,1607,Yes
307,71,4,6.9,1352,No
308,81.1,3.7,6.5,1651,No
309,63.1,2.2,3,1662,No
310,81,3,5.5,1413,No
311,93.5,4,5.4,1700,Yes
312,86.2,0.9,7.8,1664,Yes
313,82.7,3.2,5.8,1297,No
314,66.9,2,4.9,1455,No
315,77.3,4.8,6.7,1567,No
316,77.7,1.9,7,1526,No
317,78.7,1.1,4.4,1521,No
318,69.9,3.8,6.2,1413,Yes
319,72.9,3.5,4.5,1452,No
320,63.7,2.2,6.4,1611,No"""))