How to export to Excel according to marker conditions and average this result?

  • MNE version: e.g. 0.24.0
  • operating system: Windows 10

When I use to data frame to export to Excel, I don’t want to export all of them, I want to export them in terms of marker and average the results

Instead of the image below, presented by time and channel

Hello, it’s difficult to tell what you want to do. Could you please elaborate what exactly you want to do?
Thanks

Thank you for your reply

For example, after I average ERPS conditions, I need to export to Excel to use SPSS for statistical calculations.

This is similar to the GRAND_AVERAGE function in Erplab:

So what exactly is your question? It appears to me you managed to export the data. Where do you need help now?

Best,
Richard

For example, I need to export the electrode points I am interested in according to my Marker, such as FP1, FZ, FC1

I made the following attempts:


But my Marker is: s 1, s 14, etc., such as the average value of FP1, FZ, FC1 under s1,s14 conditions。
Because in the end I need to make a grand average,what should I do

I’m very sorry, but I don’t understand what you mean…

First of all, thanks for your reply
First, do you know how to get ERPS under different conditions,
Whether to correspond to the link content below
https://mne.tools/stable/auto_tutorials/evoked/30_eeg_erp.html?highlight=erps

Second, as the code below shows, I need to extract my own
l_aud = epochs[‘auditory/left’].average()
l_vis = epochs[‘visual/left’].average()

Oh, I suddenly understand. I’ll let you know if I have any questions later