samedi 24 avril 2021

Calculating over invalid / incorrect data in the data set

I have an array (dataset) consisting of 3 different data. Sample data are as follows;

price: 5 [dolar]
quota: 20 [person count]
distance: 700 [second]

My goal is to average it out for one data (in 3 ways).

For example, for these data;

answer = [distance(700)*price(5)]/quota(20) => 175

There is no problem so far. Some price information is missing in this dataset (empty) and some capacity information is below 0 (source problem)

It is not dependent on any programming language, it is algorithm-based, what should I do here?

It is not enough to give 0 because it is empty and invalid. When it is in the cross position, 0 radically changes the result and its realism is distorted.

Thank you for everything..




Aucun commentaire:

Enregistrer un commentaire