File talk:E. coli OD600 over time.svg
Jump to navigation
Jump to search
Generation of the chart[edit]
The chart was generated using a script.
# Author: Agastya agastya@wn-reporters.org # License: BSD-3-Clause # Description: Generation of this graph import pandas as pd import plotly.express as px import plotly.graph_objects as go file = r'h2data/E_Coli_OD600_Measurments.xlsx' data1 = pd.read_excel(file, sheet_name="E Coli OD600 Air") data2 = pd.read_excel(file, sheet_name="E Coli OD600 anaerobic") fig = go.Figure() fig.add_scatter(x=data1['Time Elapsed (Hours)'], y=data1['OD600'], mode='lines+markers', name='Air') fig.add_scatter(x=data2['Time Elapsed (Hours)'], y=data2['He'], mode='lines+markers', name='He') fig.add_scatter(x=data2['Time Elapsed (Hours)'], y=data2['H2'], mode='lines+markers', name='H<sub>2</sub>') fig.add_scatter(x=data2['Time Elapsed (Hours)'], y=data2['CO2/N2'], mode='lines+markers', name='CO<sub>2</sub>/N<sub>2</sub>') fig.update_xaxes(title_text='Time Elapsed (Hr)') fig.update_yaxes(title_text='OD600') fig.update_xaxes(nticks=20) fig.update_yaxes(nticks=20) fig.update_layout(title_text="E. coli optical density measurement in various atmospheres", width=850, height=500) fig.write_image("E. coli OD600.svg")