File talk:E. coli OD600 over time.svg

From Wikinews, the free news source you can write!
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")