Hi all,(adsbygoogle = window.adsbygoogle || []).push({});

I have algorithm to analyze and make it easier to implement in programming language (Python). We have table with data and we want to select only representative part.

It looks like:

ID_PRODUCT | CARDINALITY | SET VARIANCE WITH THIS ELEMENT AND ABOVE

10 ---------------- 110 --------------- 400

11 ---------------- 90 ---------------- 350

12 ---------------- 80 ---------------- 300

... --------------- ... ---------------- ...

* variance is calculated for cardinality column

Algorithm works as follows:

Iterate over rows from the top of table and in each loop add new row and count variance for cardinality column. Stop iteratation if variance is equal or less than specified (so, finally we want to produce set of rows with variance bigger than X) and then return created (now representative) set

Question:

This is legacy solution and hard to say for me how we can do it better. Is there any math tool which cut away elements hardly representative? We can not statically based on the cardinality (like: just give rows with cardinality > 50) because the day-to-day can change the order of magnitude.

Thanks in advice!

**Physics Forums - The Fusion of Science and Community**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# A Algorithm creates representative set of data

Have something to add?

Draft saved
Draft deleted

Loading...

Similar Threads - Algorithm creates representative | Date |
---|---|

A Pairing algorithm | Jan 27, 2018 |

B Bellman's and Bellman-Ford algorithm | Nov 1, 2017 |

I Dijkstra's algorithm spp | Nov 1, 2017 |

I Dijkstra's algorithm - Shortest Path Query | Jan 8, 2017 |

Do I have enough information to create a normal distribution | Mar 13, 2015 |

**Physics Forums - The Fusion of Science and Community**