GageRunChart1.py

# Import libraries and dependencies
import numpy as np
import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
%matplotlib inline

# Open Excel file
data = pd.read_excel("msa_2_crossed.xlsx")

# Sort values by Part and Operator
data = data.sort_values(["Part","Operator"])

# Reset index
data.reset_index(inplace=True, drop=True)

# Display top rows
data.head()