Python chart with compare intervals

[marcen]

Hi,

Maybe someone can give me a tip on how I can compare intervals of different activities in a python script.

I tried to get the date and start time via GC.activityMetrics(compare=True), which also works. Then I can get the intervals with GC.activityIntervals(type="", activity=Date and start time).
With "selected" I can filter the intervals that are selected in the side bar. Since the selection in the Side Bar is not the same as in the Compare Pane. I am looking for another way to get the start and end times of the interval stored in the Compare Pane.

It would be great if someone had a tip on how to do this.

[Ale Martinez]

El viernes, 31 de marzo de 2023 a la(s) 18:44:35 UTC-3, marcen escribió:

Hi,

Maybe someone can give me a tip on how I can compare intervals of different activities in a python script.

I tried to get the date and start time via GC.activityMetrics(compare=True), which also works.

I think what you are looking for would be GC.activity(compare=True), which is available in R but not Python API, likely I overlooked it when "translated" R to Python API.

A possible workaround would be to use Elapsed_Time and Elapsed_Time+Duration from GC.activityMetrics(compare=True) to get interval start and stop time, but I have not tested this.

BTW, your power profile radar chart is very nice!

[marcen]

Many thanks for the tips.

Unfortunately, GC.activity(compare=True) only works with R.
For example, when I test print(GC.activity(compare=True)) in Python, I get the following error message: TypeError: __GCactivity() got an unexpected keyword argument 'compare'.

Elapsed_Time only shows the value in the sidebar view, in the compare pane the value is zero and GC.activityMetrics(compare=True) also returns a value of zero.

Thanks a lot. It was fun to create the Power Profile Radar Chart.

[Ale Martinez]

El sábado, 1 de abril de 2023 a la(s) 16:05:16 UTC-3, marcen escribió:

Many thanks for the tips.

Unfortunately, GC.activity(compare=True) only works with R.
For example, when I test print(GC.activity(compare=True)) in Python, I get the following error message: TypeError: __GCactivity() got an unexpected keyword argument 'compare'.

It is currently unsupported, I will take a look to try to understand how much work is to add it. 

[marcen]

Thank you for the help and your work on GC.

[Ale Martinez]

Added for tracking: https://github.com/GoldenCheetah/GoldenCheetah/issues/4346

[Ale Martinez]

I created a PR to retrieve sample data for compare items: https://github.com/GoldenCheetah/GoldenCheetah/pull/4349

Basically all activity series and xdata related functions include an optional compre parameter working as an index on the compare list, for example:

GC.activity(compare=0)

Will return the sample data and xdata for the first compare item (activity or interval) if compare mode is enabled, otherwise the current activity data. And so on for compare=1, etc. matching GC.activityMetrics(compare=True) array.

A windows installer can be downloaded from https://ci.appveyor.com/project/Joern-R/goldencheetah-knhd8/builds/46747461, or the PR can be included using command line instructions in the PR for personal builds.

[Ale Martinez]

Perhaps compareindex, or just index, will be a better name to avoid confusion with compare (boolean) in other APIs. 

[marcen]

Great, thank you very much.
First tests looked good. Will test a small chart tonight.
I would prefer compareindex. As you also know what the index refers to.

[Ale Martinez]

New version using compareindex parameter is available from https://ci.appveyor.com/project/Joern-R/goldencheetah-knhd8/builds/46755451/artifacts

[marcen]

With the attached chart I could compare the activities and all kinds of intervals.
Works great, thank you.

[Ale Martinez]

Perfect, thank you, I added the example to tests/charts and merged, will update the wiki and generate new snapshots next weekend.

[marcen]

In CloudDB, the CP over under - compare chart is available. This allows activities or intervals to be compared with the new parameter compareindex .

Only compatible with version V3.6-DEV dated 15.04.2023 or later!

To use the chart, Python must be enabled in Golden Cheetah. See wiki for more: https://github.com/GoldenCheetah/GoldenCheetah/wiki/UG_Preferences_General

[Fe]

Hi Ale,

I tried 'compareindex' ... there is a problem with the gears :
'compareindex' and 'start-stop' intervals do not seem the same. (image1, script1 to check)

image1

--------------------------------------------------------------------------------------------------------------------------------------------------------

I should complete a chart for the gears. (image2 ... sample)

image2

-------------------------------------------------

Thanks a lot if you can check.

[marcen]

I think with data that does not have the same length, the data cannot be interpolated when compareindex is used.
I have attached a file with xdata gears.

The code below shows nan with compare pane enabled.

Code:

metricsAll = GC.activity(join="repeat", compareindex=0) xdataGears = GC.xdata('GEARS', 'REAR', join="repeat", compareindex=0) print("From activity: ", list(metricsAll['GEARS_REAR'])) print("From xdata: ", list(xdataGears))

​

[marcen]

Nan is only timed when the interval is between two data points.

Using the attached file in the previous post, create an interval with a from 12 minutes to 13 minutes and then compare them, then nan will be timed.

[Fe]

The gears are already interpolated, length is the same.  (GEARS_FRONT , GEARS_REAR)

Lap1' and 'Entire Activity' are always aligned, the other intervals are not.

Entire Activity (activity xxx example) :