


asked 06 Mar '18, 18:45

katethorson's gravatar image

accept rate: 0%

We recommend users to export their data and do aggregations outside of Datavyu. You can use this ( template script to export data such that the talktime cells are nested inside of the task cells (long format). You would want to set the nested_columns parameter to %w(task talktime) and update the code_map parameter with the appropriate column names and codes. If you have a column with metadata information about the file (e.g., "id"), you can specify it in the static_columns parameter to have it repeated for the entire file.

You can export summary statistics using a Ruby script, but that requires more legwork. See this post for an example: .

Here's an example of what your export script may look like:

task_col = get_column('task')
talk_col = get_column('talktime')

data = [] task_col.cells.each do |taskcell| talkcells ={ |x| taskcell.contains(x) } # Sum up durations of nested talktime cells talk_dur =, :+) task_dur = taskcell.duration data << [task_dur, talk_dur].join(',') end

Print the data to the console

puts data

The data array would contain a CSV row for each task cell. The first value would be the duration of the task (in milliseconds) and the second value would the the total duration of nested talktime cells within that task. The selection statement in the code requires a strict nesting: the talk cell must start at-or-after the task cell and must end at-or-before the task cell.

permanent link

answered 06 Mar '18, 21:24

Shohan%20Hasan's gravatar image

Shohan Hasan ♦♦
accept rate: 14%

What do you recommend if the cells don't have a strict nesting? I found this to be difficult to deal with when outside of Datavyu so I was hoping there was some way I could manage it in Datavyu. The ComboExport script won't work for this reason, I think (error message: "Can't find nesting cell in column interval30sec for cell 2 in column talktime" - this cell begins in one interval and ends in the next). And it sounds like exporting summary statistics via Ruby will also require a strict testing. Do you have any suggestions?

(07 Mar '18, 13:15) katethorson katethorson's gravatar image

Depends on your coding pass. If you don't care about strict nesting and it doesn't happen often, you could assign the cell to one of the overlapping intervals (e.g., majority wins). There are RCell functions that let you check amount of overlap between two cells (if any).

Another option is the merge the two columns together to create a single column containing all the codes from the source columns. Cells would be inserted for each change in any of the codes. This is usually the best way to handle exporting since it preserves the coded information and you can process it outside of Datavyu.

(08 Mar '18, 13:52) Shohan Hasan ♦♦ Shohan%20Hasan's gravatar image
Your answer
toggle preview

Follow this question

By Email:




Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • numbered list: 1. Foo 2. Bar
  • basic HTML tags are also supported

Question tags:


question asked: 06 Mar '18, 18:45

question was seen: 1,360 times

last updated: 08 Mar '18, 13:52

powered by OSQA