# -*- coding: utf-8 -*-
"""
Created on Mon Nov 12 10:41:29 2018

@author: tqc268
"""
import pandas as pd
import matplotlib.pyplot as plt


xl = pd.read_excel(r'..\Meas_yields.xlsx', 'data')


DMG =xl.groupby(['treatment','block','field'])    
s1ind = [(DMG.get_group((4,1,'IND'))['harvest'], DMG.get_group((4,1,'IND'))['grassDM']/100,'x')]
s2ind = [(DMG.get_group((4,2,'IND'))['harvest'], DMG.get_group((4,1,'IND'))['grassDM']/100,'x')]
s3ind = [(DMG.get_group((4,3,'IND'))['harvest'], DMG.get_group((4,1,'IND'))['grassDM']/100,'x')]
s1ud = [(DMG.get_group((4,1,'UD'))['harvest'], DMG.get_group((4,1,'IND'))['grassDM']/100,'x')]
s2ud = [(DMG.get_group((4,2,'UD'))['harvest'], DMG.get_group((4,1,'IND'))['grassDM']/100,'x')]
s3ud = [(DMG.get_group((4,3,'UD'))['harvest'], DMG.get_group((4,1,'IND'))['grassDM']/100,'x')]

