Repeating specific index of one column for certain number of rows

[kourosh kalayehParticipant]

Hi,

I am wondering how I can repeat each index of a column for n number of rows.  Below is the detail,

I have data size distribution of some particles.  The data is from the histogram created by the native software for the machine that is being used to count the particles and it comes in “bin number”, “diameter (center)”, “number”.  I have flattened the data (all of my samples).  Using pivot command I am trying to do some statistical analysis; calculating mean and standard deviation for each sample.  But since the data is not raw data and is coming from histogram, I have to do weighted analysis.  I can easily do so for the mean but for standard deviation things are a bit more complicated, I am using this formula.  I need to subtract the mean of each sample from each data point of that sample.  The best way that came to me to achieve this was to repeat the mean of each sample for number of rows that particular sample has and then subtract them.  Is there any better way to do this?  How can I repeat the means without using global variables?

Thanks

Kourosh

[kourosh kalayehParticipant]

I think I found my answer; “Map” column.  I mapped the mean column based on the “sample_id” keys.

[dgteamModerator]

That would be our suggestion.  Is the map column working for you?

[kourosh kalayehParticipant]

Yes, it works perfectly.  Thank you.

[Author]

Posts