How to get the TIME (seconds, miliseconds etc.) when you convert it to EXCEL format?


#1

Hey guys we really need help on this cause we’re conducting our thesis about brainwaves and we’re having a hard time processing the data in the csv file cause we can’t seem to output the TIME for each point.

Just a another question, can we format the data in the excel by column? because we’re having a hard time transposing the rows and columns so that we could import the csv into the rapidminer.

Please and Thank You :slight_smile:

Students from the Philippines salute you :slight_smile:


#2

Hi there,

The timestamp is the first column in the current CSV format that MusePlayer uses. What difficulty are you having accessing it, specifically?

As you’ve clearly noticed, the data in the current CSV format is not organized into columns by OSC path name. MusePlayer does have a feature to filter the data by its OSC paths, which should in theory allow you to create separate CSV files for each path that you’re interested in. CSV files with only data for a single path would be easier to import because they represent square matrices, which software packages light MATLAB and R (and I’m guessing Rapidminer, although I’m not personally familiar with it) tend to like. Unfortunately, I noticed a bug in MusePlayer where the OSC path filtering cannot tell the difference between two paths like “/muse/eeg” and “/muse/eeg/quantization”. We’ve got a fix for this that allows the user to specify a regular expression to match rather than just a string, and that will be included in the next release of the SDK (which should happen fairly soon).

In the meantime, before we release the fix, you may have to write a script of your own that parses the CSV files into a format that Rapidminer can understand. For instance, a Python script that goes through the file line by line, creating and appending to different lists depending on the OSC path specified on each line.

Another possible workaround: If you have MATLAB or Octave (essentially a free, open-source MATLAB), you should be able to import the .mat files that MusePlayer produces and then use the built-in CSV writing methods to export whatever variables you are interested in to CSV files that Rapidminer is more likely to be able to read.

Hope this helps, and we’ll let you know when the next SDK update is available.


#3

Thanks for replying :slight_smile:

Is the timestamp in milliseconds? We saw the timestamp but whats the format of the timestamp?


#4

The timestamp is in seconds since January 1, 1970, with precision down to microvolts.

See these threads for my answers to your teammates:

http://forum.choosemuse.com/forum/re…68-newbie-help
http://forum.choosemuse.com/forum/ma…timestamp-mean

[B]A small administrative note:[/B] In general, try to avoid posting the same question in multiple forums. We all know that it can be difficult waiting for a response to your question when you have a deadline, but be assured it has been seen and will likely be addressed. If you think it’s been forgotten, it’s better to just post a “Hello, anybody out there?” message in the same thread, rather than creating duplicates. Duplicate threads clutter the forums and confuse discussion. Thanks!


#5

I forgot to mention - the timezone of the timestamps is GMT.


#6

Thanks tom!

You’ve been a great help and sorry about the duplicate post. There’s been a lot of pressure in our thesis lately that’s why we really needed help asap.

I’ll take a look at the documentation and discuss it with my colleagues.

Thanks again