title: What kind of analysis can I run for this large excel file dataset?
body: <p>I work for a company that sells pails to customers. I am doing this for a class project and I'm not the best when it comes to Python. The file lists thousands of customers who purchased different types of pails from 2015-2019. My Finance Department would like to <strong>know who was returning them vs who wasn’t and at what rate?</strong></p>
  
  <p>I managed to use python to only use selected columns (<a href="https://i.stack.imgur.com/gBwTA.png" rel="nofollow noreferrer">see this data</a>) that were relevant to my analysis. Once I exported to csv file, what kind of analysis should I run in Python to help answer my question? I've already did a pivottable and chart (to count how many customers return pails and what year) but want to use Python to make things simpler to read and analyze so I can answer the question.</p>
  
  <pre><code>import pandas as pd
  
  data = pd.read_excel (r'C:\Users\Vilma\Documents\CIS450\Inidividual project\ContainerTracker.xlsx',
  sheet_name='2015-2019') 
  df = pd.DataFrame(data, columns= ['Customer for Tracking::CustomerName',
            'Customer for Tracking::CustomerID',
            'Order for Tracking::OrderDate',
            'Products for Tracking::ProdName',
            'Transaction Items for Tracking::Description',
            'RemovalNote',
            'RemovalDate',
            'OrderID'])
  
  
  df.to_csv(r'C:\Users\Vilma\Documents\CIS450\Inidividual project\ContainerTrackerTrimmed.csv',index = False)
  print (df)
  </code></pre>