Experiments with Python

From PharmWiki
Jump to navigation Jump to search

Making an MS Excel Sheet

  1. micro1=Add_Microplate()
    1. dictionary with different positions or array with different positions.
  2. micro=[multiple arrays]
  3. rows={'A':1, ... 'H':12}
  4. show_comp() # Show a component and abbreviation list
  5. micro1[columns][rows].add_comp('Ver.')


microplate("V",")

BuildMicroplate(CompNum, ComponentStr, WellStart, WellEnd, ConcStart, ConcEnd, ConcDiv, UnitStr)

V = known variable


Exp1=ExceMicroplate()

M1="Experimental Design"

M2="Absorbance"

Exp1.Add_Microplate(M1)

Exp1.BuildMicroplate(M1,"KPi",[A:1","H:2"],[500.0,'uM,2])

Exp1.BuildMicroplate(M1,"V",["A:2","H:2"],[500,0,'uM',2])

M1=Build96Microplate(


M1=Exel96Microplates()

M1.Title="Today's Experiment"

M1.Date=""

M1.ExpID=""

M1.Add_Plate()

M1.Plate[0].Title = "Experimental Design"

M1.Plate[0].Wells("KPi",["A1","H1"],[500,0,'uM,2]) # Colorize=True, HideValues=False, Overwrite=False

# Will give an error message if it overlaps

M1.Plate[0].Wells("V",["A2","H2"],[500,0,'uM']) # Default is the divider is 2

M2.Plate[0].Wells("R",["A3","H4"],[500,0,'uM',2]) # Spread over two columns

M2.Plate[0].Wells("R",["A5","H6"],[500,0,'uM',2])

M2.Plate[0].Wells("R",["A7","H8"],[500,0,'uM',2])

M2.Plate[0].Wells("R",["A9","H10"],[500,0,'uM',2])

M1.Plate("Experimental Design").Plot() # Show a diagram showing empty wells

M1.Build("KPi",["A:1","H:2"],[500,0,'uM',2])

You can make it so that it is calculating.


import ExpDesignPy # Python serves as a way to do lab notebooks

  • Experimental ID is automatically calculated with a-z determined by when you start
  • YYMMDD[a...z]

E1=ExpDesignPy()

E1.add_96MicroPlate() # This is a real plate

E1.add_Cuvette("C")

E1.Cuvette[0].Volume(1.4) # Assumed to mL

E1.ExcelTemplate.add_96Microplate() # The problem is finding the correct code.