我如何通过特定的字段将列表过滤成不同的值,如果值不是不同的,则取其平均值。请参阅示例
{
Public int Time;
Public float Voltage;
Public float Current;
Public Resistance(int time, float voltage, float current)
{
Time = time;
Voltage = voltage;
Current = current;
}
Public List<Resistance> _resistances = new List<Resistance>();
_resistances.Add(new Resistance(Time = 1, Voltage =3.2, Current = 1);
_resistances.Add(new Resistance(Time = 1, Voltage =4.0, Current = 2);
_resistances.Add(new Resistance(Time = 1, Voltage =6.5, Current = 6);
_resistances.Add(new Resistance(Time = 2, Voltage =3.2, Current =4);
_resistances.Add(new Resistance(Time =2, Voltage =3.2, Current = 2);
_resistances.Add(new Resistance(Time = 3, Voltage 5, Current = 1);目的是列出一份清单,其中包括:
_resistance[0]{ Time =1,, Voltage = Average(3.2,4,6.5), Current = Average(1,2,6))
_resistance[1]{ Time =2,, Voltage = Average(3.2,3.2,5), Current = Average(4,2,1))
}对于任意的值和条目的数量
我试过以下几种方法
int divisor = 1;
double voltageSum = 0;
double currentSum = 0;
while (j >= 1)
{
while (_resistances[j].Time== _resistances[j - 1].Time)
{
divisor++;
voltageSum += _resistances[j].Voltage;
currrentSum += _resistances[j].Current;
_resistances.RemoveAt(j);
j -= 1;
}
var averageVoltage = voltageSum / divisor;
var averageCurrent = currentSum / divisor;
_rawDataList[j].Voltage = (float)averageVoltage;
_rawDataList[j].Current= (float)averageCurrent;
j -= 1;
}我知道这是错误的,但我似乎不知道修改一个列表的逻辑,我认为创建一个新的列表并在一个新循环中附加可能是前进的道路,但我无法解决它。我认为Linq可能会有所帮助,但在Lambda的表达方面不太有经验。提前感谢
发布于 2019-08-09 19:48:40
您可以使用Linq完成这一任务,按时间对记录进行分组,并使用Average函数计算时间组的电压和电流值:
_resistances
.GroupBy(r => r.Time)
.Select(g => new {
Time = g.Key,
Voltage = g.Average(r => r.Voltage),
Current = g.Average(r => r.Current)
});https://stackoverflow.com/questions/57436194
复制相似问题