Experiments with Python
Making an MS Excel Sheet
- micro1=Add_Microplate()
- dictionary with different positions or array with different positions.
- micro=[multiple arrays]
- rows={'A':1, ... 'H':12}
- show_comp() # Show a component and abbreviation list
- 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
- Pandas seems like a good way to get a preview.
- see https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html
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.