I am currently a PhD student in Biology, and I would like some help in order to plot some graphs more efficiently than with usual built-in softwares like Numbers or Excel.
My expertise in Python programming is very weak, but I manage to understand lines of code when put in context. However, I get confused pretty quickly when alone in front of other peoples’ code.
To get into my problem :
I basically have dozens of excel-type tables, each one for every experiment, with redundant columns (experimental replica) just like this screenshot :
Every minute of the experiment up to 12h, a RFU value is measured for a specific concentration of chemicals, and I always have my “Positive Controls” somewhere in the tables.
For now, my x axis is the range of concentrations, and the y axis is the measured values (RFU).
To get my graphs, I extract an arbitrary single line (i.e a single time point) in every table to plot the results of my experiments.
Instead of extracting only one time point, I would like to gather all the data into one graph, by having a third axis (time). This could either be like a three dimensional graph, or with a ‘knob’ that would allow me to play with the third axis to see the evolution of my RFU vs Concentrations graph over time.
I’m not asking for an already made code for this task, but rather some sort of walkthrough or guide to get it done, as I suspect that it is not incredibly difficult to do so.
Thank you so much for all the help you could provide !