{ "cells": [ { "cell_type": "markdown", "id": "6358e4f7", "metadata": {}, "source": [ "## Introduction" ] }, { "cell_type": "markdown", "id": "9951a94f", "metadata": {}, "source": [ "Let's start by loading *pandas*. To make sure that the data was successfully loaded, we will use the .head() function to visualize the headers and the first five observations.\n", "\n", "Don't worry about understanding what the different columns are telling us yet, because that's exactly what we will be doing in the following section." ] }, { "cell_type": "code", "execution_count": 1, "id": "d8e9c035", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "id": "89418f80", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 1 | \n", "1/1/2015 | \n", "Quarter1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.886500 | \n", "
| 2 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "968.0 | \n", "3660 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "30.5 | \n", "0.800570 | \n", "
| 3 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "12 | \n", "0.80 | \n", "11.41 | \n", "968.0 | \n", "3660 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "30.5 | \n", "0.800570 | \n", "
| 4 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "6 | \n", "0.80 | \n", "25.90 | \n", "1170.0 | \n", "1920 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800382 | \n", "
| \n", " | team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "1197.000000 | \n", "1197.000000 | \n", "1197.000000 | \n", "691.000000 | \n", "1197.000000 | \n", "1197.000000 | \n", "1197.000000 | \n", "1197.000000 | \n", "1197.000000 | \n", "1197.000000 | \n", "1197.000000 | \n", "
| mean | \n", "6.426901 | \n", "0.729632 | \n", "15.062172 | \n", "1190.465991 | \n", "4567.460317 | \n", "38.210526 | \n", "0.730159 | \n", "0.369256 | \n", "0.150376 | \n", "34.609858 | \n", "0.735091 | \n", "
| std | \n", "3.463963 | \n", "0.097891 | \n", "10.943219 | \n", "1837.455001 | \n", "3348.823563 | \n", "160.182643 | \n", "12.709757 | \n", "3.268987 | \n", "0.427848 | \n", "22.197687 | \n", "0.174488 | \n", "
| min | \n", "1.000000 | \n", "0.070000 | \n", "2.900000 | \n", "7.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "2.000000 | \n", "0.233705 | \n", "
| 25% | \n", "3.000000 | \n", "0.700000 | \n", "3.940000 | \n", "774.500000 | \n", "1440.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "9.000000 | \n", "0.650307 | \n", "
| 50% | \n", "6.000000 | \n", "0.750000 | \n", "15.260000 | \n", "1039.000000 | \n", "3960.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "34.000000 | \n", "0.773333 | \n", "
| 75% | \n", "9.000000 | \n", "0.800000 | \n", "24.260000 | \n", "1252.500000 | \n", "6960.000000 | \n", "50.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "57.000000 | \n", "0.850253 | \n", "
| max | \n", "12.000000 | \n", "0.800000 | \n", "54.560000 | \n", "23122.000000 | \n", "25920.000000 | \n", "3600.000000 | \n", "300.000000 | \n", "45.000000 | \n", "2.000000 | \n", "89.000000 | \n", "1.120437 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 498 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1416.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 499 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "4 | \n", "0.80 | \n", "4.30 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.989000 | \n", "
| 500 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "1287.0 | \n", "6840 | \n", "100 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.950186 | \n", "
| 501 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "4 | \n", "0.80 | \n", "22.52 | \n", "1444.0 | \n", "6900 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "0.900800 | \n", "
| 502 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "1088.0 | \n", "6720 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.900130 | \n", "
| 503 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "6 | \n", "0.50 | \n", "2.90 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.899000 | \n", "
| 504 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "8 | \n", "0.65 | \n", "4.15 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.877552 | \n", "
| 505 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "11 | \n", "0.60 | \n", "2.90 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.864583 | \n", "
| 506 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "10 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.856950 | \n", "
| 507 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.853667 | \n", "
| 508 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "22.94 | \n", "1579.0 | \n", "6960 | \n", "81 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "0.850362 | \n", "
| 509 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "9 | \n", "0.70 | \n", "29.12 | \n", "1170.0 | \n", "6960 | \n", "53 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "0.850170 | \n", "
| 510 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "5 | \n", "0.65 | \n", "20.79 | \n", "1015.0 | \n", "7080 | \n", "81 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.800474 | \n", "
| 511 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.773333 | \n", "
| 512 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "12 | \n", "0.75 | \n", "15.26 | \n", "1436.0 | \n", "4200 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "35.0 | \n", "0.750647 | \n", "
| 513 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "12 | \n", "0.75 | \n", "4.08 | \n", "NaN | \n", "1080 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "9.0 | \n", "0.634667 | \n", "
| 514 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "11 | \n", "0.60 | \n", "20.10 | \n", "1601.0 | \n", "4320 | \n", "46 | \n", "0.0 | \n", "0 | \n", "0 | \n", "51.0 | \n", "0.600598 | \n", "
| 515 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "6 | \n", "0.50 | \n", "18.79 | \n", "717.0 | \n", "3960 | \n", "23 | \n", "0.0 | \n", "0 | \n", "0 | \n", "33.0 | \n", "0.500118 | \n", "
| 516 | \n", "1/29/2015 | \n", "Quarter5 | \n", "finishing | \n", "Thursday | \n", "3 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.492500 | \n", "
| 517 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "7 | \n", "0.65 | \n", "23.54 | \n", "830.0 | \n", "6600 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "55.0 | \n", "0.487920 | \n", "
| 518 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "1136.0 | \n", "6960 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "1.000457 | \n", "
| 519 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1397.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 520 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "2 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.971867 | \n", "
| 521 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "3 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.971867 | \n", "
| 522 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "4 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.971867 | \n", "
| 523 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "10 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.971867 | \n", "
| 524 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "1800 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "15.0 | \n", "0.971867 | \n", "
| 525 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "9 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "240 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "2.0 | \n", "0.971867 | \n", "
| 526 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "12 | \n", "0.75 | \n", "4.08 | \n", "NaN | \n", "1080 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "9.0 | \n", "0.971867 | \n", "
| 527 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "5 | \n", "0.70 | \n", "3.94 | \n", "NaN | \n", "240 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "2.0 | \n", "0.971867 | \n", "
| 528 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "7 | \n", "0.70 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.971867 | \n", "
| 529 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "8 | \n", "0.65 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.971867 | \n", "
| 530 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "11 | \n", "0.65 | \n", "3.94 | \n", "NaN | \n", "600 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "5.0 | \n", "0.971867 | \n", "
| 531 | \n", "1/31/2015 | \n", "Quarter5 | \n", "finishing | \n", "Saturday | \n", "6 | \n", "0.60 | \n", "3.94 | \n", "NaN | \n", "1200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.971867 | \n", "
| 532 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "1116.0 | \n", "6720 | \n", "93 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.920237 | \n", "
| 533 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "4 | \n", "0.80 | \n", "22.52 | \n", "1432.0 | \n", "6660 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "0.900537 | \n", "
| 534 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "9 | \n", "0.75 | \n", "29.12 | \n", "1082.0 | \n", "6840 | \n", "81 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.850611 | \n", "
| 535 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "1 | \n", "0.75 | \n", "22.94 | \n", "1502.0 | \n", "6960 | \n", "81 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "0.850362 | \n", "
| 536 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "12 | \n", "0.75 | \n", "15.26 | \n", "1209.0 | \n", "4200 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "35.0 | \n", "0.750647 | \n", "
| 537 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "5 | \n", "0.70 | \n", "50.89 | \n", "282.0 | \n", "5880 | \n", "56 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.656764 | \n", "
| 538 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "11 | \n", "0.65 | \n", "20.10 | \n", "1417.0 | \n", "6480 | \n", "49 | \n", "0.0 | \n", "0 | \n", "0 | \n", "54.0 | \n", "0.650148 | \n", "
| 539 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "6 | \n", "0.60 | \n", "18.79 | \n", "799.0 | \n", "3960 | \n", "23 | \n", "0.0 | \n", "0 | \n", "0 | \n", "33.0 | \n", "0.600711 | \n", "
| 540 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "7 | \n", "0.70 | \n", "23.54 | \n", "1109.0 | \n", "6720 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.388830 | \n", "
| 541 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "8 | \n", "0.50 | \n", "23.54 | \n", "1144.0 | \n", "6480 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "54.0 | \n", "0.286985 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 1 | \n", "1/1/2015 | \n", "Quarter1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.886500 | \n", "
| 2 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "968.0 | \n", "3660 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "30.5 | \n", "0.800570 | \n", "
| 3 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "12 | \n", "0.80 | \n", "11.41 | \n", "968.0 | \n", "3660 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "30.5 | \n", "0.800570 | \n", "
| 4 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "6 | \n", "0.80 | \n", "25.90 | \n", "1170.0 | \n", "1920 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800382 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1187 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "4 | \n", "0.75 | \n", "26.82 | \n", "1054.0 | \n", "7080 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.750051 | \n", "
| 1188 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.70 | \n", "26.82 | \n", "992.0 | \n", "6960 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.700557 | \n", "
| 1189 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "8 | \n", "0.70 | \n", "30.48 | \n", "914.0 | \n", "6840 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.700505 | \n", "
| 1190 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "6 | \n", "0.70 | \n", "23.41 | \n", "1128.0 | \n", "4560 | \n", "40 | \n", "0.0 | \n", "0 | \n", "1 | \n", "38.0 | \n", "0.700246 | \n", "
| 1191 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "7 | \n", "0.65 | \n", "30.48 | \n", "935.0 | \n", "6840 | \n", "26 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.650596 | \n", "
869 rows × 15 columns
\n", "| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 163 | \n", "1/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Saturday | \n", "10 | \n", "0.8 | \n", "28.08 | \n", "1082.0 | \n", "10530 | \n", "63 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "0.8 | \n", "
| 182 | \n", "1/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Sunday | \n", "2 | \n", "0.8 | \n", "28.08 | \n", "805.0 | \n", "10530 | \n", "63 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "0.8 | \n", "
| 183 | \n", "1/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Sunday | \n", "10 | \n", "0.8 | \n", "28.08 | \n", "762.0 | \n", "10530 | \n", "38 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "0.8 | \n", "
| 207 | \n", "1/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Monday | \n", "2 | \n", "0.8 | \n", "28.08 | \n", "737.0 | \n", "10530 | \n", "63 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "0.8 | \n", "
| 229 | \n", "1/13/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "2 | \n", "0.8 | \n", "28.08 | \n", "723.0 | \n", "10530 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "0.8 | \n", "
| 855 | \n", "2/19/2015 | \n", "Quarter3 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.7 | \n", "29.40 | \n", "1116.0 | \n", "6240 | \n", "0 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.7 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "10 | \n", "0.75 | \n", "19.31 | \n", "578.0 | \n", "6480 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "54.0 | \n", "0.712205 | \n", "
| 12 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "5 | \n", "0.80 | \n", "11.41 | \n", "668.0 | \n", "3660 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "30.5 | \n", "0.707046 | \n", "
| 14 | \n", "1/1/2015 | \n", "Quarter1 | \n", "finishing | \n", "Thursday | \n", "8 | \n", "0.75 | \n", "2.90 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.676667 | \n", "
| 15 | \n", "1/1/2015 | \n", "Quarter1 | \n", "finishing | \n", "Thursday | \n", "4 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "2160 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "18.0 | \n", "0.593056 | \n", "
| 16 | \n", "1/1/2015 | \n", "Quarter1 | \n", "finishing | \n", "Thursday | \n", "7 | \n", "0.80 | \n", "2.90 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.540729 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1192 | \n", "3/11/2015 | \n", "Quarter2 | \n", "finishing | \n", "Wednesday | \n", "10 | \n", "0.75 | \n", "2.90 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.628333 | \n", "
| 1193 | \n", "3/11/2015 | \n", "Quarter2 | \n", "finishing | \n", "Wednesday | \n", "8 | \n", "0.70 | \n", "3.90 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.625625 | \n", "
| 1194 | \n", "3/11/2015 | \n", "Quarter2 | \n", "finishing | \n", "Wednesday | \n", "7 | \n", "0.65 | \n", "3.90 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.625625 | \n", "
| 1195 | \n", "3/11/2015 | \n", "Quarter2 | \n", "finishing | \n", "Wednesday | \n", "9 | \n", "0.75 | \n", "2.90 | \n", "NaN | \n", "1800 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "15.0 | \n", "0.505889 | \n", "
| 1196 | \n", "3/11/2015 | \n", "Quarter2 | \n", "finishing | \n", "Wednesday | \n", "6 | \n", "0.70 | \n", "2.90 | \n", "NaN | \n", "720 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "6.0 | \n", "0.394722 | \n", "
322 rows × 15 columns
\n", "| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 337 | \n", "1/20/2015 | \n", "Quarter3 | \n", "finishing | \n", "Tuesday | \n", "5 | \n", "0.70 | \n", "4.15 | \n", "NaN | \n", "1440 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "1.033570 | \n", "
| 437 | \n", "1/26/2015 | \n", "Quarter4 | \n", "finishing | \n", "Monday | \n", "3 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "1800 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "1.059621 | \n", "
| 456 | \n", "1/27/2015 | \n", "Quarter4 | \n", "sweing | \n", "Tuesday | \n", "2 | \n", "0.75 | \n", "22.52 | \n", "1635.0 | \n", "6840 | \n", "119 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 457 | \n", "1/27/2015 | \n", "Quarter4 | \n", "sweing | \n", "Tuesday | \n", "3 | \n", "0.75 | \n", "22.52 | \n", "1299.0 | \n", "6840 | \n", "119 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 477 | \n", "1/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Wednesday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1559.0 | \n", "6840 | \n", "90 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 478 | \n", "1/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "1350.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 498 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1416.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 518 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "1136.0 | \n", "6960 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "1.000457 | \n", "
| 519 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1397.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 542 | \n", "2/1/2015 | \n", "Quarter1 | \n", "finishing | \n", "Sunday | \n", "8 | \n", "0.65 | \n", "4.15 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "1.011562 | \n", "
| 543 | \n", "2/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1396.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000671 | \n", "
| 544 | \n", "2/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "1 | \n", "0.80 | \n", "22.94 | \n", "1582.0 | \n", "3060 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "1.000402 | \n", "
| 561 | \n", "2/2/2015 | \n", "Quarter1 | \n", "sweing | \n", "Monday | \n", "1 | \n", "0.80 | \n", "22.94 | \n", "16882.0 | \n", "7020 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "1.000602 | \n", "
| 580 | \n", "2/3/2015 | \n", "Quarter1 | \n", "finishing | \n", "Tuesday | \n", "2 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "2400 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "20.0 | \n", "1.001417 | \n", "
| 581 | \n", "2/3/2015 | \n", "Quarter1 | \n", "sweing | \n", "Tuesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1500.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000019 | \n", "
| 599 | \n", "2/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1263.0 | \n", "6900 | \n", "100 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.050281 | \n", "
| 600 | \n", "2/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "968.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 618 | \n", "2/5/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1300.0 | \n", "6780 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.5 | \n", "1.000446 | \n", "
| 619 | \n", "2/5/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1485.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000019 | \n", "
| 636 | \n", "2/7/2015 | \n", "Quarter1 | \n", "finishing | \n", "Saturday | \n", "2 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "3000 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "25.0 | \n", "1.050667 | \n", "
| 637 | \n", "2/7/2015 | \n", "Quarter1 | \n", "sweing | \n", "Saturday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1186.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "1.000019 | \n", "
| 655 | \n", "2/8/2015 | \n", "Quarter2 | \n", "sweing | \n", "Sunday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1233.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000019 | \n", "
| 674 | \n", "2/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "2 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "2160 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "18.0 | \n", "1.057963 | \n", "
| 692 | \n", "2/10/2015 | \n", "Quarter2 | \n", "finishing | \n", "Tuesday | \n", "12 | \n", "0.80 | \n", "4.08 | \n", "NaN | \n", "1080 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "9.0 | \n", "1.004889 | \n", "
| 711 | \n", "2/11/2015 | \n", "Quarter2 | \n", "finishing | \n", "Wednesday | \n", "4 | \n", "0.70 | \n", "4.15 | \n", "NaN | \n", "1800 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "15.0 | \n", "1.033156 | \n", "
| 712 | \n", "2/11/2015 | \n", "Quarter2 | \n", "finishing | \n", "Wednesday | \n", "12 | \n", "0.80 | \n", "4.08 | \n", "NaN | \n", "1080 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "9.0 | \n", "1.020000 | \n", "
| 713 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1557.0 | \n", "0 | \n", "90 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000345 | \n", "
| 714 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1498.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000066 | \n", "
| 730 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1397.0 | \n", "0 | \n", "138 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.100484 | \n", "
| 731 | \n", "2/12/2015 | \n", "Quarter2 | \n", "finishing | \n", "Thursday | \n", "4 | \n", "0.70 | \n", "4.15 | \n", "NaN | \n", "1800 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "15.0 | \n", "1.096633 | \n", "
| 732 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1327.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000345 | \n", "
| 749 | \n", "2/14/2015 | \n", "Quarter2 | \n", "sweing | \n", "Saturday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1416.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 766 | \n", "2/15/2015 | \n", "Quarter3 | \n", "finishing | \n", "Sunday | \n", "1 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "1.120437 | \n", "
| 767 | \n", "2/15/2015 | \n", "Quarter3 | \n", "finishing | \n", "Sunday | \n", "2 | \n", "0.80 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "1.108125 | \n", "
| 768 | \n", "2/15/2015 | \n", "Quarter3 | \n", "sweing | \n", "Sunday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1420.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 785 | \n", "2/16/2015 | \n", "Quarter3 | \n", "sweing | \n", "Monday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1422.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 803 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1445.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 2 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "968.0 | \n", "3660 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "30.5 | \n", "0.800570 | \n", "
| 3 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "12 | \n", "0.80 | \n", "11.41 | \n", "968.0 | \n", "3660 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "30.5 | \n", "0.800570 | \n", "
| 4 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "6 | \n", "0.80 | \n", "25.90 | \n", "1170.0 | \n", "1920 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800382 | \n", "
| 5 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "7 | \n", "0.80 | \n", "25.90 | \n", "984.0 | \n", "6720 | \n", "38 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800125 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1187 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "4 | \n", "0.75 | \n", "26.82 | \n", "1054.0 | \n", "7080 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.750051 | \n", "
| 1188 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.70 | \n", "26.82 | \n", "992.0 | \n", "6960 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.700557 | \n", "
| 1189 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "8 | \n", "0.70 | \n", "30.48 | \n", "914.0 | \n", "6840 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.700505 | \n", "
| 1190 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "6 | \n", "0.70 | \n", "23.41 | \n", "1128.0 | \n", "4560 | \n", "40 | \n", "0.0 | \n", "0 | \n", "1 | \n", "38.0 | \n", "0.700246 | \n", "
| 1191 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "7 | \n", "0.65 | \n", "30.48 | \n", "935.0 | \n", "6840 | \n", "26 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.650596 | \n", "
691 rows × 15 columns
\n", "| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 5 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "7 | \n", "0.80 | \n", "25.90 | \n", "984.0 | \n", "6720 | \n", "38 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800125 | \n", "
| 7 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "3 | \n", "0.75 | \n", "28.08 | \n", "795.0 | \n", "6900 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "0.753683 | \n", "
| 8 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.75 | \n", "19.87 | \n", "733.0 | \n", "6000 | \n", "34 | \n", "0.0 | \n", "0 | \n", "0 | \n", "55.0 | \n", "0.753098 | \n", "
| 9 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "28.08 | \n", "681.0 | \n", "6900 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "0.750428 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1187 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "4 | \n", "0.75 | \n", "26.82 | \n", "1054.0 | \n", "7080 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.750051 | \n", "
| 1188 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.70 | \n", "26.82 | \n", "992.0 | \n", "6960 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.700557 | \n", "
| 1189 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "8 | \n", "0.70 | \n", "30.48 | \n", "914.0 | \n", "6840 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.700505 | \n", "
| 1190 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "6 | \n", "0.70 | \n", "23.41 | \n", "1128.0 | \n", "4560 | \n", "40 | \n", "0.0 | \n", "0 | \n", "1 | \n", "38.0 | \n", "0.700246 | \n", "
| 1191 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "7 | \n", "0.65 | \n", "30.48 | \n", "935.0 | \n", "6840 | \n", "26 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.650596 | \n", "
597 rows × 15 columns
\n", "| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 684 | \n", "2/9/2015 | \n", "Quarter2 | \n", "sweing | \n", "Monday | \n", "11 | \n", "0.75 | \n", "10.05 | \n", "103.0 | \n", "0 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "54.0 | \n", "0.750648 | \n", "
| 694 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "1268.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.900632 | \n", "
| 695 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1546.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.900471 | \n", "
| 696 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "813.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.900471 | \n", "
| 697 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1512.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.899984 | \n", "
| 713 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1557.0 | \n", "0 | \n", "90 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000345 | \n", "
| 714 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1498.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000066 | \n", "
| 718 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "598.0 | \n", "0 | \n", "75 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.850365 | \n", "
| 730 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1397.0 | \n", "0 | \n", "138 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.100484 | \n", "
| 732 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1327.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000345 | \n", "
| 790 | \n", "2/16/2015 | \n", "Quarter3 | \n", "sweing | \n", "Monday | \n", "5 | \n", "0.80 | \n", "30.10 | \n", "461.0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.800980 | \n", "
| 818 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "8 | \n", "0.60 | \n", "29.40 | \n", "179.0 | \n", "0 | \n", "23 | \n", "5.0 | \n", "30 | \n", "2 | \n", "58.0 | \n", "0.600983 | \n", "
| 822 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "10 | \n", "0.65 | \n", "18.22 | \n", "741.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "35 | \n", "1 | \n", "49.0 | \n", "0.302117 | \n", "
| 828 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.80 | \n", "30.10 | \n", "511.0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.800980 | \n", "
| 834 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.70 | \n", "30.10 | \n", "1057.0 | \n", "0 | \n", "40 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.700603 | \n", "
| 860 | \n", "2/19/2015 | \n", "Quarter3 | \n", "sweing | \n", "Thursday | \n", "7 | \n", "0.75 | \n", "30.10 | \n", "444.0 | \n", "0 | \n", "0 | \n", "5.0 | \n", "20 | \n", "1 | \n", "59.0 | \n", "0.611141 | \n", "
| 966 | \n", "2/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Saturday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "954.0 | \n", "0 | \n", "50 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.800779 | \n", "
| 996 | \n", "3/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "347.0 | \n", "0 | \n", "50 | \n", "4.0 | \n", "20 | \n", "0 | \n", "57.0 | \n", "0.682433 | \n", "
| 1011 | \n", "3/2/2015 | \n", "Quarter1 | \n", "sweing | \n", "Monday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "632.0 | \n", "0 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.800309 | \n", "
| 1027 | \n", "3/3/2015 | \n", "Quarter1 | \n", "sweing | \n", "Tuesday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "601.0 | \n", "0 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800702 | \n", "
| 1053 | \n", "3/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "433.0 | \n", "0 | \n", "38 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800702 | \n", "
| 1128 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "11 | \n", "0.80 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.960625 | \n", "
| 1129 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "12 | \n", "0.80 | \n", "4.60 | \n", "NaN | \n", "0 | \n", "1080 | \n", "0.0 | \n", "0 | \n", "0 | \n", "9.0 | \n", "0.902963 | \n", "
| 1130 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "5 | \n", "0.60 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "2880 | \n", "0.0 | \n", "0 | \n", "0 | \n", "12.0 | \n", "0.864343 | \n", "
| 1133 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "9 | \n", "0.75 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "3600 | \n", "0.0 | \n", "0 | \n", "0 | \n", "15.0 | \n", "0.841000 | \n", "
| 1137 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "3 | \n", "0.80 | \n", "4.60 | \n", "NaN | \n", "0 | \n", "1440 | \n", "0.0 | \n", "0 | \n", "0 | \n", "12.0 | \n", "0.795417 | \n", "
| 1138 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "4 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.795388 | \n", "
| 1139 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.794567 | \n", "
| 1143 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "2 | \n", "0.70 | \n", "3.90 | \n", "NaN | \n", "0 | \n", "1200 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.682500 | \n", "
| 1148 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "10 | \n", "0.70 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.477292 | \n", "
| 1149 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "8 | \n", "0.65 | \n", "3.90 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.264062 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 684 | \n", "2/9/2015 | \n", "Quarter2 | \n", "sweing | \n", "Monday | \n", "11 | \n", "0.75 | \n", "10.05 | \n", "103.0 | \n", "0 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "54.0 | \n", "0.750648 | \n", "
| 694 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "1268.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.900632 | \n", "
| 695 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1546.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.900471 | \n", "
| 696 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "813.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.900471 | \n", "
| 697 | \n", "2/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1512.0 | \n", "0 | \n", "88 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.899984 | \n", "
| 713 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1557.0 | \n", "0 | \n", "90 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000345 | \n", "
| 714 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1498.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000066 | \n", "
| 718 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "598.0 | \n", "0 | \n", "75 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.850365 | \n", "
| 730 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1397.0 | \n", "0 | \n", "138 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.100484 | \n", "
| 732 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1327.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000345 | \n", "
| 790 | \n", "2/16/2015 | \n", "Quarter3 | \n", "sweing | \n", "Monday | \n", "5 | \n", "0.80 | \n", "30.10 | \n", "461.0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.800980 | \n", "
| 818 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "8 | \n", "0.60 | \n", "29.40 | \n", "179.0 | \n", "0 | \n", "23 | \n", "5.0 | \n", "30 | \n", "2 | \n", "58.0 | \n", "0.600983 | \n", "
| 828 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.80 | \n", "30.10 | \n", "511.0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.800980 | \n", "
| 834 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.70 | \n", "30.10 | \n", "1057.0 | \n", "0 | \n", "40 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.700603 | \n", "
| 966 | \n", "2/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Saturday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "954.0 | \n", "0 | \n", "50 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.800779 | \n", "
| 1011 | \n", "3/2/2015 | \n", "Quarter1 | \n", "sweing | \n", "Monday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "632.0 | \n", "0 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "0.800309 | \n", "
| 1027 | \n", "3/3/2015 | \n", "Quarter1 | \n", "sweing | \n", "Tuesday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "601.0 | \n", "0 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800702 | \n", "
| 1053 | \n", "3/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "433.0 | \n", "0 | \n", "38 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.800702 | \n", "
| 1128 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "11 | \n", "0.80 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.960625 | \n", "
| 1129 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "12 | \n", "0.80 | \n", "4.60 | \n", "NaN | \n", "0 | \n", "1080 | \n", "0.0 | \n", "0 | \n", "0 | \n", "9.0 | \n", "0.902963 | \n", "
| 1130 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "5 | \n", "0.60 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "2880 | \n", "0.0 | \n", "0 | \n", "0 | \n", "12.0 | \n", "0.864343 | \n", "
| 1133 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "9 | \n", "0.75 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "3600 | \n", "0.0 | \n", "0 | \n", "0 | \n", "15.0 | \n", "0.841000 | \n", "
| 1138 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "4 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.795388 | \n", "
| 1139 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.794567 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 27 | \n", "1/3/2015 | \n", "Quarter1 | \n", "sweing | \n", "Saturday | \n", "12 | \n", "0.80 | \n", "26.16 | \n", "844.0 | \n", "7080 | \n", "63 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.800319 | \n", "
| 32 | \n", "1/3/2015 | \n", "Quarter1 | \n", "sweing | \n", "Saturday | \n", "10 | \n", "0.75 | \n", "19.31 | \n", "610.0 | \n", "6480 | \n", "56 | \n", "0.0 | \n", "0 | \n", "0 | \n", "54.0 | \n", "0.787300 | \n", "
| 45 | \n", "1/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "9 | \n", "0.80 | \n", "26.16 | \n", "1278.0 | \n", "7080 | \n", "60 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.850569 | \n", "
| 46 | \n", "1/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "7 | \n", "0.80 | \n", "25.90 | \n", "1227.0 | \n", "7020 | \n", "60 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.5 | \n", "0.850436 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1156 | \n", "3/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "4 | \n", "0.75 | \n", "26.82 | \n", "1104.0 | \n", "5880 | \n", "65 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.850084 | \n", "
| 1158 | \n", "3/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "12 | \n", "0.80 | \n", "15.26 | \n", "1069.0 | \n", "4080 | \n", "63 | \n", "0.0 | \n", "0 | \n", "0 | \n", "34.0 | \n", "0.800402 | \n", "
| 1159 | \n", "3/10/2015 | \n", "Quarter2 | \n", "sweing | \n", "Tuesday | \n", "3 | \n", "0.80 | \n", "30.10 | \n", "756.0 | \n", "6960 | \n", "63 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.800072 | \n", "
| 1178 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "12 | \n", "0.80 | \n", "15.26 | \n", "470.0 | \n", "4080 | \n", "63 | \n", "0.0 | \n", "0 | \n", "0 | \n", "34.0 | \n", "0.800402 | \n", "
| 1179 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.80 | \n", "30.10 | \n", "735.0 | \n", "6960 | \n", "63 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.800072 | \n", "
231 rows × 15 columns
\n", "| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 456 | \n", "1/27/2015 | \n", "Quarter4 | \n", "sweing | \n", "Tuesday | \n", "2 | \n", "0.75 | \n", "22.52 | \n", "1635.0 | \n", "6840 | \n", "119 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 457 | \n", "1/27/2015 | \n", "Quarter4 | \n", "sweing | \n", "Tuesday | \n", "3 | \n", "0.75 | \n", "22.52 | \n", "1299.0 | \n", "6840 | \n", "119 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 478 | \n", "1/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "1350.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 498 | \n", "1/29/2015 | \n", "Quarter5 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1416.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 518 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "1136.0 | \n", "6960 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "1.000457 | \n", "
| 519 | \n", "1/31/2015 | \n", "Quarter5 | \n", "sweing | \n", "Saturday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1397.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 543 | \n", "2/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1396.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000671 | \n", "
| 544 | \n", "2/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "1 | \n", "0.80 | \n", "22.94 | \n", "1582.0 | \n", "3060 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "1.000402 | \n", "
| 561 | \n", "2/2/2015 | \n", "Quarter1 | \n", "sweing | \n", "Monday | \n", "1 | \n", "0.80 | \n", "22.94 | \n", "16882.0 | \n", "7020 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.5 | \n", "1.000602 | \n", "
| 581 | \n", "2/3/2015 | \n", "Quarter1 | \n", "sweing | \n", "Tuesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1500.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000019 | \n", "
| 600 | \n", "2/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.80 | \n", "22.52 | \n", "968.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 601 | \n", "2/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "1108.0 | \n", "6720 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.999995 | \n", "
| 618 | \n", "2/5/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1300.0 | \n", "6780 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.5 | \n", "1.000446 | \n", "
| 619 | \n", "2/5/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1485.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000019 | \n", "
| 620 | \n", "2/5/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "10 | \n", "0.80 | \n", "22.52 | \n", "1039.0 | \n", "6720 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "56.0 | \n", "0.999995 | \n", "
| 637 | \n", "2/7/2015 | \n", "Quarter1 | \n", "sweing | \n", "Saturday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1186.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "1.000019 | \n", "
| 655 | \n", "2/8/2015 | \n", "Quarter2 | \n", "sweing | \n", "Sunday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1233.0 | \n", "6900 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000019 | \n", "
| 714 | \n", "2/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1498.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000066 | \n", "
| 730 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1397.0 | \n", "0 | \n", "138 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.100484 | \n", "
| 732 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "2 | \n", "0.80 | \n", "22.52 | \n", "1327.0 | \n", "0 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "1.000345 | \n", "
| 749 | \n", "2/14/2015 | \n", "Quarter2 | \n", "sweing | \n", "Saturday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1416.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 768 | \n", "2/15/2015 | \n", "Quarter3 | \n", "sweing | \n", "Sunday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1420.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 785 | \n", "2/16/2015 | \n", "Quarter3 | \n", "sweing | \n", "Monday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1422.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 803 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "1 | \n", "0.80 | \n", "22.52 | \n", "1445.0 | \n", "6840 | \n", "113 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.0 | \n", "1.000230 | \n", "
| 1128 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "11 | \n", "0.80 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.960625 | \n", "
| 1129 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "12 | \n", "0.80 | \n", "4.60 | \n", "NaN | \n", "0 | \n", "1080 | \n", "0.0 | \n", "0 | \n", "0 | \n", "9.0 | \n", "0.902963 | \n", "
| 1130 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "5 | \n", "0.60 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "2880 | \n", "0.0 | \n", "0 | \n", "0 | \n", "12.0 | \n", "0.864343 | \n", "
| 1133 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "9 | \n", "0.75 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "3600 | \n", "0.0 | \n", "0 | \n", "0 | \n", "15.0 | \n", "0.841000 | \n", "
| 1137 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "3 | \n", "0.80 | \n", "4.60 | \n", "NaN | \n", "0 | \n", "1440 | \n", "0.0 | \n", "0 | \n", "0 | \n", "12.0 | \n", "0.795417 | \n", "
| 1138 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "4 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.795388 | \n", "
| 1139 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.794567 | \n", "
| 1143 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "2 | \n", "0.70 | \n", "3.90 | \n", "NaN | \n", "0 | \n", "1200 | \n", "0.0 | \n", "0 | \n", "0 | \n", "10.0 | \n", "0.682500 | \n", "
| 1148 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "10 | \n", "0.70 | \n", "2.90 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.477292 | \n", "
| 1149 | \n", "3/9/2015 | \n", "Quarter2 | \n", "finishing | \n", "Monday | \n", "8 | \n", "0.65 | \n", "3.90 | \n", "NaN | \n", "0 | \n", "960 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.264062 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 615 | \n", "2/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.65 | \n", "30.10 | \n", "326.0 | \n", "5820 | \n", "0 | \n", "90.0 | \n", "10 | \n", "0 | \n", "58.5 | \n", "0.650835 | \n", "
| 617 | \n", "2/4/2015 | \n", "Quarter1 | \n", "sweing | \n", "Wednesday | \n", "4 | \n", "0.35 | \n", "30.10 | \n", "287.0 | \n", "6060 | \n", "23 | \n", "150.0 | \n", "15 | \n", "0 | \n", "55.5 | \n", "0.350706 | \n", "
| 650 | \n", "2/7/2015 | \n", "Quarter1 | \n", "sweing | \n", "Saturday | \n", "7 | \n", "0.70 | \n", "24.26 | \n", "658.0 | \n", "6960 | \n", "0 | \n", "270.0 | \n", "45 | \n", "0 | \n", "58.0 | \n", "0.662270 | \n", "
| 654 | \n", "2/7/2015 | \n", "Quarter1 | \n", "sweing | \n", "Saturday | \n", "8 | \n", "0.70 | \n", "24.26 | \n", "652.0 | \n", "6840 | \n", "0 | \n", "300.0 | \n", "37 | \n", "0 | \n", "57.0 | \n", "0.365319 | \n", "
| 775 | \n", "2/15/2015 | \n", "Quarter3 | \n", "sweing | \n", "Sunday | \n", "8 | \n", "0.70 | \n", "30.10 | \n", "507.0 | \n", "5880 | \n", "40 | \n", "2.0 | \n", "10 | \n", "1 | \n", "59.0 | \n", "0.700573 | \n", "
| 798 | \n", "2/16/2015 | \n", "Quarter3 | \n", "sweing | \n", "Monday | \n", "8 | \n", "0.70 | \n", "30.10 | \n", "7.0 | \n", "7080 | \n", "27 | \n", "2.0 | \n", "10 | \n", "2 | \n", "59.0 | \n", "0.621972 | \n", "
| 818 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "8 | \n", "0.60 | \n", "29.40 | \n", "179.0 | \n", "0 | \n", "23 | \n", "5.0 | \n", "30 | \n", "2 | \n", "58.0 | \n", "0.600983 | \n", "
| 822 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "10 | \n", "0.65 | \n", "18.22 | \n", "741.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "35 | \n", "1 | \n", "49.0 | \n", "0.302117 | \n", "
| 841 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "10 | \n", "0.70 | \n", "19.68 | \n", "1119.0 | \n", "5640 | \n", "0 | \n", "8.0 | \n", "35 | \n", "1 | \n", "47.0 | \n", "0.303574 | \n", "
| 843 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "8 | \n", "0.65 | \n", "29.40 | \n", "962.0 | \n", "4560 | \n", "0 | \n", "4.5 | \n", "30 | \n", "2 | \n", "57.0 | \n", "0.251399 | \n", "
| 848 | \n", "2/19/2015 | \n", "Quarter3 | \n", "sweing | \n", "Thursday | \n", "5 | \n", "0.80 | \n", "30.10 | \n", "276.0 | \n", "600 | \n", "63 | \n", "3.5 | \n", "15 | \n", "0 | \n", "59.5 | \n", "0.799983 | \n", "
| 860 | \n", "2/19/2015 | \n", "Quarter3 | \n", "sweing | \n", "Thursday | \n", "7 | \n", "0.75 | \n", "30.10 | \n", "444.0 | \n", "0 | \n", "0 | \n", "5.0 | \n", "20 | \n", "1 | \n", "59.0 | \n", "0.611141 | \n", "
| 880 | \n", "2/22/2015 | \n", "Quarter4 | \n", "sweing | \n", "Sunday | \n", "7 | \n", "0.75 | \n", "30.10 | \n", "627.0 | \n", "6960 | \n", "0 | \n", "3.5 | \n", "20 | \n", "1 | \n", "58.0 | \n", "0.393549 | \n", "
| 882 | \n", "2/22/2015 | \n", "Quarter4 | \n", "sweing | \n", "Sunday | \n", "5 | \n", "0.80 | \n", "30.10 | \n", "450.0 | \n", "5700 | \n", "0 | \n", "4.5 | \n", "25 | \n", "0 | \n", "60.0 | \n", "0.307501 | \n", "
| 996 | \n", "3/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "347.0 | \n", "0 | \n", "50 | \n", "4.0 | \n", "20 | \n", "0 | \n", "57.0 | \n", "0.682433 | \n", "
| 1001 | \n", "3/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Sunday | \n", "7 | \n", "0.80 | \n", "30.10 | \n", "934.0 | \n", "6960 | \n", "0 | \n", "3.5 | \n", "15 | \n", "0 | \n", "58.0 | \n", "0.579511 | \n", "
| 1046 | \n", "3/3/2015 | \n", "Quarter1 | \n", "sweing | \n", "Tuesday | \n", "2 | \n", "0.40 | \n", "15.28 | \n", "157.0 | \n", "5400 | \n", "0 | \n", "6.5 | \n", "30 | \n", "1 | \n", "45.0 | \n", "0.302770 | \n", "
| 1085 | \n", "3/5/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "7 | \n", "0.80 | \n", "30.10 | \n", "834.0 | \n", "1200 | \n", "0 | \n", "4.0 | \n", "40 | \n", "0 | \n", "59.0 | \n", "0.366054 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 634 | \n", "2/5/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "4 | \n", "0.50 | \n", "30.10 | \n", "417.0 | \n", "6360 | \n", "23 | \n", "0.0 | \n", "0 | \n", "1 | \n", "53.0 | \n", "0.500720 | \n", "
| 651 | \n", "2/7/2015 | \n", "Quarter1 | \n", "sweing | \n", "Saturday | \n", "4 | \n", "0.60 | \n", "30.10 | \n", "486.0 | \n", "6780 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.600224 | \n", "
| 671 | \n", "2/8/2015 | \n", "Quarter2 | \n", "sweing | \n", "Sunday | \n", "4 | \n", "0.65 | \n", "30.10 | \n", "712.0 | \n", "6780 | \n", "44 | \n", "0.0 | \n", "0 | \n", "1 | \n", "56.5 | \n", "0.568260 | \n", "
| 683 | \n", "2/9/2015 | \n", "Quarter2 | \n", "sweing | \n", "Monday | \n", "4 | \n", "0.70 | \n", "30.10 | \n", "767.0 | \n", "3300 | \n", "50 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.790003 | \n", "
| 689 | \n", "2/9/2015 | \n", "Quarter2 | \n", "sweing | \n", "Monday | \n", "7 | \n", "0.35 | \n", "30.10 | \n", "842.0 | \n", "6960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.350302 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1185 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "2 | \n", "0.75 | \n", "16.10 | \n", "971.0 | \n", "5400 | \n", "45 | \n", "0.0 | \n", "0 | \n", "1 | \n", "45.0 | \n", "0.750141 | \n", "
| 1188 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.70 | \n", "26.82 | \n", "992.0 | \n", "6960 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.700557 | \n", "
| 1189 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "8 | \n", "0.70 | \n", "30.48 | \n", "914.0 | \n", "6840 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.700505 | \n", "
| 1190 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "6 | \n", "0.70 | \n", "23.41 | \n", "1128.0 | \n", "4560 | \n", "40 | \n", "0.0 | \n", "0 | \n", "1 | \n", "38.0 | \n", "0.700246 | \n", "
| 1191 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "7 | \n", "0.65 | \n", "30.48 | \n", "935.0 | \n", "6840 | \n", "26 | \n", "0.0 | \n", "0 | \n", "1 | \n", "57.0 | \n", "0.650596 | \n", "
114 rows × 15 columns
\n", "| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 744 | \n", "2/12/2015 | \n", "Quarter2 | \n", "sweing | \n", "Thursday | \n", "11 | \n", "0.50 | \n", "11.41 | \n", "1039.0 | \n", "2280 | \n", "0 | \n", "0.0 | \n", "0 | \n", "2 | \n", "55.0 | \n", "0.500123 | \n", "
| 761 | \n", "2/14/2015 | \n", "Quarter2 | \n", "sweing | \n", "Saturday | \n", "11 | \n", "0.60 | \n", "11.41 | \n", "1039.0 | \n", "2280 | \n", "23 | \n", "0.0 | \n", "0 | \n", "2 | \n", "55.0 | \n", "0.600448 | \n", "
| 777 | \n", "2/15/2015 | \n", "Quarter3 | \n", "sweing | \n", "Sunday | \n", "11 | \n", "0.65 | \n", "11.41 | \n", "700.0 | \n", "2640 | \n", "23 | \n", "0.0 | \n", "0 | \n", "2 | \n", "53.0 | \n", "0.650224 | \n", "
| 798 | \n", "2/16/2015 | \n", "Quarter3 | \n", "sweing | \n", "Monday | \n", "8 | \n", "0.70 | \n", "30.10 | \n", "7.0 | \n", "7080 | \n", "27 | \n", "2.0 | \n", "10 | \n", "2 | \n", "59.0 | \n", "0.621972 | \n", "
| 799 | \n", "2/16/2015 | \n", "Quarter3 | \n", "sweing | \n", "Monday | \n", "11 | \n", "0.70 | \n", "11.41 | \n", "680.0 | \n", "2160 | \n", "30 | \n", "0.0 | \n", "0 | \n", "2 | \n", "54.0 | \n", "0.565972 | \n", "
| 813 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "11 | \n", "0.70 | \n", "11.41 | \n", "1054.0 | \n", "3420 | \n", "30 | \n", "0.0 | \n", "0 | \n", "2 | \n", "56.0 | \n", "0.700614 | \n", "
| 818 | \n", "2/17/2015 | \n", "Quarter3 | \n", "sweing | \n", "Tuesday | \n", "8 | \n", "0.60 | \n", "29.40 | \n", "179.0 | \n", "0 | \n", "23 | \n", "5.0 | \n", "30 | \n", "2 | \n", "58.0 | \n", "0.600983 | \n", "
| 826 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "11 | \n", "0.70 | \n", "11.41 | \n", "685.0 | \n", "3360 | \n", "30 | \n", "0.0 | \n", "0 | \n", "2 | \n", "56.0 | \n", "0.821113 | \n", "
| 843 | \n", "2/18/2015 | \n", "Quarter3 | \n", "sweing | \n", "Wednesday | \n", "8 | \n", "0.65 | \n", "29.40 | \n", "962.0 | \n", "4560 | \n", "0 | \n", "4.5 | \n", "30 | \n", "2 | \n", "57.0 | \n", "0.251399 | \n", "
| 854 | \n", "2/19/2015 | \n", "Quarter3 | \n", "sweing | \n", "Thursday | \n", "11 | \n", "0.70 | \n", "11.41 | \n", "653.0 | \n", "3480 | \n", "30 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.700540 | \n", "
| 855 | \n", "2/19/2015 | \n", "Quarter3 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.70 | \n", "29.40 | \n", "1116.0 | \n", "6240 | \n", "0 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.700000 | \n", "
| 874 | \n", "2/22/2015 | \n", "Quarter4 | \n", "sweing | \n", "Sunday | \n", "8 | \n", "0.70 | \n", "29.40 | \n", "1146.0 | \n", "6840 | \n", "40 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.700614 | \n", "
| 876 | \n", "2/22/2015 | \n", "Quarter4 | \n", "sweing | \n", "Sunday | \n", "11 | \n", "0.75 | \n", "11.41 | \n", "834.0 | \n", "3480 | \n", "0 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.672141 | \n", "
| 878 | \n", "2/22/2015 | \n", "Quarter4 | \n", "sweing | \n", "Sunday | \n", "3 | \n", "0.70 | \n", "30.10 | \n", "1041.0 | \n", "8160 | \n", "33 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.626578 | \n", "
| 893 | \n", "2/23/2015 | \n", "Quarter4 | \n", "sweing | \n", "Monday | \n", "11 | \n", "0.75 | \n", "11.41 | \n", "826.0 | \n", "2820 | \n", "0 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.750294 | \n", "
| 895 | \n", "2/23/2015 | \n", "Quarter4 | \n", "sweing | \n", "Monday | \n", "8 | \n", "0.70 | \n", "29.40 | \n", "1094.0 | \n", "6840 | \n", "40 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.700614 | \n", "
| 896 | \n", "2/23/2015 | \n", "Quarter4 | \n", "sweing | \n", "Monday | \n", "3 | \n", "0.70 | \n", "29.40 | \n", "1228.0 | \n", "6960 | \n", "30 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.700362 | \n", "
| 911 | \n", "2/24/2015 | \n", "Quarter4 | \n", "sweing | \n", "Tuesday | \n", "11 | \n", "0.75 | \n", "11.61 | \n", "698.0 | \n", "3360 | \n", "34 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.750437 | \n", "
| 912 | \n", "2/24/2015 | \n", "Quarter4 | \n", "sweing | \n", "Tuesday | \n", "3 | \n", "0.75 | \n", "29.40 | \n", "1172.0 | \n", "5340 | \n", "45 | \n", "0.0 | \n", "0 | \n", "2 | \n", "60.0 | \n", "0.750177 | \n", "
| 916 | \n", "2/24/2015 | \n", "Quarter4 | \n", "sweing | \n", "Tuesday | \n", "8 | \n", "0.70 | \n", "29.40 | \n", "1079.0 | \n", "4560 | \n", "40 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.700519 | \n", "
| 929 | \n", "2/25/2015 | \n", "Quarter4 | \n", "sweing | \n", "Wednesday | \n", "7 | \n", "0.80 | \n", "30.10 | \n", "786.0 | \n", "7080 | \n", "50 | \n", "0.0 | \n", "0 | \n", "2 | \n", "59.0 | \n", "0.800116 | \n", "
| 932 | \n", "2/25/2015 | \n", "Quarter4 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.75 | \n", "29.40 | \n", "1283.0 | \n", "6960 | \n", "45 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.750207 | \n", "
| 935 | \n", "2/25/2015 | \n", "Quarter4 | \n", "sweing | \n", "Wednesday | \n", "10 | \n", "0.70 | \n", "21.82 | \n", "1653.0 | \n", "6240 | \n", "0 | \n", "0.0 | \n", "0 | \n", "2 | \n", "52.0 | \n", "0.700058 | \n", "
| 946 | \n", "2/26/2015 | \n", "Quarter4 | \n", "sweing | \n", "Thursday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "816.0 | \n", "2820 | \n", "50 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.800517 | \n", "
| 950 | \n", "2/26/2015 | \n", "Quarter4 | \n", "sweing | \n", "Thursday | \n", "3 | \n", "0.75 | \n", "29.40 | \n", "1244.0 | \n", "6840 | \n", "45 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.750474 | \n", "
| 952 | \n", "2/26/2015 | \n", "Quarter4 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.75 | \n", "29.40 | \n", "916.0 | \n", "6960 | \n", "56 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.750207 | \n", "
| 957 | \n", "2/26/2015 | \n", "Quarter4 | \n", "sweing | \n", "Thursday | \n", "4 | \n", "0.80 | \n", "30.10 | \n", "437.0 | \n", "7080 | \n", "32 | \n", "0.0 | \n", "0 | \n", "2 | \n", "59.0 | \n", "0.495618 | \n", "
| 961 | \n", "2/26/2015 | \n", "Quarter4 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.35 | \n", "26.66 | \n", "1164.0 | \n", "6600 | \n", "23 | \n", "0.0 | \n", "0 | \n", "2 | \n", "55.0 | \n", "0.378895 | \n", "
| 966 | \n", "2/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Saturday | \n", "11 | \n", "0.80 | \n", "11.61 | \n", "954.0 | \n", "0 | \n", "50 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.800779 | \n", "
| 970 | \n", "2/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Saturday | \n", "3 | \n", "0.75 | \n", "29.40 | \n", "1144.0 | \n", "4440 | \n", "45 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.750717 | \n", "
| 972 | \n", "2/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Saturday | \n", "8 | \n", "0.75 | \n", "29.40 | \n", "792.0 | \n", "4560 | \n", "56 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.750426 | \n", "
| 979 | \n", "2/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Saturday | \n", "1 | \n", "0.50 | \n", "26.66 | \n", "1448.0 | \n", "6840 | \n", "30 | \n", "0.0 | \n", "0 | \n", "2 | \n", "57.0 | \n", "0.550350 | \n", "
| 980 | \n", "2/28/2015 | \n", "Quarter4 | \n", "sweing | \n", "Saturday | \n", "4 | \n", "0.50 | \n", "26.66 | \n", "556.0 | \n", "6960 | \n", "23 | \n", "0.0 | \n", "0 | \n", "2 | \n", "58.0 | \n", "0.500258 | \n", "
| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 7 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "3 | \n", "0.75 | \n", "28.08 | \n", "795.0 | \n", "6900 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "0.753683 | \n", "
| 9 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "28.08 | \n", "681.0 | \n", "6900 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "0.750428 | \n", "
| 10 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "9 | \n", "0.70 | \n", "28.08 | \n", "872.0 | \n", "6900 | \n", "44 | \n", "0.0 | \n", "0 | \n", "0 | \n", "57.5 | \n", "0.721127 | \n", "
| 17 | \n", "1/1/2015 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "4 | \n", "0.65 | \n", "23.69 | \n", "861.0 | \n", "7200 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "60.0 | \n", "0.521180 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1179 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "3 | \n", "0.80 | \n", "30.10 | \n", "735.0 | \n", "6960 | \n", "63 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.800072 | \n", "
| 1180 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "11 | \n", "0.80 | \n", "11.41 | \n", "560.0 | \n", "3420 | \n", "50 | \n", "0.0 | \n", "0 | \n", "0 | \n", "58.0 | \n", "0.800035 | \n", "
| 1186 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "1 | \n", "0.75 | \n", "26.82 | \n", "1322.0 | \n", "7080 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.750051 | \n", "
| 1187 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "4 | \n", "0.75 | \n", "26.82 | \n", "1054.0 | \n", "7080 | \n", "45 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.750051 | \n", "
| 1188 | \n", "3/11/2015 | \n", "Quarter2 | \n", "sweing | \n", "Wednesday | \n", "5 | \n", "0.70 | \n", "26.82 | \n", "992.0 | \n", "6960 | \n", "30 | \n", "0.0 | \n", "0 | \n", "1 | \n", "58.0 | \n", "0.700557 | \n", "
248 rows × 15 columns
\n", "| \n", " | date | \n", "quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|
| \n", " | quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "idle_time | \n", "idle_men | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "Quarter1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0.0 | \n", "0 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 1 | \n", "Quarter1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.886500 | \n", "
| \n", " | quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "wip | \n", "over_time | \n", "incentive | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "1108.0 | \n", "7080 | \n", "98 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 1 | \n", "1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "NaN | \n", "960 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.886500 | \n", "
| \n", " | quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "over_time | \n", "incentive | \n", "no_of_style_change | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "7080 | \n", "98 | \n", "0 | \n", "59.0 | \n", "0.940725 | \n", "
| 1 | \n", "1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "960 | \n", "0 | \n", "0 | \n", "8.0 | \n", "0.886500 | \n", "
| \n", " | quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "over_time | \n", "incentive | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "7080 | \n", "98 | \n", "59.0 | \n", "0.940725 | \n", "
| 1 | \n", "1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "960 | \n", "0 | \n", "8.0 | \n", "0.886500 | \n", "
| \n", " | quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "over_time | \n", "incentive | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "7080 | \n", "98 | \n", "59 | \n", "0.940725 | \n", "
| 1 | \n", "1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "960 | \n", "0 | \n", "8 | \n", "0.886500 | \n", "
| \n", " | quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "over_time | \n", "incentive | \n", "no_of_workers | \n", "actual_productivity | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "sweing | \n", "Thursday | \n", "8 | \n", "0.80 | \n", "26.16 | \n", "7080 | \n", "98 | \n", "59 | \n", "0.94 | \n", "
| 1 | \n", "1 | \n", "finishing | \n", "Thursday | \n", "1 | \n", "0.75 | \n", "3.94 | \n", "960 | \n", "0 | \n", "8 | \n", "0.89 | \n", "
| \n", " | quarter | \n", "department | \n", "day | \n", "team | \n", "targeted_productivity | \n", "smv | \n", "over_time | \n", "incentive | \n", "no_of_workers | \n", "actual_productivity | \n", "productive | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 959 | \n", "4 | \n", "finishing | \n", "Thursday | \n", "10 | \n", "0.70 | \n", "2.90 | \n", "3360 | \n", "0 | \n", "8 | \n", "0.41 | \n", "False | \n", "
| 464 | \n", "4 | \n", "finishing | \n", "Tuesday | \n", "8 | \n", "0.65 | \n", "3.94 | \n", "960 | \n", "0 | \n", "8 | \n", "0.85 | \n", "True | \n", "
| 672 | \n", "2 | \n", "sweing | \n", "Sunday | \n", "7 | \n", "0.70 | \n", "24.26 | \n", "6960 | \n", "0 | \n", "58 | \n", "0.36 | \n", "False | \n", "
| 321 | \n", "3 | \n", "sweing | \n", "Monday | \n", "6 | \n", "0.80 | \n", "11.41 | \n", "4380 | \n", "50 | \n", "31 | \n", "0.80 | \n", "True | \n", "
| 282 | \n", "3 | \n", "finishing | \n", "Saturday | \n", "9 | \n", "0.80 | \n", "3.94 | \n", "1800 | \n", "0 | \n", "10 | \n", "0.83 | \n", "True | \n", "
| 307 | \n", "3 | \n", "sweing | \n", "Sunday | \n", "10 | \n", "0.70 | \n", "22.52 | \n", "10080 | \n", "40 | \n", "56 | \n", "0.70 | \n", "True | \n", "
| 609 | \n", "1 | \n", "finishing | \n", "Wednesday | \n", "9 | \n", "0.75 | \n", "3.94 | \n", "960 | \n", "0 | \n", "8 | \n", "0.76 | \n", "True | \n", "
| 1123 | \n", "2 | \n", "sweing | \n", "Sunday | \n", "8 | \n", "0.60 | \n", "30.48 | \n", "6720 | \n", "0 | \n", "56 | \n", "0.60 | \n", "True | \n", "
| 877 | \n", "4 | \n", "sweing | \n", "Sunday | \n", "9 | \n", "0.70 | \n", "18.79 | \n", "3240 | \n", "30 | \n", "57 | \n", "0.63 | \n", "False | \n", "
| 950 | \n", "4 | \n", "sweing | \n", "Thursday | \n", "3 | \n", "0.75 | \n", "29.40 | \n", "6840 | \n", "45 | \n", "57 | \n", "0.75 | \n", "True | \n", "
| \n", " | quarter | \n", "day | \n", "department | \n", "team | \n", "no_of_workers | \n", "targeted_productivity | \n", "actual_productivity | \n", "productive | \n", "over_time | \n", "smv | \n", "incentive | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "Thursday | \n", "sweing | \n", "8 | \n", "59 | \n", "0.80 | \n", "0.94 | \n", "True | \n", "7080 | \n", "26.16 | \n", "98 | \n", "
| 1 | \n", "1 | \n", "Thursday | \n", "finishing | \n", "1 | \n", "8 | \n", "0.75 | \n", "0.89 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "
| 2 | \n", "1 | \n", "Thursday | \n", "sweing | \n", "11 | \n", "30 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "3660 | \n", "11.41 | \n", "50 | \n", "
| 3 | \n", "1 | \n", "Thursday | \n", "sweing | \n", "12 | \n", "30 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "3660 | \n", "11.41 | \n", "50 | \n", "
| 4 | \n", "1 | \n", "Thursday | \n", "sweing | \n", "6 | \n", "56 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "1920 | \n", "25.90 | \n", "50 | \n", "
| \n", " | quarter | \n", "day | \n", "dept_sweing | \n", "team | \n", "no_of_workers | \n", "targeted_productivity | \n", "actual_productivity | \n", "productive | \n", "over_time | \n", "smv | \n", "incentive | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "Thursday | \n", "1 | \n", "8 | \n", "59 | \n", "0.80 | \n", "0.94 | \n", "True | \n", "7080 | \n", "26.16 | \n", "98 | \n", "
| 1 | \n", "1 | \n", "Thursday | \n", "0 | \n", "1 | \n", "8 | \n", "0.75 | \n", "0.89 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "
| 2 | \n", "1 | \n", "Thursday | \n", "1 | \n", "11 | \n", "30 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "3660 | \n", "11.41 | \n", "50 | \n", "
| 3 | \n", "1 | \n", "Thursday | \n", "1 | \n", "12 | \n", "30 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "3660 | \n", "11.41 | \n", "50 | \n", "
| 4 | \n", "1 | \n", "Thursday | \n", "1 | \n", "6 | \n", "56 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "1920 | \n", "25.90 | \n", "50 | \n", "
| 5 | \n", "1 | \n", "Thursday | \n", "1 | \n", "7 | \n", "56 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "6720 | \n", "25.90 | \n", "38 | \n", "
| 6 | \n", "1 | \n", "Thursday | \n", "0 | \n", "2 | \n", "8 | \n", "0.75 | \n", "0.76 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "
| 7 | \n", "1 | \n", "Thursday | \n", "1 | \n", "3 | \n", "57 | \n", "0.75 | \n", "0.75 | \n", "True | \n", "6900 | \n", "28.08 | \n", "45 | \n", "
| 8 | \n", "1 | \n", "Thursday | \n", "1 | \n", "2 | \n", "55 | \n", "0.75 | \n", "0.75 | \n", "True | \n", "6000 | \n", "19.87 | \n", "34 | \n", "
| 9 | \n", "1 | \n", "Thursday | \n", "1 | \n", "1 | \n", "57 | \n", "0.75 | \n", "0.75 | \n", "True | \n", "6900 | \n", "28.08 | \n", "45 | \n", "
| \n", " | day | \n", "dept_sweing | \n", "team | \n", "no_of_workers | \n", "targeted_productivity | \n", "actual_productivity | \n", "productive | \n", "over_time | \n", "smv | \n", "incentive | \n", "q_1 | \n", "q_2 | \n", "q_3 | \n", "q_4 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 959 | \n", "Thursday | \n", "0 | \n", "10 | \n", "8 | \n", "0.70 | \n", "0.41 | \n", "False | \n", "3360 | \n", "2.90 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
| 464 | \n", "Tuesday | \n", "0 | \n", "8 | \n", "8 | \n", "0.65 | \n", "0.85 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
| 672 | \n", "Sunday | \n", "1 | \n", "7 | \n", "58 | \n", "0.70 | \n", "0.36 | \n", "False | \n", "6960 | \n", "24.26 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
| 321 | \n", "Monday | \n", "1 | \n", "6 | \n", "31 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "4380 | \n", "11.41 | \n", "50 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
| 282 | \n", "Saturday | \n", "0 | \n", "9 | \n", "10 | \n", "0.80 | \n", "0.83 | \n", "True | \n", "1800 | \n", "3.94 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
| 307 | \n", "Sunday | \n", "1 | \n", "10 | \n", "56 | \n", "0.70 | \n", "0.70 | \n", "True | \n", "10080 | \n", "22.52 | \n", "40 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
| 609 | \n", "Wednesday | \n", "0 | \n", "9 | \n", "8 | \n", "0.75 | \n", "0.76 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 1123 | \n", "Sunday | \n", "1 | \n", "8 | \n", "56 | \n", "0.60 | \n", "0.60 | \n", "True | \n", "6720 | \n", "30.48 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
| 877 | \n", "Sunday | \n", "1 | \n", "9 | \n", "57 | \n", "0.70 | \n", "0.63 | \n", "False | \n", "3240 | \n", "18.79 | \n", "30 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
| 950 | \n", "Thursday | \n", "1 | \n", "3 | \n", "57 | \n", "0.75 | \n", "0.75 | \n", "True | \n", "6840 | \n", "29.40 | \n", "45 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
| \n", " | dept_sweing | \n", "team | \n", "no_of_workers | \n", "targeted_productivity | \n", "actual_productivity | \n", "productive | \n", "over_time | \n", "smv | \n", "incentive | \n", "q_1 | \n", "q_2 | \n", "q_3 | \n", "q_4 | \n", "Monday | \n", "Saturday | \n", "Sunday | \n", "Thursday | \n", "Tuesday | \n", "Wednesday | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 959 | \n", "0 | \n", "10 | \n", "8 | \n", "0.70 | \n", "0.41 | \n", "False | \n", "3360 | \n", "2.90 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
| 464 | \n", "0 | \n", "8 | \n", "8 | \n", "0.65 | \n", "0.85 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
| 672 | \n", "1 | \n", "7 | \n", "58 | \n", "0.70 | \n", "0.36 | \n", "False | \n", "6960 | \n", "24.26 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 321 | \n", "1 | \n", "6 | \n", "31 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "4380 | \n", "11.41 | \n", "50 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 282 | \n", "0 | \n", "9 | \n", "10 | \n", "0.80 | \n", "0.83 | \n", "True | \n", "1800 | \n", "3.94 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 307 | \n", "1 | \n", "10 | \n", "56 | \n", "0.70 | \n", "0.70 | \n", "True | \n", "10080 | \n", "22.52 | \n", "40 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 609 | \n", "0 | \n", "9 | \n", "8 | \n", "0.75 | \n", "0.76 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
| 1123 | \n", "1 | \n", "8 | \n", "56 | \n", "0.60 | \n", "0.60 | \n", "True | \n", "6720 | \n", "30.48 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 877 | \n", "1 | \n", "9 | \n", "57 | \n", "0.70 | \n", "0.63 | \n", "False | \n", "3240 | \n", "18.79 | \n", "30 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 950 | \n", "1 | \n", "3 | \n", "57 | \n", "0.75 | \n", "0.75 | \n", "True | \n", "6840 | \n", "29.40 | \n", "45 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
| \n", " | dept_sweing | \n", "no_of_workers | \n", "targeted_productivity | \n", "actual_productivity | \n", "productive | \n", "over_time | \n", "smv | \n", "incentive | \n", "q_1 | \n", "q_2 | \n", "... | \n", "team_3 | \n", "team_4 | \n", "team_5 | \n", "team_6 | \n", "team_7 | \n", "team_8 | \n", "team_9 | \n", "team_10 | \n", "team_11 | \n", "team_12 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 959 | \n", "0 | \n", "8 | \n", "0.70 | \n", "0.41 | \n", "False | \n", "3360 | \n", "2.90 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
| 464 | \n", "0 | \n", "8 | \n", "0.65 | \n", "0.85 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 672 | \n", "1 | \n", "58 | \n", "0.70 | \n", "0.36 | \n", "False | \n", "6960 | \n", "24.26 | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 321 | \n", "1 | \n", "31 | \n", "0.80 | \n", "0.80 | \n", "True | \n", "4380 | \n", "11.41 | \n", "50 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 282 | \n", "0 | \n", "10 | \n", "0.80 | \n", "0.83 | \n", "True | \n", "1800 | \n", "3.94 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 307 | \n", "1 | \n", "56 | \n", "0.70 | \n", "0.70 | \n", "True | \n", "10080 | \n", "22.52 | \n", "40 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
| 609 | \n", "0 | \n", "8 | \n", "0.75 | \n", "0.76 | \n", "True | \n", "960 | \n", "3.94 | \n", "0 | \n", "1 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 1123 | \n", "1 | \n", "56 | \n", "0.60 | \n", "0.60 | \n", "True | \n", "6720 | \n", "30.48 | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 877 | \n", "1 | \n", "57 | \n", "0.70 | \n", "0.63 | \n", "False | \n", "3240 | \n", "18.79 | \n", "30 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 950 | \n", "1 | \n", "57 | \n", "0.75 | \n", "0.75 | \n", "True | \n", "6840 | \n", "29.40 | \n", "45 | \n", "0 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
10 rows × 30 columns
\n", "| \n", " | dept_sweing | \n", "no_of_workers | \n", "targeted_productivity | \n", "over_time | \n", "smv | \n", "incentive | \n", "q_1 | \n", "q_2 | \n", "q_3 | \n", "q_4 | \n", "... | \n", "team_3 | \n", "team_4 | \n", "team_5 | \n", "team_6 | \n", "team_7 | \n", "team_8 | \n", "team_9 | \n", "team_10 | \n", "team_11 | \n", "team_12 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "59 | \n", "0.80 | \n", "7080 | \n", "26.16 | \n", "98 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 1 | \n", "0 | \n", "8 | \n", "0.75 | \n", "960 | \n", "3.94 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
2 rows × 28 columns
\n", "DecisionTreeClassifier(max_depth=3, random_state=24)In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
DecisionTreeClassifier(max_depth=3, random_state=24)