text: import pandas as pd
  import matplotlib.pyplot as plt
  
  def obesity(excelfile="Obes-phys-acti-diet-eng-2014-tab.xls", nogui = False):
      data = pd.ExcelFile(excelfile)
      #print(data.sheet_names)
  
      # Read 2nd section, by age
      data_age  = data.parse('7.2', skiprows=4, skipfooter=14)
  
      # Rename unames to year
      data_age.rename(columns={'Unnamed: 0': 'Year'}, inplace=True)
  
      # Drop empties and reset index
      data_age.dropna(inplace=True)
      data_age.set_index('Year', inplace=True)
  
      #print(data_age)
  
  
      # Plotting everything cause total to override everything. So drop it.
      # Drop the total column and plot
      data_age_minus_total = data_age.drop('Total', axis = 1)
      data_age_minus_total.plot()
      if not nogui:
          plt.show()
          plt.savefig('output/plot.png')
          plt.close()
  
  
  
  if __name__ == "__main__":
      obesity()
  