所以我有一個 IEnumerable CallsForProperty 我需要找到特定時間段的前 3 個問題，所以我創建了 3 個字典 Dictionary<int, string> FAQfor3Months = null; Dictionary<int, string> FAQfor4to12Months = null; Dictionary<int, string> FAQfor12plusMonths = null; foreach(Activity call in CallsForProperty){ if( /*call is in 3 months*/ ){ //do some unrelated stuff FAQfor3Months.Add(counter, call.callQuestion) counter++; } }我有 2 個問題，我試圖找出最常見的 3 個問題，這個查詢正確嗎？var threeMonthFaqs = FAQfor3Months.GroupBy(x => x.Value).OrderByDescending(x => x.Count()).Take(3); 這也太低效了吧？有沒有更好的方法來查詢集合？
2 回答
慕的地6264312
TA貢獻1817條經驗 獲得超6個贊
反轉Dictionarys 并計算遇到的每個問題，然后可以使用 LINQ 找出最重要的 3 個問題：
var FAQfor3Months = new Dictionary<string, int>();
var FAQfor4to12Months = new Dictionary<string, int>();
var FAQfor12plusMonths = new Dictionary<string, int>();
foreach (Activity call in CallsForProperty) {
if ( /*call is in 3 months*/ ) {
//do some unrelated stuff
FAQfor3Months.TryGetValue(call.callQuestion, out int count);
FAQfor3Months[call.callQuestion] = count+1;
}
}
var top3ThreeMonthFaqs = FAQfor3Months.OrderByDescending(kvp => kvp.Value).Take(3).Select(kvp => kvp.Key).ToList();
繁星點點滴滴
TA貢獻1803條經驗 獲得超3個贊
您的代碼將返回組，而不是實際的問題。嘗試這個：
var threeMonthFaqs = FAQfor3Months.Values .GroupBy(q => q) .OrderByDescending(g => g.Count()) .SelectMany(g => g) .Distinct() .Take(3);
- 2 回答
- 0 關注
- 171 瀏覽
添加回答
舉報
0/150
提交
取消