visualdatatools.com Forum Index visualdatatools.com
Discussion for DataTank and DataGraph
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Plot average of columns 1-00 vs col 1?

 
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Getting Started
View previous topic :: View next topic  
Author Message
sgreen



Joined: 02 Jun 2012
Posts: 12

PostPosted: Fri Mar 15, 2019 5:05 pm    Post subject: Plot average of columns 1-00 vs col 1? Reply with quote

Hi,
I'd like to be able to plot the average of each row across many columns vs x values in a single column.

This is sort-of possible with an expression column, but that's very unwieldy with 100 columns.

Alternately, I can transpose the data and get column averages, but then I lose the x-values that I want to plot against.

Am I missing an obvious way to do this?

My data looks like:

Wavelength 1_m_depth 2_m_depth 3_m_depth... etc.
300 nm 1mValue@300 2mValue@300 3mValue@300
400 nm 1mValue@400 2mValue@400 3mValue@400

I want to plot the average of each row (all depths) vs wavelength.
Back to top
View user's profile Send private message
Pamela



Joined: 25 Feb 2017
Posts: 46

PostPosted: Sat Mar 16, 2019 11:25 am    Post subject: Reply with quote

See if this helps...

At the about the 5 min mark in this video, it shows how to flatten data.
https://www.youtube.com/watch?v=zLNi-_WyfM8

You can do a lot more by having many rows of data instead of columns.

Then the column headings will become an entry in the column.

You can then use pivoting to calc the averages, and extract the data back out the data table.

Also, feel free to email an example file to help@visualdatatools.com
Back to top
View user's profile Send private message
sgreen



Joined: 02 Jun 2012
Posts: 12

PostPosted: Tue Mar 19, 2019 8:54 pm    Post subject: Reply with quote

Thanks for the quick response.
That video helpful for some of my needs, though I'm finding for this specific data it's easier to do the fits in Matlab and then import to DataGraph.

Thanks for a great product!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Getting Started All times are GMT - 3 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group