Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
choufree
Level III

Re: time course data in microtiter plate format

Thanks David. This could be a solution.
Highlighted
choufree
Level III

Re: time course data in microtiter plate format

Hi Dave,

 

Do you mind showing me your data table? When you use the local data filter which column you use to do the filter?

How do you group the different column and define them as bioreators? I put the reactor name in column info. So each column is the data for this reactor. For each time point, the data is a row for a set of the reactors. In summary, I have a time series column, and all the reactors cloumns. I don't have any column to select for filter.  I am stuck at this point. Thanks

Highlighted
David_Burnham
Super User

Re: time course data in microtiter plate format

The data has been stacked: the first 'n' rows correspond to the time course data for the first bioreactor vessel, the following 'n' correspond to the next bioreactor vessel etc.  Var is on the y axis, age or timestamp on the x-axis, bireactor is the wrapping variable and/or data filter variable.

 

ambr-data.PNG

Looking at your data table, to get it into this shape you would need to first transpose the data and then stack the columns.

-Dave
Highlighted
choufree
Level III

Re: time course data in microtiter plate format

Thanks a lot for the demonstration! I am almost there. Stack column is really a key. 

By local data filter, I can choose certain column to show while still cann't display them individually.

As a new user, I really appreciate the help from you and Mark. Screen Shot 2017-05-12 at 10.32.47 PM.png

Highlighted
choufree
Level III

Re: time course data in microtiter plate format

I made it using the wrap function!
Article Labels

    There are no labels assigned to this post.